Ora-12547: Tns:Lost Contact Creating Database After Clean Installation

Ora-12547: Tns:Lost Contact Creating Database After Clean Installation [ID 744512.1]
		修改时间 14-DEC-2011类型 PROBLEM 状态 PUBLISHED

In this Document
Symptoms
Cause
Solution
References

---

Applies to:

Oracle Server - Standard Edition - Version: 9.2.0.8 and later [Release: 9.2 and later ]
Oracle Server - Enterprise Edition - Version: 9.2.0.8 and later [Release: 9.2 and later]
Information in this document applies to any platform.

Symptoms

After a clean installation of the Oracle Database Server software the following error is seen when trying to create a database either manually or via DBCA:

> sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Sep 29 13:17:17 2008
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:

Cause

Insufficient ulimit setting for stack

Bug 4335746 STARTUP GIVES TNS LOST CONTACT , TRACES GIVE SKGM ERROR 27148 WITH ERROR CODE 1

When running a system trace (truss in this case) the following stack is produced

% truss -aefo /tmp/sqlplus.out sqlplus / as sysdba

sqlplus.out
-----------
23: lxstat(2, "/rdbms1/ora10gr2/rdbms/log/testdb_ora_23.trc", 0x08045AB8) Err#2 ENOENT
23: xstat(2, "/rdbms1/ora10gr2/rdbms/log/testdb_ora_23.trc", 0x08045AB8) Err#2 ENOENT
23: open("/rdbms1/ora10gr2/rdbms/log/testdb_ora_23.trc", O_WRONLY|O_CREAT|O_TRUNC|O_LARGEFILE,
0660) = 3
23: write(3, 0x0BED1F20, 0) = 0
23: write(3, " / r d b m s 1 / o r a 1".., 44) = 44
23: write(3, "\n", 1) = 1
23: write(3, " O r a c l e D a t a b".., 122) = 122
23: write(3, "\n", 1) = 1
23: write(3, " O R A C L E _ H O M E ".., 31) = 31
23: uname(0x0C4BF314) = 1
23: write(3, " S y s t e m n a m e :".., 19) = 19
23: write(3, " N o d e n a m e :\t o".., 19) = 19
23: write(3, " R e l e a s e :\t 5 . 1".., 14) = 14
23: write(3, " V e r s i o n :\t G e n".., 27) = 27
23: write(3, " M a c h i n e :\t i 8 6".., 15) = 15
23: write(3, " I n s t a n c e n a m".., 22) = 22
23: write(3, " R e d o t h r e a d ".., 47) = 47
23: write(3, " O r a c l e p r o c e".., 25) = 25
23: write(3, " U n i x p r o c e s s".., 43) = 43
23: write(3, "\n", 1) = 1
23: write(3, "\n", 1) = 1
23: brk(0x0C4DC778) = 0
23: brk(0x0C4DE778) = 0
23: open("/usr/share/lib/zoneinfo/US/Pacific", O_RDONLY) = 5
23: fstat64(5, 0x08045BD0) = 0
23: read(5, " T Z i f\0\0\0\0\0\0\0\0".., 1017) = 1017
23: close(5) = 0
23: write(3, " * * * 2 0 0 8 - 1 0 -".., 27) = 27
23: write(3, "\n", 1) = 1
23: write(3, " s k g m e r r o r 2".., 46) = 46
23: write(3, "\n", 1) = 1
23: _exit(0)
20: read(11, 0x0803FAF0, 64) = 0
20: close(11) = 0
20: close(10) = 0
20: getpid() = 20 [29981]
20: open64("/rdbms1/ora10gr2/sqlnet.log", O_WRONLY|O_APPEND|O_CREAT, 0666) = 9

sqlnet.log
--------------
***********************************************************************
Fatal NI connect error 12547, connecting to:


(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/rdbms1/ora10gr2/bin/oracle)(ARGV0=oracletestdb)(ARGS='

(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=sqlplus@o
mnibus)(HOST=omnibus)(USER=ora10g))))

VERSION INFORMATION:
TNS for Solaris: Version 10.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for Solaris: Version 10.2.0.2.0 - Production
TCP/IP NT Protocol Adapter for Solaris: Version 10.2.0.2.0 - Production
Time: 07-OCT-2008 09:05:34
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

testdb_ora_23.trc
-----------------
/rdbms1/ora10gr2/rdbms/log/testdb_ora_23.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /rdbms1/ora10gr2
System name: SunOS
Node name: omnibus
Release: 5.10
Version: Generic_118855-36
Machine: i86pc
Instance name: testdb
Redo thread mounted by this instance: 0 <none>
Oracle process number: 0
Unix process pid: 23, image: oracle@omnibus

*** 2008-10-07 09:05:34.880
skgm error 27128: errno = 1, info = 3, 0, 0, 0

Solution

1. Collect a system trace via OS command. See

Note 110888.1 How to Trace Unix System Calls

for the available trace command on your OS.

for example:

%truss -aefo /tmp/sqlplus.out sqlplus / as sysdba

2. Check system trace for log files and additional errors

3. Confirm what the current ulimit setting is for stack

% ulimit -a

Note 188149.1 How to Display and Change UNIX Process Resource Limits

4. Check the install guide for your specific platform and version of Oracle and set stack as stated.

example: ulimit -s -1 ** This is Unlimited, the recommended setting on AIX **

Note 188149.1 How to Display and Change UNIX Process Resource Limits

5. Confirm sqlplus now works

%sqlplus / as sysdba

References

NOTE:110888.1 - How to Trace Unix System Calls
NOTE:188149.1 - How to Display and Change UNIX Process Resource Limits

相关内容 产品 Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Standard Edition Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition 关键字 AFTER INSTALLATION; CREATE DATABASE; DBCA; INSTALL & CONFIGURE; INSTALLATION; SQLNET.LOG; TRUSS; ULIMIT 错误 TNS-12547; TNS-517; ORA-12547

返回页首

Copyright (c) 2007, 2010, Oracle. All rights reserved. Legal Notices and Terms of Use | Privacy Statement