How do I restart Oracle 10g on Solaris 9 after a reboot?

I did a fresh install of Solaris 9 Entire Distribution on a Sun Enterprise 420R. This system has graphics, so I am using a Sun monitor, keyboard, and mouse. I installed the latest Solaris 9 patch cluster as well as the additional packages and patches as requested in the Oracle 10g SPARC Solaris installation manual. I downloaded what seems to be a more recent version or Oracle 10g, 10gr2_db_sol.cpio, unpacked it and installed using runInstaller. I created a new database as part of the installation and set the same password for all 4 major users (SYSTEM, etc). Finally the installer asked me to run root.sh, which I did. Root.sh asked for my local bin path, so I gave it /usr/local/bin as that is part of the PATH I set for my Oracle user and DBA group. When the installer was done, I was able to connect to the database from sqlplus and from the web iSQL*Plus (port 5560), I was also able to connect to the web Enterprise Manager (port 1158). The system was working perfectly until that moment when I rebooted Solaris. The OS came back up but Oracle did not. ps -ef showed not a single sign of Oracle!!! I did multiple web seraches and learned that a file named dbora should be re-launching Oracle for me. So I checked rc2.d and rc3.d, as well as /etc/init.d, I could not find the dbora or any file with dbora in its name. I tried making my own dbora from information I found on this page:  http://www.dbspecialists.com/presentations/oracle10gsolaris.html  but I recieved many errors. I tried doing the steps manually (see below) and still was given many errors.
bash-2.05$ export ORACLE_BASE=/oracle
bash-2.05$ export ORACLE_HOME=/oracle/product/10.2.0/Db_1/
bash-2.05$ export ORACLE_SID=orcl
bash-2.05$ /oracle/product/10.2.0/Db_1/bin/dbstart
Failed to auto-start Oracle Net Listene using /ade/vikrkuma_new/oracle/bin/tnslsnr
cat: cannot open /etc/oratab
cat: cannot open /etc/oratab
bash-2.05$ su -
Password:
Sun Microsystems Inc.   SunOS 5.9       Generic May 2002
bash-2.05# cp /var/opt/oracle/oratab /etc/oratab
bash-2.05# exit
logout
bash-2.05$ /oracle/product/10.2.0/Db_1/bin/dbstart
Failed to auto-start Oracle Net Listene using /ade/vikrkuma_new/oracle/bin/tnslsnr


My questions at this point are as follows:
1. How do I get Oracle 10g database started back up again? What must I do in order to set the proper environment variables and start the various Oracle components in motion once again?
2. How do I configure my system so that Oracle 10g properly shuts down and starts up when I reboot my Solaris system?
netironmanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Devinder Singh VirdiLead Oracle DBA TeamCommented:
In solaris machine you just try to connect database using superuser ie
oracle_sid=orcl; export oracle_sid
sqlplus
user name : sys/password as sysdba
If not write down the error
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.