-
Oracle Linux(OEL)网卡参数默认设置导致ORA-27300、ORA-27301、ORA-27302错误
Sep232016之前有一套核心数据库(2节点RAC)，磁盘资源紧张，并且存储配置存在问题，I/O性能一直不高，因此新采购了一套EMC的存储，由于数据量很大(2.5TB)，使用DG(2节点RAC)进行存储切换，这个过程不表，切换后，新主库的第二个节点遇到ORA-27300、ORA-27301、ORA-27302错误。本案例环境OEL6.5，ORACLE 11.2.0.4。 Thu Sep 22 08: ...
阅读全文抢沙发
-
ORA-02019 connection description for remote database not found错误
Jul282016近期有一个项目要上线，开发人员在测试生产数据库的用户是否满足需求时，遇到了ORA-02019错误。 SQL> select * 2 from (select m.brd_pgm_schd_id || d.brd_pgm_schd_seq as adv_id, 3 m.brd_bgn_dtm as ymd, 4 m.brd_cl_dtm as eymd, 5 (case 6 when m.use_yn = 'Y' then 7 1 8 ...
阅读全文
-
使用DBLINK跨库查询遇到ORA-16000 database open for read-only access错误
Jul272016开发人员在备库使用DB LINK跨库查询时遇到ORA-16000: database open for read-only access错误。 SQL> SELECT A.ERP单号 AS REP_NO, 2 A.SKU AS SKU, 3 A.在途数量 AS QTY, 4 LOTATT08 AS GB_LVL 5 FROM VIEW_EDI_ERP_INVONLINE@WMS A 6 LEFT JOIN DOC_ASN_DETAILS@WMS B 7 ON A.WMS ...
阅读全文
-
使用DBLINK跨库查询遇到ORA-01861,ORA-02063错误
Jul212016开发人员在备库使用DB LINK跨库查询时遇到ORA-01861和ORA-02063错误。 SQL> with RST_WMS AS 2 -- T_WH_NO REP_NO REP_NUM WMS_NO F_WH_NO SY_RESOURCE SKU YQ_QTY QTY GB_LVL 3 (SELECT a.ERP单号 as REP_NO, 4 a.ERP行号 as REP_NUM, 5 a.WMS单号 as WH_NO, 6 a.WMS行号 as WMS_NUM, ...
阅读全文
-
ORA-04045，ORA-16000 database open for read-only access错误
Jul202016开发人员在备库查询时遇到ORA-16000错误。 SQL> SELECT /* broad-program-product-schedule-mapper.xml | selectGoodsSalesBrdUntPrdPMinOrdSList | han.ji.yul */ 2 M.BRD_PGM_SCHD_ID, 3 M.BRD_BGN_DTM, 4 (SELECT P.BRD_PGM_NM FROM MED_BRD_PGM_M P WHERE P.BRD_PGM_ID = M.BRD_PGM_ID) AS BRD_P ...
阅读全文
-
RMAN恢复遇到ORA-19909错误
May232016在使用RMAN恢复数据库的时候，有一个数据库在恢复的时候遇到ORA-01180错误，如下： Starting restore at 20-MAY-16 creating datafile file number=1 name=/data2/u01/app/oracle/oradata/ivlifdb/system01.dbf released channel: d1 released channel: d2 released channel: d3 released channel: d4 RMAN-005 ...
阅读全文作者：dbdream | 分类：Oracle, oracle 10g, oracle 11g | 标签：DBMS_BACKUP_RESTORE, ORA-01180, ORA-19909, RMAN-11003
-
11g新特性密码错误延迟严重导致数据库夯住
May092016
-
ORACLE数据库ORA-00392 log 4 of thread 1 is being cleared, operation not allowed错误
May052016昨天在使用RMAN备份恢复测试数据库的时候，不小心在rename logfile的时候把名字搞错了路径，导致在resetlogs打开数据库的时候遇到以下错误。 SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-00344: unable to re-create online log '/data2/u04/app/oracle/oradat ...
阅读全文作者：dbdream | 分类：Oracle, oracle 10g, oracle 11g | 标签：Linux-x86_64 Error, ORA-00312, ORA-00344, ORA-00392, ORA-27040
-
ORACLE数据库内存设置过大，导致服务器异常缓慢
Apr292016昨天登录一个数据库服务器，感觉很慢，通过top命令发现当前CPU已经使用50%，交换分区基本用光。 [oracle@SL010A-IVTDB1-NEW ~]$ free -m total used free shared buffers cached Mem: 64383 63870 512 0 9 58696 -/+ buffers/cache ...
阅读全文
-
ORACLE数据库SQL优化
Apr282016今天一早，开发人员就过来找我看一条SQL，业务人员说这条SQL很慢，要30秒才能跑完，SQL如下： SELECT SUM(B.RL_SLS_AMT) as "sumPrice", A.ORD_ID as "orderId" FROM CHGSHS.ORD_ORD_ADT_D A, CHGSHS.ORD_ORD_DTL_D B, CHGSHS.ORD_ORD_DTL_D_EXT D WHERE A.ORD_ADT_PSS_YN = 'N' AND A.ORD_ID = B.ORD_ID AND A ...
阅读全文