![](https://img-blog.csdnimg.cn/20201014180756754.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle TroubleShooting
zbdba
live in oracle
展开
-
OER 7451
前几天帮别人看了,他对数据库做了 一些操作,但是发现并没生效:我到警告日志文件找到:Tue Nov 05 22:29:18 2013OER 7451 in Load Indicator : Error Code = OSD-04500: 指定了非法选项O/S-Error: (OS 1) 函数不正确。 !OER 7451 in Load Indicator : Error原创 2013-11-07 08:37:26 · 1625 阅读 · 0 评论 -
WARNING OGG-00952 Purging log history from OGG.GGS_DDL_HIST
经常在巡检OGG日志的时候发现如下警告:2013-01-18 16:52:56 WARNING OGG-00952 Oracle GoldenGate Manager for Oracle, mgr.prm: Purging log history from OGG.GGS_DDL_HIST older than 2013-01-13 15:52:56.084114: Could not原创 2014-09-16 09:58:05 · 4030 阅读 · 0 评论 -
oradebug推进scn
有时候我们遇到如下错误:ORA-01092: ORACLE instance terminated. Disconnection forcedORA-00600: internal error code, arguments: [2662], [0], [5685940], [0], [5685970], [4194432], [], [], [], [], [], []Process I原创 2014-11-11 11:34:38 · 1749 阅读 · 0 评论 -
10061事件
数据库启动的时候直接关闭,查看告警日志:Errors in file /opt/oracle/diag/rdbms/orcl11g/orcl11g/trace/orcl11g_mmon_3749.trc (incident=65276):ORA-00600: internal error code, arguments: [4194], [0x000000011], [0x7F967679原创 2014-11-11 12:05:19 · 2422 阅读 · 0 评论 -
Apply Bug10010310 On Oracle RAC 10.2.0.5
9月24日数据库上频繁出现如下错误Errors in file /u04/admin/njord/udump/njord_ora_25895.trc:ORA-27300: OS system dependent operation:invalid_process_id failed with status: 0ORA-27301: OS failure message: Error原创 2014-10-01 09:16:41 · 2850 阅读 · 1 评论 -
ORA-00600 [kollasg:client-side tmp lob]
今天在查看一个库的日志时,发现被ORA-00600 [kollasg:client-side tmp lob] 错误刷屏了。发生该错误的原因是因为应用那边lob的问题。lob没有被初始化,建议使用EMPTY_CLOB函数对其初始化mos上原文: ORA-00600 [kollasg:client-side tmp lob] Fetching Ro原创 2014-10-11 14:12:13 · 2608 阅读 · 0 评论 -
db_recovery_file_dest_size 满导致数据库启动失败
启动数据库时:SYS@orcl11g>startupORACLE instance started.Total System Global Area 417546240 bytesFixed Size 2213936 bytesVariable Size 327157712 bytesDatabase Buffers原创 2014-11-16 10:38:25 · 5194 阅读 · 0 评论 -
ORA-00600 qerpxInitialize
今天早上巡检又见bug:A select query using a connect-by clause executing using parallel query may fail with ORA-600 [qerpxInitialize].Bug 7308675 OERI:qerpxInitialize from parallel query using CONNECT BY原创 2014-10-14 09:40:48 · 1635 阅读 · 0 评论 -
shutdown abort模式丢失redo,使用隐含参数启库
shutdown abort模式丢失redo log无法open数据库通过告警报错ORA-00354: corrupt redo log block header 从该错误可以看出当前日志的redo block的header出现问题,导致oracle无法读取redo进行恢复。通过以下检查发现数据库文件头都一致,没有需要恢复的文件,但是由于数据库是非正常关闭,last_change sc原创 2014-11-01 18:18:25 · 1543 阅读 · 0 评论 -
ORA-27301: OS failure message: Not enough space
OS:HP-UNIXORA-27300: OS system dependent operation:fork failed with status: 12 ORA-27301: OS failure message: Not enough space ORA-27302: failure occurred at: skgpspawn3swapinfo -mt发现s原创 2014-10-16 11:02:05 · 4003 阅读 · 0 评论 -
Oracle 字符集修改(ORA-29275 )
今天有朋友数据库出现ORA-29275 部分多字节字符,对应的字段只能用to_char才能正常查询,感觉是字符集问题。询问字果然修改过字符集。他的修改方式:SQL>STARTUP MOUNT; SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION; SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; SQ原创 2014-11-23 22:25:25 · 12656 阅读 · 1 评论 -
ORA-00600 kcratr_nab_less_than_odr
早上发现数据库报如下错误:Successful mount of redo thread 1, with mount id 339694234Database mounted in Exclusive ModeLost write protection disabledCompleted: ALTER DATABASE MOUNTMon Jan 26 09:12:01 2015原创 2015-01-26 09:52:47 · 1801 阅读 · 0 评论 -
BUG 10010310
今日在巡检的时候发现如下错误:ORA-27300: OS system dependent operation:invalid_process_id failed with status: 0ORA-27301: OS failure message: Error 0ORA-27302: failure occurred at: skgpalive1MOS上面已经明确说明是BU原创 2014-09-26 10:11:52 · 986 阅读 · 0 评论 -
GCS shadows traversed, 4001 replayed
今天在巡检仪套rac的第一节点日志发现以下错误: LMS 8: 7888 GCS shadows traversed, 4001 replayed LMS 2: 7957 GCS shadows traversed, 4001 replayed LMS 0: 6164 GCS shadows traversed, 3120 replayed查阅资料发现是同步出现了问题。遂看了另原创 2014-09-12 11:42:41 · 3146 阅读 · 0 评论 -
ORA-19809&&ORA-03113
idle>startupORACLE 例程已经启动。Total System Global Area 3407261696 bytesFixed Size 2180504 bytesVariable Size 2348812904 bytesDatabase Buffers 1040187392 b原创 2013-12-29 15:42:47 · 1088 阅读 · 0 评论 -
ORACLE AWR
Concept:Automatic Workload Repository (AWR) is a repository of historical performance data that includescumulative statistics for the system, sessions, individual SQL statements, segments, and serv原创 2013-12-19 08:32:55 · 1466 阅读 · 0 评论 -
sqlplus: error while loading shared libraries
解决方法:1.用root用户登陆2.编辑 /etc/selinux/config文件,如下:# This file controls the state of SELinux on the system.# SELINUX= can take one of these three values:# enforcing - SELinux security polic原创 2014-01-23 17:33:23 · 1111 阅读 · 0 评论 -
Error in invoking target 'all_no_orcl ihsodbc' of makefile '/oracle/product/10g/rdbms/lib/ins_rdbms.
今天在linux AS4上安装oracle10gR2时,安装到62%时报下面的错误:Error in invoking target 'all_no_orcl ihsodbc' of makefile '/oracle/product/10g/rdbms/lib/ins_rdbms.mk'. See '/oracle/oraInventory/logs/installActions2009转载 2014-02-21 20:05:10 · 1986 阅读 · 0 评论 -
ORA-27125
启动客户的数据库,遇到:SQL> startup ORA-27125: unable to create shared memory segment Linux-x86_64 Error: 1: Operation not permitted网上找到了解决方法 在某些操作系统上,当启动数据库或者创建数据库时都可能出现ORA-27125错误,我在Oracle转载 2014-02-21 18:14:38 · 2854 阅读 · 0 评论 -
pdksh-5.2.14 install pdksh conflicts with ksh-20100621-16.el6.x86_64
解决办法:rpm -e ksh-20100621-16.el6.x86_64[root@mac1 mnt]# rpm -ivh pdksh-5.2.14-*warning: pdksh-5.2.14-37.el5_8.1.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID e8562897: NOKEYPreparing...原创 2014-02-17 23:43:52 · 5969 阅读 · 0 评论 -
User equivalence unavailable on all nodes
./runcluvfy.sh comp nodecon -n ahrac1,ahrac2 -verboseVerifying node connectivity ERROR: User equivalence unavailable on all the nodes.Verification cannot proceed.Verification of node转载 2014-03-01 16:25:05 · 2065 阅读 · 0 评论 -
CRS-4530,CRS-4534
现象:oracle crs 不能正确启动[root@dtydb5 tmp]# su - grid[root@dtydb5 log]# /oracle/11.2.0/grid/bin/crs_stat –t CRS-0184: Cannot communicate with the CRS daemon.[root@dtydb5 bin]# ./crsctl check crsC转载 2014-03-05 14:43:09 · 3049 阅读 · 0 评论 -
CRS-0184
[oracle@rac1 ~]$ crs_stat -t CRS-0184: Cannot communicate with the CRS daemon. rac1和rac2上都是一样。但是检测:ocr和votedisk,rac1和rac2上都是正常的: [root@rac1 bin]# crsctl check crs Failure 1 contacting C转载 2014-03-08 15:40:07 · 2630 阅读 · 1 评论 -
OGG-01224 Bad file number
今天在看OGG的日志时,发现如下OGG-01224 Bad file number错误,查阅资料才知道端口不可用,看了一下mgr的参数,发现是设置的DYNAMICPORTLIST 动态端口,为什么还不可用。看看MOS上面咋说的: OGG GoldenGate Extract | Pump Abends with: "TCP/IP Error 9 (Bad Fil原创 2014-09-19 11:18:26 · 3660 阅读 · 0 评论 -
WARNING: Heavy swapping observed on system in last 5 mins.
今天在巡检alert日志的时候,发现如下报错:pct of memory swapped in [7.16%] pct of memory swapped out [0.56%].Please make sure there is no memory pressure and the SGA and PGAare configured correctly. Look at DBRM原创 2014-09-11 11:10:39 · 4004 阅读 · 0 评论 -
ORA-00600 ORA-01565 ORA-27046
昨天在做数据泵导入导出的时候,突然遇到ude-00008错误,查看日志文件:Errors in file /oracle/afcprd01/db/10.2.0/admin/afcprd01_afcdb/bdump/afcprd01_dbw0_1417220.trc: ORA-00600: internal error code, arguments: [kmgs_parameter_upda原创 2015-03-12 09:57:00 · 2677 阅读 · 0 评论