adclone error problem

---------------------------------------------------------------

                   ADX Database Utility                        

---------------------------------------------------------------

 

getConnectionUsingAppsJDBCConnector() -->

    APPS_JDBC_URL='null'

    Trying to get connection using SID based connect descriptor

getConnection() -->

    sDbHost    : proddbst

    sDbDomain  : yeepay.com

    sDbPort    : 1538

    sDbSid     : FIS

    sDbUser    : apps

    Trying to connect using SID...

getConnectionUsingSID() -->

    JDBC URL: jdbc:oracle:thin:@proddbst.yeepay.com:1538:FIS

    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory

 

    Trying to connect using SID as ServiceName

getConnectionUsingServiceName() -->

    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=proddbst.yeepay.com)(PORT=1538))(CONNECT_DATA=(SERVICE_NAME=FIS)))

    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory

 

    Trying to connect using SID as ServiceName.DomainName

getConnectionUsingServiceName() -->

    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=proddbst.yeepay.com)(PORT=1538))(CONNECT_DATA=(SERVICE_NAME=FIS.yeepay.com)))

    Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:

ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

 

    Connection could not be obtained; returning null

 

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

 

 

adcrdb.sh started at Tue Sep 23 20:58:34 CST 2014

 

The environment settings are as follows ...

 

       ORACLE_HOME : /oracle/FIS/ora/db/tech_st/11.2.0

        ORACLE_SID : FIS

          TWO_TASK : 

              PATH : /oracle/FIS/ora/db/tech_st/11.2.0/perl/bin:/oracle/FIS/ora/db/tech_st/11.2.0/bin:/usr/bin:/usr/sbin:/oracle/FIS/ora/db/tech_st/11.2.0/jdk/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/oracle/FIS/ora/db/tech_st/11.2.0/appsutil/clone/bin/../jre/bin:/oracle/FIS/ora/db/tech_st/11.2.0/appsutil/clone/bin/../jre/bin:/oracle/FIS/ora/db/tech_st/11.2.0/perl/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/orafis/bin:/usr/ccs/bin:.

   LD_LIBRARY_PATH : /oracle/FIS/ora/db/tech_st/11.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/oracle/FIS/ora/db/tech_st/11.2.0/lib:/usr/dt/lib:/oracle/FIS/ora/db/tech_st/11.2.0/ctx/lib

 

Executable : /oracle/FIS/ora/db/tech_st/11.2.0/bin/sqlplus

 

The log information will be written to

/oracle/FIS/ora/db/tech_st/11.2.0/appsutil/log/FIS_proddbst/adcrdb_FIS.txt

 

 

Creating the control file for FIS_proddbst database ...

 

 

SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 23 20:58:34 2014

 

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

 

Connected to an idle instance.

ORACLE instance shut down.

Connected to an idle instance.

ORACLE instance started.

 

Total System Global Area 1068937216 bytes

Fixed Size    2235208 bytes

Variable Size  427820216 bytes

Database Buffers  624951296 bytes

Redo Buffers   13930496 bytes

 

Control file created.

 

alter database open resetlogs

*

ERROR at line 1:

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/oracle/FIS/ora/db/apps_st/data/system01.dbf'

 

 

alter tablespace TEMP1 add tempfile '/oracle/FIS/ora/db/apps_st/data/temp01.dbf' REUSE

*

ERROR at line 1:

ORA-01109: database not open

 

 

alter tablespace TEMP2 add tempfile '/oracle/FIS/ora/db/apps_st/data/temp02.dbf' REUSE

*

ERROR at line 1:

ORA-01109: database not open

 

 

ALTER DATABASE RENAME GLOBAL_NAME TO "FIS.yeepay.com"

                                     *

ERROR at line 1:

ORA-01109: database not open

 

 

ORA-01109: database not open

 

 

Database dismounted.

ORACLE instance shut down.

Connected to an idle instance.

ORACLE instance started.

 

Total System Global Area 1068937216 bytes

Fixed Size    2235208 bytes

Variable Size  427820216 bytes

Database Buffers  624951296 bytes

Redo Buffers   13930496 bytes

Database mounted.

 

PL/SQL procedure successfully completed.

 

ORACLE instance shut down.

Connected to an idle instance.

ORACLE instance started.

 

Total System Global Area 1068937216 bytes

Fixed Size    2235208 bytes

Variable Size  427820216 bytes

Database Buffers  624951296 bytes

Redo Buffers   13930496 bytes

 

Control file created.

 

alter database open resetlogs

*

ERROR at line 1:

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/oracle/FIS/ora/db/apps_st/data/system01.dbf'

 

 

alter tablespace TEMP1 add tempfile '/oracle/FIS/ora/db/apps_st/data/temp01.dbf' REUSE

*

ERROR at line 1:

ORA-01109: database not open

 

 

alter tablespace TEMP2 add tempfile '/oracle/FIS/ora/db/apps_st/data/temp02.dbf' REUSE

*

ERROR at line 1:

ORA-01109: database not open

 

 

ALTER DATABASE RENAME GLOBAL_NAME TO "FIS.yeepay.com"

                                     *

ERROR at line 1:

ORA-01109: database not open

 

 

Error Running create/replace library with adupdlib.sql

ORA-01109: database not open

 

PL/SQL procedure successfully completed.

 

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

exit_code=0

 

Checking for errors ...

 

The database has not been successfully created. Shutting down the instance ...

 

SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 23 20:58:51 2014

 

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

 

Connected.

ORACLE instance shut down.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

.end std out.

 

.end err out.

 

 

---------------------------------------------------------------

                   ADX Database Utility                        

---------------------------------------------------------------

 

getConnectionUsingAppsJDBCConnector() -->

    APPS_JDBC_URL='null'

    Trying to get connection using SID based connect descriptor

getConnection() -->

    sDbHost    : proddbst

    sDbDomain  : yeepay.com

    sDbPort    : 1538

    sDbSid     : FIS

    sDbUser    : apps

    Trying to connect using SID...

getConnectionUsingSID() -->

    JDBC URL: jdbc:oracle:thin:@proddbst.yeepay.com:1538:FIS

    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory

 

    Trying to connect using SID as ServiceName

getConnectionUsingServiceName() -->

    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=proddbst.yeepay.com)(PORT=1538))(CONNECT_DATA=(SERVICE_NAME=FIS)))

    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory

 

    Trying to connect using SID as ServiceName.DomainName

getConnectionUsingServiceName() -->

    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=proddbst.yeepay.com)(PORT=1538))(CONNECT_DATA=(SERVICE_NAME=FIS.yeepay.com)))

    Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:

ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

 

    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.doConf(ApplyDatabase.java:635)

at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:473)

at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:366)

at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:110)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Constructor.java:501)

at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:67)

at java.lang.Thread.run(Thread.java:637)

 

 

Hello,

this sounds like a problem with the source preparation command. You need to execute the adcfgclone prepare on the source machine and then copy the files over to the target machine. In this case it would be the best to start the clone again from scratch.

 

Best regards

 

Rüdiger Ziegler - Oracle Support