你好,游客 登录 注册 搜索
背景:
阅读新闻

修改文件目录权限导致数据库连接报错ORA-12547

[日期:2013-01-07] 来源:Linux社区  作者:hijk139 [字体: ]

修改文件目录权限导致数据库连接报错
1,使用Oracle用户sysdba登录数据库报错ORA-12547
-bash-3.2$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.2.0 Production on 星期五 1月 4 16:59:26 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:
ORA-12547: TNS: 丢失连接

-bash-3.2$ oerr ora 12547
12547, 00000, "TNS:lost contact"
// *Cause: Partner has unexpectedly gone away, usually during process
// startup.
// *Action: Investigate partner application for abnormal termination. On an
// Interchange, this can happen if the machine is overloaded.

2,此时查看listener的配置,service不是很正常,blocked
[grid@dtydb3 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 04-JAN-2013 17:14:56

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias                    LISTENER
Version                  TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                04-JAN-2013 17:13:34
Uptime                    0 days 0 hr. 1 min. 21 sec
Trace Level              off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File  /oracle/11.2.0/grid/network/admin/listener.ora
Listener Log File        /oracle/11.2.0/grid/log/diag/tnslsnr/dtydb3/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.4.124.233)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.4.124.243)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "SMPDB" has 1 instance(s).
  Instance "SMPDB1", status READY, has 1 handler(s) for this service...
Service "SYS$STRMADMIN.STREAMS_QUEUE.HRDB" has 1 instance(s).
  Instance "hrdb1", status READY, has 1 handler(s) for this service...
Service "hrdb" has 1 instance(s).
  Instance "hrdb1", status READY, has 1 handler(s) for this service...
Service "tyolap" has 1 instance(s).
  Instance "tyolap1", status READY, has 1 handler(s) for this service...
The command completed successfully

   
[grid@dtydb3 trace]$ lsnrctl services

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 04-JAN-2013 17:18:40
Service "tyolap" has 1 instance(s).
  Instance "tyolap1", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:444 state:blocked
        LOCAL SERVER
The command completed successfully


此时业务也已不能正常连接
[grid@dtydb3 trace]$ tail -f listener.log
 TNS-12547: TNS:lost contact
  TNS-12560: TNS:protocol adapter error
  TNS-00517: Lost contact
    Linux Error: 32: Broken pipe
04-JAN-2013 17:15:24 * (CONNECT_DATA=(SID=tyolap1)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.4.125.56)(PORT=63947)) * establish * tyolap1 * 12518
TNS-12518: TNS:listener could not hand off client connection
 TNS-12547: TNS:lost contact
  TNS-12560: TNS:protocol adapter error
  TNS-00517: Lost contact
    Linux Error: 32: Broken pipe

linux
相关资讯       ORA-12547 
本文评论   查看全部评论 (0)
表情: 表情 姓名: 字数

       

评论声明
  • 尊重网上道德,遵守中华人民共和国的各项有关法律法规
  • 承担一切因您的行为而直接或间接导致的民事或刑事法律责任
  • 本站管理人员有权保留或删除其管辖留言中的任意内容
  • 本站有权在网站内转载或引用您的评论
  • 参与本评论即表明您已经阅读并接受上述条款