‘ap7001are.us.oracle.com’ Target Host in R12 Database Control

Posted by Vasudev Seeram on September 6, 2012 Leave a comment (0) Go to comments

Problem:

After enabling and launching Database Control on an R12.1 instance, the instance ‘ap7001are.us.oracle.com’ is seen as a target host and ‘PROD_ap7001are.us.oracle.com’ as the listener.

Solution:

Drop and recreate the Enterprise Manager repository on the R12 instance.

On the UAT2 instance, I used the following commands to recreate the repository on the UAT2 instance (source the database tier environment before starting):

C:oracleUAT2dbtech_st11.1.0cfgtoollogsemcaUAT2>sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Thu Sep 6 17:57:06 2012

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> drop role mgmt_user;

Role dropped.

SQL> drop user MGMT_VIEW;

User dropped.

SQL> drop user sysman cascade;

User dropped.

SQL> disc
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Pr
oduction
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exit

C:oracleUAT2dbtech_st11.1.0cfgtoollogsemcaUAT2>set ORACLE_HOSTNAME=ittl-
hrmstest.hostname.com

C:oracleUAT2dbtech_st11.1.0cfgtoollogsemcaUAT2>emca -deconfig all db

STARTED EMCA at Sep 6, 2012 5:59:12 PM
EM Configuration Assistant, Version 11.1.0.7.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: UAT2

Do you wish to continue? [yes(Y)/no(N)]: Y
Sep 6, 2012 5:59:17 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at C:oracleUAT2dbtech_st11.1.0cfgtool
logsemcaUAT2emca_2012_09_06_17_59_12.log.
Sep 6, 2012 5:59:18 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be p
erformed.
Enterprise Manager configuration completed successfully
FINISHED EMCA at Sep 6, 2012 5:59:18 PM

C:oracleUAT2dbtech_st11.1.0cfgtoollogsemcaUAT2>emca -config dbcontrol db
  -repos recreate -SID UAT2 -PORT 1536 -ORACLE_HOME %ORACLE_HOME% -DBCONTROL_HTT
P_PORT 1158

STARTED EMCA at Sep 6, 2012 5:59:34 PM
EM Configuration Assistant, Version 11.1.0.7.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Password for SYSMAN user: Email address for notifications (optional): vasudev.se
eram@hostname.com
Outgoing Mail (SMTP) server for notifications (optional): mail.hostname.com
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ C:oracleUAT2dbtech_st11.1.0

Local hostname ................ ittl-hrmstest.hostname.com
Listener port number ................ 1536
Database SID ................ UAT2
Email address for notifications ............... vasudev.seeram@hostname.com
Outgoing Mail (SMTP) server for notifications ............... mail.hostname.c
om

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Sep 6, 2012 6:00:00 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at C:oracleUAT2dbtech_st11.1.0cfgtool
logsemcaUAT2emca_2012_09_06_17_59_34.log.
Sep 6, 2012 6:00:04 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Sep 6, 2012 6:00:12 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Sep 6, 2012 6:00:12 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Sep 6, 2012 6:05:46 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Sep 6, 2012 6:05:51 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToReposi
tory
INFO: Uploading configuration data to EM repository (this may take a while) ...
Sep 6, 2012 6:06:57 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Sep 6, 2012 6:07:20 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLi
b
INFO: Software library configured successfully.
Sep 6, 2012 6:07:20 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrar
y
INFO: Deploying Provisioning archives ...
Sep 6, 2012 6:07:27 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrar
y
INFO: Provisioning archives deployed successfully.
Sep 6, 2012 6:07:27 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Sep 6, 2012 6:07:40 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Sep 6, 2012 6:07:40 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Sep 6, 2012 6:08:20 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Sep 6, 2012 6:08:20 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://ittl-hrmstest.hostname.com
:1158/em <<<<<<<<<<<
Sep 6, 2012 6:08:23 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: C:orac
leUAT2dbtech_st11.1.0ittl-hrmstest.hostname.com_UAT2sysmanconfigemk
ey.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 Sep 6, 2012 6:08:23 PM

C:oracleUAT2dbtech_st11.1.0cfgtoollogsemcaUAT2>

Note that the above worked for me. You are encouraged to read further as different authors have slightly different steps for configuring EM.

Reference:

Configure EM10g Database Control after install or clone of Applications 12.0 [ID 382634.1]
How To Drop, Create And Recreate the Database Control (DB Control) Release 10g and 11g [ID 278100.1]

The above MOS document (278100.1) has multiple ways of dropping the repository.

[amazon asin=1849684782&template=iframe image&chan=default] [amazon asin=0071763228&template=iframe image&chan=default] [amazon asin=0071790578&template=iframe image&chan=default]