EM creation hangs on OEL 5.3

From: aionios <belantos_at_gmail.com>
Date: Wed, 10 Jun 2009 23:12:26 -0700 (PDT)
Message-ID: <05447bb6-e968-4ecd-9282-56600ed69239_at_y33g2000prg.googlegroups.com>

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/B28359_01/relnotes.111/b32001/toc.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 Received on Thu Jun 11 2009 - 01:12:26 CDT