Wednesday, May 20, 2009

Starting Up with a Non-Default Server Parameter File

Create a one-line text initialization parameter file that contains only the SPFILEparameter. The value of the parameter is the non-default server parameter filelocation.For example, create a text initialization parameter file/u01/oracle/dbs/spf_init.ora that contains only the following parameter:SPFILE = /u01/oracle/dbs/test_spfile.oraSTARTUP PFILE = /u01/oracle/dbs/spf_init.ora

No comments:

Post a Comment

About Me

Working as Oracle DBA for Wipro Technologies, Chennai, India