In Windows, Oracle cannot start em due to host name or IP address changes.

Source: Internet
Author: User

Error message:

Win Event Viewer:
An error occured while trying to initialize the service.

Manual start: emctl start dbconsole
Environment Variable oracle_sid not defined. Please define it.
When set oarcle_sid = orcl is executed, an error is returned.
Unable to determine local host from URL repository_url = http: // localhost: % em_upload_port %/EM/upload/

Note the following:

1: Host Name:
C:/Windows/system32/Drivers/etc/hosts

2: Em link JDBC:
$ ORACLE_HOME/Solaris/J2EE
OC4J_DBConsole_fox-kook_kook
Oc4j_dbconsole_localhost_kook (copy the directory from the Fox-kook host name as localhost)

3: the connection method for modifying the listener to the host name. Do not use the IP address.
$ ORACLE_HOME/Network/admin/listener. ora

Sid_list_listener =
(Sid_list =
(Sid_desc =
(Global_dbname = kook.glfsoft.com)
(ORACLE_HOME = G:/Oracle/product/10.2.0/db_1)
(Sid_name = kook)
)
)

Listener =
(Description =
(Address = (Protocol = TCP) (host = fox-kook) (Port = 1521 ))
)

$ ORACLE_HOME/Network/admin/tnsnames. ora is the same.
Kook =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = fox-kook) (Port = 1521 ))
)
(CONNECT_DATA =
(Server = dedicated)
(SERVICE_NAME = kook.glfsoft.com)
)
)

Eventually, IP address changes do not affect Oracle's Em startup.

Command Group with re-built Em

Reference to create an EM Database
Emca-repos create re-creates an EM Database
Emca-repos recreate deletes an EM Database
Emca-repos drop: Configure Database Control for the database
Emca-config dbcontrol dB deletes the Database Control Configuration of a Database
Emca-deconfig dbcontrol DB: reconfigure the Database Control port. The default port is 1158.
Emca-reconfig ports
Emca-reconfig ports-dbcontrol_http_port 1160
Emca-reconfig ports-agent_port 3940 first sets the oracle_sid environment variable and then starts the EM console service
Emctl start dbconsole first sets the oracle_sid environment variable and then stops the EM console service
Emctl stop dbconsole first sets the oracle_sid environment variable to view the EM console service status
Emctl status dbconsole

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

 

 

Http://www.52zhe.cn/read.php/170.htm

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.