OraFAQ Forum: Server Administration » Just Wondered...pls. help!!

Home » RDBMS Server » Server Administration » Just Wondered...pls. help!!

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

Just Wondered...pls. help!! [message #59530]

Sun, 30 November 2003 21:11

sachin kumar gupta
Messages: 157
Registered: March 2003

Senior Member

Hi,

I am running Oracle 9.0.1 on Windows 2000 Adv. Server. I know that the default parameter file is SPFILESID.ora for instance startup. But, I think OEM uses ORACLE_HOMEsysmanifilesdef_SID.ora file for instance startup. I wondered when I saw the shared pool size was much higher in def_SID.ora than SPFILESID.ora. Even def_SID.ora was also much higher processes. This happened when I automated for dbstartup using def_SID.ora.

Why is this def_SID.ora used for & why it is introduced when SPFILESID.ora is already there? Also, what parameter file shall I use for instance starup?

TIA,
Sachin

Report message to a moderator

Re: Just Wondered...pls. help!! [message #59543 is a reply to message #59530]

Tue, 02 December 2003 11:47

Sanjay
Messages: 236
Registered: July 2000

Senior Member

I dunno much about windows env, but the thing is after you make changes in the init.ora file, you have to update the spfile

1. delete the spfile;

2. SQL> create spfile from pfile;

And as you mentioned, since you have automated the startup using the init.ora, why were you expecting to startup with the spfile ?

spfile, if it is there, is used in the startup when it is given without any params, like just 'startup'.

Later.

Hope this helps.

Report message to a moderator

Re: Just Wondered...pls. help!! [message #59547 is a reply to message #59543]

Tue, 02 December 2003 21:27

sachin kumar gupta
Messages: 157
Registered: March 2003

Senior Member

I haven't made any changes in init.ora. And also I am not starting db using init.ora. I have started db using def_SID.ora.
I just want to know the difference betwn. def_SID.ora and spfileSID.ora. & why is def_SID introduced.

TIA,
Sachin

Report message to a moderator

Previous Topic:	ORA-00600 -- internal error
Next Topic:	Location of Alert, log or error file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 11:00:58 CDT 2025