ORA-12162: TNS:net service name is incorrectly specified [solved]

When starting sqlplus, I ended up with following error message: ORA-12162: TNS:net service name is incorrectly specified

Elements to check:

  1. echo $ORACLE_HOME // make sure path points to appropriate oracle folder, if you don’t know the folder, run find / -name ‘startdb.sh’
  2. echo $PATH // make sure $ORACLE_HOME/bin is part of PATH (export PATH=$PATH:$ORACLE_HOME/bin)
  3. echo $ORACLE_SID // make sure appropriate value is set up in ORACLE_SID (export ORACLE_SID=orcl where ‘orcl’ is the name of the database being worked upon)

sources

Post a Comment

Your email is never published nor shared. You're allow to say what you want...