6 逝鸿

尚未进行身份认证

我要认证

暂无相关简介

等级
TA的排名 1w+

ORA-12514: TNS:listener does not currently know of service requested in connect

db_unique_name写错了

2020-02-20 22:23:17

oracle RAC OCR磁盘所需空间的计算方式

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

2019-12-18 15:50:23

create index/create index online区别

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

2019-01-21 14:28:36

一个挺好的查看错误的方法

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

2019-01-18 17:22:34

如何在 RAC 集群或单机 ASM 环境中对已经存在的 Diskgroup 添加新磁盘(最佳实践) (Doc ID 1946668.1)

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

2019-01-10 21:12:34

[Linux小技巧] 一行命令让CPU占用率达到100%

转自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...

2019-01-09 21:37:15

Resize Operation Completed For File# 201; FILE# Does Not Exist (Doc ID 2246369.1)

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

2018-12-24 16:23:15

一个比较方便的查看DG同步失败原因的方法

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

2018-12-21 14:18:43

ORA-00936: missing expression

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

2018-11-07 11:31:41

oracle ORA-01000: maximum open cursors exceeded问题的解决方法

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

2018-11-02 18:17:16

RMAN Connect Target fails RMAN-06900 RMAN-06901 ORA-19921: maximum number of 128 rows exceeded

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

2018-10-25 09:38:12

OERR: ORA-19921 "maximum number of %s rows exceeded" Reference Note (Doc ID 288203.1)

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

2018-10-25 09:18:44

CommVault备份Oracle相关问题总结

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

2018-10-25 09:08:17

ORA-29902: error in executing ODCIIndexStart() routine when creating spatial index with st_geometry

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

2018-10-22 01:18:18

"Cannot format given Object as a Date" and "Invalid data found"

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

2018-10-12 15:06:29

在冗余互连环境中拔出一根网络电缆后,11gR2 CSS终止/节点驱逐(Doc ID 1481481.1)

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

2018-08-30 21:59:22

长度超过32个字符的字符列的直方图的SQL计划不正确导致表完全扫描(文档ID 2413826.1)

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

2018-08-30 14:10:26

ORA-01152: file 1 was not restored from a sufficiently old backup

备端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...

2018-08-29 15:30:35

WMSYS.WM_CONCAT Should Not Be Used For Customer Applications, It Is An Internal Function (文档 ID 1336

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

2018-08-11 09:59:26

Incomplete recovery gives ORA-01152 (文档 ID 278856.1)

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

2018-08-08 13:52:41

查看更多

勋章 我的勋章
  • 勤写标兵Lv1
    勤写标兵Lv1
    授予每个自然周发布1篇到3篇原创IT博文的用户。本勋章将于次周周三上午根据用户上周的博文发布情况由系统自动颁发。