Home » RDBMS Server » Server Administration » SPFILE
SPFILE [message #254605] Fri, 27 July 2007 04:37 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

hi ,

I have created spfile from pfile(initbala01.ora and i want to startup the database with that spfile.

what is the command to start my database with the spfile.

help me out this.

Regards,
Balaji
Re: SPFILE [message #254612 is a reply to message #254605] Fri, 27 July 2007 04:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just "startup".
If there is a spfile (in default directory of course) then Oracle will take it, otherwise it takes init.ora.

Regards
Michel
Re: SPFILE [message #254741 is a reply to message #254612] Fri, 27 July 2007 15:14 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

thanks michel
Re: SPFILE [message #254797 is a reply to message #254741] Sat, 28 July 2007 06:46 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member



hi,

i created a default spfile from pfile;

create spfile from pfile -- the spfile was created successfully


i also created non- default spfile called 's_params' from pfile

create spfile='s_params' from pfile


now i want to startup my database with the non-default spfile ('s_params')


could you please tell me what command is useed to startup the database with non default spfile ('s_params')


Regards,
Balaji


Re: SPFILE [message #254803 is a reply to message #254797] Sat, 28 July 2007 07:41 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From Administrator's Guide:
Quote:
Starting Up with a Non-Default Server Parameter File

A non-default server parameter file (SPFILE) is an SPFILE that is in a location other than the default location. It is not usually necessary to start an instance with a non-default SPFILE. However, should such a need arise, you can use the PFILE clause to start an instance with a non-default server parameter file as follows:

1. Create a one-line text initialization parameter file that contains only the SPFILE parameter. The value of the parameter is the non-default server parameter file location.

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.ora

2. Start up the instance pointing to this initialization parameter file.

STARTUP PFILE = /u01/oracle/dbs/spf_init.ora

Please just search a little bit on documentation for such obvious question.

Regards
Michel
Previous Topic: Database hasn't coming up after rebooting.
Next Topic: Oracle 10g SQL Tuning Advisor
Goto Forum:
  


Current Time: Tue Dec 06 16:12:14 CST 2016

Total time taken to generate the page: 0.12109 seconds