Creating SPFILE in E-Business Suite R12 (12.0.6)
Hi,
I am new to oracle database administration and I wanted to create a SPFILE from our current PFILE. However, upon navigating to the path where our init.ora is located:
"/oracle/oracle/database/db/tech_st/10.2.0/dbs/"
I see two .ora files, init.ora (8kb) and initdev.ora (19kb) where dev is our <ORACLE_SID>. What ora file shall I use in the 'CREATE SPFILE FROM PFILE' command?
Also, where do I enter the command? Do I need to use SQLPLUS? My problem here is that, it is advised to create the SPFILE before database startup. However, I could not connect to SQLPLUS when the database is not started. Is it ok to run the 'CREATE SPFILE FROM PFILE' command even if the database is running?
I am new to oracle database administration and I wanted to create a SPFILE from our current PFILE. However, upon navigating to the path where our init.ora is located:
"/oracle/oracle/database/db/tech_st/10.2.0/dbs/"
I see two .ora files, init.ora (8kb) and initdev.ora (19kb) where dev is our <ORACLE_SID>. What ora file shall I use in the 'CREATE SPFILE FROM PFILE' command?
Also, where do I enter the command? Do I need to use SQLPLUS? My problem here is that, it is advised to create the SPFILE before database startup. However, I could not connect to SQLPLUS when the database is not started. Is it ok to run the 'CREATE SPFILE FROM PFILE' command even if the database is running?
0