1. Overview
The Oracle EM11g database needs to be migrated. The main steps are as follows:
1. Disable OMS
2. Back up the current database and restore it to the new server.
3. Update OracleEM OMS database connection Configuration
4. Start OMS
This operation method is also valid in Oracle EM 12c.
2. Procedure
Step 1: Disable OMS
Find the emctl tool in the bin where OMS is located and disable the OMS service.
/U01/app/oracle/middlehome/oms11g/bin @ lin-65-210-dba => emgrid $./emctlstop oms
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996,201 0 Oracle Corporation. All rights reserved.
Stopping WebTier...
WebTier Successfully Stopped
Stopping Oracle Management Server...
Oracle Management Server Successfully Stopped
Oracle Management Server is Down
Step 2: Use RMAN to back up and restore data. It is very simple and will not be explained.
Step 3: update the configuration of Oracle em oms database connection
First, check the database connection configuration details.
/U01/app/oracle/middlehome/oms11g/bin @ lin-65-210-dba => emgrid $./emctlconfig oms-list_repos_details
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996,201 0 Oracle Corporation. All rights reserved.
Repository Connect Descriptor :( DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.65.14) (PORT = 6688) (CONNECT_DATA = (SID = emrep )))
Repository Host:
Repository SID:
Repository User: SYSMAN
You can use the emctl tool to modify the database configuration of em grid control. emctl provides two modification methods.
Emctl config oms-store_repos_details (-repos_host
Connect descriptor shoshould be enclosed in quotes. eg: '"<conn_descr>"' or "'<conn_descr> '"
The specific command is as follows:
Emctl config oms-store_repos_details-repos_conndesc "'(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.65.8) (PORT = 6688 ))) (CONNECT_DATA = (SID = emrep) '"-repos_user sysman-repos_pwd welcome2012
Emctl config oms-store_repos_details-repos_host 192.168.65.8-repos_port 6688-repos_sid emrep-repos_user SYSMAN-repos_pwd welcome2012
Finally, modify one of the two commands.
/U01/app/oracle/middlehome/oms11g/bin @ lin-65-210-dba => emgrid $ emctlconfig oms-store_repos_details-repos_conndesc "'(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.65.8) (PORT = 6688) (CONNECT_DATA = (SID = emrep) '"-repos_user sysman-repos_pwd welcome2012
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996,201 0 Oracle Corporation. All rights reserved.
Successfully stored repository details in Credential Store.
/U01/app/oracle/middlehome/oms11g/bin @ lin-65-210-dba => emgrid $ emctlconfig oms-list_repos_details
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996,201 0 Oracle Corporation. All rights reserved.
Repository Connect Descriptor :( DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.65.8) (PORT = 6688) (CONNECT_DATA = (SID = emrep )))
Repository Host:
Repository SID:
Repository User: sysman
/U01/app/oracle/middlehome/oms11g/bin @ lin-65-210-dba => emgrid $ emctlconfig oms-Example-repos_port 6688-repos_sid emrep-Example-repos_user SYSMAN-repos_pwd welcome2012
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996,201 0 Oracle Corporation. All rights reserved.
Successfully stored repository details in Credential Store.
/U01/app/oracle/middlehome/oms11g/bin @ lin-65-210-dba => emgrid $ emctlconfig oms-list_repos_details
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996,201 0 Oracle Corporation. All rights reserved.
Repository Connect Descriptor :( DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.65.8) (PORT = 6688) (CONNECT_DATA = (SID = emrep )))
Repository Host: 192.168.65.8
Repository Port: 6688
Repository SID: emrep
Repository User: SYSMAN
Step 4: Start OMS
/U01/app/oracle/middlehome/oms11g/bin @ lin-65-210-dba => emgrid $./emctlstart oms
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996,201 0 Oracle Corporation. All rights reserved.
Starting WebTier...
WebTier Successfully Started
Starting Oracle Management Server...
Oracle Management Server Successfully Started
AdminServer cocould Not Be Started
Oracle Management Server is Up
Key Points of migrating 11G data to 10g platform through expdp & impdp
Oracle Data Pump examples and some precautions (expdp/impdp)
Oracle datapump expdp/impdp hang
Expdp/impdp for Oracle 10g to 11g data migration