CODEWITHSUNDEEP
sqloracle11g
Minion Skywalker
Minion Skywalker

Reputation: 37

Oracle: How to create spfile.ora?

I read that Oracle 9i has spfile.ora by default, but I don't understand: why that file isn't in Oracle 9i by default.

I want to know how to create spfile.ora correctly in Oracle 11g?

Upvotes: 0

Views: 7755

Answers (2)

santosh tiwary
santosh tiwary

Reputation: 708

Where do you want to create? RAC or standalone database.

In RAC follow the steps. Stop the database srvctl stop database -d test

Startup any one instance using existing pfile. SQL> startup nomount pfile='/scratch/u01/app/oracle/product/12.1.0/dbhome_1/dbs/inittest.ora';

Create spfile from pfile. SQL> create spfile='+DATA/spfiletest.ora' from pfile='/scratch/u01/app/oracle/product/12.1.0/dbhome_1/dbs/inittest.ora';

Stop and start the database [oracle@orahow dbs]$ srvctl stop database -d test [oracle@orahow dbs]$ srvctl start database -d test

Read full at: Create spfile from pfile

Upvotes: 0

tale852150
tale852150

Reputation: 1628

You must be connected to your Oracle 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';

Upvotes: 2

Related Questions