ITPub博客

昨天给某客户做巡检，检查alert警告日志文件发现ORA-07445: exception encountered: core dump [qkaqkn()+5390] [SIGSEGV] [Address not mapped to object]错误，客户环境是两节点RAC，数据库版本是10.2.0.5.0，两节点的alert警告日志文件中都报这个错误，打开对应的trace文件，错误如下：ksedmp: internal or fatal error...

今天给虚拟机添加了一块磁盘，然打算设置为自动挂载的时候将/etc/fstab文件改错了导致系统启不来用root用户进入修改/etc/fstab文件，报错说是只读文件，使用w!强制保存也不行然后进入grub以sigle方式也不行，再用光盘启动也不行，最后的解决办法是1.然后输入fsck －a命令，检查硬盘；2.然后再输入df命令查看li...

插入数据时遭遇ORA-01552: cannot use system rollback segment for non-system tablespace 'xxx'错误如下：JZH@test>insert into test values('sequence 25');insert into test values('sequence 25')            *ERROR at line 1:ORA-01552: cannot use system rollback segment fo...

首先创建一张测试表JZH@test>create table t2 as select * from dba_objects where 0=1;Table created.JZH@test>select * from t2;no rows selected设置nologgingJZH@test>alter table t2 nologging;Table altered.插入数据JZH@test>insert /*+ append */ into t2 select * from dba_objects;75301 rows created....

1、创建directoryJZH@test>create directory test_dir as '/home/oracle/';Directory created.2、创建测试表JZH@test>create table emp1 as select * from scott.emp;Table created.3、查看表所在表空间JZH@test>select owner,table_name,tablespace_name from dba_tables where table_name='EMP1';OWNER   &n...

expdp jzh/jzh dumpfile=emp1.dmp directory=test_dir tables=emp1 logfile=emp1.logExport: Release 11.2.0.3.0 - Production on Sat Sep 27 14:40:07 2014Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3...

library hitbuffer hit--这两项应该特别关注报告的第一部分：它包含了一些数据库和实例的信息sessions--采集实例连接的会话数，了解并发用户的大概情况，判断数据库的类型很有用db time--这个数据比较重要，它表...

MySQL体系结构

一、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错误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...

一、创建测试表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安装[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...

用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...

一、查看状态[root@rac1 bin]# ./crs_stat -tName           Type           Target    State     Host        ------------------------------------------------------------ora....B1.inst application    ON...