Infrastructure at your Service

Yann Neuhaus

Monitoring 11g databases with Grid Control 10.2.0.5

The Metalink note 949858.1 describes problems with 10.2.0.5 agents monitoring 11g databases – this might be the case if you have an “old” 10.2.0.5 Grid Infrastructure you did not want to upgrade yet. The 11g databases are generating errors in both the alert.log and the log.xml file. The agent 10.2.0.5 agent seems to have problem with this. This posting will show you what to do.

To make an agent 10.2.0.5 aware about 11g databases, the changes described below must be performed. First of all, a library is not visible for the 10g agent software. This needs to be fixed with a soft link. The procedure is described here:

Bug 8482764 : VIEWING/SEARCHING DATABASE ODL ALERT LOG DISPLAYS NO RESULTS

/u00/app/oracle/product/10.2.0/agent10g/sysman/jlib/ ls -lrt ojdl*
 /bin/ls: ojdl*: No such file or directory
/u00/app/oracle/product/10.2.0/agent10g/sysman/jlib/ 
 ln -s ../../diagnostics/lib/ojdl.jar
/u00/app/oracle/product/10.2.0/agent10g/sysman/jlib/ 
 agent.ksh stop agent10g
/u00/app/oracle/product/10.2.0/agent10g/sysman/jlib/ 
 agent.ksh start agent10g

The function sys.dbms_system.ksdwrt cannot be used anymore in 11g in order to simulate an error in the alert.log file. In 10.2.0.5 databases, the following procedure has be used for testing the alert.log scanning:

declare
 Mess varchar2(300);
 begin
 Mess := 'ORA-04031 Test error for monitoring';
 sys.dbms_system.ksdwrt(2,Mess);
 commit;
 end;
 /

In 11g instead,you have to use “alter system set events” (see bug 10213998):

Bug 10213998: DBMS_SYSTEM.KSDWRT DOES NOT WRITE TO LOG.XML NO EFFECTIVE WAY TO SIMULATE ERRORS

Follow the procedure below:

SQL> alter system set events '942 incident(test)';
 System altered.
SQL> exit;

Connect to another session:

sqlplus / as sysdba
SQL> drop table foobar;
drop table foobar 
 * 
 ERROR at line 1: 
 ORA-942: table or view does not exist

In the alert.log:

Errors in file /u00/app/oracle/diag/rdbms/SID_site1/SID/trace/SID_ora_3314.trc  (incident=459770):
 ORA-00700: soft internal error, arguments: [EVENT_CREATED_INCIDENT], [942], [TEST], [], [], [], [], []
 ORA-00942: table or view does not exist

To disable the event:

SQL> alter system set events '942 off';

The following error is reported in the Grid and sent by mail if configured as follows:

yan_100205_1

yan_100205_2

Leave a Reply

Yann Neuhaus
Yann Neuhaus

Chairman of the Board, Chief Sales Officer (CSO), Region Manager