Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 337
  • Last Modified:

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
0
Osloiite
Asked:
Osloiite
  • 4
  • 3
  • 2
1 Solution
 
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
 
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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
 
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:
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

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now