Solution to EM (dbconsole) Startup failure after Oracle 10g host name or IP address is changed

Solution to EM (dbconsole) Startup failure after Oracle 10g host name or IP address is changed:

From: http://sjsky.iteye.com/blog/644197
PS: the host name or IP address is changed. If only PL/SQL is used to connect to the database, you do not need to reconfigure em,
You only need to change the listener. ora and tnsnames. ora files under \ oracle \ product \ 10.2.0 \ db_1 \ Network \ admin,
In the file, change host = *** to the corresponding primary key name or IP address.
If you want to start em, the above changes will not meet our requirements. You need to reconfigure the relevant information.
-> Set oracle_sid = ora10g
-> Emca-repos recreate
...........
Enter the following information:
Database Sid: ora10g
Listener port: 1521
Sys user password:
Password of the sysman User:
Continue? [Yes (y)/NO (n)]: Yes
...........
-> Emca-config dbcontrol DB
Enter the following information:
Database Sid: ora10g
Database Control configured for the database ora10g
You have chosen to configure Database Control to manage the database ora10g
This operation will remove the existing configuration and default settings, and re-execute the configuration
Continue? [Yes (y)/NO (n)]: Yes
Listener port: 1521
Sys user password:
Dbsnmp user password:
Password of the sysman User:
Email Address of the notification (optional ):
Notification sending (SMTP) server (optional ):
-----------------------------------------------------------------
The following settings have been specified:
Database ORACLE_HOME ...... D: \ oracle \ product \ 10.2.0 \ db_1
Database Host Name ...... MICROSOF-029
Listener port number ...... 1521
Database Sid ...... ora10g
Email Address of the notification ...............
Notification sending (SMTP) server ...............
-----------------------------------------------------------------
Continue? [Yes (y)/NO (n)]: Yes
-> Emctl start dbconsole
.....................
If you see that the service has been successfully started, the configuration is successful.
Emca Command Parameters
D: \ oracle \ product \ 10.2.0 \ db_1 \ bin \ emca. Bat [operation] [mode] [database type] [tag] [parameter]
-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] [parameter]: Configure Database Control and central proxy Management

-Deconfig dbcontrol DB [-repos drop] [-cluster] [-Silent] [parameter]: Disable Database Control
-Deconfig centralagent (DB | ASM) [-cluster] [-Silent] [parameter]: cancels Agent Management in the configuration center.
-Deconfig all DB [-repos drop] [-cluster] [-Silent] [parameter]: Disable Database Control 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 the RAC Database Control deployment.

-Displayconfig dbcontrol-cluster [-Silent] [parameter]: displays information about the RAC Database Control Configuration.

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

-Restore (DB | ASM | db_asm) [-cluster] [-Silent] [parameter]: restores the current version of EM configuration to a lower version.

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: the port number of the listener.
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]

Common emca commands
PS: first set the oracle_sid environment variable
Emca-repos create creates an EM Database
Emca-repos recreate re-creates an EM Database
Emca-repos drop delete an EM Database
Emca-config dbcontrol dB configure Database Control of the database
Emca-deconfig dbcontrol dB deletes the Database Control Configuration of a Database
Emca-reconfig ports: reconfigure the port of DB control. The default port is 1158.
Emca-reconfig ports-dbcontrol_http_port 1160
Emca-reconfig ports-agent_port 3940

Emctl start dbconsole start em console service
Emctl stop dbconsole stop em console service
Emctl status dbconsole view the EM console service status

Steps for configuring dbconsole
Emca-repos create
Emca-config dbcontrol DB
Emctl start dbconsole

To reconfigure dbconsole
Emca-repos drop
Emca-repos create
Emca-config dbcontrol DB
Emctl start dbconsole