ORACLE_HOME_LISTNER is not SET
Got this error when I used dbstart to startup all required instances: ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener.
This is because dbstart takes the first argument of this command as the database home path for listener to startup. Which means, this command will start both database and listener at the same time.
You can either add an argument right after dbstart every time you use it:
[oracle@test ~]$ dbstart $ORACLE_HOME
Or set the variable ORACLE_HOME_LISTNER to an explicit path in the script if you won’t change listener home path in the near future.
[oracle@test ~]$ vi `which dbstart`
It’s worth mentioning that there’s a missing letter “E” in the variable name ORACLE_HOME_LISTNER deliberately, which is NOT a typo. Can you tell that?
As for dbshut, it has the same story as dbstart: ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener.
Shell Scripts for Server Reboots
In addition to dbstart and dbshut, you may need a shell script to auto start and auto stop Oracle database on Linux. Or a shell script to auto start and auto stop Oracle database on Solaris.
You can find out more information about systematical startup and shutdown at Oracle documentation: Stopping and Starting Oracle Software