This discussion is archived
1 Reply Latest reply: Apr 26, 2013 2:06 AM by user7986366 RSS

OEM11g: emagent.trc messages: SYS login on +ASM - ORA-01219 DB not open

user7986366 Newbie
Currently Being Moderated
OEM GridControl 11g - RHEL5

On all our DB servers message below is generated constantly in emagent.trc. I can't seem to find any info about this. Does anybody know how to fix this?
Targets in GC all seems ok. Except one thing, and that is: Active Incidents = Unknown in the asm pane. If I click on unknown I can enter host and +ASM database credentials. If I do that after a while the message unknown is displayed.

emagent.trc Messages:
2013-03-19 10:00:05,987 Thread-119184288 WARN vpxoci: OCI Error -- ErrorCode(1219): ORA-01219: database not open: queries allowed on fixed tables/views only

SQL = "/* OracleOEM */
select RTRIM(severity_index, ' ') severity_index,
critic"...
LOGIN = sys/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=HOST1)(Port=1521))(CONNECT_DATA=(SERVICE_NAME=+ASM1)(INSTANCE_NAME=+ASM1)(UR=A)))
2013-03-19 10:00:05,987 Thread-119184288 WARN vpxoci: OCI Error -- ErrorCode(1219): ORA-01219: database not open: queries allowed on fixed tables/views only

SQL = "/* OracleOEM */
select RTRIM(severity_index, ' ') severity_index,
critic"...
LOGIN = sys/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=HOST1)(Port=1521))(CONNECT_DATA=(SERVICE_NAME=+ASM1)(INSTANCE_NAME=+ASM1)(UR=A)))
2013-03-19 10:00:05,988 Thread-119184288 ERROR fetchlets.sql: ORA-01219: database not open: queries allowed on fixed tables/views only
2013-03-19 10:00:05,989 Thread-119184288 ERROR engine: [osm_instance,+ASM1_HOST1,incident_meter] : nmeegd_GetMetricData failed : <<<METRIC SKIP>>>ORA-01219: database not open: queries allowed on fixed tables/views only
2013-03-19 10:00:05,989 Thread-119184288 WARN collector: <nmecmc.c> Error exit. Error message: <<<METRIC SKIP>>>ORA-01219: database not open: queries allowed on fixed tables/views only

Thanx in advance.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points