-
编辑 删除
表空间小写导致ORA-31655错误
使用expdp导出表空间时遇到ORA-31655: no data or metadata objects selected for job错误[oracle@jzh5 ~]$ expdp jzh/jzh tablespaces=test directory=dir dumpfile=test.dmpExport: Release 11.2.0.3.0 - Production on Wed Dec 21 03:10:46 2016Copyright (c) 1982, 2011, Oracle and/or its affiliates. All r...
-
编辑 删除
ORA-12154:TNS:无法解析指定的连接标识符
使用PL/SQL Developer连接数据库报ORA-12154错误该错误是由于64位操作系统安装32位的pl/sql developer在Program Files (x86)目录下，把目录改一下名或是把pl/sql移到Program Files目录下就可以了。
-
编辑 删除
测试将表缓存到keep池
1、设置keep池大小SYS@jzh>alter system set db_keep_cache_size=60m;System altered.2、创建测试表JZH@jzh>create table t as select * from dba_objects;Table created.3、查看执行计划JZH@jzh>select * from t;74756 rows selected.Statistics----------------------------------------------------------&nb...
-
编辑 删除
ASM file metadata operation
CAUSEEvent 'KSV master wait' indicates the process on the RDBMS side is waiting for a reply from a process on the ASM side. In 11g, the parameter cell_offload_processing is set to TRUE. Although that is a parameter is not applicable for non-Exadata databases, it caused ASM to...
-
编辑 删除
RMAN恢复单个表空间或被DROP/DELETE/TRUNCATE的表
1、初始化数据JZH@jzh>create table t as select * from dba_objects;Table created.JZH@jzh>select count(*) from t; COUNT(*)---------- 74756JZH@jzh>select bytes/1024/1024 from dba_segments where segment_name='T';BYTES/1024/1024--------------- ...
-
编辑 删除
等待事件：regmsr：become active
regmsr：become active该等待事件说明：会话正在等待一个resource manager的活动会话slot,当启用resource manager时，并且当前会话consumer group的活动session数量超过当前resource plan的会话限制就会发生该等待事件。禁用与启用resource plan与window 步骤如下：一、禁用resource plan与window:1、查询WINDOW状态和禁...
-
编辑 删除
ORACLE TEXT安装与卸载
1.创建CTXSYS用户以SYS用户执行以下脚本：SQL> connect SYS/password as SYSDBASQL> spool text_install.txtSQL> @?/ctx/admin/catctx.sql change_on_install SYSAUX TEMP NOLOCK各参数含义：change_on_install – 设置ctxsys用户密码SYSAUX – 调置ctxsys用户默认表空间TEMP – 设置ctxsys用户默认临时表空间LOCK...
-
编辑 删除
ORA-00600: internal error code, arguments: [kssadd: null parent]
某客户核心系统报ORA-00600,ORA07445错误,alert日志如下：Fri Nov 04 02:01:01 2016Errors in file /oracleser/app11203/oracle/diag/rdbms/jzhdb/jzhdb/trace/jzhdb_ora_15269992.trc (incident=1177618):ORA-00600: internal error code, arguments: [kssadd: null parent], [], [], [], [], [], [], [], ...
-
编辑 删除
ORA-00494: enqueue [CF] held for too long (more than 900 seconds)
近日某客户数据库凌晨5点左右crash，报如下错误：Fri Nov 11 03:17:51 2016Thread 1 advanced to log sequence 583682 (LGWR switch) Current log# 16 seq# 583682 mem# 0: /jzh/jzh_u38/jzh/redo16a.logFri Nov 11 05:23:03 2016ALTER SYSTEM ARCHIVE LOGFri Nov 11 05:23:03 2016Thread 1 cannot allocate n...
-
编辑 删除
ORACLE 回滚段详解
ORACLE 回滚段 回滚段概述 回滚段用于存放数据修改之前的值（包括数据修改之前的位置和值）。回滚段的头部包含正在使用的该回滚段事务的信息。一个事务只能使用一个回滚段来存放它的回滚信息，而一个回滚段可以存放多个事务的回滚信息。 回滚段的作用 事务回滚：当事务修改...
-
编辑 删除
位图索引导致update阻塞insert语句
近日某客户核心系统数据库出现hang住情况，AWR报告top 5中”enq: TX - row lock contention“占DB Time 97%以上，如下：trace文件中显示两个session互相阻塞，并且阻塞了大量sessionsclient details: O/S info: user: sunflow, term: unknown, ospid: 1234 machine: pdccsfwm...
-
编辑 删除
X$ 视图介绍 （一）
原文：Oracle Wait Interface—A Practical Guide to Performance Diagnostics & Tuning Richmond Shee Kirtikumar Deshpande K Gopalakrishnan McGraw-Hill/Osborne 2100 Powell Street, 10th Floor Emeryville, Ca...
-
编辑 删除
x$视图介绍（二）
Why are people so intensely interested in Oracle internals? Partly because internals information can be useful for tuning and troubleshooting. But also because Oracle Corporation has kept most of the ...
-
编辑 删除
PING[ARC2]: Heartbeat failed to connect to standby 'jzhddg'. Error is 16032.
重建Data Guard遭遇错误PING[ARC2]: Heartbeat failed to connect to standby 'jzhddg'. Error is 16032.主库端archivelog无法传至备库端，主库端报如下错误：FAL[server, ARC0]: FAL archive failed, see trace file.ARCH: FAL archive failed. Archiver continuingORACLE Instance jzhd1 - Archival Error. Archiver ...
-
编辑 删除
ORA-00245:control file backup failed;targetis likely on local file system
在RAC数据库其中一个实例创建standby controlfile失败，报如下错误：SQL> alter database create standby controlfile as '/home/oracle/standby01.ctl';*ERROR at line 1:ORA-00245:control file backup failed;targetis likely on local file system该错误是由于11gR2 RAC在备份控制时，每个实例都要能够写snapshot ...
-
编辑 删除
RMAN-06100: no channel to restore a backup or copy of datafile
今日重建DG遭遇RMAN-06100: no channel to restore a backup or copy of datafile错误，源端是一套RAC数据库，目标端是单实例，报错信息如下：Starting restore at 06-APR-16released channel: d1released channel: d2released channel: d3released channel: d4RMAN-00571: ========================================...
-
编辑 删除
lsdg中的Usable_file_MB 为什么是负值?
lsdg中的Usable_file_MB 为什么是负值?Negative Values of USABLE_FILE_MB Due to the relationship between FREE_MB, REQUIRED_MIRROR_FREE_MB, and USABLE_FILE_MB, USABLE_FILE_MB can go negative. Although this is not necessarily a critical situation, it does mean that: Depending on the value of FREE_MB, you may not be able to create new files. The next failure may result in files with reduced redundancy. If USABLE_FILE_MB becomes negative, it is strongly recommended that you a
-
编辑 删除
【AWR】调整AWR数据采样时间间隔及历史快照保留时间
1.AWR默认的采样间隔和历史快照保留时间默认是保留七天，采集间隔是1小时，这个信息可以从DBA_HIST_WR_CONTROL视图中获得。sys@ora10g> col SNAP_INTERVAL for a20sys@ora10g> col RETENTION for a20sys@ora10g> sel...
-
编辑 删除
Oracle 11R2 snapshot Data Guard
Oracle在11r1就开始支持snapshot data guard了，本次测试版本为11.2.0.31、取消DG端恢复模式SYS@jzh>select open_mode,database_role from v$database;OPEN_MODE DATABASE_ROLE-------------------- ----------------READ ONLY WITH APPLY PHYSICAL STANDBYSYS@jzh>recover...
-
编辑 删除
ORA-15018: diskgroup cannot be created
1、近日在redhat 5.8上安装Oracle 11.2.0.4 RAC时，在第二点节执行root.sh时遇到如下报错：ORA-15018: diskgroup cannot be createdORA-15072: command requires at least 3 regular failure groups, discovered only 0ORA-15080: synchronous I/O operation to a disk failed2、于是查看disk权限是否正确，结果没有任...
