What to do after ORA-12162?

After installing Oracle XE on Debian I got into problems with connection to Oracle's instance. Every connection ended with error 'ORA-12162 TNS:net service name is incorrectly specified' Resolution is very simple - you only have to set correct environment variables:

    export ORACLE_SID=XE
    export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
 

and that's all After that you should also make this change permanent by writing those settings to shell initialization file. For Debian it will be /etc/profile (globally) or per user (.bashrc in user directory) I'm really missing /etc/env.d directory from Gentoo distro...

Comments

Raynes

Raynes wrote

You've ipmressed us all with that posting!

Comment