PLS-00382: expression is of wrong type When using “execute immediate” dynamic SQL statement

今天测式部门同事遇到的一个问题记录一下,开发库运行正常,同样的复制到测试库执行应用报错,
LINE/COL ERROR
——– —————————————————————–
59/5 PL/SQL: Statement ignored
59/23 PLS-00382: expression is of wrong type

,

Exp Error exp-56 ORA-24324 and ora-7445 in alert When shared pool is very small

EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
ORA-07445: exception encountered: core dump [kgghstfel()+15] [SIGSEGV] [Address not mapped to object]

Script:List all SQL in the library cache cursor referencing a given table .(列出指定表上所有相关SQL)

PROMPT List all SQL in the library cache cursor referen […]

How to setup Mysql Replication Master-Slave ?(MySQL主从复制)

只是简单的记录主从的配置过程和一些常用排错方法 ,我本次安装使用的是mysql 5.6.16,和之前的老版本配置可能有些不同。

MySql 5.5 tar安装及sysbench 配置

Next, let’s create the mysql user and group: groupadd m […]

Recovery Loss Of Datafile For Which No Backup Is Available(恢复没有备份的数据文件)

来模拟一种刚建的表空间,还没来的及备份,数据文件被删除,但archive log 都在时的恢复。 sys@AN […]

Build the BBED utility in ORACLE 11G on linux

Oracle has the BBED utility (block browser and editor) is is all releases of Oracle, from Oracle7 to Oracle10g,In Oracle 11g, BBED becomes unavailable but if you search in the ins_rdbms.mk makefile,…

11G ADG automatic repair corrupt data blocks(ABMR自动坏块修复)测试二

standby site 的ABMR没有成功, 后来是怀疑buffer header中有mrec 的block, 现在我接着测试如果buffer header 中没有此类block,ABMR是否成功?以前用bbed 标记corrupt block的方式, 如果有corrupt block时rman backup 又会怎么样?

,

11G ADG automatic repair corrupt data blocks(ABMR自动坏块修复)测试一

Automatic block repair allows corrupt data blocks to be automatically repaired as soon as the corruption is detected. This feature reduces the amount of time that data is inaccessible due to block corruption.

,

ORA-12592: TNS:bad packet issue on Dataguard primary site

今天刚搭建的一个Data guard环境,一开始在日志传输时遇到ora-12592错误,ORA-12592: TNS:bad packet

,

AWR Formatter (一个不错的AWR报告格式化google chrome 插件)

一个不错的oracle AWR 报告本地文件格式化chrome浏览器插件,看似用js完成,有一些特性非常不错, […]

Resize datafile hit ORA-01237 ORA-27059 OSD-04005 O/S-Error: (OS 665) on windows 2008

当你在windows NTFS文件系统操作大的数据文件时,有时会遇到下面的错误:
The operating system returned error 665 (The requested operation could not be completed due to a file system limitation)

CRS-4124 CRS-4000 Oracle HAS startup failed after reboot server (RHEL6)

# crsctl start has
CRS-4124: Oracle High Availability Services startup failed.
CRS-4000: Command Start failed, or completed with errors.

How to used the gdb (GNU Debugger) Collecting Hanganalyze and Systemstate Dumps on Linux systems(操作系统收集hanganalyze和systemstate)

Prior to 10g you can use a unix debugger like gdb, adb or dbx to attach to a shadow process and dump the system state using the function ksudss which is the subroutine in the Oracle source code which does the same.

More about dead transactions recovery and cleanup(死事务的回滚清理)

If you need to recovery the dead transaction record of more than 100(_cleanup_rollback_entries parameter value), PMON only responsible for cleaning up dead session, which is responsible for the SMON recovery dead transaction.

2013辞旧迎新2014

结束意味着新开始,结束会有莫名的伤感和失落,2013 有快乐有忧伤,有收获有遗憾,放下那些本该不属于你的东西, 不要急着上头条成为万人瞩目, 因为这一年你没有汪峰忙…

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.

How to enable SQL*Net Tracing with Oracle Instant Client (二)

Dynamic server tracing allows for tracing at a per-process level and can be enabled ad hoc on any running server process. This is useful for tracing individual server side processes of a specific client connection or for tracing background server processes.