OraFAQ Forum: Server Administration » where is init.ora for the datbases in 9.2.0?

Home » RDBMS Server » Server Administration » where is init.ora for the datbases in 9.2.0?

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

where is init.ora for the datbases in 9.2.0? [message #58392]

Fri, 22 August 2003 12:56

Tony
Messages: 190
Registered: June 2001

Senior Member

where is init.ora for the datbases in 9.2.0? Has it been redefined? Because I cannot find it in the entire oracle directory structure.

Report message to a moderator

Re: where is init.ora for the datbases in 9.2.0? [message #58393 is a reply to message #58392]

Fri, 22 August 2003 13:02

Tony
Messages: 190
Registered: June 2001

Senior Member

All I see is the following files for a given database:

initdbname1.ora.7122003165338
spfiledbname1.ora

And it looks like I cannot edit spfiledbname1.ora as there are several control characters in the beginning and looks like its automatically generated. And also there isn't much to edit there. Not all parameters are there.

What about the initdbname1.ora.7122003165338? Is this even used? Should I even rename it to initdbname1.ora?

Thanks

Report message to a moderator

Re: where is init.ora for the datbases in 9.2.0? [message #58394 is a reply to message #58393]

Fri, 22 August 2003 14:43

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

if you are using the spfile, you will see somethinglike
spfile< sid >.ora in $ORACLE_HOME/dbs.
You can create an init< sid >.ora from an spfile
and use it

Report message to a moderator

Re: where is init.ora for the datbases in 9.2.0? [message #58400 is a reply to message #58393]

Sat, 23 August 2003 21:52

ctg
Messages: 146
Registered: July 2002

Senior Member

SQL> show parameter spfile -- if a file is displayed, you are using an spfile.

An spfile is a binary parameter file that oracle maintains. So now when you do "ALTER SYSTEM SET paramater = value [[SCOPE=SPFILE/MEMORY/BOTH]]" oracle can modify the parameter in the file as well.

Like Mahesh said, you can create a pfile from an spfile. CREATE PFILE[[='file']] FROM SPFILE[[='file']];

Report message to a moderator

Re: where is init.ora for the datbases in 9.2.0? [message #58416 is a reply to message #58400]

Mon, 25 August 2003 13:12

Tony
Messages: 190
Registered: June 2001

Senior Member

Thanks guys.

Report message to a moderator

Previous Topic:	What is the hardware requirment for this
Next Topic:	Oracle Password File.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 07:33:28 CDT 2024