Re: Oracle on Linux hints and tips

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sat, 10 Apr 2004 07:58:37 -0700
Message-ID: <1081609101.637014@yasure>

Mark Bole wrote:

> Adam Monsen wrote:
>

>> 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)
>>

> [...]
>

>>
>> Anyone have any corrections/additions/comments/suggestions?

>
>
> If you want support from Oracle Corp. you won't edit the TNSNAMES.ORA
> file by hand or copy if from one disparate platform to another. ;-)
>
> Officially, you're supposed to use the Net8 config assistant native to
> your platform, which will avoid this problem.
>
> Realistically, as you have discovered, the newline convention in the
> Unix world differs from that in the WinDOS world (and guess which one
> came first!) If you "ftp" the file using the default transfer mode
> (ASCII), that will also avoid this problem, as well as the "dos2unix"
> and "unix2dos" utilities that you mention.
>
> --Mark Bole

TNSNAMES files must be edited ... there are entries in the file that may be required and can not be entered by the configuration assistant. Among them ... some of those required for RAC.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Sat Apr 10 2004 - 09:58:37 CDT