Solved

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

Posted on 2006-11-25
2
2,151 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 48

Accepted Solution

by:
schwertner earned 500 total points
ID: 18017956
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

828 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