-
编辑 删除
关于DFS lock handle等待事件
碰到数据库中出现DFS lock handle等待事件，该如何分析
-
编辑 删除
OCR / Vote disk Maintenance Operations: (ADD/REMOVE/REPLACE/MOVE)
Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.6Information in this document applies to any platform.Oracle Server Enterprise Edition - Version: 10.2.0.1 to 10.2.0....
-
编辑 删除
查看表空间剩余空间的详细信息
- PL/SQL script. to determine how much contiguous free space is available for each tablespace in the database. Oracle will acquire space by searching first for exact fit, then ne...
-
编辑 删除
解决crs_stat -t看到资源为UNKNOWN的情况
Common Causes for CRS Resources in UNKNOWN State [ID 860441.1]Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.7 - Release: 10.2 to 11.1Information in this document applies ...
-
编辑 删除
How to Deinstall Oracle Clusterware Home Manually
In this Document Goal SolutionApplies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later [Release: 10.2 and later ]Information in this document applies to any platf...
-
编辑 删除
Drop Table Fails With ORA-600 [15264]
Drop Table Fails With ORA-600 [15264] [ID 338953.1]修改时间 10-APR-2012 类型 PROBLEM 状态 PUBLISHEDIn this DocumentSymptomsChangesCauseSolutionReferencesApplies to:Oracle Server - Enterprise Edition ...
-
编辑 删除
oracle ASM参数ASM_POWER_LIMIT以及其它一些参数详解
ASM_POWER_LIMIT 参数 这个参数 ASM_POWER_LIMIT 参数控制 ASM 后台进程 ARBx 的数量。ARBx 进程用来进行 ASM 磁盘数据重新分布打散。ASM_POWER_LIMIT 取值 从 0 到 11(据说从 10gR2 开始可以设置为 0，设置为0是为...
-
编辑 删除
一次ASM磁盘空间假装耗尽 ORA-15041: DISKGROUP SPACE EXHAUSTED
给ASM磁盘新增一块盘进去，ASM_DISK2剩余空间四百多G：SQL> select * from v$asm_diskgroup;GROUP_NUMBER NAME &...
-
编辑 删除
oracle数据库不完全恢复
一个表的数据被删掉，不清楚具体时间，得恢复到几天前的数据，准备恢复26号的全备。1、用spfile启动数据库到nomount状态。2、恢复一个全备之后不久的控制文件出来，启动到mount状态3、restore database4、recover da...
-
编辑 删除
dbms_logmnr 在线挖归档 恢复数据
需求确认：A.删除数据的表：USERNAME.TABLE_NAME B.执行删除操作的用户：USERNAMEC.执行操作的时间范围： 4月1日10:11左右操作步骤：1.查询指定时间点上的归档select thread#,SEQUE...
-
编辑 删除
ORA-01555
ORA-01555错误的基本步骤，希望对大家有所帮助0. 开始先看看rollback segment是否有分配不当的问题，例如某一个rollback segment（报错的那个）太小。如果有，先recreate rollback segment以保持所有的回滚段大小一...
-
编辑 删除
ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on device
一个库需要调整内存参数alter system set pga_aggregate_target=2G scope=spfile;alter system set sga_max_size=10G scope=spfile;alter system set sga_target=10G scope=spfile;调整完之后，重启SQL> sta...
-
编辑 删除
使用在线重定义建分区表
Applies to:Oracle Server - Enterprise Edition - Version 9.2.0.4 and laterInformation in this document applies to any platform."Checked for relevance on 29-Sep-2010"GoalThe purpose of this document is ...
-
编辑 删除
Installing and Using Standby Statspack in 11g
Applies to:Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.2.0.2 - Release: 11.1 to 11.2Information in this document applies to any platform.PurposeStatspack/AWR cannot be executed on a s...
-
编辑 删除
Simplified Approach to Resolve ORA-4031
After writing few Case studies and other related articles, I will be sharing my approach for Resolving ORA -4031 error. First we will see what ORA-4031 actually means.04031, 00000, "unable to allocate...
-
编辑 删除
Oracle的home目录空间占用异常处理
OS：HP-UX B.11.31 U ia64Oracle：10.2.0.4Oracle的home目录空间占用异常处理,情况如下：/export/home/oracle 空间占用90％了du出来的空间是8333060，bdf出来的是18725588bdf结果如下：/dev/v...
-
编辑 删除
Oracle安装，ssh配置
11G Oracle安装介质中自带有ssh配置脚本，配置双机信任关系变的很简单，运行一下脚本就行，如下：在rac1上运行cd /mnt/hgfs/vmsharedir/Oracle11gR2p1linux/grid/sshsetup/./sshUserSetup.sh -user root -hosts ...
-
编辑 删除
Drop tablespace与drop user
drop user sam_gdcz31 cascade;Drop tablespace 有下面两种方式：drop tablespace crm_data including contents and datafiles;drop tablespace crm_data including contents cascade constraints;报错有下面几种：...
-
编辑 删除
ORA-19706: invalid SCN
SQL> create public database link TEST connect to system identified by oracle using 'abmsrv1';Database link created.SQL> select count(*) from dba_users@TEST;select count(*) from dba_users@TEST &n...
-
编辑 删除
online rebulid index异常终止遇到ora-08104
create index idx_p_merchant_detail_id on D_ORDER_DETAIL (merchant_detail_id) Online;创建好长时间，没有反映；然后取消，结果删除索引的时候，报如下的错误： 错误：ORA-08104: this index object 67420 i...
