Oracledbconsoleorcl cannot be started. Error Code 2 is returned.

Source: Internet
Author: User

Modify your host parameter file

Modify:
C: host file under/Windows/system32/Drivers/etc.
If you do not have one, add an IP address to match your computer name. If you already have one, map your IP address to your computer name.
For example:
# Copyright (c) 1993-1999 Microsoft Corp.
#
# This is a sample hosts file used by Microsoft TCP/IP for Windows.
#
# This file contains the Mappings of IP addresses to host names. Each
# Entry shoshould be kept on an individual line. The IP address shold
# Be placed in the first column followed by the corresponding host name.
# The IP address and the host name shocould be separated by at least one
# Space.
#
# Additionally, comments (such as these) may be inserted on individual
# Lines or following the machine name denoted by a' # 'symbol.
#
# For example:
#
#102.54.94.97 rhino.acme.com # source server
#38.25.63.10 x.acme.com # X client host
127.0.0.1 localhost
192.168.1.104 wang-decjedi4h9

I

Start the computer. On the login page, the computer reports that a service failed to start. The computer does not have any new software installed, and there is no problem on Saturday. How can I suddenly report this error? So I went to the Event Viewer to see what the problem was. It showed that oracledbconsoleorcl failed to start. I checked that it was not started in the service. Start it manually. Error Code 2 is returned.
I installed 10 Gb, so I went to the oracleproduct10.2.0db _ 1test_orclsysmanlog directory to check what was written in the log and opened oracledbconsoleorclsrvc. log.
The log records the following:
----- [Oracledbconsoleorcl] ----
Emdroot = C: oracleproduct10.2.0db _ 1
ORACLE_HOME = C: oracleproduct10.2.0db _ 1
Emdstate = C: oracleproduct10.2.0db _ 1wangzh_orcl
Lele_cfg = dbconsole
Trace_level = 16
Timeout = 15
12/10/07 10:56:03 start pending...
12/10/07 10:56:03 verifying dbconsole is not started already. Command
Line "C: oracleproduct10.2.0db _ 1binemctl. Bat" istatus dbconsole
12/10/07 10:56:04 dbconsole launch CommandLine is "C: oracleproduct10.2.0db _ 1binemctl. Bat" istart dbconsole
12/10/07 10:56:04 tracking process launch...
12/10/07 10:56:34 dbconsole exited with retcode 2.
12/10/07 10:56:34 check C: oracleproduct10.2.0db _ 1test_orclsysmanlogemdblele.nohup for details
The log shows the emdbconsole. nohup file. This file is not found in the directory.
Run emctl manually. bat, so start the console and execute emctl. bat istart dbconsole, error reported. oracle_sid is not defined. Enable emctl. bat, here is the place where the environment variables are defined, and these have been set:
If not defined remote_emdroot (set ORACLE_HOME = EC: oracleproduct10.2.0db _ 1)
If not defined remote_emdroot (set emdroot = % ORACLE_HOME %)
If defined remote_emdroot (set ORACLE_HOME = % remote_emdroot %)
If defined remote_emdroot (set emdroot = % ORACLE_HOME %)
If defined remote_emdroot (set local_emdroot = C: oracleproduct10.2.0db _ 1)
......
There is another setting:
If not defined dbconsole_service_name (Set
Dbconsole_service_name = oracledbconsole % oracle_sid %). oracle_sid is used, but the preceding
You can only set oracle_sid manually. Therefore, add a setting:
If defined remote_emdroot (set oracle_sid = orcl) orcl is the name of my database instance
Start oracledbconsoleorcl in the service, OK, no error is reported;
No error is reported when you restart the computer. The oracledbconsoleorcl service is also started.

II

 

Today, the machine crashed, and the oracledbconsoleorcl service failed to get up. After a while, I finally found a solution:

Operation
In the database configuration Assistant Program, select "Configure Database options" to reconfigure Database Control
After the configuration tool is complete, the port number will change (I Used To Be 1158 and later changed to 5500). You can go to./Oracle/product/10.2.0/db_1
In the/export toollogs/emca/orcl/folder, find the URL of the new database control in the generated log file. Run the command.

**************************************** **************************************** ************************

(If the IP address is changed frequently, oracledbconsoleorcl cannot be started.) The following is a formal solution:

Modify your host parameter file

Modify:
C: host file under/Windows/system32/Drivers/etc.
If you do not have one, add an IP address to match your computer name. If you already have one, map your IP address to your computer name.
For example:
# Copyright (c) 1993-1999 Microsoft Corp.
#
# This is a sample hosts file used by Microsoft TCP/IP for Windows.
#
# This file contains the Mappings of IP addresses to host names. Each
# Entry shoshould be kept on an individual line. The IP address shold
# Be placed in the first column followed by the corresponding host name.
# The IP address and the host name shocould be separated by at least one
# Space.
#
# Additionally, comments (such as these) may be inserted on individual
# Lines or following the machine name denoted by a' # 'symbol.
#
# For example:
#
#102.54.94.97 rhino.acme.com # source server
#38.25.63.10 x.acme.com # X client host
127.0.0.1 localhost
192.168.1.104 wang-decjedi4h9

3.

Start manually from the CMD command line:

C:/Documents and Settings/wangnc> emctl start dbconsole

Environment Variable oracle_sid not defined. Please define it.

 

Set oracle_sid environment variables:


C:/Documents and Settings/wangnc> set oracle_sid = orcl

C:/Documents and Settings/wangnc> emctl start dbconsole

.

Still not working. Go to the directory
C:/Oracle/product/10.2.0/db_1/Solaris/J2EE
Only the oc4j_dbconsole_localhost_orcl directory is found, and no oc4j_dbconsole_sz-
Wangncd.cn.linecom.com _ orcl directory

Copy the directory to the folder name prompted by the system, and then run
Emctl start dbconsole

A similar error message will be reported, and another directory will be processed as well. After the restart, the service can be started properly.

Access http: // 127.0.0.1: 1158/EM/OK!

Thu

The oracledbconsoleorcl service cannot be started.

C:> set oracle_sid = orcl

C:> emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996,200 5 Oracle Corporation. All rights reserved.

Http: // jx02: 1158/EM/console/aboutapplication


Starting Oracle Enterprise Manager 10g Database Control... oracledbconsoleorcl
The service is starting.
The oracledbconsoleorcl service cannot be started.

System error.

System Error 3.

The specified path cannot be found.
//// The above is an error at startup. My database is oracle10.2.0.1.0.

Solution:

Enter
$ Emca-config dbcontrol DB
Enter the following information:
Sid: xxxx
Listener port number: 1521
Sys password :******
......
Okay, run emctl start dbconsole em again!
Common Oracle 10gr2-emca commands

Oracle

2008
Zookeeper

In 10 Gb, we may often encounter OEM problems that cannot be used normally, but the causes are different. In the end, most problems can be solved through the emca command, for more information, see the connection help. Below are some common commands and instance steps.

Create an EM Database
Emca-repos create

Rebuilding an EM Database
Emca-repos recreate

Delete An EM Database
Emca-repos drop

Configure Database Control for the database
Emca-config dbcontrol DB

Delete 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

Set the oracle_sid environment variable and start the EM console service.
Emctl start dbconsole

Set the oracle_sid environment variable and stop the EM console service.
Emctl stop dbconsole

Set 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

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.