ITPub博客

For users wanting to determine if a tablespace can be transported.RELATED DOCUMENTSNote:76670.1 ALERT Transportable Tablespaces can corrupt target databaseNote:77523.1 Lists some known restrictions to transporting a tablespaceNote:132545.1 Transported Tablespace with UNUSED Columns Leads to Unreadableor wrong dataTo check whether a tablespace can be transported and whether a tablespaceis self contained, run: dbms_tts.transport_set_checkThe dbms_tts package is owned by sys, so to execute as anoth

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@]

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

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@]

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]

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]

asmlib 包 下载的网址http://www.oracle.com/us/solutions/midsize/rhel5-084877.html[@more@]

11gr2 x64 rhel5.3 rac 关闭归档原因：需要批量加载sqlserver数据到oracle rac 库中操作：第一个节点：shutdown immediate第二个节点：shutdown immediate第一个节点：startup mount第一个节点：alter database noarchivelog第一个节点：alter database open第二个节点：startup 之后，分别登录2个节点的sqlplus ，archive log list 的结果反馈是no archive log[@more@]