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

Using network link to import data in Oracle

Using network link to import data in Oracle

1.Create database link ,in destination database, pointing to source database from where you want import the data as below.

In our case:
Source Schema =dwadm
Destination Schema=zz_dwadm

SQL> conn zz_dwadm/zz_dwadm
Connected.
SQL> create database link QA1DB_TO_DEVDB connect to dwadm identified by dwadm using 'QA1DB';

Database link created.

SQL> exit
Disconnected from Oracle

2.Import the table TEST_TABLE from dwadm into zz_dwadm using below command

impdp directory=dump_dir network_link=QA1DB_TO_DEVDB tables=dwadm.TEST_TABLE logfile=impdp.log remap_schema=dwadm:zz_dwadm


Import: Release 11.2.0.1.0 - Production on Wed Mar 13 09:40:30 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Username: zz_dwadm/zz_dwadm

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options