Oracle 11g Release 2 Oracle Linux Enterprise 5.10
[oracle@dub-ImrORA3 scripts]$ id oracle
uid=502(oracle) gid=502(oinstall) groups=502(oinstall),503(dba),504(oper) context=user_u:system_r:unconfined_t
We recently changed the oracle id to 502 and the group oinstall to 502.
Everything under the $ORACLE_HOME/bin is owned by oracle:oinstall
Since this change we can only connect locally to the database using IPC. When we try to connect remotely using TCP we the error => ORA-12537: TNS:connection closed
When the oracle user tries to stop the LISTENER we get the TNS-01190 error.
[oracle@dub-ImrORA3 bin]$ ls -al lsnrctl
-rwxr-x--x 1 oracle oinstall 153535 Nov 26 09:45 lsnrctl
Is this an ownership/permission issue? How to resolve?
ps
. If not, that'll be the problem - the running processes would be horribly confused.cd $ORACLE_HOME; chown -R oracle:dba bin lib lib32 network
- anyway, you've messed it up by taking shortcuts