www.dbatoolz.com › ORACLE DBA Forums › Solutions › Topic Id: 2830 | Permalink

HTTP-503 ORA-12514 because nobody - can't read tnsnames.ora

Topic ID: 2830
Created By:	2007-DEC-28 16:19:36 [Vitaliy]
Updated By:	2007-DEC-28 16:19:36 [Vitaliy]
Status:	Open
Severity:	Normal
Read Only:	No

8644

2007-DEC-28 16:19:36

Vitaliy

Moderator

Registered On: Mar 2006

Total Posts: 267

Issue

You've switched your Oracle Application server to run as nobody:nobody and none 
of your mod_plsql based applications are working with the following error 
reported in the error_log:

HTTP-503 ORA-12514

SOLUTION

chmod a=r,u=rw $ORACLE_HOME/network/admin/tnsnames.ora
chmod a=r,u=rw $ORACLE_HOME/network/admin/sqlnet.ora

hostname.oraas-> ls -l $ORACLE_HOME/network/admin
total 24
drwx------  2 applmgr oinstall 4096 Dec 14 17:48 samples
-rwx------  1 applmgr oinstall  172 Dec 14 17:48 shrept.lst
-rw-r--r--  1 applmgr oinstall  134 Dec 21 19:48 sqlnet.ora
-rw-r--r--  1 applmgr oinstall  210 Dec 21 19:48 tnsnames.ora
hostname.oraas->

This is caused by the fact that USER nobody - can't read tnsnames.ora

Permalink