ORACLE Database / WAS (iAS) / SQL 자료실 - 포기하지 않으면 실패하지 않는다!
Vote Reply Modify Delete Forward Prev Next List

  Author   : 조성환 [ ladmin ] Vote: 1684, Modifies: 2, Hit: 4377, Lines: 62, Category: Etc.
파라메터 파일을 spfile 에서 pfile 로 운영하고 싶을때

SQL> create pfile from spfile;

SQL> exit

이렇게 하시면 (/oracle/dbs 디렉토리에) initSID.ora 파라메터 파일이 생길겁니다.........


$ mv spfile*.ora spfileSID.ora_old



[변경후 테스트]

swdb@ CHUN [/oracle] $   sqlplus '/as sysdba'

SQL*Plus: Release 9.2.0.7.0 - Production on Fri Apr 28 10:07:49 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production


SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string


이렇게 됩니다........




참고로 변경전의 spfile 운영시는 다음과 같습니다.


SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      ?/dbs/spfile@.ora
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> show parameter pfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      ?/dbs/spfile@.ora
SQL>
SQL>


Prev: Oracle (9i) Database PatchSet 설치 가이드 [초강추]
Next: Database 비교 ; Oralce RAC 에 대한 간단한 설명
2006/05/26(10:41) from 203.234.120.78
CrazyWWWBoard 2000

Vote Reply Modify Delete Forward Prev Next List
(c) Nobreak Technologies, Inc.