Oracle is attempting to read the wrong initSID.ora file

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Article Type: General
Product: Aleph
Product Version: 20, 21, 22, 23

Description:
On our test server I noticed that Oracle had stopped running. I then tried starting it via Util O | 1 | 1 and got this message:
idle> idle> ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/exlibris/app/oracle/product/920/dbs/initaleph1.ora'

This server however has an ORACLE_SID of aleph0 and the initaleph0.ora file exists in /exlibris/app/oracle/product/920/dbs. Can you tell me where I define the parameter to tell Oracle to run the initaleph0.ora file instead?

Resolution:
The aleph_start for Prod has been mistakenly placed in the $alephe_root directory on Test.

This aleph_start has:

setenv ORA_HOST Prod
...
setenv ORACLE_SID aleph1

Article last edited: 10/8/2013