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