Tag Archives: oracle

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: 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 http://docs.oracle.com/cd/E11882_01/server.112/e10897/em_manage.htm#ADMQS12369

installing oracle XE 11gR2 on linux mint 16

Collection of steps identified to have oracle up and running. Part1. Setting up required packages, groups, users and folders make sure your distro is up to date then reboot sudo apt-get update sudo apt-get dist-upgrade sudo shutdown -r now install pre-requisite packages sudo apt-get install alien build-essential gawk ksh libtool libmotif3 libaio1 ensure your shell points to bash shell sudo ln -sf /bin/bash /bin/sh create necessary users and groups sudo addgroup oinstall sudo addgroup dba sudo addgroup nobody sudo usermod -g nobody nobody sudo useradd -g oinstall -G dba -p password -d /home/oracle -s /bin/bash oracle sudo passwd oracle // […]