ITPub博客

DB:Oracle 9.2.0.7OS:HP-UX 9000/800 64bit周五接到应用人员反映其程序日志中报如下错误：[@more@] 写记录时发生一个错误。请继续操作，如果问题仍然存在，请系统管理员检查应用程序的配置。(SBL-DBC-00111) ORA-01116: error in opening database file 762 ORA-01110: data file 762: '/dev/vgcrm09/rlv9_data16g_21' ORA-27041: unable to open file HP-UX Error: 23: File table overflow Additional information: 3 (0x56b5) EAITransport EAITransportWarning 2 0 2012-03-22 16:31:13 [3] Stack trace:写记录时发生一个错误。请

今天打开虚拟机中的一个DB，这个DB好久没打开过了，在执行STARTUP启动时报错：[oracle@ligle-db admin]$ sqlplus '/assysdba' SQL*Plus: Release 10.2.0.4.0 - Productionon Mon Mar 28 14:0...

今天在做实验时发现连着执行两边下面的SQL语句时，就报如下错误：SQL> insert /*+ append */ into t01 nologging select *from dba_objects;insert /*+ append */ into t01 nologging select * from...

昨天客户反映说在下午某时间段有几个事务失败了，让我查下当时数据库系统的负载是否正常，看了下CPU的历史负载，很正常，于是看了下日志发现有几个timeout错误和一个ORA-02050错误。 Tue Feb 15 20:44:05 2011 Error 1013 trapped in 2PC on transaction 199.40.297416. Cleaning up. Tue Feb 15 20:44:56 2011 Error stack returned to user: ORA-02050: transaction 199.40.297416 rolled back, some remote DBs may be in-doubt ORA-01013: user requested cancel of current operation 这个是分布式事务处理出错的提示

应用端查询等操作被异常中止且记录如下信息 ORA-01115: IO error reading block from file 50 (block # 1624) ORA-01110: data file 50: '/dev/ra_dhyx02' ORA-27091: skgfqio: unable to queue I/O ORA-27072: skgfdisp: I/O error IBM AIX RISC System/6000 Error: 5: I/O error ; nested exception is java.sql.SQLException: ORA-01115: IO error reading block from file 50 (block # 1624) ORA-01110: data file 50: '/dev/ra_dhyx02' ORA-27091: skgfqio: unable to queue I/O ORA-27072: skgf

在客户的综合结算数据库系统的日志中发现如下错误： Mon Sep 20 15:16:04 2010 Errors in file /settle/oracle/admin/zhjs/udump/zhjs_ora_995502.trc: ORA-00600: internal error code, arguments: [qmxiUnpPacked2], [121], [], [], [], [], [], [] trace文件zhjs_ora_995502.trc的内容： /settle/oracle/admin/zhjs/udump/zhjs_ora_995502.trc Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.8.0 – Produc

客户说执行sqlplus时报错，详细见下： $ sqlplus 'sys/ligle as sysdba' SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jun 22 08:56:29 2011 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. exec(): 0509-036 Cannot load program oraclebcrm because of the following errors: 0509-130 Symbol resolution failed for /usr/lib/libc.a[aio_64.o] because: 0509-136 Symbol kaio_rdwr64 (number 1) is not exported from dependent module /unix.

刚刚客户说crm到prm的dblink有问题，我还觉得dblink能有什么问题，于是看了下，执行了一个简单的select，果真报错，见下： SQL> SELECT * FROM TAB@LINKPRM; SELECT * FROM TAB@LINKPRM * ERROR at line 1: ORA-00257: archiver error. Connect internal only, until freed. ORA-02063: preceding line from LINKPRM 一看archiver字样，就知道是远端归档有问题，应该是归档目录满了，按说归档是2小时一备一清的，难道短短2个小时产生这么的日志么？ 首先到prm上一看，归档目录所在文件系统使用率1

最近时常遇到分布式事务失败，把官方的解释贴上来，呵呵！ Error: ORA 2050 Text: transaction <num> rolled back, some remote DBs may be in-doubt ------------------------------------------------------------------------------- Cause: There was a network failure or a remote failure during the two-phase commit. Action: Notify the database administrator. The remote databases will automatically resynchronize when the failure is repaired. [@more@]

今天给客户装Oracle（aix5.3 + raw + oracle10g）,在点击finsh开始建库时报：ora-21561 OID generation failed.简单google了下，大都说是hosts文件的问题，于是打开/etc/hosts文件看看，发现除了注释仅有一行，见下：127.0.0.1 loopback localhost # loopback (lo0) name/address于是在其下加上具体的IP地址和对应的主机名称，如：10.13.28.99 ligle继续安装就没问题有任何问题了… [@more@]

今天早上，应用的人说新装的那台数据库连接报错，用PL/SQL Developer连接报：ORA-12537:TNS:连接关闭。开始处理：以oracle身份登陆系统，报：/etc/profile[50]: 0403-030 The fork function failed. Too many processes already exist.执行sqlplus登陆数据库又报：ORA-12549: TNS:operating system resource quota exceeded.这个类错误还是第一次遇见，不过看起来不算是有难度的问题，然后开始查询数据库告警日志alert.log，有很多类似的错误：Tue May 10 21:00:37 2011Process startup failed, error stack:Tue May 10 21:00:37 2011Erro