romance

0 积分	1 好友	1 主题

发消息

[SQL调优] ebs clone 问题

1^#

发表于 2013-1-18 09:54:08 | 查看: 4621| 回复: 2

请大家帮忙看看ebs克隆报错问题，因为是克隆之前自动备份的tar包，没有执行prepare操作，之后在source执行prepare操作拷贝$ORACLE_HOME/appsutil/clone到target也报这个错误：版本是r12.1.3 db是11.2.0.3.0 os是rhel5.4

  /    50% completed    RC-50004: Fatal: Error occurred in ApplyDatabase:
Control file creation failed

ERROR while running Apply...
Fri Jan 18 08:43:53 2013

ERROR: Failed to execute /u01/TEST10/db/tech_st/11.2.0/appsutil/clone/bin/adclone.pl

log信息：
Trying to connect using SID...
getConnectionUsingSID() -->
JDBC URL: jdbc:oracle:thin:@oraprod.pkuph.com:1531:TEST10
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=oraprod.pkuph.com)(PORT=1531))(CONNECT_DATA=(SERVICE_NAME=TEST10)))
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=oraprod.pkuph.com)(PORT=1531))(CONNECT_DATA=(SERVICE_NAME=TEST10.pkuph.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)

分享0