Database can't start automatically on solaris


 
Thread Tools Search this Thread
Operating Systems Solaris Database can't start automatically on solaris
# 1  
Old 02-15-2008
Database can't start automatically on solaris

Hi,
I have installed oracle 9i on solaris 10 sucessfully. I have configured listener & tnsname.ora file sucessfuly. Even i can start database manully by starting listener first and from sqlplus promt data base sucessfully. Now i want to start the database automatically after system reboots.

I alrady have set environment in profile, also created the dbora file in /etc/init.d and linked it with rc0.d and rc2.d. Also i have set the oracle sid & home in /etc/var/opt/oracle/oratab file.

After restarting the server i have get log in log file
as
below

SQL> Connected to an idle instance.
SQL> ORA-27100: shared memory realm already exists
SVR4 Error: 17: File exists
SQL> Disconnected


So please guide me how would overcome this problem.

thanks

Sv.
# 2  
Old 02-19-2008
Autostart Oracle DB

The Shared memory realm error usually means the database is already mounted and/or open.

File already exists? That is really odd, sounds like you're trying to create a database file or control file on startup.

Please let me see what your startup script looks like. I usually make my own, but know my way around the one oracle ships.
# 3  
Old 02-28-2008
I'm not oracle DBA but normally problems starting up database is due to semaphore settings under /etc/system file.

Since you say you are able to manually startup database I assume your settings are correct.

The other area maybe you like to look at will be the /var/opt/oracle/oratab file

<some instance>:/oracle/prod/8.1.7:N <-------------- dbora script will check oratab at boot time. N means no startup
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Red Hat

Start a service manager process automatically on startup

Hello, I am in the process of learning Linux OS. How do I run the below lines of code automatically as root on server startup. cd /opt/program_folder/ServiceManager/bin nohup ./servce_manager DEV & Currently, as soon as the server is up and running I log in as root (as this... (6 Replies)
Discussion started by: rparavastu
6 Replies

2. Linux

How to start pc automatically when power comes (Server)?

Can anyone tell me how to start pc automatically when power comes, here I just want to start server automatically, on boot, my server starts automatically because I have written some startup commands in rc.local file but if power fails, then how can I boot automatically (2 Replies)
Discussion started by: Akshay Hegde
2 Replies

3. Ubuntu

Customizing XUbuntu 12.04 Live CD - Start my Exe Automatically

Hi all http://ubuntuforums.org/images/smilies/smiley-faces-80.gif, I am customizing the LIVE CD of Xubuntu 12.04.. I removed the ubiquity package and changed the live username and hostname using uck-gui.. I am almost done with the customization. Now after the splash screen , the text in motd... (1 Reply)
Discussion started by: selvarajvss
1 Replies

4. UNIX for Advanced & Expert Users

start some services automatically

Hello All i have a question related to some services,i want to start some services with server linux centos. i make "chkconfig httpd on" and "chkconfig asterisk on",but when i verify with chkconfig --list i found httpd 0: off 1: off 2: on 3: on 4: on 5: on 6:... (6 Replies)
Discussion started by: bernard12
6 Replies

5. UNIX and Linux Applications

How do I Start postgre SQL automatically when boot my linux machine

Can any body give me the script to start postgre SQL 8.3.1 when boot linux? (2 Replies)
Discussion started by: shiraz
2 Replies

6. Shell Programming and Scripting

How do I Start JBoss automatically when boot my linux machine.

I have created a script file named 'start-jboss' ------------------------------------------------- #!/bin/sh # For starting Jboss JAVA_HOME=/home/argole/jdk/jdk1.6.0_10 export JAVA_HOME cd /home/argole/server/jboss-4.2.0.GA/bin echo "Starting JBOSS server" nohup ./run.sh -c... (25 Replies)
Discussion started by: shiraz
25 Replies

7. Ubuntu

How can I automatically start a daemon at boot time.

Hi masters, I am still learning trades in kernel. I am trying to learn the basic of daemon programming. Can any one tell me how can I start a daemon automatically during boot up. I will be greatfull if anyone post some example code to the above task. Also what are... (3 Replies)
Discussion started by: iamjayanth
3 Replies

8. Shell Programming and Scripting

How can I make a program start up automatically after the computer restart/startup?

hi all How can I make a program start up automatically after the computer restart/startup in fedora? something like: ... Establish a shell then run some of command code. Thanks for Help!! (1 Reply)
Discussion started by: munna_dude
1 Replies

9. Solaris

How to start Oracle database automatically

How to start Oracle database automatically when after SunSolaris is being re-booted? TIA, Greg (3 Replies)
Discussion started by: greg0320
3 Replies

10. UNIX for Dummies Questions & Answers

getting postfix tyo start automatically

Postfix has an initscript just like sendmail did so while logged in as root, simply type: ntsysv and select postfix. The message above is from the Redhat postifx FAQ. I tried running ntsysv and postfix is not listed as a selection. I can start postfix manually without any problems, but I need... (2 Replies)
Discussion started by: kmgrady01
2 Replies
Login or Register to Ask a Question

Featured Tech Videos