11G OCM Patch OEM 10.2.0.5 (4)


Now that I solved the problem that I encountered in 11G OCM Patch OEM 10.2.0.5 (3), I am ready to try to configure OMS again.

Plan

The current plan is to:

  1. Use the procedure in Oracle Support Doc ID 278100.1 (How To Drop, Create And Recreate DB Control In A 10g Database).
  2. Retry the configuration procedure from 11G OCM Patch OEM 10.2.0.5 (3).

Remove Partial Repository

I will use Option 4. Delete DB Control Repository Objects Manually from Oracle Support Doc ID 278100.1.

drop user sysman cascade;
drop role MGMT_USER;
drop user MGMT_VIEW cascade;
drop public synonym MGMT_TARGET_BLACKOUTS;
drop public synonym SETEMVIEWUSERCONTEXT;

The result is:



User dropped.

SQL> 
Role dropped.

SQL> drop user MGMT_VIEW cascade
          *
ERROR at line 1:
ORA-01918: user 'MGMT_VIEW' does not exist


SQL> drop public synonym MGMT_TARGET_BLACKOUTS
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


SQL> drop public synonym SETEMVIEWUSERCONTEXT
                    *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist

Configure OMS Attempt #3

Using the script from 11G OCM Patch OEM 10.2.0.5 (3):

export PERL5LIB=/opt/oracle/app/oms10g/perl/lib/5.6.1
/opt/oracle/app/oms10g/perl/bin/perl /opt/oracle/app/oms10g/sysman/install/ConfigureGC.pl /opt/oracle/app

After an about one (1) hour, I get the following failure messages:

[oracle@gridctrl cfgfw]$ cd /opt/oracle/app/oms10g/cfgtoollogs/cfgfw
[oracle@gridctrl cfgfw]$ grep -in failed CfmLogger_2009-12-30_09-32-41-AM.log
784:INFO: oracle.sysman.top.oms:Secure Command = /opt/oracle/app/oms10g/bin/emctl status oms -secure  has failed. OMS Status Returned=
Securing agent...   Failed..agent:
914:INFO: oracle.sysman.top.agent:Requested Operation /opt/oracle/app/agent10g/bin/emctl secure agent has failed to perform with Status = 1
Securing agent...   Failed.
1064:DEFAULT WEBSITE EM Website CREATION FAILED : ORA-01403: no data foundORA-01403:
1070:ORA-20999: CREATE DEFAULT WEBSITE FAILED : ORA-01403: no data found
1082:DEFAULT WEBSITE EM Website CREATION FAILED : ORA-01403: no data foundORA-01403:
1088:ORA-20999: CREATE DEFAULT WEBSITE FAILED : ORA-01403: no data found
1100:DEFAULT WEBSITE EM Website CREATION FAILED : ORA-01403: no data foundORA-01403:
1106:ORA-20999: CREATE DEFAULT WEBSITE FAILED : ORA-01403: no data found
1118:DEFAULT WEBSITE EM Website CREATION FAILED : ORA-01403: no data foundORA-01403:
1124:ORA-20999: CREATE DEFAULT WEBSITE FAILED : ORA-01403: no data found
1130:Website target creation script failed.
1132:INFO: oracle.sysman.top.agent:Requested Operation /opt/oracle/app/agent10g/perl/bin/perl /opt/oracle/app/agent10g/bin/chronos_config.pl has failed to perform with Status = 1
1133:INFO: oracle.sysman.top.agent:configureAgent:DiscoverTargets completed=1 and errMsg=001, details=configureAgent:discovery on non RAC:  Oracle Application Server discovery failed.
1150:The Management Agent Configuration Assistant has failed. The following failures were recorded:
Securing agent...   Failed.
Securing agent...   Failed.
1172:configureAgent:discovery on non RAC:  Oracle Application Server discovery failed.
1175:INFO: oracle.sysman.top.agent:Internal PlugIn for {Micro Step state:step:1:configuration in CfmAggregateInstance: oracle.sysman.top.agent:10.2.0.5.0:common:family=CFM:oh=/opt/oracle/app/agent10g:label=5} failed with an unhandled exception:
1177:The Management Agent Configuration Assistant has failed. The following failures were recorded:
Securing agent...   Failed.
Securing agent...   Failed.
1199:configureAgent:discovery on non RAC:  Oracle Application Server discovery failed.
1209:INFO: oracle.sysman.top.agent:The plug-in Agent Configuration Assistant has failed its perform method

Further Investigation Required

I am going to track down these error messages.

Status of Oracle Application Server

The Oracle Application Server (OAS) seems to be active:

[oracle@gridctrl bin]$ cd /opt/oracle/app/oms10g/opmn/bin
[oracle@gridctrl bin]$ ./opmnctl status

Processes in Instance: EnterpriseManager0.gridctrl
-------------------+--------------------+---------+---------
ias-component      | process-type       |     pid | status  
-------------------+--------------------+---------+---------
DSA                | DSA                |     N/A | Down    
HTTP_Server        | HTTP_Server        |    6808 | Alive   
LogLoader          | logloaderd         |     N/A | Down    
dcm-daemon         | dcm-daemon         |     N/A | Down    
OC4J               | home               |    6809 | Alive   
OC4J               | OC4J_EMPROV        |    6810 | Alive   
OC4J               | OC4J_EM            |    6818 | Alive   
WebCache           | WebCache           |   31447 | Alive   
WebCache           | WebCacheAdmin      |    6819 | Alive   

Status of the OMA

The agent seems to be active but is not uploading files and is not secured:

[oracle@gridctrl bin]$ cd /opt/oracle/app/agent10g/bin
[oracle@gridctrl bin]$ ./emctl status agent
Oracle Enterprise Manager 10g Release 5 Grid Control 10.2.0.5.0.  
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version     : 10.2.0.5.0
OMS Version       : 10.2.0.5.0
Protocol Version  : 10.2.0.5.0
Agent Home        : /opt/oracle/app/agent10g
Agent binaries    : /opt/oracle/app/agent10g
Agent Process ID  : 31287
Parent Process ID : 31254
Agent URL         : http://gridctrl:3872/emd/main/
Repository URL    : http://gridctrl:4889/em/upload/
Started at        : 2009-12-30 10:01:30
Started by user   : oracle
Last Reload       : 2009-12-30 10:01:48
Last successful upload                       : (none)
Last attempted upload                        : (none)
Total Megabytes of XML files uploaded so far :     0.00
Number of XML files pending upload           :      134
Size of XML files pending upload(MB)         :    14.43
Available disk space on upload filesystem    :    84.93%
Last attempted heartbeat to OMS              : 2009-12-30 10:43:06
Last successful heartbeat to OMS             : unknown
---------------------------------------------------------------
Agent is Running and Ready

I tried to manually secure the agent:

[oracle@gridctrl bin]$ ./emctl secure agent
Oracle Enterprise Manager 10g Release 5 Grid Control 10.2.0.5.0.  
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
Agent successfully stopped...   Done.
Securing agent...   Started.
Enter Agent Registration Password :           
Agent successfully restarted...   Done.
Securing agent...   Failed.

I will need to check the logs later.

Status of OEM Console

When I tried to connect to http://127.0.0.1:7777/em , I get the following message:

503 Service Unavailable

Servlet error: Service is not initialized correctly. Verify that the repository connection information provided is correct.
Advertisements

3 thoughts on “11G OCM Patch OEM 10.2.0.5 (4)

  1. 11G OCM Patch OEM 10.2.0.5 (5) « Yet Another OCM

  2. 11G OCM Patch OEM 10.2.0.5 (6) « Yet Another OCM

  3. 2010 in review « Yet Another OCM

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