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

简介: Ora-12547: Tns:Lost Contact Creating Database After Clean Installation [ID 744512.
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

目录
相关文章
|
11月前
|
SQL Oracle 关系型数据库
Backup and Recovery User‘s Guide 学习笔记
For each file that is not listed in the CREATE CONTROLFILE statement but is present in the data dictionary, an entry is created for them in the control file. These files are named as MISSINGnnnnn, where nnnnn is a 5-digit number starting with 0
|
Oracle 关系型数据库
Creating ASMSNMP User reports ORA-15306
In this Document  Symptoms   Cause   Solution Applies to: Oracle Server - Enterprise Edition - Version: 11.
1324 0
|
机器学习/深度学习 Oracle 关系型数据库