Thursday, October 9, 2008

OEM cannot monitor second RAC instance - ORA-12519

Failed to connect to database instance: ORA-12519: TNS:no appropriate service handler found (DBD ERROR: OCIServerAttach).

Modify the SID definition for the second instance in the "Database Configuration Page":

FROM :-

racsid2

TO :-

racsid2)(INSTANCE_ROLE=ANY

emctl clearstate agent
emctl upload agent
emctl status agent

See the following Metalink Note :-
Note.335046.1 Problem Database Monitoring ORA-12519 Returned When Monitoring Secondary Instance Of Rac Database