Q

Parameter file to use when starting an instance

I use Oracle9i release 1 on Windows 2000. I need help multiplexing my control file. I take a copy of my control file through operating system command and add a new path of this control file in parameter file. But when I restart my instance and apply this query...

(select * from control_files )

... I am not shown the new control file path. What do I do?

Also, when the instance is started, which file is read pfile or spfile?
When you start an instance, the following order is used to know which parameter file to use:

1. Use the explicitly stated parameter file in the STARTUP command, if provided.
2. Use the $ORACLE_HOME/dbs/spfileSID.ora (Unix) or %ORACLE_HOME%databasespfileSID.ora (Windows) if available.
3. Use the $ORACLE_HOME/dbs/initSID.ora (Unix) or %ORACLE_HOME%databaseinitSID.ora (Windows) if available.
4. Use the $ORACLE_HOME/dbs/init.ora (Unix) or %ORACLE_HOME%databaseinit.ora (Windows) if available.
5. No parameter files were available so issue an error message and abort the startup of the database.

So when you wanted to change your CONTROL_FILES parameter, you needed to make that change in your SPFILE. Your changes in the INIT.ORA were never read. Make the change in your SPFILE (ALTER SYSTEM SET CONTROL_FILES='file1','file2' SCOPE=SPFILE) and bounce the database.

This was first published in March 2004

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close