Oracle EM 11g/12c database migration

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.