Reconfigure Oracle Enterprise Management Tool orcale Enterprise Manager (OEM)

Due to Database Server IP changes and other issues, the need to re-build the OEM for Oracle 10g basic process.

First, you must know the Instance name, port, and SYS password, and then perform the following steps:

1. Change the password of Dbsnmp to clear old configuration-related roles, users, and synonyms.

2. Use the ECMA command to recreate the configuration information (emca-config dbcontrol DB-repos recreate)

3. check em running status (emctl status dbconsole)

4. Access the management page through the new em address

The interaction process on the console is as follows (the comment is in the black body ):

Microsoft Windows XP [version 5.1.2600]

(C) Copyright 1985-2001 Microsoft Corp.

C: \ Documents ents and Settings \ Administrator> sqlplus/nolog # Run sqlplus

SQL * Plus: Release 10.2.0.1.0-production on Monday April 26 12:21:24 2010

Copyright (c) 1982,200 5, Oracle. All rights reserved.

SQL> Conn/As sysdba # connect as sysdba, or use the conn sys/password as sysdba

Connected.

SQL> select instance_name from V $ instance; # obtain the Instance name, which is orcl

Instance_name

----------------

Orcl

SQL> alter user Dbsnmp identified by XXX; # Change Dbsnmp user password to xxx

The user has changed.

SQL> drop role mgmt_user; # Delete the role and user information of the old em Configuration

The role has been deleted.

SQL> drop user mgmt_view cascade;

The user has been deleted.

SQL> drop user sysman cascade;

The user has been deleted.

SQL> drop public synonym mgmt_target_blackouts;

The synonym has been deleted.

SQL> drop public synonym setemviewusercontext;

The synonym has been deleted.

SQL> exit

From Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production

With the partitioning, OLAP and Data Mining options disconnected

C: \ Documents ents and Settings \ Administrator> emca # view the help of the emca command

C: \ oracle \ product \ 10.2.0 \ db_1 \ bin \ emca. Bat [operation] [mode] [database type] [tag] [Parameter

Number]

-H | -- H |-help | -- help: print the help message.

-Version: print the version.

-Config dbcontrol DB [-repos (create | recreate)] [-cluster] [-Silent] [-Backup]

[Parameter]: Configure Database Control for the database.

-Config centralagent (DB | ASM) [-cluster] [-Silent] [parameter]: configuration center proxy Management

-Config all DB [-repos (create | recreate)] [-cluster] [-Silent] [-Backup] [Parameters

]: Configure Database Control and central proxy Management

-Deconfig dbcontrol DB [-repos drop] [-cluster] [-Silent] [parameter]: Cancel datab Configuration

ASE Control

-Deconfig centralagent (DB | ASM) [-cluster] [-Silent] [parameter]: cancel the configuration center proxy

Management

-Deconfig all DB [-repos drop] [-cluster] [-Silent] [parameter]: Cancel database co Configuration

Ntrol and central proxy Management

-Addinst (DB | ASM) [-Silent] [parameter]: Configure em for the new RAC instance

-Deleteinst (DB | ASM) [-Silent] [parameter]: Cancel configuring em for the specified RAC instance

-Reconfig ports [-cluster] [parameter]: re-allocate the Database Control Port

-Reconfig dbcontrol-cluster [-Silent] [parameter]: reconfigure RAC Database Control

Agency

-Displayconfig dbcontrol-cluster [-Silent] [parameter]: displays the related RAC database contro

L configuration information

-Upgrade (DB | ASM | db_asm) [-cluster] [-Silent] [parameter]: Upgrade the EM configuration of earlier versions

Grade to current version

-Restore (DB | ASM | db_asm) [-cluster] [-Silent] [parameter]: Re-configure the current version of em

Earlier versions

Parameters and options:

[Parameter]: [-respfile file name] [-paramname paramvalue] *

DB: Performs configuration operations on databases (including databases using ASM ).

ASM: Only configures the ASM instance.

Db_asm: Upgrade/restore databases and ASM instances

-Repos create: Create a New Database Control Archive

-Repos drop: deletes the Current Database Control archive.

-Repos recreate: Delete the current database control archives and recreate

-Cluster: configure the RAC database.

-Silent: Perform the configuration operation without prompting the parameter.

-Backup: Configure Automatic database backup.

Single-instance database Parameters

HOST: Database Host Name

Sid: Database Sid

Port: ListenerProgramPort Number

ORACLE_HOME: Database ORACLE_HOME

Host_user: Host user name for automatic backup

Host_user_pwd: Host user password for automatic backup

Backup_schedule: automatic backup Scheduling (HH: mm)

Email_address: email address of the notification

Mail_server_name: Notification sender (SMTP) Server

Asm_oh: ASM ORACLE_HOME

Asm_sid: ASM Sid

Asm_port: ASM Port

Asm_user_role: ASM User Role

Asm_user_name: ASM User Name

Asm_user_pwd: ASM User Password

Src_oh: ORACLE_HOME of the database to be upgraded

Dbsnmp_pwd: Password of Dbsnmp user

Sysman_pwd: password of the sysman user

Sys_pwd: password of the Sys user

Dbcontrol_http_port: Database Control http port

Agent_port: Em proxy Port

Rmi_port: RMI port of Database Control

Jms_port: JMS port of Database Control

Other cluster database Parameters

Cluster_name: Cluster name

Db_unique_name: Unique name of the database

SERVICE_NAME: Service name

Em_node: Database Control Node name

Em_sid_list: proxy Sid list [separated by commas]

C: \ Documents ents and Settings \ Administrator> emca-config dbcontrol DB-repos recreat

E # re-configure em

Emca starts at 14:32:25

Em configuration assistant 10.2.0.1.0 official version

Copyright (c) 2003,200 5, Oracle. All rights reserved.

Enter the following information:

Database Sid: orcl # enter the Instance name

Listener port: 1521 bytes. Enter the oracleport. In Windows, you can use tcpview.exe to find the correct port or use the old configuration file.

Sys User Password: # enter the Sys Password

Dbsnmp User Password: # enter the modified Dbsnmp password. This example is XXX.

Sysman user's password: # set a new password for sysman, such as XXX

Email Address of the notification (optional): # Skip by pressing enter

Notification sending (SMTP) server (optional ):

-----------------------------------------------------------------

The following settings have been specified:

Database ORACLE_HOME ...... c: \ oracle \ product \ 10.2.0 \ db_1

Database Host Name ...... PC-20100401BTXZ

Listener port number ...... 1521

Database Sid ...... orcl

Email Address of the notification ...............

Notification sending (SMTP) server ...............

-----------------------------------------------------------------

Continue? [Yes (y)/NO (n)]: y # Enter y to continue

14:33:24 oracle. sysman. emcp. emconfig perform

Information: The operation is being recorded in c: \ oracle \ product \ 10.2.0 \ db_1 \ export toollogs \ emca \ orcl \ EMC

A_2010-04-26_02-32-25-Afternoon. log.

14:33:29 oracle. sysman. emcp. emreposconfig droprepository

Information: deleting the EM archives. This operation may take some time )...

14:33:32 oracle. sysman. emcp. emreposconfig invoke

Information: The archive has been deleted successfully.

14:33:33 oracle. sysman. emcp. emreposconfig createrepository

Information: creating the EM archives (this operation may take some time )...

14:39:22 oracle. sysman. emcp. emreposconfig invoke

Information: You have created a Data Archiving database.

14:40:45 oracle. sysman. emcp. util. dbcontrolutil startoms

Information: Starting Database Control (this operation may take some time )...

14:41:37 oracle. sysman. emcp. emdbpostconfig configure mconfiguration

Information: The Database Control has been started successfully.

14:41:40 oracle. sysman. emcp. emdbpostconfig configure mconfiguration

Warning: The Database Control shortcut cannot be created.

14:41:41 oracle. sysman. emcp. emdbpostconfig configure mconfiguration

Information: >>>>>>>>>> Database Control URL is http: // PC-20100401BTXZ: 5500/EM <

<

Enterprise Manager Configuration completed successfully # Get the new em address http: // PC-20100401BTXZ: 5500/em

Emca ended at 14:41:41

C: \ Documents ents and Settings \ Administrator> emctl status dbconsole # view the running status of the EM Service

Environment Variable oracle_sid not defined. Please define it. # The system prompts that the oracle_sid value is not set.

C: \ Documents ents and Settings \ Administrator> set oracle_sid = orcl # Set oracle_sid to the Instance name. This example is orcl.

C: \ Documents ents and Settings \ Administrator> emctl status dbconsole # view the running status of the EM Service

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0

Copyright (c) 1996,200 5 Oracle Corporation. All rights reserved.

Http: // PC-20100401BTXZ: 5500/EM/console/aboutapplication

Oracle Enterprise Manager 10g is running. # is running. Now you can enter the new em address in the browser to access the manager.

------------------------------------------------------------------

Logs are generated in directory c: \ oracle \ product \ 10.2.0 \ db_1/PC-20100401BTXZ_or

CL/sysman/log

C: \ Documents ents and Settings \ Administrator> emctl stop dbconsole # Use this command to stop the EM Service

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0

Copyright (c) 1996,200 5 Oracle Corporation. All rights reserved.

Http: // PC-20100401BTXZ: 5500/EM/console/aboutapplication

Oracledbconsoleorcl service is stopping .......

The oracledbconsoleorcl service has been stopped successfully.

 

C: \ Documents ents and Settings \ Administrator> emctl start dbconsole # Use this command to start the EM Service

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0

Copyright (c) 1996,200 5 Oracle Corporation. All rights reserved.

Http: // PC-20100401BTXZ: 5500/EM/console/aboutapplication

Starting Oracle Enterprise Manager 10g Database Control... oracledbconsoleorcl

The service is starting ...................

The oracledbconsoleorcl service has been started successfully.

 

C: \ Documents ents and Settings \ Administrator>

 

If the configuration is incorrect, a page similar to the following is displayed:

 

Check the entered configuration information and reconfigure it according to the preceding steps.

In addition, the sysman account lock issue does not appear here.

You can use this command under sqlplus to check:

SQL> select username, account_status from dba_users;

Username account_status

--------------------------------------------------------------

Mgmt_view open

Sys open

System open

Dbsnmp open

Sysman open

Oyi319 open

Outln expired & locked

MDSYS expired & locked

Ordsys expired & locked

EXFSYS expired & locked

Dmsys expired & locked

Username account_status

--------------------------------------------------------------

Wmsys expired & locked

Ctxsys expired & locked

Anonymous expired & locked

XDB expired & locked

Ordplugins expired & locked

Si_informtn_schema expired & locked

Olapsys expired & locked

Scott expired & locked

Tsmsys expired & locked

Bi expired & locked

PM expired & locked

Username account_status

--------------------------------------------------------------

Mddata expired & locked

IX expired & locked

Sh expired & locked

Dip expired & locked

OE expired & locked

HR expired & locked

Select 28 rows.

 

 

Note: Some ports are 5500, some are 1158, and the reason for this situation is unclear. However, when viewing the information, check the port carefully. It should be correct.

Http: // localhost: 1158/EM/(localhost can be changed to a computer name or IP address locally)