OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » SPFILE

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SPFILE [message #254605]

Fri, 27 July 2007 04:37

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

Report message to a moderator

Re: SPFILE [message #254612 is a reply to message #254605]

Fri, 27 July 2007 04:49

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: SPFILE [message #254741 is a reply to message #254612]

Fri, 27 July 2007 15:14

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

thanks michel

Report message to a moderator

Re: SPFILE [message #254797 is a reply to message #254741]

Sat, 28 July 2007 06:46

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

Report message to a moderator

Re: SPFILE [message #254803 is a reply to message #254797]

Sat, 28 July 2007 07:41

Michel Cadot
Messages: 68686
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 19:48:41 CDT 2024