Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle on Linux hints and tips

Re: Oracle on Linux hints and tips

From: Adam Monsen <adamm_at_wazamatta.com>
Date: 13 Apr 2004 16:16:23 -0700
Message-ID: <9b12ed8d.0404131516.a559dd4@posting.google.com>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US