1. How to start Oracle Listening and instance automatically when Linux starts
Modify the/etc/oratab file with the following command:
[oracle@oracle11g ~]$ Vi/etc/oratab
Found: Accp:/u01/oracle:n modified to: accp:/u01/oracle:y
Step Two: add lsnrctl start and Dbstart to the rc.local file with the following commands:
[oracle@oracle11g ~]$ vi/etc/rc.d/rc.local
Add to:
Su oracle-lc "/u01/oracle/bin/lsnrctl start"
Su Oracle-lc/u01/oracle/bin/dbstart
2. Executive Dbstart and Dbshut will prompt:
[oracle@oracle11g ~]$ 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 reason for the error is: There is a problem with the Oracle_home_listner settings in the Dbstart and Dbshut script files, open two files respectively to find: oracle_home_listner=$1, modified to
Oracle_home_listner= $ORACLE _home, the order is as follows:
[oracle@oracle11g ~]$ VI $ORACLE _home/bin/dbstart
[oracle@oracle11g ~]$ VI $ORACLE _home/bin/dbshut
PS: The first command has spaces, so use quotation marks