| 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
|
|
|
|
|
|
|
|
|
|
| Re: sqlplus ORA-12547: TNS:lost contact [message #378869 is a reply to message #378566] |
Fri, 02 January 2009 03:51  |
bitmus
Messages: 3
Registered: December 2008
|
Junior Member |
|
|
ok. tnx for reply.
what i have now is:
os user oracle and dbop.
uid=501(oracle) gid=501(dba) groups=501(dba)
uid=500(dbop) gid=500(dbop) groups=500(dbop),501(dba)
oracle application directory /u01/oracle/product
oracle db directory /u02/oracle/dbs
database sid name is mysid.
database is created by oracle user.
those 2 folder itself and all subdirs and files of those 2 folders are owned by user oracle and group dba.
permission is set to 775(all subdirs and files).
1. oracle user
[oracle@testb ~]$env | grep ORA
ORACLE_SID=mysid
ORACLE_HOME=/u01/oracle/product
[oracle@testb ~]$env | grep TNS
[oracle@testb ~]$ sqlplus sys as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Sat Jan 3 01:10:08 2009
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@testb ~]$ sqlplus system
SQL*Plus: Release 11.1.0.7.0 - Production on Sat Jan 3 01:10:15 2009
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
2. dbop user
[dbop@testb ~]$env | grep ORA
ORACLE_SID=mysid
ORACLE_HOME=/u01/oracle/product
[dbop@testb ~]$env | grep TNS
[dbop@testb ~]$ sqlplus sys as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Sat Jan 3 01:16:11 2009
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:
[dbop@testb ~]$ sqlplus system
SQL*Plus: Release 11.1.0.7.0 - Production on Sat Jan 3 01:16:19 2009
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:
Also i have found some messages in /u01/oracle/product/log/diag/clients/user_dbop/host_2398143949_11/trace/sqlnet.log
Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/oracle/product/bin/oracle)(ARGV0=oraclemysid)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRES S=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=sqlplus)(HOST=testb)(USER=dbop))))
VERSION INFORMATION:
TNS for Linux: Version 11.1.0.7.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
Time: 03-JAN-2009 01:16:24
Tracing not turned on.
Tns error struct:
ns main err code: 12547
TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517
TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
Thanks.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: sqlplus ORA-12547: TNS:lost contact [message #659779 is a reply to message #659768] |
Mon, 30 January 2017 08:33 |
 |
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
So why saying "Another possible solution to ORA-12547 TNS LOST CONTACT for HP-UX"
And no, it does not work.
It works IF the problem was about privileges on /dev/null and does not for ALL other causes something you don't know and won't ever know as OP did not come back since January 2009.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
