Startup and init.ora file

[bhunter]

I am trying to use the "startup" command without any parameters in SQLPlus. When I issue the command I get the following message because the file that it is looking for no longer exists:

LRM-00109: could not open parameter file 'E:\Oracle\Ora81\DATABASE\INITauc3.ORA'
ORA-01078: failure in processing system parameters

I know that the file is gone because I removed the database called auc3. I now have a database called 'auc' and there is an INITauc.ora file in the directory path listed above. I connect to the 'auc' database with SQLPlus, but I don't understand why it is looking for the old init.ora file when I issue a startup command. When I specify the full path of the init.ora that I want then it works fine. Is there a way to change the settings so that I can specify the default init.ora that I want so that I don't have to specify it when I want to startup the database?

 

[karluk]

On NT the default pfile location appears to be {Oracle_home}\database\init{SID}.ora. {SID} takes on the current value of Oracle_sid. It seems unlikely that you set this value to an obsolete name, so my guess is that the value "auc3" is set in the NT registry.

Please check in the NT registry under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE to see if ORACLE_SID is assigned a value of "auc3". If it is, change it "auc" and retry the startup command. It should work without needing to specify a pfile.

 

[carp]

You should also check the setting of the environmental variable ORACLE_SID. If it is still set to AUC3, change it to AUD, then start a new sqlplus session and try it again.