Tag Archives: OEM

OEM安装报错不是内部或外部程序的解决过程

Posted on 2012/10/08 by yangtingkun

标题比较拗口，客户在安装OEM的时候碰到了“不是内部或外部命令，也不是可运行的程序或批处理文件”的错误。 客户环境是11.2.0.1 for Windows环境，以前配置过OEM，有一段时间没有使用，最近打算启用OEM，发现无法正常启动，尝试了多次后，只能将OEM清除掉。在卸载OEM并重新安装时，出现了这个错误。 详细的错误为： Connecting TO DATABASE USING CONNECT string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=NODE)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=DAISY))) IN home E:\app\Administrator\product\11.2.0\dbhome_1 WITH USER "SYS" ROLE "SYSDBA". connected TO DATABASE. SQL TO EXECUTE DECLARE repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); BEGIN repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); … Continue reading →

Posted in ORACLE | Tagged , , , | Leave a comment

ORA-600(qerfxFetch_01)错误

Posted on 2011/12/03 by yangtingkun

在客户的9201数据库中，发现这个错误。 错误信息为： Wed Jul 29 09:23:32 2009 Errors IN file /opt/oracle/admin/eomsdb/udump/eomsdb_ora_20242.trc: ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], [], [], [], [], []Wed Jul 29 09:23:32 2009 Errors in file /opt/oracle/admin/eomsdb/udump/eomsdb_ora_20242.trc: ORA-00600: internal error code, arguments: [qerfxFetch_01], [], [], … Continue reading →

Posted in BUG | Tagged , , | Leave a comment

OEM模块审计查询语句占用较大资源

Posted on 2011/10/14 by yangtingkun

发现一个导致Oracle自己的低效SQL，在AWR报告中占用较大的资源。 这个SQL在Elapsed Time、CPU Time、User I/O Wait Time、Buffer Gets、Physical Reads都会出现，其SQL模块是Oracle Enterprise Manager.Metric Engine。显然这是一个OEM自己的SQL，检查完整SQL语句： <pre lang=’SQL’>SELECT TO_CHAR(current_timestamp AT TIME ZONE ‘GMT’, ‘YYYY-MM-DD HH24:MI:SS TZD’) AS curr_timestamp, COUNT(username) AS failed_count FROM sys.dba_audit_session WHERE returncode != 0 AND TO_CHAR(timestamp, ‘YYYY-MM-DD HH24:MI:SS’) >= TO_CHAR(current_timestamp – … Continue reading →

Posted in BUG | Tagged , , | Leave a comment