OMS 11g strange behaviour after server restore

From: Patrice sur GMail <patrice.boivin_at_gmail.com>
Date: Mon, 6 Feb 2012 08:28:53 -0400
Message-ID: <CACH2EDL5DAi=Qxr9aB6nrYg0uwN9NOmkj9Y8t4thkdSu+qpAgg_at_mail.gmail.com>

We had to restore our EM11g server, but now the OMS is acting strangely. It fails to start but parts of it start flooding the repository database with sessions.

08:00 --
SQL> select username, count(*) from v$session group by username;

USERNAME                         COUNT(*)
------------------------------ ----------
                                       27
SYSMAN                                  1

[oracle_at_vsnsbioxp34 bin]# pwd

/u01/app/oracle/product/Middleware/oms11g/bin
[oracle_at_vsnsbioxp34 bin]# ./emctl start oms
Oracle Enterprise Manager 11g Release 1 Grid Control Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved. Starting WebTier...
WebTier Successfully Started
Starting Oracle Management Server...

SQL> /

USERNAME                         COUNT(*)
------------------------------ ----------
                                       28
SYSMAN                                  9
SYSMAN_MDS                              1

[oracle_at_vsnsbioxp34 bin]# ./emctl start oms
Oracle Enterprise Manager 11g Release 1 Grid Control Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved. Starting WebTier...
WebTier Successfully Started
Starting Oracle Management Server...
Oracle Management Server is not functioning because of the following reason: Unexpected error occurred. Check error and log files.

USERNAME                         COUNT(*)
------------------------------ ----------
                                       28
SYSMAN                                 50
SYSMAN_MDS                              1

after that, the session count keeps climbing. SQL> /

USERNAME                         COUNT(*)
------------------------------ ----------
                                       25
SYSMAN                                165
SYSMAN_MDS                              1

SQL> /

USERNAME                         COUNT(*)
------------------------------ ----------
                                       26
SYSMAN                                234
SYSMAN_MDS                              1

08:05 -- killing the OMS
[oracle_at_vsnsbioxp34 bin]# ./emctl stop oms
Oracle Enterprise Manager 11g Release 1 Grid Control Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved. Stopping WebTier...
WebTier Successfully Stopped
Stopping Oracle Management Server...
Oracle Management Server Successfully Stopped Oracle Management Server is Down

This is on AIX.

I have an SR open but am wondering if you might have encountered this.

• Patrice

<http://www.viadeo.com/fr/profile/patrice.boivin>
[image: Facebook]

<http://www.facebook.com/profile.php?id=100000206805521> [image:
LinkedIn] <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9> [image:
Twitter] <http://www.twitter.com/PatriceBoivin> [image:

Amazon]<http://www.amazon.com/gp/redirect.html?ie=UTF8&location=http%3A%2F%2Fwww.amazon.com%2Fgp%2Fregistry%2Fregistry.html%3Fie%3DUTF8%26type%3Dwishlist%26id%3D2JU0BBL2AGGSD&tag=casper-20>
[image:

Digg] <http://digg.com/patriceboivin> [image: Google]<http://https://sites.google.com/site/patriceboivin/>   Get a signature like this.
<http://r1.wisestamp.com/r/landing?promo=19&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_19> CLICK
HERE.<http://r1.wisestamp.com/r/landing?promo=19&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_19>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 06 2012 - 06:28:53 CST