Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle on Linux hints and tips
"DJ" <nospamplease_at_goaway.com> wrote in message news:<MYgdc.644$D%6.441_at_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
Excellent point. A user designated solely for modifying this file would be a better choice as owner for this file, but you're right that it doesn't need to be owned by anyone in particular.
[...]
> why is your tnsnames file in /etc it really belongs in
> $ORACLE_HOME/network/admin
What I usually do is symlink $ORACLE_HOME/network/admin/tnsnames.ora to /etc/tnsnames.ora with 'ln -s', this way I only have to maintain the file in one place.
Others: thank you for your suggestions! This thread was helpful for me. Received on Tue Apr 13 2004 - 18:16:23 CDT