missymadi
asked on
Start Oracle database as a service on box
Experts,
How do I create a Oracle service on a Linux box to start when Linux boots? Right now I manually set the environment, log onto SQLPLUS start the db. Then run emctl start dbconsole. How can I put this as a serivice?
Thanks, MIssyMadi
How do I create a Oracle service on a Linux box to start when Linux boots? Right now I manually set the environment, log onto SQLPLUS start the db. Then run emctl start dbconsole. How can I put this as a serivice?
Thanks, MIssyMadi
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Is there an extension on the dbora file, such as, dbora.bat or dbora.txt?
No. Plain dbora
Make it executable
chmod +x /etc/init.d/dbora
Make it executable
chmod +x /etc/init.d/dbora
Make sure to set the ORA_HOME in the script to your correct path. It is the same as your ORACLE_HOME environment var.
Also, make sure /etc/oratab has the instance set to Y for auto-start to work. dbstart reads that file.
Then reboot the box and find out if it works! :)
Then reboot the box and find out if it works! :)
http://www.oracle-base.com/articles/linux/AutomatingDatabaseStartupAndShutdownOnLinux.php