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)