EM creation hangs on OEL 5.3

[aionios]

Hi,

I wonder if anyone can give some pointers as to how to resolve this issue we are experiencing.

We are creating databases for various environment on our Oracle Enterprise Linux 5.3. The kernel parameters are set as per Oracle's recommendations:

$ cat /etc/sysctl.conf
# Kernel sysctl configuration file for Red Hat Linux
#
# For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and
# sysctl.conf(5) for more details.

# Controls IP packet forwarding
net.ipv4.ip_forward = 0

# Controls source route verification
net.ipv4.conf.default.rp_filter = 1

# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0

# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0

# Controls whether core dumps will append the PID to the core filename
# Useful for debugging multi-threaded applications
kernel.core_uses_pid = 1

# Controls the use of TCP syncookies
net.ipv4.tcp_syncookies = 1

# Controls the maximum size of a message, in bytes
#kernel.msgmnb = 65536

# Controls the default maxmimum size of a mesage queue
#kernel.msgmax = 65536

# Controls the maximum shared segment size, in bytes
kernel.shmmax = 68719476736

# Controls the maximum number of shared memory segments, in pages
kernel.shmall = 4294967296

# Oracle specific additions
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=4194304
net.core.wmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_max=1048576
fs.file-max = 6553600
fs.aio-max-nr=1048576

# SV specific additions

kernel.msgmnb = 262144
kernel.msgmni = 2048
kernel.msgmax = 131072

(see also http://download.oracle.com/docs/cd/B...c.htm#CHDFCJFD)

EM creation hangs when attempting it through dbca.

When running 'emca -config dbcontrol db -repos recreate' in the terminal:

Jun 11, 2009 2:37:54 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /xyx/oracle/cfgtoollogs/emca/ORASID/emca_2009_06_11_14_37_35.log.
Jun 11, 2009 2:37:55 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Jun 11, 2009 2:39:03 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Jun 11, 2009 2:39:03 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jun 11, 2009 2:42:33 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Jun 11, 2009 2:42:35 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...

At the last line all life stops and no additional entries are found in the above log file beyond the last line:

Jun 11, 2009 2:42:35 PM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
CONFIG: Unlocked mgmt_view account
Jun 11, 2009 2:42:35 PM oracle.sysman.emcp.EMReposConfig invoke
CONFIG: Successfully unlocked mgmt_view account
Jun 11, 2009 2:42:35 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Jun 11, 2009 2:42:35 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: ORASID, oracleHome: /home/xy/yz/product/11.1.0, and user: SYS
Jun 11, 2009 2:42:35 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Jun 11, 2009 2:42:35 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
CONFIG: Passed listener validation check.Listener is up and running.
Jun 11, 2009 2:42:35 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Jun 11, 2009 2:42:35 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...

We have not been able to find anything in any of the log files that would give us a hist as to why EM creation is failing.

Any help is appreciated.

Thanks,

Aionios

[davey23uk]

how do you know it hanging?

[aionios]

We tried to create EM a couple of times. A few times we left the command running for half an hour after it hung, with running 'top' showing no sign of activity and the timestamp on the log files showed they were not updated. Once we left it running overnight, same result.