OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Which init.ora?

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

Which init.ora? [message #61836]

Fri, 04 June 2004 01:45

Alex
Messages: 190
Registered: August 1999

Senior Member

I work with a 8.0.5 DB on windows NT. My Problem is, that there are some similar init.ora's. Is there any way to find out which one my database exactly use to start up?

Report message to a moderator

Re: Which init.ora? [message #61838 is a reply to message #61836]

Fri, 04 June 2004 03:54

Deepak Panda
Messages: 24
Registered: May 2004

Junior Member

Try this out...

select value from v$parameter
where name = 'ifile';

Report message to a moderator

Re: Which init.ora? [message #61849 is a reply to message #61838]

Sun, 06 June 2004 23:01

Alex
Messages: 190
Registered: August 1999

Senior Member

Thanks.
I tried but I couldn't see any location or path!
Any other suggestions?

Report message to a moderator

Re: Which init.ora? [message #61851 is a reply to message #61849]

Sun, 06 June 2004 23:45

Deepak Panda
Messages: 24
Registered: May 2004

Junior Member

It should show the path if your DB is using any init.ora file. Are you using spfile instead?

try this

select value from v$parameter
where name ='spfile';

Report message to a moderator

Re: Which init.ora? [message #61852 is a reply to message #61851]

Sun, 06 June 2004 23:57

Alex
Messages: 190
Registered: August 1999

Senior Member

Thanks. I tried again.
The query for the ifile shows 1 row selected but there is no value-entry.
When I make the query for the spfile no row is selected!

Report message to a moderator

Re: Which init.ora? [message #61855 is a reply to message #61849]

Mon, 07 June 2004 00:49

neemic
Messages: 4
Registered: May 2004

Junior Member

Hi Alex -

You could try looking in the registry

HKEY_LOCAL_MACHINESOFTWAREORACLEHOME??

Check ORACLE_SID & ORACLE_sid_PFILE parameters.

Remember the ORACLE_sid_PFILE may contain an IFILE parameter pointing to the true init.ora file for your sid.

Regards,
neemic

Report message to a moderator

Re: Which init.ora? [message #61858 is a reply to message #61855]

Mon, 07 June 2004 01:56

Alex
Messages: 190
Registered: August 1999

Senior Member

Thanks neemic, but I checked the registry last week and found no entries to the pfile I need. There are only entries from the pfiles older unused databases.
I wonder how this database starts up!

Report message to a moderator