-
编辑 删除
0509-130 Symbol resolution failed for /usr/lib/libc.a[aio_64.o]
客户说执行sqlplus时报错，详细见下： $ sqlplus 'sys/ligle as sysdba' SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jun 22 08:56:29 2011 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. exec(): 0509-036 Cannot load program oraclebcrm because of the following errors:0509...
-
编辑 删除
channel t1: no AUTOBACKUP in 7 days found
RMAN> run {<br />2> allocate channel t1 type 'sbt_tape'<br />3> parms 'ENV=(NSR_SERVER=backupsvr4, NSR_CLIENT=toyy2b,NSR_DATA_VOLUME_POOL=TOYY2fulldata)';<br />4> restore controlfile from 'IBM-3584-2_toyy2_full_ORAYY2_gfqd4urg';<br />5> release channel t1;<br />6> }<br /><br ...
-
编辑 删除
ALTER SYSTEM FLUSH REDO TO shsnc_standby;报错 ORA-00922
SQL> shutdown abort;ORACLE instance shut down.SQL> startup mount;ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instanceORACLE instance started.Total System Global Area 246386688 bytesFixed Size 2212208 b...
-
编辑 删除
客户端通过SCAN TNS无法连接ORA-12545
[oracle@c4yybcv3] /oracle/app/oracle/product/11.2.0/dbhome_1/network/admin> sqlplus hurp/hurp@toyy3_scanSQL*Plus: Release 11.2.0.3.0 Production on Tue May 26 09:48:27 2015Copyright (c) 1982, 2011, Oracle. All rights reserved.ERROR:ORA-12545: Connect failed because target host or obje...
-
编辑 删除
TNS-12533: TNS:illegal ADDRESS parameters
[oracle@c4yybcv3] /oracle/app/oracle/product/11.2.0/dbhome_1/network/admin> tnsping toyy3_scanTNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 26-MAY-2015 09:36:51Copyright (c) 1997, 2011, Oracle. All rights reserved.Used parameter files:Used TNSNAMES adapt...
-
编辑 删除
ORA-38754: FLASHBACK DATABASE NOT STARTED时请求的归档无效
参考文档：ORA-38754: FLASHBACK DATABASE NOT STARTED - REQUIRED REDO LOG IS NOT AVAILABLE (文档 ID 560686.1)版本：Oracle Database - Enterprise Edition - Version 10.1.0.2 and laterInformation in this document applies to any platform.***Checked for relevance on 29-Apr-2013***问题现象：When try...
-
编辑 删除
CRS-4640
[root@toyy3a_cs] /grid/product/11.2.0/gridhome_1/bin> ./crsctl start crsCRS-4640: Oracle High Availability Services is already activeCRS-4000: Command Start failed, or completed with errors.
-
编辑 删除
oracle data guard dest_id 出现错误（wrong)目标号 通过SRL解决此问题
适合版本：Oracle Server - Enterprise Edition - Version: 10.2.0.5 to 11.2.0.2 - Release: 10.2 to 11.2Information in this document applies to any platform.问题描述：Within a Dataguard environment the value of dest_id in v$archived_log on standby database lists the primary dest_id instead of th...
-
编辑 删除
ges resources暴长导致 ORA-04031 一案例
一存储过程，导致数据库出现ORA-04031且现象：Wed May 6 09:16:34 2015Errors in file /oracle/app/admin/oraxy3/udump/oxy3a_ora_1483130.trc:ORA-04031: unable to allocate 4216 bytes of shared memory ("shared pool","insert into CREDIT_EVENT_ERR...","sga heap(3,0)","library cache")ORA-04031: unab...
-
编辑 删除
Oracle审计－－AUD$占用空间较大处理方案
Oracle 11G以后，数据库默认是开启审计功能的，因此有时候我们忘记了关闭该功能导致SYSTEM表空间暴满，但由于关闭审计功能需要重启数据库，此类操作生产环境下是不允许的，因此我们需要找出哪类审计产生的较多，然后单独的进行关闭；我们可以通过如下方法查找：如果你发现AUD$这个表比较大了，检查下是哪种审计占的空间...
-
编辑 删除
登陆数据库时，如果密码中包含@字符时，需要进行转义，否时报ORA-12154?
操作系统下登陆数据库时，如果密码中包含@字符时，需要进行转义，否时报ORA-12154oracle@TBZJS1:[/oracle/app/oracle/product/11.2.0/dbhome_1/bin] sqlplus CHENJING/bzzw@4321@TBZJS1_obzjs1SQL*Plus: Release 11.2.0.2.0 Production on Mon Apr 27 14:45:47 2015Copyright (c) 1982, 2010, Oracle.  ...
-
编辑 删除
How To Resolve Stranded DBA_2PC_PENDING Entries [ID 401302.1]
修改时间 21-NOV-2011 类型 BULLETIN 状态 PUBLISHED Applies to:Oracle Server - Enterprise Edition - Version: 8.1.5.0 to 11.1.0.6 - Release: 8.1.5 to 11.1Information in this ...
-
编辑 删除
ORACLE 创建DBLINK 自动加域名解决方案
创建DBLINK 自动加域名通过如下方法可以解决，创建DBLINK自动加域名1.查看global_name的设置（默认都是false，不过跟这个没有任何关系的，这个参数如果为true时就需要建db_link时域名必要跟目标库一致才行)SQL> show parameters global_name;NAME  ...
-
编辑 删除
ORACLE 逻辑坏块真实案例ORA-01578 ORA-01110
2015年04月15日 某系统由于内存故障导致RAC的B节点发生宕机，在宕机其间tjs1b库由于宕机出现3个坏块，经分析3个坏块为逻辑坏块，共涉及到两个索引的两个分区。对索引分区进行重建完成修复；现象：ORACLE Instance ojs1a (pid = 26) - Error 1578 encountered while recovering transaction (173, 11) on object 4054036....
-
编辑 删除
ORA-14086: a partitioned index may not be rebuilt as a whole
SQL> alter index SDSETTLE.UN_PK_STLGPRSCNGKEY rebuild online parallel 16;alter index SDSETTLE.UN_PK_STLGPRSCNGKEY rebuild online *ERROR at line 1:ORA-14086: a partitioned index may not be rebuilt as a whole正常重建分区...
-
编辑 删除
oracle gcr sleep in the Top Timed Events in report
如下图所示：GCR sleep 等待事件占用比例很高Applies to:Oracle Server - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]Information in this document applies to any platform.GoalThe GCR sleep Event is appearing in the Top 5 Timed Events in a statspack report.How do I ...
-
编辑 删除
dblink 删除问题
今天看到yangtingkun在blog上遇到无法删除 db link的问题（http://yangtingkun.itpub.net/post/468/259496），我在半年前也遇到类似的问题，当时也作了简单的记录，现在贴出来，希望大家一起分析原因。今天遇到一个很奇怪的问题在linux as3+oracle9204配置高级复制时，新建了一个dblink，后来不知道做过什么操作...
-
编辑 删除
ORA-22835: 缓冲区对于 CLOB 到 CHAR 转换或 BLOB 到 RAW 转换而言太小
报错信息：Tue Jan 06 09:34:24 2015Errors in file /ggs/oracle_log/diag/rdbms/orayy3/oyy3a/trace/oyy3a_ora_10028532.trc:ORA-22835: 缓冲区对于 CLOB 到 CHAR 转换或 BLOB 到 RAW 转换而言太小 (实际: 9419, 最大: 4000)Tue Jan 06 09:34:31 2015Errors in file /ggs/oracle_log/diag/rdbms/orayy3/oyy3a/trace/...
-
编辑 删除
oracle troubleshooting waits for locks/Enqueues other than 'TM','TX' and 'UL'
Troubleshooting Waits for Locks / Enqueues Other than 'TM', 'TX' and 'UL' (文档 ID 1905157.1)适用范围：7i以后的任何平台，任何版本；目的：本章节的目的是当面对非普通锁（TM\TX\UL）时我们如何处理；注：enqueues分两种，一种是普通锁也可叫做User Type Locks (TM, TX and UL Enqueues)，另一种是非普通锁被...
-
编辑 删除
9I RAC驱逐案例分析－ORA-29740
9I RAC驱逐案例：参考文档：Troubleshooting Instance Evictions (Instance terminates with ORA-29740, Instance Abort, Instance Kill) (文档 ID 1549135.1)现状：开通系统：skt2b 数据库宕掉原因：客服3系统服务IP被SKF3A接管原因：服务IP网卡所在的笼子损坏，被skf3a正常接管；开通系统...
