When starting sqlplus, I ended up with following error message: ORA-12162: TNS:net service name is incorrectly specified
Elements to check:
- echo $ORACLE_HOME // make sure path points to appropriate oracle folder, if you don’t know the folder, run find / -name ‘startdb.sh’
- echo $PATH // make sure $ORACLE_HOME/bin is part of PATH (export PATH=$PATH:$ORACLE_HOME/bin)
- 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