1. Opatch failed WITH error code 73.
You may get below message FOR the above error code
Running prerequisite CHECK..
prerequistie CHECK "CheckActiveFilesandExecutables" failed.
Following executables are active
/u0/abcd/db/tech_st/11.2.0/bin/oracle
UtilSession failed:prerequisite CHECK "CheckActiveFilesandExecutables" failed.
Opatch failed WITH error code 73.
To Fix this Issue:
CHECK
ps -ef | grep oracle
ps -ef | grep tns
oracle process may be running.
KILL the Oracle process.
KILL -9 process-id
2. ORA-12162 : TNS: net service name IS incorrectly specified
Sqlplus '/as sysdba'
The error message ORA-12162 IS very misleading, AS it suggests there IS a problem WITH the tnsnames.ora FILE CONTENTS.
To Fix this Issue:
export ORACLE_HOME=/u01/abcd/db/tech_st/11.1.0
export ORACLE_SID=ABCD (Your SID)
