![]() |
|
|
|
|
|||||||
| Forums | Portal | Register | Forum Rules | FAQ | Contribute | Members List | Arcade | Search | Today's Posts | Mark Forums Read |
| 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 !! |
|
|
||||
| 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 |
|
|
Submit Tools | LinkBack | Thread Tools | Display Modes |
|
|||
|
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 | ||
|
|
|
|||
|
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. |
|
|||
|
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. |
|
|||
|
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 |