sqlplus ORA-12547: TNS:lost contact [message #378566] |
Tue, 30 December 2008 23:59 |
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
|
|
|