Minion Skywalker Minion Skywalker - 1 year ago 120
SQL Question

Oracle: How to create spfile.ora?

I red what Oracle 9i have spfile.ora default , but i don't understand : why that file isn't in Oracle 9i as default. Because: how to create spfile.ora correctly in Oracle 11g ?

Answer Source

You must be connected to your Oracle 9i instance as SYS. Then use the following to create your spfile

CREATE SPFILE='/u01/oracle/dbs/spfile.ora'
FROM PFILE='/u01/oracle/dbs/init.ora';
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download