-
编辑 删除
11g ADG环境搭建
一、primary (实例名：jzh) standby(实例名：jyp)IP地址：192.168.1.200 192.168.1.199主机名：orcl.oracle.com ...
-
编辑 删除
ORA-16038: log 2 sequence# 30 cannot be archived
启动数据库遭遇ORA-16038: log 2 sequence# 30 cannot be archived错误SYS@ORCL>startupORACLE instance started.Total System Global Area 1224736768 bytesFixed Size 2020384 bytesVariable Size 31877...
-
编辑 删除
索引扫描方式实验
1.INDEX UNIQUE SCAN创建测试表T1JZH@ORCL>create table t1 as select object_id,object_name from dba_objects;Table created.创建唯一性索引JZH@ORCL>create unique index indx_t1 on t1(object_id);Index created.JZH@ORCL>set autot trace exp statJZH@ORCL>select * from t1 where object_id=1;no rows selec...
-
编辑 删除
模拟cache buffers chains与library cache pin等待事件
一、创建测试表JZH@ORCL>create table test (id int,name varchar2(30));Table created.二、插入数据JZH@ORCL>insert into test values(1,'AAAA');1 row created.三、查询数据JZH@ORCL>select rowid,id,name from test;ROWID ...
-
编辑 删除
BBED学习之一
一、BBED安装[oracle@10g ~]$ cd /u01/app/oracle/product/10.2.0/db_1/rdbms/lib/[oracle@10g lib]$ make -f ins_rdbms.mk /u01/app/oracle/product/10.2.0/db_1/rdbms/lib/bbed密码：blockedit二、进入BBED[oracle@10g lib]$ ./bbedPassword: blockeditBBED: Release 2.0.0.0.0 - Limited Production on Sun Mar...
-
编辑 删除
Oracle 11gR2 RAC连接报错ora-12537错误
用SQL developer连数据库时报错ora-12537，数据库是11g R2 RAC，操作系统是suse 11。监听日志信息：214.58)(PORT=53959)) * establish * dss * 12518TNS-12518: TNS:listener could not hand off client connectionTNS-12547: TNS:lost contact TNS-12560: TNSprotocol adapter error TN...
-
编辑 删除
Oracle 10g RAC删除、增加节点
一、查看状态[root@rac1 bin]# ./crs_stat -tName Type Target State Host ------------------------------------------------------------ora....B1.inst application ON...
