Oracle OEM configuration error: no value was set for the parameter dbcontrol_http_port Solution

 

These days have often been on top of the OEM. I have just solved an OEM problem a few days ago and I have encountered it again today.

Oracle Installation OEM error: cannot unlock all em-related accounts Solution

Http://blog.csdn.net/tianlesoftware/article/details/6816938

 

I was planning to install Oracle 11gr2. Then upgrade it to 0.3. The final installation error is returned. Em cannot work.

 

 

Prepare to check the EM status. Run the command to prompt that the environment variable is not configured:

[Oracle @ singledb ~] $ Emctl status dbconsole

Environment Variable oracle_unqname notdefined. Please set oracle_unqname to database unique name.

 

After modifying the environment variables, check whether there is a problem:

[Oracle @ singledb ~] $ VI/home/Oracle/. bash_profile

[Oracle @ singledb ~] $ Source/home/Oracle/. bash_profile

 

[Oracle @ singledb ~] $ Emctl status dbconsole

For more information, see <G id = "1"> Add </G>.

[Oracle @ singledb ~] $

 

View the EM Log File:

[Oracle @ singledb ~] $ Tail-80/u01/APP/Oracle/export toollogs/dbca/Anqing/emconfig. Log

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. paramsmanager getparam

Config: no value was setfor the parameter dbcontrol_http_port.

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. paramsmanager getparam

Config: no value was setfor the parameter agent_port.

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. paramsmanager getparam

Config: no value was setfor the parameter rmi_port.

SEP 30,201 2 6:34:20 PM oracle. sysman. emcp. paramsmanagergetparam

Config: no value was set for the parameterjms_port.

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. paramsmanager getparam

Config: no value was set for the parameteroracle_hostname.

SEP 30,201 2 6:34:20 PM oracle. sysman. emcp. util. clusterutilgetlocalnode

Config: islocalnodedone: True localnode: NULL

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. util. dbcontrolutil isdbconsoleconfigured

Config: Sid: Anqing HOST: singledb node: NULL Oh:/u01/APP/Oracle/product/11.2.0/db_1 isdbc: false

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. paramsmanager getparam

Config: no value was set for the parameteroracle_hostname.

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. paramsmanager getparam

Config: no value was set for the parameterports_file.

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. util. clusterutil getlocalnode

Config: islocalnodedone: True localnode: NULL

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. paramsmanager getparam

Config: no value was set for the parameterjms_port_singledb.

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. paramsmanager getparam

Config: no value was set for the parameterjms_port.

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. paramsmanager getparam

Config: no value was set for the parameterrmi_port_singledb.

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. paramsmanager getparam

Config: no value was set for the parameterrmi_port.

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. paramsmanager getparam

Config: no value was set for the parameterdbcontrol_http_port_singledb.

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. paramsmanager getparam

Config: no value was set for the parameterdbcontrol_http_port.

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. paramsmanager getparam

Config: no value was set for the parameteragent_port_singledb.

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. paramsmanager getparam

Config: no value was set for the parameteragent_port.

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. util. ouiinventoryutil setouiloc

Config: Setting oracle. Installer. oui_loc to/u01/APP/Oracle/product/11.2.0/db_1/OUI

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. util. ouiinventoryutil isvalidoh

Config: Invalid oraclehome:/u01/APP/Oracle/product/10.2.0/db_1

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. util. portmanager markallusedports

Config: homes to scan for used ports: [/u01/APP/Oracle/product/11.2.0/db_1]

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. util. portmanager markallusedports

Config: searching all dbconsole instancesfor used ports under ORACLE_HOME/u01/APP/Oracle/product/11.2.0/db_1

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. util. portmanager markallusedports

Config: Marking JMS port: NULL from/u01/APP/Oracle/product/11.2.0/db_1/Solaris/J2EE/oc4j_dbconsole

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. util. portmanager markallusedports

Config: Marking RMI port: NULL from/u01/APP/Oracle/product/11.2.0/db_1/Solaris/J2EE/oc4j_dbconsole

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. util. portmanager markallusedports

Config: Marking http port: nullfrom/u01/APP/Oracle/product/11.2.0/db_1/Solaris/J2EE/oc4j_dbconsole

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. util. portmanager getagentport

Config: cannot parse emd_url correctly. noport identified

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. util. portmanager markallusedports

Config: marking agent port: NULL from/u01/APP/Oracle/product/11.2.0/db_1/sysman/config/EMD. Properties

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. util. portmanager markallusedports

Config: cannnot parse emd_url correctly. noport identified

SEP 30,201 2 6:34:20 pmoracle. sysman. emcp. util. fileutil getproperties

Config: Error reading file/u01/APP/Oracle/product/11.2.0/db_1/install/staticports. ini

SEP 30,201 2 6:34:21 pmoracle. sysman. emcp. emconfig perform

Severe: failed to allocate port (s) in thespecified range (s) for the following process (es): JMS [5540-5559], RMI [5520-5539], database Control [5500-5519], EM agent [3938] | [1830-1849]

Refer to the log file at/u01/APP/Oracle/export toollogs/dbca/Anqing/emconfig. log for more details.

SEP 30,201 2 6:34:21 pmoracle. sysman. emcp. emconfig perform

Config: stack trace:

Oracle. sysman. emcp. exception. emconfigexception: failed to allocate port (s) in the specified range (s) for the followingprocess (ES): JMS [5540-5559], RMI [5520-5539], database Control [5500-5519], emagent [3938] | [1830-1849]

At oracle. sysman. emcp. emdbpreconfig. checkports (emdbpreconfig. Java: 2682)

Atoracle. sysman. emcp. emdbpreconfig. receivmconfiguration (emdbpreconfig. Java: 864)

At oracle. sysman. emcp. emdbpreconfig. Invoke (emdbpreconfig. Java: 282)

At oracle. sysman. emcp. emdbpreconfig. Invoke (emdbpreconfig. Java: 195)

At oracle. sysman. emcp. emconfig. Perform (emconfig. Java: 250)

Atoracle. sysman. assistants. util. Em. emconfiguration. Run (emconfiguration. Java: 583)

At oracle.sysman.assistants.util.em.emconfigstep.exe cuteimpl (emconfigstep. Java: 139)

Atoracle.sysman.assistants.util.step.basicstep.exe cute (basicstep. Java: 210)

Atoracle. sysman. assistants. util. Step. basicstep. callstep (basicstep. Java: 251)

At oracle.sysman.assistants.dbca.backend.postdbconfigurestep.exe cuteimpl (postdbconfigurestep. Java: 269)

Atoracle.sysman.assistants.util.step.basicstep.exe cute (basicstep. Java: 210)

At oracle.sysman.assistants.util.step.step.exe cute (step. Java: 140)

At oracle. sysman. assistants. util. Step. stepcontext $ moderunner. Run (stepcontext. Java: 2667)

At java. Lang. thread. Run (thread. Java: 595)

SEP 30,201 2 6:34:21 pmoracle. sysman. emcp. emconfig restoreouiloc

Config: Restoring oracle. Installer. oui_locto/u01/APP/Oracle/product/11.2.0/db_1/OUI

[Oracle @ singledb ~] $

 

 

Check the configuration file of the listener:

[Oracle @ singledb admin] $ cat listener. ora

# Listener. ora network configuration file:/u01/APP/Oracle/product/11.2.0/db_1/Network/admin/listener. ora

# Generated by Oracle configuration tools.

 

Sid_list_listener =

(Sid_list =

(Sid_desc =

(Global_dbname = Anqing)

(ORACLE_HOME =/u01/APP/Oracle/product/11.2.0/db_1)

(Sid_name = Anqing)

)

)

 

Listener =

(Description_list =

(Description =

(Address = (Protocol = IPC) (Key = extproc1521 ))

)

(Description =

(Address = (Protocol = TCP) (host = singledb) (Port = 1521 ))

)

)

 

Adr_base_listener =/u01/APP/Oracle

 

[Oracle @ singledb admin] $

 

The host name is the machine name.

 

Check the hosts configuration file:

[Oracle @ singledb admin] $ CAT/etc/hosts

# Do not remove the following line, orvarious programs

# That require Network functionality willfail.

#192.168.3.200 singledb

127.0.0.1 singledb

 

The cause is found. Because I installed it on a virtual machine, I changed the IP address before, and the/etc/hosts file was not modified in time. Modified the address in the hosts file. Then restart the listener.

 

[Oracle @ singledb ~] $ LSNRCTL stop

 

LSNRCTL for Linux: Version 11.2.0.1.0-production on 30-sep-2012 18:44:52

 

Copyright (c) 1991,200 9, Oracle. All rights reserved.

 

Connecting to (description = (address = (Protocol = IPC) (Key = extproc1521 )))

The command completed successfully

 

[Oracle @ singledb ~] $ LSNRCTL start

 

LSNRCTL for Linux: Version 11.2.0.1.0-production on 30-sep-2012 18:45:11

 

Copyright (c) 1991,200 9, Oracle. All rights reserved.

 

Starting/u01/APP/Oracle/product/11.2.0/db_1/bin/tnslsnr: Please wait...

 

Tnslsnr for Linux: Version 11.2.0.1.0-Production

System parameter file is/u01/APP/Oracle/product/11.2.0/db_1/Network/admin/listener. ora

Log messages written to/u01/APP/Oracle/diag/tnslsnr/singledb/listener/alert/log. xml

Listening On :( description = (address = (Protocol = IPC) (Key = extproc1521 )))

Listening On :( description = (address = (Protocol = TCP) (host = singledb) (Port = 1521 )))

 

Connecting to (description = (address = (Protocol = IPC) (Key = extproc1521 )))

Status of the listener

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

Alias listener

Version tnslsnr for Linux: version11.2.0.1.0-Production

Start date 30-sep-2012 18:45:11

Uptime 0 days 0 HR. 0 min. 0 sec

Trace Level off

Security on: Local OS Authentication

SNMP off

Listener parameter file/u01/APP/Oracle/product/11.2.0/db_1/Network/admin/listener. ora

Listener log file/u01/APP/Oracle/diag/tnslsnr/singledb/listener/alert/log. xml

Listening endpoints summary...

(Description = (address = (Protocol = IPC) (Key = extproc1521 )))

(Description = (address = (Protocol = TCP) (host = singledb) (Port = 1521 )))

Services summary...

Service "Anqing" has 1 instance (s ).

Instance "Anqing", status unknown, has 1 handler (s) for thisservice...

The command completed successfully

[Oracle @ singledb ~] $

 

Finally, we use the dbca command to recreate some OEMs. This reconstruction is normal and there is no problem.

 

 

 

 

Bytes -------------------------------------------------------------------------------------------------------

Blog: http://blog.csdn.net/tianlesoftware

WEAVER: http://weibo.com/tianlesoftware

Email: dvd.dba@gmail.com

Dba1 group: 62697716 (full); dba2 group: 62697977 (full) dba3 group: 62697850 (full)

Super DBA group: 63306533 (full); dba4 group: 83829929 (full) dba5 group: 142216823 (full)

Dba6 group: 158654907 (full) dba7 group: 69087192 (full) dba8 group: 172855474

DBA super group 2: 151508914 dba9 group: 102954821 chat group: 40132017 (full)

-- Add the group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, the application is rejected.