Re: Oracle on Linux hints and tips

From: DJ <nospamplease_at_goaway.com>
Date: Thu, 8 Apr 2004 19:37:07 +0100
Message-ID: <MYgdc.644$D%6.441@newsfe3-win.server.ntli.net>

"Adam Monsen" <adamm_at_wazamatta.com> wrote in message news:9b12ed8d.0404071528.537c1ea_at_posting.google.com...
> 1. /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)
>
> 2. /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)
>
> 3. the ORACLE_HOME environment variable needs to be set to the root of
> your oracle installation
>
> Anyone have any corrections/additions/comments/suggestions?

tnsnames file owned by root - no need for that

ORACLE_HOME doesnt need to be set to the root of the oracle installation it needs to be set to your oracle home!

why is your tnsnames file in /etc it really belongs in $ORACLE_HOME/network/admin Received on Thu Apr 08 2004 - 13:37:07 CDT