- /etc/tnsnames.ora MUST have UNIX line endings. If you see ^M
characters at the end of every line when you do 'cat -v
/etc/tnsnames.ora', execute the command 'dos2unix /etc/tnsnames.ora'
(I've seen sqlplus fail because of this but not issue a warning)
- /etc/tnsnames.ora should have permissions set to rw-r--r-- (0755)
and should be owned by root (I've seen sqlplus fail because of this
but not issue a warning)
- the ORACLE_HOME environment variable needs to be set to the root of
your oracle installation
Anyone have any corrections/additions/comments/suggestions?
Received on Wed Apr 07 2004 - 18:28:57 CDT