ORA-10631: SHRINK clause should not be specified for this object(原因)

Shrink operations can be performed only on segments in locally managed tablespaces with automatic segment space management (ASSM). Within an ASSM tablespace. Restrictions on the shrink_clause.The shrink_clause is subject to the following restrictions…

ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [VOPRVL1], [], [], [], [], [], [], [] Issues

insert into table “with” subquery Failing with the following internel error.
ORA-600: internal error code, arguments: [voprvl1], [], [], [], [], [], [], []

ora-600 [2663]/[2662] internal error issue

A description for this ORA-600 [2003] error is not yet published. ora-600 2663/2662 is a data block SCN is ahead of the current SCN.

ORA-28002 Even If Default Prpfile PASSWORD_LIFE_TIME Has UNLIMITED Limit(用户profile密码生命周期无限制,密码仍然过期锁定的情形)

上周也就是2013年的最后一天,突然客户反应有些WEB应用页面报错只提到了ora-28002, 我立即用sqlplus 登录提示是ora-28001,显然密码已经过期, 我清清楚记的才因为一起类似问题, 前不久把所有的oracle 数据库应用用户profile PASSWORD_LIFE_TIME改为unlimited,怎么还会这样呢?

How to avoid “ORA-00932: inconsistent datatypes: expected – got CLOB” when distinct CLOB datatypes.

Large objects (LOBs) are not supported in comparison conditions. However, you can use PL/SQL programs for comparisons on CLOB data.

skgpspawn failed:category = 27143 in alert log

skgpspawn failed:category = 27143, depinfo = 24, op = pipe, loc = skgpspawn2


alter system set memory_max_target=0 scope=spfile;
shutdown immediate
SQL> show parameter target

memory_max_target big integer 3824M

Logon Storm and Memory shortage issue ORA-07445 dbgtrReserveSpace (记录一次登录风暴致内存不足的问题)

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x10] [PC:0x938E8C5, dbgtrReserveSpace()+99] [flags: 0x0, count: 1]
Errors in file /oracle/diag/rdbms/ora11g/ora11g/trace/ora11g_ora_13864.trc (incident=60801):
ORA-07445: exception encountered: core dump [dbgtrReserveSpace()+99] [SIGSEGV] [ADDR:0x10] [PC:0x938E8C5] [Address not mapped to object] []
Incident details in: /oracle/diag/rdbms/ora11g/ora11g/incident/incdir_60801/ora11g_ora_13864_i60801.trc
Use ADRCI or Support Workbench to package the incident.

Send email using utl_smtp in Oracle 11g (results in ORA-24247)(11g ACL 网络访问控制列表)

ORA-24247: network access denied by access control list (ACL)
ORA-06512: at “SYS.UTL_TCP”, line 17
ORA-06512: at “SYS.UTL_TCP”, line 267

How to imp job to another schema in same db(同一数据库导入JOB到另外一用户)

ORA-39083: Object type JOB failed to create with error:
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated

Dynamically Changing shared_pool_size fail!(动态修改Shared pool size失败)

因安装数据库时启用了ASMM,过了几天发现分配不太理想想禁用ASMM,手动调整shared_pool_size, 这是一个动态参数,修改后立即生效无需重启数据库实例,但修改时遇到了比较奇怪的现象。

ORA-07445 [kggchk()+77] [SIGSEGV] [Address not mapped to object]

今天有个项目系统负载突然变大,查到top sql是一个存储过程,执行计划缺少合理的索引,SQL是个update […]

Enabling Listener Trace ,TNS-01251

Enabling Listener Trace ,TNS-01251 Oracle version 11g i […]

ORA-00600 [qkssao2s1] internal error issue

ORA-00600: internal error code, arguments: [ORA-00600: internal error code, arguments: [qkssao2s1], [], [], [], [], [], [], []


exp 时注意保证三处的字符集一致,对于本例的US7ASCII(10g) DMP 导入 ZHS16GBK DB (11g),采用了修改dmp文件中的两处字符集编号,最终解决了字符集乱码问题。


The lowercase and quotes table names may not be able to audit(小写表名可能不会审计)

昨一好朋友问我开了审计,有些表但无审计记录。 下面我来还原这个问题 db_version oracle 102 […]

ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY

1) Export the snapshots and then do a manual purge To p […]

statement suspended, wait error to be cleared(二)

Oracle Database provides a means for suspending, and later resuming,
the execution of large database operations in the event of space allocation failures.

bind variable在11g 中出现Cursor: mutex S

今天看到一个案例,从10G升级到11GR2后cpu负载迅速上升,很快达到100%,通过OWI显示出现大量“Cursor: mutex S”事件,mutex S是发生在cursor cache上的序列化mutex

RMAN-08137: WARNING archived log not deleted, needed for standby or upstream capture process

When he tried deleting archivelog manually with RMAN on primary db host, he got following warning:

“归档日志未删除, 因为备用或上游捕获进程需要它”