AWR Warehouse adding host fails with ORA-20233..Or..”Just Add The Darn Thing..”

When happily adding hosts to the AWR Warehousing, some ex-RAC One nodes didn’t seem willing to be added..

When looking in the log file from OEM

/oracle/omsbase/em/EMGC_OMS1/sysman/log/emoms.log

The following entry came, just after adding the host:

2015-09-23 14:29:37,842 [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR ui.DbAwrDashboardBean logp.251 - Error submitting Extract / Transfer Job for [DB NAME HERE]
java.sql.SQLException: ORA-20233: Invalid Target=[DB NAME HERE] or Metric=db_failed_awr_uploads_status (validate_target_metric)
ORA-06512: at "SYSMAN.EM_COLL_UTIL", line 585
ORA-06512: at "SYSMAN.MGMT_COLLECTION", line 331
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
...

Googling this didn’t provide me any help, and Oracle Support came up blank also..

Dropping and adding the host in OEM didn’t help me either, so I did some digging..and found out this:

SQL> show parameter cluster_database

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cluster_database                     boolean     TRUE
cluster_database_instances           integer     1

However in OEM this host was known as an INSTANCE, and not an CLUSTER database.

Fix:

SQL> alter system set cluster_database=FALSE scope=spfile;

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1.2827E+10 bytes
Fixed Size                  2265224 bytes
Variable Size            7449087864 bytes
Database Buffers         5335154688 bytes
Redo Buffers               40861696 bytes
Database mounted.
Database opened.
SQL>

Now I was able to add the host correctly into the AWR Warehouse..

Advertisements

About GemsOfProgramming

Beeing a previously enthusiastic Java programmer, I rolled into the Oracle Database Administration world. It turned out I got a knack for this, and since approx. 2000 I'm a full time DBA. My experiences touches lot of Oracle products like Forms and Reports 9/10, JDAPI, Application Server, Weblogic Fusion and of course: Oracle Enterprise Databases, JavaFX, Swing and other Java components.
This entry was posted in AWR Warehouse, Oracle Enterprise Manager and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s