ORA-12547 TNSlost contact

更新时间:2023-05-17 09:42:49 阅读: 评论:0

今天登陆oracle10g的sqlplus发现如下错误:
[oracle@redhat4U4 10g]$ sqlplus /nolog
SQL*Plus: Relea 10.2.0.3.0 - Production on Wed Oct 29 11:15:05 2008
Copyright (c) 1982, 2006, Oracle. All Rights Rerved.
SQL> conn / as sysdba;
oracleirmdb: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
叛逆青春ORA-12547: TNS:lost contact
SQL> quit
Disconnected
错误原因可能是libaio的rpm包没有装,su到root检验一下
[oracle@redhat4U4 ~]$ exit
logout
如果有话,可以查到以下:长期戴耳机
[root@redhat4U4 ~]# rpm -qa | grep libaio
libaio-devel-0.3.105-2
libaio-0.3.105-2
结果没有发现这两个包,于是到第三张安装盘里找到了这两个安装包,安装
[root@rac1 rpm]# rpm -vih libaio-0.3.102-1.i386.rpm
warning: libaio-0.3.102-1.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e
<                >>>>>>>>### [100%]
1:libaio                >>>>>>>>### [100%]
[root@rac1 rpm]# rpm -ivh libaio-devel-0.3.102-1.i386.rpm
warning: libaio-devel-0.3.102-1.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e
<                >>>>>>>>### [100%]
1:libaio-devel          >>>>>>>>### [100%]
再到oracle用户下,可以了:
[oracle@rac1 +ASM]$ sqlplus "/as sysdba"
SQL*Plus: Relea 10.2.0.1.0 - Production on Wed Jun 3 10:14:45 2009
Copyright (c) 1982, 2005, Oracle. All rights rerved.
Connected to an idle instance.
SQL>
为了您的安全,请只打开来源可靠的网址管理处
打开网站    取消
来自: /lichangzai
Oracle 8.1.6.0
徐州会战简介Linux AS2.1 .
出现过一次Server僵死, 然后就不行了。
$sqlplus "/as sysdba"
报错 ORA-12547: TNS: lost contact
后来查找metalink . 可能的几个原因排除,然后找到一个很相似的 。 果然奏效 。
$ relink oracle 即可 。
具体原因:
Veirfy that your LIBPATH also includes $ORACLE_HOME/lib and
relink the oracle software. Shutdown all running oracle rvices before 漫天星光
relinking the oracle software
Note.209272.1
Title: Cannot connect to 9.2 databa - Dependent module libjox9.a(shr.o) could not be loaded
Note.219211.1
Title: Bequeath Sqlplus Connection Fails with TNS-12547
=====================================================
Displayed below are the messages of the lected thread.
Thread Status: Active
From: alain moizeau 14-Feb-06 08:30
Subject: other ur can not connect databa using sqlplus
RDBMS Version: 9.2.0.7
Operating System and Version: unix aix 5L
Error Number (if applicable): ORA-12547: TNS:lost contact
Product (i.e. SQL*Loader, Import, etc.): sqlplus
Product Version: 9.2.0.7
other ur can not connect databa using sqlplus
Hi,
other ur can not connect databa
using sqlplus
I have same problem and followd all documents but not success. If I login as oracle on unix and run sqlplus system/manager it connects right a way but doing same with other ur gives me following error. 与字开头的成语
sqlplus system/manager 虾皮的做法大全
exec() : 0509-036 Impossible de charger le programme oracleMH30SDRH
en raison des erreurs suivantes :
0509-150 Le module dépendant libjox9.a(shr.o) n'a pas pu être chargé.
0509-022 Impossible de charger le module libjox9.a(shr.o).
0509-026 Erreur système : Un fichier ou un répertoire du chemin d'accès n'existe pas.
ERROR:
ORA-12547: TNS:lost contact
LIBPATH=/usr/oracle/9.2.0.7/lib32:/usr/oracle/9.2.0.7/lib
ORACLE_SID=MH30SDRH 汕头中山公园
ORA_NLS33=/usr/oracle/9.2.0.7/ocommon/nls/admin/data
ORACLE_HOME=/usr/oracle/9.2.0.7
WHEN the ur connect with SQLPLUS system/manager@MH30SDRH, its right
When export TWO_TASK=MH30SDRH
sqlplus system/manager
SQL*Plus: Relea 9.2.0.7.0 - Production on Tue Feb 14 09:31:00 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights rerved.
Connected to:
Oracle9i Enterpri Edition Relea 9.2.0.7.0 - 64bit Production
With the Partitioning and Oracle Data Mining options
JServer Relea 9.2.0.7.0 - Production
which is the problem
thanks

本文发布于:2023-05-17 09:42:49,感谢您对本站的认可!

本文链接:https://www.wtabcd.cn/fanwen/fan/89/907584.html

版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,我们将在24小时内删除。

标签:找到   原因   发现   打开   可能   网址
相关文章
留言与评论(共有 0 条评论)
   
验证码:
推荐文章
排行榜
Copyright ©2019-2022 Comsenz Inc.Powered by © 专利检索| 网站地图