The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
Google UNIX.COM


UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
start a script from another tty moka Shell Programming and Scripting 1 05-05-2008 05:31 AM
Start up script Mr Pink Shell Programming and Scripting 1 03-09-2007 03:14 AM
script to start DB didn't work, help duke0001 Shell Programming and Scripting 0 02-16-2007 08:02 AM
Set start point in script handak9 Shell Programming and Scripting 2 04-19-2005 05:46 AM
Start/Stop Script jjv1 UNIX for Dummies Questions & Answers 2 12-16-2003 12:28 PM

Closed Thread
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 07-20-2001
Registered User
 

Join Date: Jul 2001
Location: US
Posts: 17
Post Start Up Script

guys/gals...does anyone have a startup shell script for oracle/sybase...meaning at shutdown the databases stop themselves and at start up they start automatically...thanks much...
Forum Sponsor
  #2 (permalink)  
Old 07-21-2001
Registered User
 

Join Date: May 2001
Location: Bay Area
Posts: 25
You don't need it.

I thought the same thing.

When you send an init 0-6 at the machine, oracle is capable of picking up where it left off. Unless you have the poopiest DBA in the world, you might lose 5 mins worth of data but thats it.

I tried this once until my DBA talked to me about it. It was damn near impossible to get the script to execute commands within the Oracle Admin (the listner) from a script. I was complileing C++ code for this.

  #3 (permalink)  
Old 07-21-2001
Registered User
 

Join Date: Nov 2000
Location: India
Posts: 83
hi

This is related to solaris and oracle.
you can write your own script
for e.g
the normal commands that I issue to bring down a database is

svrmgrl
connect internal
shutdown immediate or shutdown normal.

( These are commands which i use to bring my database down.Yours may be different.)

now you can place these commands in a script file and have the script file execute when your system shuts down i.e in the directory where your run level 0 scripts are placed. ALso all the script files that bring down one or more services start with Alphabet K followed by a number. Similiar script for starting the database can be made and suppose if your system comes up at run level 3 then you need to place the startup script in the directory where your other run level 3 scripts are placed or in the directory where your other run level 2 scripts (run level 2 , i am saying b'cos run level 2 is an intermediate state when your system comes up in run level 3). Also the startup script should start with alphabet S followed by a number.
ALso in all these scripts your ORACLE_HOME and ORACLE_SID parameter should be set otherwise you will get the sqllang error. Verify the startup and shutdown scripts by your DBA after you are done with them

Last edited by kapilv; 07-21-2001 at 10:23 AM.
  #4 (permalink)  
Old 07-23-2001
Registered User
 

Join Date: Jul 2001
Location: US
Posts: 17
Thanks guys. I am fully aware of the S & K scripts.In my last company we had start and shutdown scripts for oracle, infact for all applications. I will write the scripts and see how it goes. Thanks again for your help.
Google The UNIX and Linux Forums
Closed Thread

Thread Tools
Display Modes




All times are GMT -7. The time now is 09:11 PM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008. All Rights Reserved.Ad Management by RedTyger Visit The Global Fact Book

Content Relevant URLs by vBSEO 3.2.0