OWB Control Center Service Fails to Start after OWB cloning.

We cloned 10.2.0.2 database and OWB. When we tried to start the control center service after host name change in WB_RT_SERVICE_NODES(present in  repository owner schema) table, we got error as below

SQL> @start_service.sql
Not available
Diagnostics:
service startup failure using command "/orasw/app/oracle/product/owb10201/owb/b
in/unix/run_service.sh -manual 1 /orasw/app/oracle/product/owb10201 BIREPOWN sl
c04kvm.us.oracle.com 1521 BI221SF1" reason ORA-29532: Java call terminated by u
ncaught Java exception: java.io.IOException: service early exit: code=0 : err=
: out=2013/03/24-23:30:44-PDT [1AC1FE4] Connection Manager - OCI fix performed

2013/03/24-23:30:44-PDT [1AC1FE4] Thin driver connection time - 126 millisecond
(s)
2013/03/24-23:30:44-PDT [1AC1FE4] Connection Manager - property user.timezo
ne value is PST8PDT
2013/03/24-23:30:44-PDT [1AC1FE4] Connection Manager - conn
ection.timezone not set. Defaulting to value SERVICE
2013/03/24-23:30:44-PDT [1

PL/SQL procedure successfully completed.

Reason:

The OS open file limit for the Oracle user is set either set to unlimited or less value. In our case it was

-bash-3.2$ ulimit -a
core file size          (blocks, -c) 0
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 124064
max locked memory       (kbytes, -l) 32
max memory size         (kbytes, -m) unlimited
open files                      (-n) 8192
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
real-time priority              (-r) 0
stack size              (kbytes, -s) 10240
cpu time               (seconds, -t) unlimited
max user processes              (-u) 124064
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited

Solution:

1.Change open files limit to 65536 in /etc/security/limits.conf for oracle user  with root as below

oracle     soft   nofile    131072
oracle    hard   nofile    65536

2. Login with new session and start the service.

-bash-3.2$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Mar 25 00:48:26 2013

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> conn birepown/birepown
Connected.
SQL> @stop_service.sql
Not Available

PL/SQL procedure successfully completed.

SQL> @start_service.sql
Available

PL/SQL procedure successfully completed.

SQL> @show_service.sql
Available

PL/SQL procedure successfully completed.

SQL> exit