Solved

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

Posted on 2006-11-25
2
2,147 Views
Last Modified: 2013-12-05
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
Comment
Question by:netironman
2 Comments
 
LVL 15

Expert Comment

by:Devinder Singh Virdi
ID: 18013891
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
 
LVL 47

Accepted Solution

by:
schwertner earned 500 total points
ID: 18017956
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Web Service from a stored procdure oracle 10 49
Martian Packets Unix 5 30
Create table from select - oracle 6 22
Oracle Listener Not Starting 11 25
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now