I just installed this on the Sun box. Got the database software installed and a database up and running. Now I am trying to setup the start and stop scripts for the when the machine gets rebooted, etc.
Seems that the scripts are having a problem shutting down the instance (don't know about the sartup yet)., ie. scripts connect but the shutdown command does not get initiated.
Thing is the scripts that I am using are the ones that came with the database ($ORACLE_HOME/bin/dbshut and dbstart). Ones that oracle bundled. I took a look at them and they are old scripts. (go figure). (I also copied working ones from a Solaris 8 machine and those have a problem too).
So does anyone have any working scripts for Solaris 9?
Also, has anyone encountered anything like two smon processes for the same database on the same machine? ie, pid 1400 ora_smon_SID, 1500 ora_smon_SID? I didn't think this was possible. Maybe the machine is screwed but wanted to know if anyone has encountered something like it.
Originally posted by ramaral Also, has anyone encountered anything like two smon processes for the same database on the same machine? ie, pid 1400 ora_smon_SID, 1500 ora_smon_SID? I didn't think this was possible. Maybe the machine is screwed but wanted to know if anyone has encountered something like it.
This can happen when you don't have your environment variables setup correctly. You actually start two instances with the same name and different $ORACLE_HOMEs.
Originally posted by ramaral
I just installed this on the Sun box. Got the database software installed and a database up and running. Now I am trying to setup the start and stop scripts for the when the machine gets rebooted, etc.
Seems that the scripts are having a problem shutting down the instance (don't know about the sartup yet)., ie. scripts connect but the shutdown command does not get initiated.
Thing is the scripts that I am using are the ones that came with the database ($ORACLE_HOME/bin/dbshut and dbstart). Ones that oracle bundled. I took a look at them and they are old scripts. (go figure). (I also copied working ones from a Solaris 8 machine and those have a problem too).
90% of the time, these problems are due to environment variables not being setup correctly. I would write a script that echos your EVs during startup/shutdown.
Does dbstart/dbshut work from the command line as the oracle software owner? If yes, you've got an environment variable problem.
Hi,
As Jeff said,
check the env..
script may be pointing to old oracle_home/bin/dbstart and dbshut.
check the script again and correct it.
Thanks.
Thanigaiuvasan.
It's not a crisis situation thankfully. Just curious having this kind of problem on Solaris 9. Guess it's too new for Oracle still. I have also noticed in the alert log something funny:
WARNING: EINVAL creating segment of size 0x000000000f086000
fix shm parameters in /etc/system or equivalent
I have updated the system parameters given Oracle's specs.
If that is the case where did you give link to dbora scripts...?.
meaning in /etc/rc2.d or rc3.d???.Give both for start and shut in same place!!!!!!!!!!!!!!!!Try.
Thanks.
Thanigaivasan.
Reply With Quote
Bookmarks