OraFAQ Forum: Server Administration » init file name in oracle 9i

Home » RDBMS Server » Server Administration » init file name in oracle 9i

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

init file name in oracle 9i [message #126294]

Sun, 03 July 2005 02:12

owais303
Messages: 19
Registered: July 2005
Location: India

Junior Member

hi
My init file name is showing as init.ora.553432123 and not like init<SID>.ora
i am using oracle 9i,can any one suggest why is it so and is there any way to find out which init file is my database using currently

Report message to a moderator

Re: init file name in oracle 9i [message #126296 is a reply to message #126294]

Sun, 03 July 2005 02:27

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Hi,

There is no easy way to tell. Your database may have been started with any INIT.ORA file using "STARTUP PFILE=/path/to/any/init.ora".

Best would be to find all INIT.ORA files on your system and compare the parameters with the output from V$PARAMETER:

SQL> SELECT name||'='||value "INIT.ORA"
  2    FROM sys.v_$parameter WHERE isdefault = 'FALSE'
  3  /

INIT.ORA
--------------------------------------------------------------------------------
processes=250
shared_pool_size=100663296
large_pool_size=8388608
java_pool_size=50331648
...

Best regards.

Frank

Report message to a moderator

Re: init file name in oracle 9i [message #126306 is a reply to message #126296]

Sun, 03 July 2005 03:41

owais303
Messages: 19
Registered: July 2005
Location: India

Junior Member

Thanks for the responce i compared the out from v$parameters with my init.ora.582005193241 and they match exactly but my query is what does the file name extension .582005193241 suggest and why isnt it as init<sid>.ora

Report message to a moderator

Re: init file name in oracle 9i [message #126307 is a reply to message #126306]

Sun, 03 July 2005 03:53

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Hi,

Good question. I guess you can call it whatever you like.

The easiest would be to rename it to init${ORACLE_SID}.ora and put it into your $OH/dbs directory (or create a symlink). If you do, you don't have to use the PFILE= argument to startup the database.

Another approach would be to convert the DB to use a SPFILE (Server Parameter File) instead of a PFILE.

Best regards.

Frank

Report message to a moderator

Re: init file name in oracle 9i [message #126346 is a reply to message #126307]

Mon, 04 July 2005 00:00

Achchan
Messages: 86
Registered: June 2005

Member

Hi Frank,
1. Frank is right in %nix OS! in windows put your PFILE in %ORACLE_HOME%\database folder instead of dbs which exists too.
You can make a link (in %nix) or shortcut (in Win) to the recent path of your init.ora file without moving it really.
2.By default it will try to use SPFILE so no need to do something.

NOTE for original poster(owais303): I see many PFILES look like yours and there is not a bad thing,Don't worry! But I don't know what is it really,sorry.

Report message to a moderator

Re: init file name in oracle 9i [message #126730 is a reply to message #126294]

Wed, 06 July 2005 07:20

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

I'd like to second (or third?) the notion of using an spfile. That way you always know which parameter file is being used by the show parameter spfile command in sqlplus.

Report message to a moderator

Previous Topic:	Switching tablespace from permanent to temporary
Next Topic:	Oracle 9206

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 07:35:08 CST 2025