[BNM] Accessing Oracle Db on AIX

[Quentin North (noisy)]

Key questions for Oracle on AIX:

Is you $ORACLE_HOME environment variable set correct?

Is $ORACLE_HOME/bin in your PATH?

Is $ORACLE_HOME/lib in your LD_LIBRARY_PATH?

Is $ORACLE_SID set to the correct db name?

Is $TNS_ADMIN set to $ORACLE_HOME/network/admin?

Is $NLS_LANG set correctly? (should be similar to ENGLISH_UNITED  
KINGDOM.WE8ISO8859P15 or AL32UTF8)

Is $LANG set to something like en_US?

Is $ORACLE_HOME/JRE/lib in your $CLASSPATH?

Have you tried TNSPING? (tnsping <dbname>) if that works most of the  
environment should be correct and it will just be down to the language.

Is Oracle client or database correctly installed (run the installer  
to check)?

Are you using full or instant client?

Is the instance running on the same server?

HTH

Q