Saturday, July 5, 2014

ERROR: ORA-12162: TNS:net service name is incorrectly specified


I just installed oracle software and trying to connect sqlplus

When I say sqlplus, it was giving an error.

-bash-3.00$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jul 6 00:54:32 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12162: TNS:net service name is incorrectly specified


Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified


Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
I forgot to export ORACLE_SID
I exported the ORACLE_SID and tried again, it was successful


-bash-3.00$ export ORACLE_SID=prod


-bash-3.00$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jul 6 01:04:52 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> exit
Disconnected
It was just a thought to share, to those who forgets like me !

Error 6 initializing SQL*Plus

When I tried to connect sqlplus was giving an error.


-bash-3.00$ sqlplus '/as sysdba'
Error 6 initializing SQL*Plus
Message file sp1.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory


Log out from the user and login again. Don't source any environment variables yet.
Check the location of your correct oracle home by going into the directory. Export the oracle home
-bash-3.00$ export ORACLE_HOME=/u01/oracle/product/10.2.0/db_1
-bash-3.00$ export PATH=$ORACLE_HOME/bin:$PATH:.

Now try log in again

-bash-3.00$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jul 6 01:04:52 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> exit

NLS boot file not found or invalid opmnctl ping – EBS 12.2 ADCFGCLONE FAIL

Error: adcfgclone.pl failed while performing clone of EBS 12.2 instance. This occurred while ohsT2PApply is in progress. INST_TOP/adm...