ADPRECLONE.PL Fails With Error 'CLONE-20435 Some of the Oracle Homes are excluded during copy operation EBS R12.2.X

 Dear All,

In this post i am sharing one of the issue which i got the recently in My EBS R12.2.10 with 19C Database issue while running adpreclone.pl got the below error .

When running  $ADMIN_SCRIPTS_HOME/adpreclone.pl on an application node, the below error occurs in $INST_TOP/admin/log/clone/fmwT2PStage/CLONEXXXXXX_XXXXX.error file:

SEVERE : <DATE&TIME> - ERROR - CLONE-20435 Some of the Oracle Homes are excluded during copy operation.

SEVERE : <DATE&TIME> - CAUSE - CLONE-20435 The following Oracle Homes were excluded during copy operation.

[/u07/EBSApps/Oracle/fs1/FMW_Home/webtier, /u07/EBSApps/Oracle/fs1/FMW_Home/oracle_common] , and possible causes were:

1. All the Oracle Homes were not registered with one OraInventory.

2. If all Oracle Homes were registered with a single custom OraInventory, then corresponding inventory pointer file was not provided to T2P operation.

3. Canonical path of Oracle Home registered with OraInventory was not child of Middleware Home.

SEVERE : <DATE&TIME> - ACTION - CLONE-20435 Make sure that all possible causes mentioned in above CAUSE section are taken care.

SEVERE : <DATE&TIME> - ERROR - CLONE-20218 Cloning is not successful.

SEVERE : <DATE&TIME> - CAUSE - CLONE-20218 An internal operation failed.

SEVERE : <DATE&TIME> - ACTION - CLONE-20218 Provide the clone log and error file for investigation.

java.lang.Exception: Some of the Oracle Homes are excluded during copy operation.

at oracle.as.clone.cloner.builder.CreateClonerBuilder.showMessageIfAnyOHIgnored(CreateClonerBuilder.java:1356)

at oracle.as.clone.cloner.builder.CreateClonerBuilder.getMWAndOHCreateClonerObjects(CreateClonerBuilder.java:226)

at oracle.as.clone.cloner.builder.CreateClonerBuilder.getCreateClonerObjects(CreateClonerBuilder.java:147)

at oracle.as.clone.cloner.builder.CreateClonerBuilder.getClonerObjects(CreateClonerBuilder.java:133)

at oracle.as.clone.process.CloningExecutionProcess.execute(CloningExecutionProcess.java:91)

at oracle.as.clone.client.CloningClient.executeT2PCommand(CloningClient.java:236)

at oracle.as.clone.client.CloningClient.main(CloningClient.java:124)

 

The below messages were also seen in the $INST_TOP/admin/log/clone/fmwT2PStage/CLONEXXXXXX_XXXXX.log file

FINE : <DATE&TIME> - [CreateClonerBuilder:isItPossibleToArchiveOracleHome] Trying to find out Oracle home properties for the Oracle home /u07/EBSApps/Oracle/fs1/FMW_Home/webtier and to check its dependency on Middleware home.

FINE : <DATE&TIME> - [OracleHomeDepRefUtil:deriveDepRefOHAndProperty] Deriving dependent Oracle home, reference Oracle home and additional properties for Oracle home /u07/EBSApps/Oracle/<INSTANCE NAME>/fs1/FMW_Home/webtier.....

FINE : <DATE&TIME> - [CreateClonerBuilder:isItPossibleToArchiveOracleHome] Oracle home is associated with Middleware home /u07/EBSApps/Oracle/fs2/FMW_Home

FINE : <DATE&TIME> - [CreateClonerBuilder:isItPossibleToArchiveOracleHome] Checking whether dependent Middleware home /u07/EBSApps/Oracle/fs2/FMW_Home is same as provided Middleware home /u07/EBSApps/Oracle/fs1/FMW_Home or not.

FINE : <DATE&TIME> - [CreateClonerBuilder:isItPossibleToArchiveOracleHome] Oracle home /u07/EBSApps/Oracle/fs1/FMW_Home/webtier has dependency on Middleware home /u07/EBSApps/Oracle/<INSTANCE NAME>/fs2/FMW_Home , but an attempt was made to archive another Middleware home /u07/EBSApps/Oracle/fs1/FMW_Home

FINE : <DATE&TIME> - [CreateClonerBuilder:createOHClonerObjects] Oracle home /u07/EBSApps/Oracle/fs1/FMW_Home/webtier is not possible to archive, adding it to invalid Oracle home list.

FINE : <DATE&TIME> - [CreateClonerBuilder:getOHCloners] Excluding Oracle home /u07/EBSApps/Oracle/fs1/FMW_Home/webtier

FINE : <DATE&TIME> - [CreateClonerBuilder:getOHCloners] All Oracle home(s) size in ascending order are = [1511235425]

INFO : <DATE&TIME> - CLONE-21038 The archive will contain both Middleware Home /u07/EBSApps/Oracle/fs1/FMW_Home and Oracle Home(s) /u07/EBSApps/Oracle/fs1/FMW_Home/Oracle_EBS-app1.

..

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

T2P Summary Begin

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

Error Message :1

<DATE&TIME> - ERROR - CLONE-20435 Some of the Oracle Homes are excluded during copy operation.

<DATE&TIME> - CAUSE - CLONE-20435 The following Oracle Homes were excluded during copy operation.

[/u07/EBSApps/Oracle/fs1/FMW_Home/webtier, /u07/EBSApps/Oracle/fs1/FMW_Home/oracle_common] , and possible causes were:

1. All the Oracle Homes were not registered with one OraInventory.

2. If all Oracle Homes were registered with a single custom OraInventory, then corresponding inventory pointer file was not provided to T2P operation.

3. Canonical path of Oracle Home registered with OraInventory was not child of Middleware Home.

<DATE&TIME> - ACTION - CLONE-20435 Make sure that all possible causes mentioned in above CAUSE section are taken care.

Cause of the issue :

The cause of this issue is incorrect details on either the central inventory, or local inventory of EBS ORACLE_HOME. 

The above error was identified with the incorrect path for the PROPERTY NAME="MIDDLEWARE_HOME" on file "<FMW_HOME>/Oracle_EBS-app1/inventory/ContentsXML/oraclehomeproperties.xml" located under the below directories:

/u07/EBSApps/Oraclefs1/FMW_Home/webtier/inventory/ContentsXML

/u07/EBSApps/Oraclefs1/FMW_Home/oracle_common/inventory/ContentsXML

The reason for checking the above two paths was identified from the error message seen on the $INST_TOP/admin/log/clone/fmwT2PStage/CLONEXXXXXX_XXXXX.error file:

SEVERE : <DATE&TIME> - CAUSE - CLONE-20435 The following Oracle Homes were excluded during copy operation.

[/u07/EBSApps/Oraclefs1/FMW_Home/webtier, /u07/EBSApps/Oraclefs1/FMW_Home/oracle_common] , and possible causes were:

Solution : 

Step 1: Take backup of the instance and the existing "<FMW_HOME>/webtier/inventory/ContentsXML/oraclehomeproperties.xml" file located under the ORACLE_HOME local inventory. 

eg: /u07/EBSApps/Oracle/fs1/FMW_Home/webtier/inventory/ContentsXML

Step : Check the path mentioned for PROPERTY NAME="MIDDLEWARE_HOME" in the file. This should point to the FMW_HOME on the same filesystem.

For example If the file is located in "<FMW_HOME>/oracle_common/inventory/ContentsXML/oraclehomeproperties.xml", then the value of PROPERTY NAME="MIDDLEWARE_HOME" should be "/u07/EBSApps/Oracle/fs1/FMW_Home"

Step 3:  If the path mentioned is incorrect, edit the file to point to correct path.

Step 4: Save the changes.

Step 5:  Rerun the failed adpreclone.pl command.

Step 6:  Confirm  adpreclone.pl command now complete successfully without error.

Note:  test these steps in a non-business critical instance where the problem can be reproduced and then migrate accordingly...

Thanks,

Srini

How to Start and Stop Oracle 13C OEM services including OEM database Serivces

 Hi All,

In this post i am going to share how to start and stop the Oracle OEM 13C services manually.

Database version : 19.27.0.0 

OEM version : 13.5C

OEL Version  : 7

Manual Method to stop OEM services :

Stop MS :

  - export OMS_HOME=/u01/app/oracle/middleware

  - /u01/app/oracle/middleware/bin/emctl stop oms -all

 

Stop Agent :

 -   export AGENT_HOME=/u01/app/oracle/agent/agent_inst

  - /u01/app/oracle/agent/agent_inst/bin/emctl stop agent

 

Stop database : 

 - sqlplus / as sysdba > shut immediate;

 - stop listener :: lsnrctl stop OEMDB

Manual Method to start OEM services :

Start Database : 

 - sqlplus / as sysdba > startup;

 - start listener :: lsnrctl start OEMDB

Start MS :

  - export OMS_HOME=/u01/app/oracle/middleware

  - /u01/app/oracle/middleware/bin/emctl start oms

Start Agent :

   - /u01/app/oracle/agent/agent_inst/bin/emctl start agent

>>> check in detailed OMS status

$OMS_HOME/bin/emctl status oms -details

>>> check repository details

$OMS_HOME/bin/emctl config oms -list_repos_details

>>>  get list of targets monitored by agent

$AGENT_HOME/bin/emctl config agent listtargets

Thanks,

Srini