Friday, February 29, 2008

Mirroring PFILE

To have two copies of PFILE in a ORACLE Database, follow the below steps...

UNIX:
Create a Symbolic link in $ORACLE_HOME/dbs folder that points to the file in $ORACLE_BASE/admin/XYZ/pfile/initXYZ.ora

ln -s $ORACLE_BASE/admin/XYZ/pfile/initXYZ.ora $ORACLE_BASE/dba/initXYZ.ora
where XYZ is the database

WINDOWS:
Create a pfile in ORACLE_BASE\admin\XYZ\pfile and put an entry in the ORACLE_HOME\dbs\initXYZ.ora as given below
ifile=\admin\XYZ\pfile\initXYZ.ora
where XYZ is the database

No comments: