starting Oracle on Reboot


 
Thread Tools Search this Thread
Operating Systems Solaris starting Oracle on Reboot
# 1  
Old 11-29-2005
Error starting Oracle on Reboot

Hi All,

I have to maunally startup oracle and the associated listeners whenever the Sun Solaris server is rebooted. Is there any way by which, everytime the server boots up, The Oracle startups itself.

Do we need to change the init.ora file or the init.d file?
Please let me know which files in which directories need to be modified. ALso if you can state the parameters to be put it would be helpful.

Thanks,
Rahul.
# 2  
Old 11-29-2005
Do you have a script to start/stop your DBs?
How about a script to check if your DBs are online?

If the answer is yes, then you can put together script that will check, and start if it is offline...
You can have multiple entries in cron that checks/starts in oracle/root's crontab.

While your at it, you might as well create something to notify you if they are down (when they should NOT be)...

I'm in the DON'T automatically start DBs when box is online...schedule it through cron or bring them up manually (when performing maintenance).

We use Crontab extensively for our production schedule and alerts management.

hope this helps.
manny
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. Linux

Application services not starting with server reboot

Hi All, My application uses three different sub-services to make complete application up and running to normal. The entry of all the three services are present in /etc/init.d directory with proper softlink created to application home path where it actually exists. In one rare case one of the... (3 Replies)
Discussion started by: hk_kamozalwar
3 Replies

2. UNIX for Dummies Questions & Answers

How to grep a line not starting with # from a file (there are two lines starting with # and normal)?

e.g. File name: File.txt cat File.txt Result: #INBOUND_QUEUE=FAQ1 INBOUND_QUEUE=FAQ2 I want to get the value for one which is not commented out. Thanks, (3 Replies)
Discussion started by: Tanu
3 Replies

3. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies

4. AIX

sendmail/ntp/qdaemon not starting automaticlly after reboot ?!

Hi all, I have a small problem, after a reboot the following services do not start automaticly, like they are supposed to do even though they are commented in in /etc/rc.tcpip sendmail xntpd qdaemon snmpd snmpmibd aixmibd hostmibd why ?!?! anybody ? :confused: (3 Replies)
Discussion started by: art
3 Replies

5. UNIX for Advanced & Expert Users

problem connecting to oracle 10g after NCR node reboot

Hi All, I am facing a connection problem with Oracle 10g on Solaris 10 when my application (started by /etc/rc3.d at node reboot) tries to establish a session after reboot of the node where my application is running (NCR UNIX (MP RAS)). I find that my application (run as a deamon process)... (1 Reply)
Discussion started by: sowjanya
1 Replies

6. UNIX for Dummies Questions & Answers

Starting daemons at reboot.

I rebooted my server (solaris 5.8) and I had to manually start the cron and mailx daemons. How do I get these to automatically start at reboot? Thanks in advance. (2 Replies)
Discussion started by: shorty
2 Replies

7. Solaris

different between soft reboot and hard reboot

Hi Guru's Can any want here could explain to me the different between soft reboot and hard reboot . Best Regards Seelan (3 Replies)
Discussion started by: seelan3
3 Replies
Login or Register to Ask a Question