⌘KCtrl+K 快速搜索

> 文章列表 / Page 289

2010-11-28

ORA-00600: [qksrcBuildRwo]内部错误一例

一套HP-UX上的11.1.0.7上的系统,在使用11g自带的新特性dictionary health check(数据字典健康检查)功能时发现FILE$基表存在讹误,并且告警日志中伴随出现ORA-00600:[qksrcBuildRwo]内部错误,具体错误信息如下: RMAN> list failure; List of Database Failures ================...
#POST 19 MIN READ
2010-11-23

How to Recover Corrupted Root Partition from Rescue Mode

APPLIES TO: Linux OS - Version Oracle Linux 5.6 and later Linux x86-64 Linux x86 GOAL This note provides step-by-step instruction on how to recover the corrupted root filesystem. SOLUTION Booting up O...
#POST 6 MIN READ
2010-11-20

How to troubleshooting RAC Vip Problem

1.- Please provide the output of the following commands from each node: srvctl config nodeapps -n <nodename> -a -g -s -l ifconfig -a cat /etc/hosts 2.- Please set debug mode for VIP resources an...
#POST 4 MIN READ
2010-11-14

了解sqlplus中的copy命令

复制表数据是Oracle dba和应用开发人员的日常工作之一,常见的三种复制表数据的方式是: 以INSERT ..SELECT的方式将目标数据由源表插入到源表中,以此种方法复制表上的数据时可以灵活运行SELECT语句剔除那些无用的数据;同时也可以利用append nologging和并行parallel等特性加速数据复制速度.通过使用DBLINK数据库远程连接,INSERT...SELECT方式可...
#POST 8 MIN READ
2010-11-12

How to setup Oracle Streams Bi-Directional

构建Oracle双向流复制是一个十分复杂的过程,我写这个文档的目的是尽量有条理地列出所需做的工作,帮助DBA更有效的建设流复制环境。 1.以scott模式为复制示例,一般只要在创建数据库时选择了安装sample schema,都会存在该scott模式;至少保证源库中存在该schema,以便可以初始化到目标库中。 2.在源和目标2个数据库中创建strmadmin流管理用户,当然你也可以选用其他名字。...
#POST 28 MIN READ
2010-11-10

searchmysite

这是一个搜索结果预留页面, Page For Search Result
#POST 1 MIN READ
2010-11-08

Patch your 10g Oracle database to PSU 10.2.0.4.5

Patch Set Update PSU 10.2.0.4.5 is an overlay PSU whose base PSU is 10.2.0.4.4. This patch can only be applied in an Oracle home for which PSU 10.2.0.4.4 has already been installed.
#POST 288 MIN READ
2010-11-08

High Contrast for My Oracle Supports

My Oracle supports现在可以使用High Contrast高对比度界面设置功能了,目前提供2种选项:Black Text on White或者White Text on Black。个人比较喜欢黑底白字这类高对比度的界面,不过感觉现在这个White Text on Black还有待微调: 登录后的Dashboard: 这次的高亮界面因该是My Oracle Support Rele...
#POST 9 MIN READ
2010-11-08

How does RECORDLENGTH affect your exp speed?

exp导出工具的几个常用参数想必大家都很熟悉;有时为了加速导出作业我们会加上direct=y,进一步的可能就会设置RECORDLENGTH参数了,Oracle官方对这个参数的定义是:length of IO record;这个解释过于简单了,偶有余暇来探究一下RECORDLENGTH的工作原理: [maclean@rh2 test]$ exp help=y Export: Release 10.2...
#POST 39 MIN READ
2010-11-07

How to trouble shooting Library cache lock/pin

1.Troubleshooting Library Cache: Lock, Pin and Load Lock (Doc ID 444560.1) What is "Library cache lock" ? This event controls the concurrency between clients of the library cache. It acquires a lock o...
#POST 10 MIN READ