社区
基础和管理
帖子详情
oracle远程连接 ORA-12560:TNS:protocol adapter error
a477761183
2014-01-10 09:49:31
我在远程局域网中的linux 32位服务器上安装的oracle 11g,系统是centos6.4 ,在我自己的电脑上装的32位的instantclient 和PL/SQL developer ,连接的时候出现ORA-12650错误,服务器防火墙关了,服务器的路由也做了1521端口映射,实例和监听都用dbsart和lsnrctl start 命令启动。我在本机用ssh远程可以用sqlplus / as sysdba 命令连接数据库,用欧冠PL/SQL就不行。这是截图
...全文
1264
回复
打赏
收藏
oracle远程连接 ORA-12560:TNS:protocol adapter error
我在远程局域网中的linux 32位服务器上安装的oracle 11g,系统是centos6.4 ,在我自己的电脑上装的32位的instantclient 和PL/SQL developer ,连接的时候出现ORA-12650错误,服务器防火墙关了,服务器的路由也做了1521端口映射,实例和监听都用dbsart和lsnrctl start 命令启动。我在本机用ssh远程可以用sqlplus / as sysdba 命令连接数据库,用欧冠PL/SQL就不行。这是截图
复制链接
扫一扫
分享
转发到动态
举报
写回复
配置赞助广告
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复
打赏红包
TNS
-12541:
TNS
: 无监听程序
TNS
-
12560
TNS
-12541:
TNS
: 无监听程序
TNS
-
12560
:
TNS
: 协议适配器错误
TNS
-00511: 无监听程序 文章转自:http://www.luocs.com/archives/464.html 此文版权归作者 – yaogang所有,转载请注明yaogang©www.luocs.com。 Luocs说:这是我一个朋友的一个监听器问题解决案例,这是昨天发生的事情,我一直跟朋友一起Troubleshooting,折腾了半天最后是BUG所致。再次汗颜,Windows平台惹不起啊!好,那么下面开始分享我朋友的案例! 环境描述: OS : Windows Server 2008 64Bit (做了HA) DB : 11.1.0.7.0 排错过程: 前天应用不能访问数据库了 (后台应用能访问数据库),故障发生。 马上登录到服务器里查看监听状态,发现有
TNS
-12541 ,
TNS
-
12560
等错误 Luocs补充:我跟朋友要了错误代码,但他没有保存,就直接贴图。 从计算器的管理 –> 服务选项 –> 检查
ora
cle
监听服务程序,发现该服务已经停止。 手动把监听服务启动,这时候服务状态上显示为已启动,但在CMD窗口执行lsnrctl status的时候依然返回错误信息: C:\>lsnrctl status LSNRCTL for 64-bit Windows: Version 11.1.0.7.0 -
Pro
duction on 12-11月-2012 18:1 8:32 Copyright (c) 1991, 2008,
Ora
cle
. All rights reserved. 正在连接到 (DESCRIPTION=(ADDRESS=(
PRO
TOCOL
=TCP)(HOST=10.10.203.218)(PORT=1521)))
TNS
-12541:
TNS
: 无监听程序
TNS
-
12560
:
TNS
: 协议适配器错误
TNS
-00511: 无监听程序 64-bit Windows
Error
: 61: Unknown
error
正在连接到 (DESCRIPTION=(ADDRESS=(
PRO
TOCOL
=IPC)(KEY=EXT
PRO
C1521))) 过段时间回显非常慢。 然后我检查了下告警日志,大量的
ora
错误 Fatal NI connect
error
12170. VERSION INFORMATION:
TNS
for 64-bit Windows: Version 11.1.0.7.0 -
Pro
duction
Ora
cle
Bequeath NT
Pro
tocol
Adapter
for 64-bit Windows: Version 11.1.0.7.0 -
Pro
duction Windows NT TCP/IP NT
Pro
tocol
Adapter
for 64-bit Windows: Version 11.1.0.7.0 -
Pro
duction Time: 12-11月-2012 15:23:33 Tracing not turned on.
Tns
error
struct: ns main err code: 12535
TNS
-12535:
TNS
: 操作超时 ns secondary err code:
12560
nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 Client address:
ORA
-609 : opiodr aborting
pro
cess unknown ospid (4116_6104) 这时候朋友怀疑是不是监听器配置问题,就把原先的监听器删除重建了下,问题依然。 网上有个解决
TNS
-12535错误的案例,平台和版本都很类似,如下: 1、在 sqlnet.
ora
文件中 增加如下行: DIAG_ADR_ENABLED = OFF 2、在listener.
ora
文件中增加如下行: DIAG_ADR_ENABLED_ = OFF 如何监听是listener时,则前面的名称为:DIAG_ADR_ENABLED_LISTENER = OFF 3、重新启动windows服务管理中的监听程序.先停止,然后再重新启动. 4、检查结果.发现可以了,返回的值在10毫秒.有时为0毫秒.成功!! 但这并不是问题发生原因,在继续排查过程中偶然发现监听日志大小居然为4G。然后把这现象告诉了Luocs。 过了一会儿,Luocs回应是
Ora
cle
数据库
ORA
-
12560
错误问题的解决办法
官网中关于
ORA
-
12560
的解释:
ORA
-
12560
:
TNS
:
pro
tocol
adapter
error
Cause: A generic
pro
tocol
adapter
error
occurred. Action: Check addresses used for
pro
per
pro
tocol
specification. Before reporting this
error
, look at the
error
stack and check for lower level transport
error
s. For further details, turn on tra
Ora
cle
11g服务器、客户端的安装和plsql developer(一次成功)
1.你能保证
Ora
cle
11g不出现错误吗?2.你能保证
Ora
cle
11g 服务器安装不出现错误吗?3.你能保证plsql developer不出
ORA
-12541
TNS
无监听程序错误吗?4.你知道
Ora
cle
11g安装服务器端,客户端,plsql developer都有哪些坑点吗?
ora
10g客户端
ora
10g客户端 *********************************************************************** Fatal NI connect
error
12560
, connecting to: (DESCRIPTION=(ADDRESS=(
PRO
TOCOL
=BEQ)(
PRO
GRAM=
ora
cle
)(ARGV0=
ora
cle
ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(
PRO
TOCOL
=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(
PRO
GRAM=D:\
ora
cle
\
ora
10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION:
TNS
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction
Ora
cle
Bequeath NT
Pro
tocol
Adapter
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction Windows NT TCP/IP NT
Pro
tocol
Adapter
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction Time: 17-SEP-2011 12:24:11 Tracing not turned on.
Tns
error
struct: ns main err code:
12560
TNS
-
12560
: Message
12560
not found; No message file for
pro
duct=NETWORK, facility=
TNS
ns secondary err code: 0 nt main err code: 530
TNS
-00530: Message 530 not found; No message file for
pro
duct=NETWORK, facility=
TNS
nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect
error
12560
, connecting to: (DESCRIPTION=(ADDRESS=(
PRO
TOCOL
=BEQ)(
PRO
GRAM=
ora
cle
)(ARGV0=
ora
cle
ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(
PRO
TOCOL
=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(
PRO
GRAM=D:\
ora
cle
\
ora
10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION:
TNS
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction
Ora
cle
Bequeath NT
Pro
tocol
Adapter
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction Windows NT TCP/IP NT
Pro
tocol
Adapter
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction Time: 17-SEP-2011 12:24:12 Tracing not turned on.
Tns
error
struct: ns main err code:
12560
TNS
-
12560
: Message
12560
not found; No message file for
pro
duct=NETWORK, facility=
TNS
ns secondary err code: 0 nt main err code: 530
TNS
-00530: Message 530 not found; No message file for
pro
duct=NETWORK, facility=
TNS
nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect
error
12560
, connecting to: (DESCRIPTION=(ADDRESS=(
PRO
TOCOL
=BEQ)(
PRO
GRAM=
ora
cle
)(ARGV0=
ora
cle
ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(
PRO
TOCOL
=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(
PRO
GRAM=D:\
ora
cle
\
ora
10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION:
TNS
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction
Ora
cle
Bequeath NT
Pro
tocol
Adapter
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction Windows NT TCP/IP NT
Pro
tocol
Adapter
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction Time: 18-SEP-2011 10:22:30 Tracing not turned on.
Tns
error
struct: ns main err code:
12560
TNS
-
12560
: Message
12560
not found; No message file for
pro
duct=NETWORK, facility=
TNS
ns secondary err code: 0 nt main err code: 530
TNS
-00530: Message 530 not found; No message file for
pro
duct=NETWORK, facility=
TNS
nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect
error
12560
, connecting to: (DESCRIPTION=(ADDRESS=(
PRO
TOCOL
=BEQ)(
PRO
GRAM=
ora
cle
)(ARGV0=
ora
cle
ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(
PRO
TOCOL
=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(
PRO
GRAM=D:\
ora
cle
\
ora
10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION:
TNS
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction
Ora
cle
Bequeath NT
Pro
tocol
Adapter
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction Windows NT TCP/IP NT
Pro
tocol
Adapter
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction Time: 19-SEP-2011 10:20:57 Tracing not turned on.
Tns
error
struct: ns main err code:
12560
TNS
-
12560
: Message
12560
not found; No message file for
pro
duct=NETWORK, facility=
TNS
ns secondary err code: 0 nt main err code: 530
TNS
-00530: Message 530 not found; No message file for
pro
duct=NETWORK, facility=
TNS
nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect
error
12560
, connecting to: (DESCRIPTION=(ADDRESS=(
PRO
TOCOL
=BEQ)(
PRO
GRAM=
ora
cle
)(ARGV0=
ora
cle
ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(
PRO
TOCOL
=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(
PRO
GRAM=D:\
ora
cle
\
ora
10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION:
TNS
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction
Ora
cle
Bequeath NT
Pro
tocol
Adapter
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction Windows NT TCP/IP NT
Pro
tocol
Adapter
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction Time: 20-SEP-2011 10:27:04 Tracing not turned on.
Tns
error
struct: ns main err code:
12560
TNS
-
12560
: Message
12560
not found; No message file for
pro
duct=NETWORK, facility=
TNS
ns secondary err code: 0 nt main err code: 530
TNS
-00530: Message 530 not found; No message file for
pro
duct=NETWORK, facility=
TNS
nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect
error
12560
, connecting to: (DESCRIPTION=(ADDRESS=(
PRO
TOCOL
=BEQ)(
PRO
GRAM=
ora
cle
)(ARGV0=
ora
cle
ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(
PRO
TOCOL
=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(
PRO
GRAM=D:\
ora
cle
\
ora
10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION:
TNS
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction
Ora
cle
Bequeath NT
Pro
tocol
Adapter
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction Windows NT TCP/IP NT
Pro
tocol
Adapter
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction Time: 20-SEP-2011 11:50:33 Tracing not turned on.
Tns
error
struct: ns main err code:
12560
TNS
-
12560
: Message
12560
not found; No message file for
pro
duct=NETWORK, facility=
TNS
ns secondary err code: 0 nt main err code: 530
TNS
-00530: Message 530 not found; No message file for
pro
duct=NETWORK, facility=
TNS
nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect
error
12505, connecting to: (DESCRIPTION=(ADDRESS=(
PRO
TOCOL
=TCP)(HOST=192.168.0.200)(PORT=1521))(CONNECT_DATA=(SID=dba)(CID=(
PRO
GRAM=D:\
ora
cle
\
ora
10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION:
TNS
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction Windows NT TCP/IP NT
Pro
tocol
Adapter
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction Time: 27-OCT-2011 22:03:49 Tracing not turned on.
Tns
error
struct: ns main err code: 12564
TNS
-12564: Message 12564 not found; No message file for
pro
duct=NETWORK, facility=
TNS
ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect
error
12505, connecting to: (DESCRIPTION=(ADDRESS=(
PRO
TOCOL
=TCP)(HOST=192.168.0.200)(PORT=1521))(CONNECT_DATA=(SID=dba)(CID=(
PRO
GRAM=D:\
ora
cle
\
ora
10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION:
TNS
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction Windows NT TCP/IP NT
Pro
tocol
Adapter
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction Time: 27-OCT-2011 22:04:07 Tracing not turned on.
Tns
error
struct: ns main err code: 12564
TNS
-12564: Message 12564 not found; No message file for
pro
duct=NETWORK, facility=
TNS
ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect
error
12505, connecting to: (DESCRIPTION=(ADDRESS=(
PRO
TOCOL
=TCP)(HOST=192.168.0.200)(PORT=1521))(CONNECT_DATA=(SID=dba)(CID=(
PRO
GRAM=D:\
ora
cle
\
ora
10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION:
TNS
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction Windows NT TCP/IP NT
Pro
tocol
Adapter
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction Time: 29-OCT-2011 11:57:00 Tracing not turned on.
Tns
error
struct: ns main err code: 12564
TNS
-12564: Message 12564 not found; No message file for
pro
duct=NETWORK, facility=
TNS
ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect
error
12560
, connecting to: (DESCRIPTION=(ADDRESS=(
PRO
TOCOL
=BEQ)(
PRO
GRAM=
ora
cle
)(ARGV0=
ora
cle
ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(
PRO
TOCOL
=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(
PRO
GRAM=D:\
ora
cle
\
ora
10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION:
TNS
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction
Ora
cle
Bequeath NT
Pro
tocol
Adapter
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction Windows NT TCP/IP NT
Pro
tocol
Adapter
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction Time: 29-OCT-2011 11:57:30 Tracing not turned on.
Tns
error
struct: ns main err code:
12560
TNS
-
12560
: Message
12560
not found; No message file for
pro
duct=NETWORK, facility=
TNS
ns secondary err code: 0 nt main err code: 530
TNS
-00530: Message 530 not found; No message file for
pro
duct=NETWORK, facility=
TNS
nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect
error
12560
, connecting to: (DESCRIPTION=(ADDRESS=(
PRO
TOCOL
=BEQ)(
PRO
GRAM=
ora
cle
)(ARGV0=
ora
cle
ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(
PRO
TOCOL
=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(
PRO
GRAM=D:\
ora
cle
\
ora
10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION:
TNS
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction
Ora
cle
Bequeath NT
Pro
tocol
Adapter
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction Time: 29-OCT-2011 11:59:39 Tracing not turned on.
Tns
error
struct: ns main err code:
12560
TNS
-
12560
: Message
12560
not found; No message file for
pro
duct=NETWORK, facility=
TNS
ns secondary err code: 0 nt main err code: 530
TNS
-00530: Message 530 not found; No message file for
pro
duct=NETWORK, facility=
TNS
nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect
error
12560
, connecting to: (DESCRIPTION=(ADDRESS=(
PRO
TOCOL
=BEQ)(
PRO
GRAM=
ora
cle
)(ARGV0=
ora
cle
ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(
PRO
TOCOL
=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(
PRO
GRAM=D:\
ora
cle
\
ora
10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION:
TNS
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction
Ora
cle
Bequeath NT
Pro
tocol
Adapter
for 32-bit Windows: Version 10.2.0.5.0 -
Pro
duction Time: 29-OCT-2011 11:59:43 Tracing not turned on.
Tns
error
struct: ns main err code:
12560
TNS
-
12560
: Message
12560
not found; No message file for
pro
duct=NETWORK, facility=
TNS
ns secondary err code: 0 nt main err code: 530
TNS
-00530: Message 530 not found; No message file for
pro
duct=NETWORK, facility=
TNS
nt secondary err code: 126 nt OS err code: 0
ORA
-
12560
:
TNS
:协议适配器错误的解决方案
今天重温
ora
cle
数据库,发现启动不了了
ORA
-
12560
:
TNS
: 协议适配器错误的解决方法 造成
ORA
-
12560
:
TNS
: 协议适配器错误的问题的原因有三个: 1.监听服务没有起起来。windows平台个一如下操作:开始—程序—管理工具—服务,打开服务面板,启动
ora
cle
home92
TNS
listener服务。 2.database instance没有起起来。windows平台...
基础和管理
17,377
社区成员
95,127
社区内容
发帖
与我相关
我的任务
基础和管理
Oracle 基础和管理
复制链接
扫一扫
分享
社区描述
Oracle 基础和管理
社区管理员
加入社区
获取链接或二维码
近7日
近30日
至今
加载中
查看更多榜单
社区公告
暂无公告
试试用AI创作助手写篇文章吧
+ 用AI写文章