initsidname.ora file

Can anyone tell whats  is initsidname.ora file in oracle database and how can i locate it using the oracle enterprise manager.

thanks a lot
OsloiiteAsked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
the spfile parameter points to the location of the spfile.

This is a binary file and cannot be manually edited.

To change the parameters you need to issue the proper alter system commands.

If you are not familiar with this, the docs have all the information:
http://download.oracle.com/docs/cd/E11882_01/server.112/e25494/create006.htm#i1010034

Since you are using entperprise manager, just change them.

>>parameters in the initsidname.ora

If the spfile parameter is null then you are using a pfile.  I don't believe you can edit these parameters inside Enterprise Manager.
0
 
sdstuberCommented:
you'll find it in the operating system  it should be in $ORACLE_HOME/dbs
0
 
slightwv (䄆 Netminder) Commented:
It is your pfile, startup, for the oracle database.

You cannot locate it in exnterprise namager.  If is in a default location:  %ORACLE_HOME%/dbs
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
slightwv (䄆 Netminder) Commented:
Now if you are using a stored,  or spfile, there is an spfile database parameter that can tell you the location.
0
 
OsloiiteAuthor Commented:
slighttwv

I have opened the spfile now . can you tell me about that parameter?

Also I am just checking into one of the manuals I have been provided by my senior at the company I work and it says I have to modify the parameters like open_cursors and hash parameters in the initsidname.ora using oracle enterprise manager.

Thanks.
0
 
sdstuberCommented:
from a sql prompt

alter system set open_cursors= <<<some value>>>  scope=spfile

this will take affect on next restart

or


alter system set open_cursors= <<<some value>>>  scope=both  

this will take affect immediately and also write to spfile for future restarts
0
 
OsloiiteAuthor Commented:

Okay thanks

I have modified the open cursors parameter but could not locate the hash join enabled parameter . I am using oracle 10g. I heard that its obsolete or is having an alternate name in 10g. Is it true? and if it is true what is the new name.

Thanks
0
 
sdstuberCommented:
alter system set hash_area_size=12345678 scope=spfile


you can't do "both" with this parameter
0
 
slightwv (䄆 Netminder) Commented:
The online docs are your friend.  It will have the old depreciated  parameters and new replacement ones.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.