APPLIES TO:
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
SYMPTOMS
While executing the $ORACLE_HOME/bin/dbstart it fails with an error similar to the following:
$ dbstart
ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
Usage: /u01/app/oracle/product/10.2.0/bin/dbstart ORACLE_HOME
CAUSE
This error is documented in unpublished Bug
Bug 4509652 - Abstract: INSTALL:050624:$OH/BIN/DBSTART FAILED TO START NET LISTENER IN DB 10.2.0:SIDB
The fix is included in 10.2.0.2. However, the problem can still be found in 10.2.0.3 (at least on some OS platforms, including HP-UX Itanium).
SOLUTION
If the issue is not solved with patch set 10.2.0.2, please use the following workaround.
To resolve this issue, pass the ORACLE_HOME directory that contains "bin/tnslsnr" as a parameter to dbstart.
For example:
dbstart $ORACLE_HOME
-- OR --
dbstart /u01/app/oracle/product/10.2.0
The dbstart script will expect to find "bin/tnslsnr" under the directory you specify.
You will need to do the same for dbshut if you want to stop the listener using dbshut.
For example:
dbshut $ORACLE_HOME
-- OR --
dbshut /u01/app/oracle/product/10.2.0
