Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

0

好友

6

主题
1#
发表于 2013-7-12 13:26:53 | 查看: 2118| 回复: 0
本帖最后由 钱多多 于 2013-7-12 13:42 编辑

有一台Oracle 11203 x86的服务器,部署在Red Hat Enterprise Linux AS release 4 (Nahant Update 8) x86上,近期频繁出现连不上,随后实例自行崩溃的情况。

OS:RHEL 4.8 x86
Mem:8G
Oracle: 11.2.0.3 x86,单点

检查Alert日志后发现,频繁出现下面这样的日志,然后就实例消失。重新登录sqlplus并正常startup,库能正常使用。

Fatal NI connect error 12170.

  VERSION INFORMATION:
        TNS for Linux: Version 11.2.0.3.0 - Production
        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
  Time: 11-JUL-2013 16:43:43
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12535
   
TNS-12535: TNS:operation timed out
    ns secondary err code: 12560
    nt main err code: 505
   
TNS-00505: Operation timed out
    nt secondary err code: 110
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=1.2.3.4)(PORT=44598))
Thu Jul 11 16:43:58 2013

---------------------------------------------------------------------------------------------------------------------------

Fatal NI connect error 12547, connecting to:
(LOCAL=NO)

  VERSION INFORMATION:
        TNS for Linux: Version 11.2.0.3.0 - Production
        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
  Time: 12-JUL-2013 11:10:02
  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: 0
    nt secondary err code: 0
    nt OS err code: 0

opiodr aborting process unknown ospid (6936) as a result of ORA-609

alert_epdb.tar.gz (102.04 KB, 下载次数: 459)



您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-16 20:27 , Processed in 0.058010 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569