Home » Infrastructure » Linux » sqlplus ORA-12547: TNS:lost contact (RHEL5.1 x86_64 , oracle 11.1.0.6(x86_64) + oracle 11.1.0.7 patch(x86_64))
sqlplus ORA-12547: TNS:lost contact [message #378566] Tue, 30 December 2008 23:59 Go to previous message
bitmus
Messages: 3
Registered: December 2008
Junior Member
Dear All

i've installed RHEL 5.1 (x86_64)
and
installed oracle 11.1.0.6(x86_64) by oracle user, then patched oracle 11.1.0.7 patch(x86_64).

created db and all(dbstart and dbshut, lsnrctl) is ok when use oracle user.

also i have another os user who is member of dba.

but sqlplus gives ORA-12547: TNS:lost contact.

SQL*Plus: Release 11.1.0.7.0 - Production on Wed Dec 31 21:27:47 2008

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password: 
ERROR:
ORA-12547: TNS:lost contact


but there is no error when using sqlplus by oracle user.
i suspect there is something like file permission.

oracle user is
uid=501(oracle) gid=501(dba) groups=501(dba)
another os user is
uid=500(dbop) gid=500(dbop) groups=500(dbop),501(dba)

oracle folder is owned by orace:dba and has 775 permission.


just confused.
help, please.
Tnx
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Want to view .gz file contents from particular text onwards.
Next Topic: version of GCC for Oracle 11.2.0.4 on Linux 7
Goto Forum:
  


Current Time: Fri Mar 29 07:07:36 CDT 2024