Oracle EBS 11i克隆不成功，请各位大神指点一二。

dashiio2005

查看日志文件部分记录如下所示：
You are running addlnctl.sh version 115.6

Logfile: /u01/erpenv/erpdb/9.2.0/appsutil/log/ERPZY_ywzy/addlnctl.txt

Starting listener process ERPZY ...


Listener ERPZY has already been started.


addlnctl.sh: exiting with status 0

.end std out.

.end err out.

Executing CreateDB...

---------------------------------------------------------------
                   ADX Database Utility                        
---------------------------------------------------------------

getConnection() -->
    sDbHost    : ywzy
    sDbDomain  : ywjt.com
    sDbPort    : 1526
    sDbSid     : ERPZY
    sDbUser    : APPS
    Trying to connect using SID...
getConnectionUsingSID() -->
    JDBC URL: jdbcracle:thinywzy.ywjt.com:1526:ERPZY
    Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
    Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ywzy.ywjt.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=ERPZ
Y)))
    Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
    Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ywzy.ywjt.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=ERPZ
Y.ywjt.com)))
    Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
    Connection could not be obtained; returning null

-------------------ADX Database Utility Finished---------------


adcrdb.sh started at Fri Dec 14 06:13:31 CST 2012

The environment settings are as follows ...

       ORACLE_HOME : /u01/erpenv/erpdb/9.2.0
        ORACLE_SID : ERPZY
          TWO_TASK :
              PATH : /u01/erpenv/erpdb/9.2.0/Apache/perl/bin:/u01/erpenv/erpdb/9.2.0/bin:/usr/bin:/usr/sbin:/u01/erpenv/erpdb/9.2.0/
jre/1.4.2/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/u01/erpenv/erpdb/9.2.0/appsutil/clone/bin/../jre/1.3.1/bin:/u01/erpenv/
erpdb/9.2.0/Apache/perl/bin:/u01/erpenv/erpdb/9.2.0/bin:/usr/bin:/usr/sbin:/u01/erpenv/erpdb/9.2.0/jre/1.4.2/bin:/usr/ccs/bin:/bin:/
usr/bin/X11:/usr/local/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin
   LD_LIBRARY_PATH : /u01/erpenv/erpdb/9.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/erpenv/erpdb/9.2.0/ctx/lib

Executable : /u01/erpenv/erpdb/9.2.0/bin/sqlplus

The log information will be written to
        /u01/erpenv/erpdb/9.2.0/appsutil/log/ERPZY_ywzy/adcrdb_ERPZY.txt


Creating the control file for ERPZY_ywzy database ...


SQL*Plus: Release 9.2.0.5.0 - Production on Fri Dec 14 06:13:31 2012

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to an idle instance.
ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.

Total System Global Area  581506616 bytes
Fixed Size                   452152 bytes
Variable Size             402653184 bytes
Database Buffers          167772160 bytes
Redo Buffers               10629120 bytes
CREATE CONTROLFILE REUSE SET DATABASE "ERPZY"
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/u01/erpenv/erpdata/^Ca_txn_ind05.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


alter database open resetlogs
*
ERROR at line 1:
ORA-01507: database not mounted


alter tablespace TEMP2 add tempfile '/u01/erpenv/erpdata/TEMP201.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open


alter tablespace TEMP2 add tempfile '/u01/erpenv/erpdata/temp202.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open


ALTER DATABASE RENAME GLOBAL_NAME TO ERPZY.ywjt.com
                                     *
ERROR at line 1:
ORA-01109: database not open


ORA-01507: database not mounted


ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.

Total System Global Area  581506616 bytes
Fixed Size                   452152 bytes
Variable Size             402653184 bytes
Database Buffers          167772160 bytes
Redo Buffers               10629120 bytes
ORA-00205: error in identifying controlfile, check alert log for more info


BEGIN dbms_backup_restore.zeroDbid(0); END;

*
ERROR at line 1:
ORA-00210: cannot open the specified controlfile
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 3284
ORA-06512: at line 1


ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.

Total System Global Area  581506616 bytes
Fixed Size                   452152 bytes
Variable Size             402653184 bytes
Database Buffers          167772160 bytes
Redo Buffers               10629120 bytes
CREATE CONTROLFILE REUSE SET DATABASE "ERPZY"
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/u01/erpenv/erpdata/^Ca_txn_ind05.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
alter database open resetlogs
*
ERROR at line 1:
ORA-01507: database not mounted


alter tablespace TEMP2 add tempfile '/u01/erpenv/erpdata/TEMP201.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open


alter tablespace TEMP2 add tempfile '/u01/erpenv/erpdata/temp202.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open


ALTER DATABASE RENAME GLOBAL_NAME TO ERPZY.ywjt.com
                                     *
ERROR at line 1:
ORA-01109: database not open


declare lib_ver varchar2(3);
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
exit_code=1

Checking for errors ...

ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/u01/erpenv/erpdata/^Ca_txn_ind05.dbf'
ORA-27037: unable to obtain file status
ORA-01507: database not mounted
ORA-01109: database not open
ORA-01109: database not open
ORA-01109: database not open
ORA-01507: database not mounted
ORA-00205: error in identifying controlfile, check alert log for more info
ORA-00210: cannot open the specified controlfile
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 3284
ORA-06512: at line 1
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/u01/erpenv/erpdata/^Ca_txn_ind05.dbf'
ORA-27037: unable to obtain file status
ORA-01507: database not mounted
ORA-01109: database not open
ORA-01109: database not open
ORA-01109: database not open
The database has not been successfully created. Shutting down the instance ...

SQL*Plus: Release 9.2.0.5.0 - Production on Fri Dec 14 06:13:48 2012

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected.
ORACLE instance shut down.
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production

.end std out.

.end err out.


---------------------------------------------------------------
                   ADX Database Utility                        
---------------------------------------------------------------

getConnection() -->
    sDbHost    : ywzy
    sDbDomain  : ywjt.com
    sDbPort    : 1526
    sDbSid     : ERPZY
    sDbUser    : APPS

    Trying to connect using SID...
getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@ywzy.ywjt.com:1526:ERPZY
    Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
    Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ywzy.ywjt.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=ERPZ
Y)))
    Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
    Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ywzy.ywjt.com)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=ERPZ
Y.ywjt.com)))
    Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
    Connection could not be obtained; returning null

-------------------ADX Database Utility Finished---------------

RC-00118: Error occurred during creation of database
Raised by oracle.apps.ad.clone.ApplyDatabase


StackTrace:
java.lang.Exception: Control file creation failed
        at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:399)
        at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:131)
        at java.lang.reflect.Constructor.newInstance(Native Method)
        at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:68)
        at java.lang.Thread.run(Thread.java:479)

(END)


请大神们分析一下，并指点一下。谢谢大神先。

dashiio2005

自己顶一下，别沉下去了。

dashiio2005

my3274 发表于 2012/12/14 17:41
Logs已经给出问题所在了...

数据库没起来，后面也就一串问题了。

我看到这个错误了，复制过程路径的填写也没有什么问题。

dashiio2005

my3274 发表于 2012/12/15 10:12
你检查目标DB Tier （/u01/erpenv/erpdb/9.2.0/appsutil/clone）下的数据库控制文件adcrdb.zip (内含 ad ...

谢谢您的回复，我的问题解决了。原因是我有一个数据文件存放的位置不对，对其执行了alter database rename datafile '' to ''； 就Ok了。