ORA-01078:failureinprocessingsystemparameters
ORA-01565:errorinidentifyingfile'+DG1/gffdb/spfilegisdb.ora'
ORA-17503:ksfdopn:2Failedtoopenfile+DG1/gisdb/spfilegisdb.ora
ORA-12547:TNS:lostcontact
Troubleshooting ORA-12547 TNS: Lost Contact [ID 555565.1]
|
|
|
修改时间 30-NOV-2011类型 TROUBLESHOOTING状态 PUBLISHED |
|
In this Document
Purpose
Last
Review Date
Instructions
for the Reader
Troubleshooting
Details
Bequeath
(Local) :
Remote
Connections:
Listener
specific :
Diagnosis
:
References
Applies to:
Oracle Net Services - Version: 9.2.0.1.0 to 11.1.0.6.0 - Release: 9.2 to 11.1
Information in this document applies to any platform.
Purpose
Step by Step Troubleshooting Guide for ORA-12547 TNS LOST CONTACT error faced while using Oracle Database server.
Last Review Date
September 21, 2010
Instructions for the Reader
A Troubleshooting Guide is provided to assist in debugging a specific issue. When possible, diagnostic tools are included in the document to assist in troubleshooting.
Troubleshooting Details
Background / Why ORA-12547
12547 indicates that the communication channel has been broken.
It'smost often thrownbecause the other end of the process went away unexpectedly.
Known Scenarios / Where ORA-12547 can Occur
This error can occur in following scenarios:
Bequeath (Local) :
The following/below are common scenarios in which 12547 occurs while making a BEQ
connection.
Problem:-
BEQ connection fails when connecting with / as sysdba
Cause:-
Oracle binaries have not been linked correctly
Solution :-
relink the Oracle binaries by executing the following command :
$ ORACLE_HOME/bin relink all
(OR)
Cause :-
Shared memory segment and/or semaphores are not flushed properly.
A system level trace taken while connecting to the database " / as sysdba " reveals the following :
2654: write(5, " O R A - 0 0 6 0 0 : i".., 81) = 81
2654: write(5, "\n", 1) = 1
2654: write(5, " O R A - 2 7 1 0 0 : s".., 45) = 45
Solution :-
Please identify and clear the problematic memory segment and semaphores.
The following metalink document describes the steps in detail.
Note 381566.1 connect / as sysdba Fails with Ora-12547 And Tns-12514
(OR)
Cause :-
External Shared Memory is configured in the environment.Extended Shared Memory is not supported by Oracle and should not be set/exist in the environment.
Truss of sqlplus connection shows a trace file being generated in $ORACLE_HOME/rdbms/log directory instead of the BDUMP location.
Excerpt from truss output:
569536: statx("/opt/oracle/oracle/product/11.1.0/rdbms/log/mdsp_ora_569536.trc", 0x0FFFFFFFFFFF7DF0, 176, 01) = 0
569536: statx("/opt/oracle/oracle/product/11.1.0/rdbms/log/mdsp_ora_569536.trc", 0x0FFFFFFFFFFF7DF0, 176, 0) = 0
569536: open("/opt/oracle/oracle/product/11.1.0/rdbms/log/mdsp_ora_569536.trc", O_WRONLY|O_APPEND|O_LARGEFILE) = 3
569536: kwrite(3, " D u m p f i l e ", 10) = 10
569536: kwrite(3, " / o p t / o r a c l e /".., 63) = 63
569536: kwrite(3, "\n", 1) = 1
569536: kwrite(3, "\n * * * 2 0 0 9 - 0 2".., 29) = 29
569536: kwrite(3, " O r a c l e D a t a b".., 200) = 200
Solution :-
1. Unset the EXTSHM environment variable in the session where you are connecting to database:
unsetenv EXTSHM
2. Run sqlplus:
sqlplus / as sysdba
(OR)
Cause :-
The ulimit settings for 'open files' and 'pipe size' is very low
Truss on sqlplus may look like :
4074: shmat(9, 0x380000000, 040000) = 0x380000000
4074: Incurred fault #6, FLTBOUNDS %pc = 0x100E59824
4074: siginfo: SIGSEGV SEGV_MAPERR addr=0x000006C0
4074: Received signal #11, SIGSEGV [caught]
4074: siginfo: SIGSEGV SEGV_MAPERR addr=0x000006C0
4074: lwp_sigmask(SIG_SETMASK, 0x9FBEF457, 0x0000FFF7) = 0xFFBFFEFF [0x0000FFFF]
4074: lwp_sigmask(SIG_SETMASK, 0x9FBEF057, 0x0000FFF7) = 0xFFBFFEFF [0x0000FFFF]
4074: Incurred fault #6, FLTBOUNDS %pc = 0x100E5BD3C
4074: siginfo: SIGSEGV SEGV_MAPERR addr=0x00000008
Solution:-
Increase the open files and pipe size (optional) resource limit to a higher value with ulimit
Problem :-
Bequeath connections fail with ORA-12547.
Remote connections fail with ORA-12500.
The below error stack is noticed in the listener log followed by a operating system error :
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
The version of the database server is 9.2.0.2
Cause :-
This issue is identified as unpublished Bug 2654576 which is raised when the processes value reaches a limit.
Solution :-
The bug is fixed in patch set 9.2.0.3 and in 10g.
The workaround will be :
1. Increase the PROCESSES parameter in the init.ora to a large value say 2000.
2. If increasing the PROCESSES parameter did not help, than the the following parameter in init.ora along with increasing the processes parameter.
_attach_count_slack = 2000
Remote Connections:
The following/below are common scenarios in which 12547 occurs while making a TCP connection.
Problem :-
Remote connections to the database server fail with ORA-12547
Cause :-
SQLNET.INBOUND_CONNECT_TIMEOUT and/or INBOUND_CONNECT_TIMEOUT_listener_name is set in the database server's sqlnet.ora and listener.ora
If the client fails to establish a connection and complete authentication in the time specified, then the database server terminates the connection.
From 10g and higher ORA-3136 errors may appear in the alert.log
Solution :-
Tune the parameters SQLNET.INBOUND_CONNECT_TIMEOUT and/or INBOUND_CONNECT_TIMEOUT_listener_name to appropriate values.
The database server and the listener has to be restarted for these parameters to take effect.
(OR)
Cause :-
TCP.VALIDNODE_CHECKING is active on the database server and the TCP.INVITED_NODES list does not have the IP address of the failing client.
Alternatively the TCP.EXCLUDED_NODES list contain the IP address of the failing client.
Solution :-
Either add the IP address of the failing client in the TCP.INVITED_NODES list or remove it from the TCP.EXCLUDED_NODES list
It is recommended to restart the database server and the listener for these parameters to take effect.
Listener specific :
Problem :-
Listener is failing to start with the error ORA-12547.
Cause :-
TCP.VALIDNODE_CHECKING is active on the database server and the TCP.INVITED_NODES list does not have the IP address of the Database server specified in the address definition of the listener.
Alternatively the TCP.EXCLUDED_NODES list contain the IP address of the Database server specified in the address definition of the listener.
Solution :-
Either add the IP address of the Database server in the TCP.INVITED_NODES list and remove it from the TCP.EXCLUDED_NODES list if present
It is recommended to restart the database server and the listener for these parameters to take effect.
Problem :-
This is specific to the listener versions below 9.2
Attempt to set the lsnrctl feature SAVE_CONFIG_ON_STOP to ON and stopping the listener further result in ORA-12547. A core dump or Dr. Watson error may follow the error.
Cause :-
In the listener.ora if the SID_LIST_<listener_name> section exceeds 2048 Bytes, the SAVE_CONFIG_ON_STOP feature fails with TNS errors.
This behavior is filed as unpublished BUG1965005 .
Solution :-
This bug is fixed in Oracle version 9.2.
The work around for this would be to keep the size of the SID_LIST with in 2048 bytes .
Problem:-
After changing variables in /etc/system and rebooting), the 10g R2 TNS Listener will not start.
lsnrctl> start
Starting /u01/oracle/product/10.2.0/Db_1/bin/tnslsnr: please wait...
TNSLSNR for Solaris: Version 10.2.0.1.0 - Production
System parameter file is /u01/oracle/product/10.2.0/Db_1/network/admin/listener.ora
Log messages written to /u01/oracle/product/10.2.0/Db_1/network/log/listener.log
Trace information written to /u01/oracle/product/10.2.0/Db_1/network/trace/listener.trc
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server11)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc10)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server11)(PORT=1521)))
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Solaris Error: 131: Connection reset by peer
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=extproc10)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Solaris Error: 146: Connection refused
Cause:-
Issue is due to a DNS client process, 'BIND 9' not running/started on the Solaris 10 Server.
"BIND allows DNS clients and applications to query DNS servers for the IPv4 and IPv6 networks.
BIND includes two main components: a stub resolver API, resolver(3resolv), and the DNS name server
with various DNS tools."
Reference:
http://docs.sun.com/app/docs/doc/817-0547/6mgbdbsna?a=view
Solaris 10 Release and Installation Collection--> Solaris 10 What's New--> 2. What's New in the
Solaris 10 3/05 Release -->Freeware Enhancements
Solution:-
Contact the System Administrator to start the BIND 9 DNS Client on the Solaris10 Server.
Diagnosis :
If the above discussed scenarios did not help than please collect the following diagnostic information and the provide the same while logging a service request .
The diagnosis on this error depends on the context or the scenario in which the error is occurring:
1. If the error is occurring during the connection establishment from a remote installation than
a. Enable a support level client, listener and server side SQLNET traces.
Reproduce the issue or wait until the error reoccurs and upload the corresponding traces .
Note 395525.1How to Enable Oracle SQLNet Client , Server , Listener , Kerberos and External procedure Tracing from Net Manager
b. Upload the SQLNET.ORA, LISTENER.ORA of the database server.
c. From the client where connection fails, check whether telnet to the listener port works.(expected to bring a blank screen)
$ telnet <database server hostname/ IP> <listener port>
2. If the error is occurring on a remote installation after connection establishment than
a. Enable a support level client and server side SQLNET traces.
Reproduce the issue or wait until the error reoccurs and upload the corresponding traces .
b. From the client where connection fails, check whether telnet or putty to the database server also fails with idle time.
$ telnet <database server hostname/ IP>
3. If the error occurs while performing listener operations than
a. Enable a support level Listener traces.
Reproduce the issue and upload the corresponding traces.
Please see the other referenced documents for more information.
References
NOTE:372143.1 - ORA-12547 connecting to sqlplus '/ as sysdba' on AIX
NOTE:381566.1 - connect / as sysdba Fails with Ora-12547 And Tns-12514
NOTE:395525.1 - How to Enable Oracle SQLNet Client , Server , Listener , Kerberos and External procedure Tracing from Net Manager
NOTE:422173.1 - ORA-12547: TNS:Lost Contact From SqlPlus
相关内容
产品
- Oracle Database Products > Oracle Database > Net Services > Oracle Net Services
关键字
INBOUND_CONNECT_TIMEOUT; LISTENER; LSNRCTL START; SQLNET.INBOUND_CONNECT_TIMEOUT; START LISTENER |
错误
TNS-12541; TNS-12500; TNS-511; TNS-12547; TNS-517; TNS-12560; TNS-12514; ORA-12547; ORA-12500; ORA-3136 |
|
分享到:
相关推荐
ORA-12154: TNS: 无法解析指定的连接标识符的解决方法
oracle报错ora-12541:TNS无监听程序
最近在工作中遇到了一个问题,错误是Oracle dbca时报错:ORA-12547: TNS:lost contact,通过查找相关的资料终于找到了解决的方法,下面分享给大家,话不多说了,来一起看看详细的介绍吧。 环境: OS:RHEL6.5 x86-...
ora-12514:TNS:监听程序当前无法识别连接描述符中请求的服务bug,解决文档.
ora-01033:oracle initialization or shutdown in progress 解决方法 ora-01033:oracle initialization or shutdown in progress 解决方法 ora-01033:oracle initialization or shutdown in progress 解决方法 ora-...
解决ORACLE TNS: 无法解析指定的连接标识符; 里面有步骤
ORA-00031:标记要终止的会话解决方案; ORA-00031:标记要终止的会话解决方案;
ORA-32001:write to spfile requested but no spfile is in use请求写入spfile,但没有使用spfile的解决方法 在输入以下语句中报了这样的错误: SQL>alter system set control_files=’/u01/app/oracle/oradata/prod/...
在运行查询SELECT * FROM V$SESSION 会出现ORA-29275:部分多字节字符的错误,这是什么原因开始我不得其解,网上也没有介绍什么好办法。本文给出答案。
ORA-01036:非法的变量名/编号 oracle特有的错误
oracle远程连接服务器出现 ORA-12170 TNS:连接超时 解决办法,需要的朋友可以参考一下
调整参数后引起,ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 3 2768M 的解决方案
oracle12c程序连接时异常: ORA-01017: 用户名/口令无效; 登录被拒绝 的解决方案。
ORA-12518 TNS:监听程序无法分发客户机连接,在您安装好数据库后配置连接数据库的过程中遇到这类问题应该很头疼吧,不过,当您还是四处查资料来解决您遇到的另你头疼的问题时,如果不经意间看到了这则贴子,那请您升...
oracle 12 c ORA-01017: 用户名/口令无效; 登录被拒绝
-- 解决ORA-00904: "WMSYS"."WM_CONCAT": 标识符无效 的文件包....... -- 解决ORA-00904: "WMSYS"."WM_CONCAT": 标识符无效 的文件包....... -- 解决ORA-00904: "WMSYS"."WM_CONCAT": 标识符无效 的文件包....... ...
报错如下 报错: ORA-12170:TNS connect timeout occurred 第一反应是监听没开: 1. 测试了一下, 连接超时没用ping 通 C:\Users\Administrator>tnsping brorcl TNS Ping Utility for 64-bit Windows: Version 11.2...
NULL 博文链接:https://3w1h.iteye.com/blog/1211779