Error in TNS-01201: Listener cannot find executablen

The TNS-01201: Listener cannot find executable... error message was recently received when the Listener was started. This error has never been encountered. I really don't know what it is. The following is a detailed description of the error and the solution.

 

1. fault description
# An TNS-01201 error was received when the listener was started, and the listener could not find the executable file
Oracle @ DevDB02: ~> Lsnrctl start LISTENER_USBO2

LSNRCTL for Linux: Version 10.2.0.3.0-Production on 06-JUN-2014 17:06:37

Copyright (c) 1991,200 6, Oracle. All rights reserved.

Starting/home/oracle/OraHome10g/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.3.0-Production
System parameter file is/home/oracle/OraHome10g/network/admin/listener. ora
Log messages written to/home/oracle/OraHome10g/network/log/listener_usbo2.log
Listening on: (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 192.168.1.202) (PORT = 1403 )))
TNS-01201: Listener cannot find executable/users/oracle/OraHome10g/bin/oracle for SID USBO2

Listener failed to start. See the error message (s) abve...

 

2. Fault Analysis
# Meatlink provides a description of this problem (Doc ID 22060.1)
# Check whether the ORACLE_HOME environment variable points to a valid location
Error: TNS 1201
Text: Listener cannot find executable % s for SID % s
-------------------------------------------------------------------------------
Cause: The executable for the Oracle dedicated server process cannot be
Found.
Action: Check the appropriate SID_DESC in LISTENER. ORA to make sure that
The ORACLE_HOME component is pointing to a valid location.
If this component is not set, then check the value of the ORACLE_HOME
Environment variable.
Comment: This error is reported only on UNIX platforms.

 

3. troubleshooting
# The oracle_home configured in the listener is different from the current ORACLE_HOME
Oracle @ DevDB02: ~> More $ ORACLE_HOME/network/admin/listener. ora
LISTENER_USBO2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.202) (PORT = 1403 ))
)
)
)

SID_LIST_LISTENER_USBO2 =
(SID_LIST =
(SID_DESC =
(Sid_name = USBO2)
(Oracle_home =/users/oracle/OraHome10g)
)
)

Oracle @ DevDB02: ~> Echo $ ORACLE_HOME
/Home/oracle/OraHome10g

# Because the listener Configuration content is directly copied from another machine, the new machine and the old machine use different ORACLE_HOME
# So I received the error message above. The following is the correct content. restart the system again
Oracle @ DevDB02: ~> Grep home $ ORACLE_HOME/network/admin/listener. ora
(Oracle_home =/home/oracle/OraHome10g)

References
RMAN configuration retention policy

Oracle Flash recovery area)

Snapshot control file)

Backup and recovery solution for small and medium databases rman catalog (1)

Backup and recovery solution for small and medium databases rman catalog (2)

Backup and recovery solution for small and medium databases rman catalog (III)

Block RECOVERY BASED ON RMAN)

Use DBMS_REPAIR to fix Bad blocks

Method for converting the cloned file location in the RMAN Database

RMAN duplicate)

RMAN-based database cloning on the same machine

User-managed database clone

Cloning from an active database based on RMAN (rman duplicate from active DB)

RMAN duplicate from active encountered ORA-17627 ORA-12154

Oracle cold backup

Oracle Hot Backup

Concept of Oracle backup recovery

Oracle instance recovery

Oracle recovery based on user management

SYSTEM tablespace management and Backup Recovery

SYSAUX tablespace management and recovery

Oracle backup control file recovery (unsing backup controlfile)

RMAN overview and architecture

RMAN configuration, Monitoring and Management

Detailed description of RMAN backup

RMAN restoration and recovery

Create and use RMAN catalog

Create RMAN storage script based on catalog

Catalog-based RMAN backup and recovery

RMAN backup path confusion

Customize the date and time format displayed by RMAN

Backup and recovery of read-only tablespace

Incomplete recovery of Oracle based on user management

Understanding using backup controlfile

Use RMAN for recovery from different machine backups (WIN platform)

Use RMAN to migrate a file system database to ASM

Oracle backup policy (RMAN) in Linux)

Linux RMAN backup shell script

Use RMAN to migrate the database to a different machine

Run the SQL statement at the RMAN prompt.

Oracle RMAN-based incomplete recovery (incomplete recovery by RMAN)

Rman restores archivelog)