Set up Oracle Auto-start

1. After installing the Oracle database: Execute Dbstart and Dbshut will prompt:

[Email protected] ~]$ Dbstart
Oracle_home_listner is isn't SET, unable to auto-start Oracle Net Listener
Usage:/u01/app/oracle/oracle/product/10.2.0/db_1/bin/dbstart oracle_home

The cause of the error is: There is a problem with the Oracle_home_listner settings in the Dbstart and Dbshut script files, open two files respectively. Found: oracle_home_listner=$1, modified to

Oracle_home_listner= $ORACLE _home, the command is as follows:

[Email protected] ~]$ VI $ORACLE _home/bin/dbstart

[email protected] ~]$ VI $ORACLE _home/bin/dbshut

after the modification save exits, the first issue has been resolved;

2. How to automatically start Oracle monitoring and instance at Linux boot time

First of all to solve the above problem, can continue yo!

The first step: Modify the/etc/oratab file with the following command:

[Email protected] ~]$ Vi/etc/oratab

Find: oauat:/u01/app/oauat/product/11.2.0/db_1:n modified to: oauat:/u01/app/oauat/product/11.2.0/db_1:y

Step Two: Add Lsnrctl start and Dbstart to the rc.local file with the following command:

[Email protected] ~]$ vi/etc/rc.d/rc.local

Add :

Su oracle-lc "/u01/app/oauat/product/11.2.0/db_1/bin/lsnrctl start"
Su Oracle-lc/u01/app/oauat/product/11.2.0/db_1/bin/dbstart

Note: The first command has a space, so use quotation marks

Reboot and try it!

This article is from the "strive to the front" blog, please be sure to keep this source http://liucb.blog.51cto.com/3230681/1590773

Set up Oracle Auto-start