ITPub博客

dataguard的备端 dba_temp_files中无记录[@more@]

Error appears on upgrade of database : 9.2.0.8 -> 10.2.0.5 ，在dbua的运行过程中报错： ORA-00600: internal error code, arguments: [kqludp2], [0x7000000C5F874D0], [0],之后，dbua断开。之后，用9208的oracle_home起库，alert日志直接报：ORA-00704: bootstrap process failureORA-00604: error occurred at recursive SQL level 1ORA-01406: fetched column value was truncatedError 704 happened during db open, shutting down databaseUSER: terminating instance due to error 704Instance terminated by USER, pid = 20

db2 update db cfg for sdwst using logarchmeth1 disk:/db2data/db2log[@more@]

GoalThe Monitor Admin Guide and Release notes state that Monitor can only be used with Oracle GoldenGate release 11.1.1.1.1 and later.But we see that OGG v11.1.1.1.0 has the required agent and seem to work with Monitor. Is this supported?SolutionThe OGG Monitor agent was provided with OGG v11.1.1.1.0. But the agent was found to have issues so only OGG v11.1.1.1.1 and later are currently supported with Monitor.[@more@]

Applies to: Management Pack for Oracle GoldenGate - Version: 2.0.0.0 and later [Release: 2.0 and later ]Information in this document applies to any platform.GoalHow do we enable reporting for GoldenGate Director, so that the reports can be published to the teams?SolutionOGG Director has no functionality to generate reports. Director does keep the current status of each monitored OGG process in the repository. You can query the Director repository to get the current status of processes monitor

Requirements For Installing Oracle10gR2 On RHEL 5/OEL 5 (x86_64) [ID 421308.1]1. Hardware Requirementsi) Physical Memory # grep MemTotal /proc/meminfoii) Swap Space # grep SwapTotal /proc/meminfo2. Kernel Requirements # uname -r The system must be running the following kernel version (or a later version) 2.6.18-8 SELinux disable 3. Installing required packages rpm -qa | grep binutils-2.17.50.0.6-2 (x86_64)rpm -qa | grep compat-db-4.2.52-5.1 (x86_64)rpm -qa | grep compat-libstdc++-296-2.96-138

[root@leitest ~]# oracleasm querydisk DATADisk "DATA" is a valid ASM disk[root@leitest ~]# oracleasm querydisk /dev/sdb1Device "/dev/sdb1" is marked an ASM disk with the label "DATA"[root@leitest ~]# oracleasm querydisk -d dataDisk "DATA" is a valid ASM disk on device /dev/sdb1[8,17][root@leitest ~]# oracleasm querydisk /dev/sdc1Device "/dev/sdc1" is not marked as an ASM disk[@more@]

Applies to: Oracle Server - Standard Edition - Version: 10.2.0.1 to 11.1.0.7 - Release: 10.2 to 11.1Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.7 [Release: 10.2 to 11.1]Information in this document applies to any platform. Oracle Database Description Oracle NUMA (Non Uniform Memory Architecture) support can be used with large SMP multiprocessor environments with NUMA hardware. When enabled Oracle NUMA support facilitates efficient use of underlying NUMA har

How to Migrate Oracle 10.2 32bit to 10.2 64bit on Microsoft Windows [ID 403522.1][@more@]

在pfile里添加_allow_resetlogs_corruption=true_corrupted_rollback_segments='_SYSSMU1$','_SYSSMU2$','_SYSSMU3$','_SYSSMU4$','_SYSSMU5$','_SYSSMU6$','_SYSSMU7$','_SYSSMU8$','_SYSSMU9$','_SYSSMU10$'加第一个隐含参数，报错Errors in file d:oracleadminoracleudumporacle_ora_820.trc:ORA-00600: 内部错误代码，参数: [2662], [0], [24912535], [0], [24917934], [8388617], [], []之后，在mount状态下，SQL> alter session set events '10015 trace name ADJUST_SCN level 1';会话已更改。之后，open库时，报：Errors in fi

sqlserver2005 数据库表损坏处理一例：sqlserver2005中有个cwbase1数据库，此库中有lc0019999.xsfp表，select * from lc0019999.xsfp时，一开始还能查询出点记录，后来直接就报824错误，看到824错误，就知道是表有损坏了。处理步骤：1.DBCC CHECKTABLE ( 'lc00X9999.xsfp ',REPAIR_REBUILD) 反馈如下：lc0019999.XSFP的 DBCC 结果。消息 8928，级别 16，状态 1，第 1 行对象 ID 1414296098，索引 ID 1，分区 ID 374162285789184，分配单元 ID 92687309078528 (类型为 In-row data): 无法处理页 (1:20184)。有关详细信息，请参阅其他

hpux下主机资源监控的工具glance[@more@]

http://www.ibm.com/developerworks/cn/aix/library/analyze_aix/http://www.ibm.com/developerworks/wikis/display/WikiPtype/nmonhttp://www.alidba.net/index.php/archives/227http://hi.baidu.com/qiaobincs/blog/item/00b8dac3c93ced59b319a8ce.html[@more@]

原因是 把老oracle_home下的spfile.ora文件以root用户上传到新oracle_home下的dbs目录了，这样权限就不对了。ORA-00600: internal error code, arguments: [kmgs_parameter_update_timeout_1], [27091], [], [], [], [], [], [] ORA-27091: unable to queue I/O ORA-27072: File I/O error [@more@]

C:>sqlplus / as sysdbaSQL*Plus: Release 11.1.0.6.0 - Production on Fri Oct 14 08:48:07 2011Copyright (c) 1982, 2007, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - ProdPL/SQL Release 10.2.0.4.0

SYSDBA and SYSOPER Privileges in Oracle [ID 50507.1][@more@]SYSDBA and SYSOPER Privileges in Oracle [ID 50507.1]

Changing between 32-bit and 64-bit Word Sizes [ID 62290.1][@more@]

How to convert a 32-bit database to 64-bit database on Linux? [ID 341880.1][@more@]

GoldenGate 不支持从oracle 11g的 active dataguard 目的端进行extractDoes GoldenGate Support Extract Reading Redo from Active Data Guard? [ID 1299805.1]SolutionNo. This is not supported in current version (v11). Extract must read the redo/archived logs from the primary database.[@more@]

Troubleshooting when srvctl can't start RAC instance, but sqlplus can start it [ID 844272.1][@more@]Troubleshooting when srvctl can't start RAC instance, but sqlplus can start it [ID 844272.1]