| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> srvctl and spfile
Dear list,
I have setup a two-node RAC and in the process of configuring srvctl to
manage the instances. I have discovered some strange behavior regarding
the way srvctl utility looks for the spfile. The SID names are e52racn1
and e52racn2. The database name is e52rac:
-- I setup the initial configuration with command:
srvctl add database -d e52rac -o /home/oracle/v9i2_otc_e52rac -s
spfile.ora
(Do I need to specify the absolute path for the spfile here?)
-- I then added instance one to the configuration with command:
srvctl add instance -d e52rac -i e52racN1 -n mc0300ux550
This is an 11i instance and the autoconfig utility creates the listener and tnsnames files in a context directory and not in the $ORACLE_HOME/network/admin
The problem is that when I issue the command "srvctl start instance -d e52rac -i e52racN1", the database comes up fine but when I use "show spfile" command from SQL*Plus, it shows me a blank string meaning that the instance is using initSID.ora file and not the spfile.ora file. When I rename the initSID.ora file and bounce the instance via srvctl command, the "show spfile" shows me "?/dbs/spfile.ora" meaning that the instance is using the spfile. So, it seems that the srvcel utility looks for the initialization parameters file in the reverse order than what SQL*Plus uses. When I renamed both the spfile and the initSID.ora files and tried to bring up the instance via srvctl, I got the following message:
Has anyone experienced this behavior with the srvctl utility? Any help will be appreciated.
Thanks
Amir
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 07 2005 - 15:50:07 CDT
 |
 |