Thursday, May 27, 2010

Backup Job fails with Agent unreachable when agent in one of rac nodes is down.

Please run the below procedure connecting as SYSMAN to the repository database

BEGIN
EMD_RAC.REGISTER_AVAILABILITY( 'rac_database', 'Response', 'Status', 'oracle_database','3.1');
COMMIT;
END;

Bounce the DB Control.

The Cpu & Active Sessions Charts Show "No Data Is Currently Available" For Cluster Database

On the EM dbconsole home page the Cpu & Active Sessions Charts Show "No Data Is Currently Available" For Cluster Database. In emagent.trc you find the following lines:

emagent.trc shows:-
2008-07-02 09:06:10 Thread-4124015504 WARN TargetManager: Query returned 0 rows (only one expected) for the dynamic property DGPrimaryDBName
2008-07-02 09:06:10 Thread-4124015504 WARN TargetManager: The execution of the query for DGPrimaryDBName in {RACDB, rac_database} is missing the following required property values : DGPrimaryDBName

This is can happen after a RAC node reboot.

To fix this issue you must apply patch for BUG:6005707

The following workaround is available:

$ORACLE_HOME/bin/emctl reload agent dynamicproperties [targetname]:[targettype]

eg.

emctl reload agent dynamicproperties RACDB:rac_database

Wait 5 minutes , after this the charts should be visible.

Thursday, May 20, 2010

10gR2 RAC ORA-00600 kgeade_is_0

Full Error on alert.log :
ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []

Line from trace file :
select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag from GV$FILESPACE_USAGE where inst_id != :inst and (changescn_wrap >= :
w or (changescn_wrap = :w and changescn_base >= :b))

Having the initialization parameter PARALLEL_EXECUTION_MESSAGE_SIZE set to a different value on one or more instances in the cluster could cause an error when querying the gv$ views.

Solution

Make the parameter same across all RAC instances.

ALTER SYSTEM SET parallel_execution_message_size=2148 SCOPE=SPFILE SID='*';

Restart instance having this errors !!!

Tuesday, May 18, 2010

Oracle Blogs on the WEB

One of the coolest blogs about Oracle in the Web.

http://jarneil.wordpress.com/

Thursday, May 13, 2010

Oracle 10g RAC articles

A nice collection of articles concerning Oracle 10g RAC from database journal.

http://www.databasejournal.com/article.php/3559996