逝鸿的博客

db_unique_name写错了

For Oracle Clusterware installations, you must also add additional disk space for the Oracle ASM metadata. You can use the following formula to calculate the disk space requirements (in MB) for OCR an...

转自http://blog.itpub.net/7417681/viewspace-1061318/1.create index 会阻塞其它会话修改索引字段，直到索引创建结束；2.create index online 允许其它会话修改索引字段，但如果修改索引字段的会话没有commit或是rollbak，则索引创建会被阻塞；3.online创建索引时会临时创建一个IOT的表，索引创建结束后...

SQL> begin 2 p_rowid(3,0); 3 end; 4 / p_rowid(3,0); *ERROR at line 2:ORA-06550: line 2, column 5:PLS-00905: object SCOTT.P_ROWID is invalidORA-06550: line 2, column 5:PL/...

适用于:Oracle Database - Enterprise Edition - 版本 10.1.0.2 到 12.1.0.1 [发行版 10.1 到 12.1]本文档所含信息适用于所有平台目标在您将磁盘加入到已有的生产磁盘组之前，您可以使用下面步骤去校验候选磁盘状态，并保障可以被每个节点访问（这样可以防止对现有生产磁盘组造成损害），具体步骤如下：解决方案1) 使用 Or...

转自https://blog.csdn.net/robertsong2004/article/details/36879233for i in `seq 1 $(cat /proc/cpuinfo |grep "physical id" |wc -l)`; do dd if=/dev/zero of=/dev/null & done说明:cat /proc/cpuinfo |g...

APPLIES TO:Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]Information in this document applies to any platform.GOALalert.log has many entries with:R...

select error from v$archive_dest where target='STANDBY';

看看选取的最后一个字段与from之间是不是有逗号。

转自http://www.cnblogs.com/qinjunli/p/4588089.html项目在运行过程中，后台报错：   ORA-01000: maximum open cursors exceeded ORA-00604: error occurred at recursive SQL level 1       网上搜索了一下，找到了原因根源：　　使用Oracl...

APPLIES TO:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.4 [Release 10.1 to 11.2]Enterprise Manager for Oracle Database - Version 10.2.0.4 to 10.2.0.4 [Release 10.2]Information...

Versions 10.1, 10.2, 11.1, 11.2, 12.1Error: ORA-19921 maximum number of %s rows exceeded ---------------------------------------------------------------------------Cause: The maximum number of ...

转自http://scs.commvault.com/forum.php?mod=viewthread&tid=731. 文档说明本文档主要描述了工程师在安装配置及使用CommVault时，与ORACLE相关的常见问题及解决思路和办法。主要包括以下几部分内容：在哪里查看错误信息与ORACLE相关常见问题  2. 详细内容2.1. 在哪里查看错误信息在Comm...

描述Oracle中的模式（大约24个字符或更大）尝试使用st_geometry创建空间索引可能导致以下Oracle错误： 代码：ORA-29902: error in executing ODCIIndexStart() routineORA-06502: PL/SQL: numeric or value error: character string buffer too smal...

java -Duser.language=en -Duser.country=us -jar oswbba.jar -i或者在控制面板>区域>格式改成英语（美国）

APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.2.0 and laterInformation in this document applies to any platform.SYMPTOMSo Multi node RAC clustero Grid Infrastructure 11.2.0....

由于直方图的限制，直方图中只存储12c之前的前32个字符（或12c以上的64个字符）。 具有相同前32个字符的值将被视为相同，这会导致更多列值被视为常用值。 这会导致估计不正确的基数，并错误地选择TABLE FULL SCAN。执行以下命令删除12c之前超过32个字符（或12c以上64个字符）的列的错误直方图：exec DBMS_STATS.DELETE_COLUMN_STATS(own...

备端SQL> ALTER DATABASE OPEN READ ONLY;ALTER DATABASE OPEN READ ONLY*ERROR at line 1:ORA-10458: standby database requires recoveryORA-01152: file 1 was not restored from a sufficiently old bac...

APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]Workspace Manager - V...

APPLIES TO:Oracle Database - Enterprise Edition - Version 8.1.7.4 and laterInformation in this document applies to any platform.SYMPTOMSGetting ORA-1152 trying to open the database after incomp...