Re: Oracle on Linux hints and tips

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

root ownership? No - never have seen that:

[oracle_at_csdb01 oracle]$ ls -l /opt/oracle/920/network/admin/tnsnames.ora -rw-r--r-- 1 oracle oinstall 713 Jan 3 15:09 opt/oracle/920/network/admin/tnsnames.ora

I think root ownership will add possibilities for hackers (there _are_ alerts on buffer overflows on Metalink!)

Don't run listener as root, either

-- 

Regards,
Frank van Bortel