Ora-12547: Tns:Lost Contact Creating Database After Clean Installation
来源:互联网 发布:淘宝直播排名规则 编辑:程序博客网 时间:2024/05/17 18:42
Ora-12547: Tns:Lost Contact Creating Database After Clean Installation [ID 744512.1]
修改时间 14-DEC-2011类型 PROBLEM状态 PUBLISHED
Oracle Server - Enterprise Edition - Version: 9.2.0.8 and later [Release: 9.2 and later]
Information in this document applies to any platform.
Note 110888.1 How to Trace Unix System Calls
for the available trace command on your OS.
for example:
2. Check system trace for log files and additional errors
3. Confirm what the current ulimit setting is for stack
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
NOTE:188149.1 - How to Display and Change UNIX Process Resource Limits
产品
AFTER INSTALLATION; CREATE DATABASE; DBCA; INSTALL & CONFIGURE; INSTALLATION; SQLNET.LOG; TRUSS; ULIMIT错误
TNS-12547; TNS-517; ORA-12547
修改时间 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:
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
-----------
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
--------------
***********************************************************************
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
-----------------
/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. SeeNote 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 CallsNOTE: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
- Ora-12547: Tns:Lost Contact Creating Database After Clean Installation
- ORA-12547: TNS:lost contact
- ORA-12547: TNS:lost contact
- ORA-12547: TNS:lost contact
- ORA-12547: TNS:lost contact
- ORA-12547: TNS:lost contact
- ORA-12547:TNS:lost contact
- ORA-12547: TNS:lost contact
- ORA-12547: TNS:lost contact
- ORA-12547: TNS:lost contact 错误处理
- relink处理ORA-12547:TNS:lost contact
- ORA-12547: TNS:lost contact 解决方法
- dbca ora-12547 tns lost contact
- ORA-12547: TNS:lost contact错误解决方法
- TNS-12547: TNS:lost contact
- TNS-12547: TNS:lost contact
- 启动ArcSDE服务报:“ORA-12547: TNS:lost contact”
- ORA-12547: TNS:lost contact - Oracle执行文件权限问题
- error LNK2019: 无法解析的外部符号
- EXT JS学习网站
- 神舟III号 USART-COM1工程配置
- PostgreSQL启动过程中的那些事七:初始化共享内存和信号十七:shmem中初始化AutoVacuum相关结构
- Launcher源码初探
- Ora-12547: Tns:Lost Contact Creating Database After Clean Installation
- SI信号完整性分析术语
- Android横竖屏限制切换
- 第八周任务四——关于分数与整数运算一各种运算符的重载
- 软件开发之结构化分析与设计
- DBCA error while loading shared libraries: cannot restore segment prot after reloc [ID 956792.1]
- apress
- Eclipse安装ADT Plugin时发生错误,提示连接不到 https://dl-ssl.google.com/android/eclipse/...的解决办法!
- Linux内核的ioctl函数学习