Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2171
  • Last Modified:

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?
0
netironman
Asked:
netironman
1 Solution
 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now