Wednesday, August 25, 2010

Procedure to reconfigure EM on 11gR2 running Oracle Application 11.5.10.2

This is a complete procedure I used to reconfigure the dbconsole on 11gR2. I migrated my source Oracle application database version 9.2.0.8 running on a 32 bit architecture listener to port 1523 single node to a dual node 64bit architecture for the 11gR2 database and the appsTier running on a HS22blade with 32 GB.

For clarity I used used the export import as its a cross platform migration. The destination 11gR2 I installed with the complete options Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options Release 11.2.0.1.0 - 64bit Production the source had Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.8.0 - Production 32 bit. Follow the
Metalink Doc: 946413.1 Using Oracle E-Business Suite with a Split Configuration Database Tier on Oracle 11gR2
Metalink Doc: 881505.1 Oracle E-Business Suite Release 11i with Oracle Database 11g Release 2 (11.2.0)
Metalink Doc: 230627.1 Export/Import Process for Oracle Applications Release 11i Database Instances Using Oracle9i Enterprise Edition

The detail of the patching and spliting is not included here see my next posting. The initial 11gR2 db Console was functional.

Shutdown the EM dbconsole from $ORACLE_HOME/bin using $emctl stop dbconsole
Shutdown the listener from $ORACLE_HOME/bin using $lsnrctl stop LISTENER (note my Oracle Applications listener name is PROD)
Shutdown the Oracle configuration manager from $ORACLE_HOME/ccr using $ emCCR stop

Drop the following user ,role and sysnonym

applprod@gva2ebsdbprod:/u01/PROD/apps/proddb/cfgtoollogs/emca/PROD $ sqlplus '/as sysdba';
SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 25 14:13:00 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

SQL> drop user sysman cascade;
User dropped.

SQL> drop role MGMT_USER;
Role dropped.

SQL> commit;
Commit complete.

SQL> drop user sysman cascade;
User dropped.

SQL> drop public synonym SETEMVIEWUSERCONTEXT;
Synonym dropped.

SQL> drop role MGMT_USER;
Role dropped.

SQL> drop PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
Synonym dropped.

SQL> drop user MGMT_VIEW;
User dropped.


I had to register the new Listener PROD which is listening on port 1523 whereas the default IIg install listener was listener on port 1521

SQL> ALTER SYSTEM SET LOCAL_LISTENER="PROD" scope=spfile;
System altered.

First deconfigured the original EM dbconsole

applprod@gva2ebsdbprod:/u01/PROD/apps/proddb/11.2.0/bin $ emca -deconfig dbcontrol db

STARTED EMCA at Aug 25, 2010 12:07:32 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: PROD
Do you wish to continue? [yes(Y)/no(N)]: y
Aug 25, 2010 12:07:38 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/PROD/apps/proddb/cfgtoollogs/emca/PROD/emca_2010_08_25_12_07_32.log.
Aug 25, 2010 12:07:39 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed.
Enterprise Manager configuration completed successfully

Now use the recreate option

applprod@gva2ebsdbprod:/u01/PROD/apps/proddb/11.2.0/bin $ emca -config dbcontrol db -repos recreate

STARTED EMCA at Aug 25, 2010 12:55:25 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: PROD
Listener port number: 1523
Listener ORACLE_HOME [ /u01/PROD/apps/proddb/11.2.0 ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional): gshelton@pajago.com
Outgoing Mail (SMTP) server for notifications (optional): vezfe1.europe.pajagogroup.com
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /u01/PROD/apps/proddb/11.2.0

Local hostname ................ gva2ebsdbprod.pajagogroup.com
Listener ORACLE_HOME ................ /u01/PROD/apps/proddb/11.2.0
Listener port number ................ 1523
Database SID ................ PROD
Email address for notifications ............... gshelton@pajago.com
Outgoing Mail (SMTP) server for notifications ............... vezfe1.europe.pajagogroup.com

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Aug 25, 2010 12:55:53 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/PROD/apps/proddb/cfgtoollogs/emca/PROD/emca_2010_08_25_12_55_25.log.
Aug 25, 2010 12:55:54 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Aug 25, 2010 12:56:47 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Aug 25, 2010 12:56:47 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Aug 25, 2010 1:01:26 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Aug 25, 2010 1:01:29 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Aug 25, 2010 1:02:06 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Aug 25, 2010 1:02:08 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Aug 25, 2010 1:02:08 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Aug 25, 2010 1:02:28 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Aug 25, 2010 1:02:28 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Aug 25, 2010 1:03:08 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Aug 25, 2010 1:03:08 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Aug 25, 2010 1:03:29 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Aug 25, 2010 1:03:29 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://gva2ebsdbprod.pajagogroup.com:1158/em <<<<<<<<<<<
Aug 25, 2010 1:03:31 PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************ WARNING ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: /u01/PROD/apps/proddb/11.2.0/gva2ebsdbprod.pajagogroup.com_PROD/sysman/config/emkey.ora. Please ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Aug 25, 2010 1:03:31 PM
applprod@gva2ebsdbprod:/u01/PROD/apps/proddb/11.2.0/bin $



Cmments are welcome
sheltong@gmail.com
Senior Oracle Applications and OBIA DBA

No comments:

Post a Comment