Database、Code

前几天帮别人看了，他对数据库做了 一些操作，但是发现并没生效：我到警告日志文件找到：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

经常在巡检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

有时候我们遇到如下错误：ORA-01092: ORACLE instance terminated. Disconnection forcedORA-00600: internal error code, arguments: [2662], [0], [5685940], [0], [5685970], [4194432], [], [], [], [], [], []Process I

数据库启动的时候直接关闭，查看告警日志：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

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

今天在查看一个库的日志时，发现被ORA-00600 [kollasg:client-side tmp lob] 错误刷屏了。发生该错误的原因是因为应用那边lob的问题。lob没有被初始化，建议使用EMPTY_CLOB函数对其初始化mos上原文： ORA-00600 [kollasg:client-side tmp lob] Fetching Ro

启动数据库时：SYS@orcl11g>startupORACLE instance started.Total System Global Area 417546240 bytesFixed Size 2213936 bytesVariable Size 327157712 bytesDatabase Buffers

今天早上巡检又见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

shutdown abort模式丢失redo log无法open数据库通过告警报错ORA-00354: corrupt redo log block header 从该错误可以看出当前日志的redo block的header出现问题，导致oracle无法读取redo进行恢复。通过以下检查发现数据库文件头都一致，没有需要恢复的文件，但是由于数据库是非正常关闭，last_change sc

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

今天有朋友数据库出现ORA-29275 部分多字节字符，对应的字段只能用to_char才能正常查询，感觉是字符集问题。询问字果然修改过字符集。他的修改方式：SQL>STARTUP MOUNT;　　SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;　　SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;　　SQ

早上发现数据库报如下错误：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

今日在巡检的时候发现如下错误：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

今天在巡检仪套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查阅资料发现是同步出现了问题。遂看了另

idle>startupORACLE 例程已经启动。Total System Global Area 3407261696 bytesFixed Size                  2180504 bytesVariable Size            2348812904 bytesDatabase Buffers         1040187392 b

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

解决方法：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

今天在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

启动客户的数据库,遇到:SQL> startup ORA-27125: unable to create shared memory segment Linux-x86_64 Error: 1: Operation not permitted网上找到了解决方法 在某些操作系统上，当启动数据库或者创建数据库时都可能出现ORA-27125错误，我在Oracle

解决办法：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...    

./runcluvfy.sh comp nodecon -n ahrac1,ahrac2 -verboseVerifying node connectivity ERROR: User equivalence unavailable on all the nodes.Verification cannot proceed.Verification of node

现象：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

[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

今天在看OGG的日志时，发现如下OGG-01224 Bad file number错误，查阅资料才知道端口不可用，看了一下mgr的参数，发现是设置的DYNAMICPORTLIST 动态端口，为什么还不可用。看看MOS上面咋说的： OGG GoldenGate Extract | Pump Abends with: "TCP/IP Error 9 (Bad Fil

今天在巡检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

昨天在做数据泵导入导出的时候，突然遇到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