?
Solved

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

Posted on 2006-11-25
2
Medium Priority
?
2,157 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 2000 total points
ID: 18017956
0

Featured Post

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Suggested Courses
Course of the Month12 days, 11 hours left to enroll

777 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