adop fs_clone failing on the DR site

[Zubear]

We are trying to synchronize the DR run and patch filesystem and we are getting the following error

on  remote_execution_result

<Name>dr-ebswapp1</Name>
      <ProcessName>dr-ebswapp1_CORPDR_dr-ebswapp1pool-1-thread-1_dr-ebswapp1_CORPDR_dr-ebswapp1</ProcessName>
      <ResultString>    [WARNING]: There could be issues while validating the ports used for E-Business Suite instance against ports used in /etc/services. Refer the log file for more details.
        [WARNING]: Either some of the required entries in /etc/hosts file might be missing (e.g. localhost or hostname) OR the file /etc/hosts could not be read.
        [ERROR]: The value for dbSid do not match in application tier and database tier.

DR DB Context values
<oa_system_name oa_var="s_systemname">CORPDR</oa_system_name>
<global_db_name oa_var="s_dbSid">CORPDR1</global_db_name>
<db_name_lower oa_var="s_dbSidLower">corpdr1</db_name_lower>
<dbname oa_var="s_dbGlnam">PPCORP</dbname>

DR APPS Context values

<oa_system_name oa_var="s_systemname">CORPDR</oa_system_name>
<global_db_name oa_var="s_dbSid">CORPDR</global_db_name>
<global_db_name oa_var="s_dbGlnam">PPCORP</global_db_name>
<db_name_lower oa_var="s_dbSidLower">corpdr</db_name_lower>
<oa_site_name oa_var="s_sitename">CORPDR</oa_site_name> 

[ErmanArslansOracleBlog]

There are documented issues about this on Oracle Support. Did you check those?

For example:

--> this look very similar to yours.. but I need the see the detailed log.

12.2 E-Business Suite Patching Adop Phase=fs_clone Failing on TxkADOPPreparePhaseSynchronize.pl RC-50204: Error: - ONS Remote Port in Use (Doc ID 2045627.1)

Send me txkADOPValidations.log and ADOPValidations_detailed.log for further analysis.. I can comment better if I can see the port in question.

[Zubear]

Error suggesting in the Log file

Inside _validateSID()...
===============================


s_dbSid = CORPDR
dbGlnam = PPCORP
value in db = PPCORP

ERROR: the values of s_dbSid, s_dbGlnam are not in sync with the value in the database

[ErmanArslansOracleBlog]

Describe your environment.

This is standby, I know.
You activated it somehow.. (maybe using snapshot standby) okay.

1)But what are these sid/service/globaldb names?
CORPDR  ? DR db name?
PPCORP  ?  Primary DB name?
CORPDR1 ? Standby sid? Standby is RAC?

2)Is your primary RAC?
3)Is your standby RAC?
4)What is your purpose? I think you need to sync standby apps tier with primary, and you also want standby apps run fs to be sync with standby patch fs , am I right? Why do directly you use fs_clone? "Why don't you follow Business Continuity for Oracle E-Business Suite Release 12.2 Using Oracle 12c (12.1.0.2) Physical Standby Database (Doc ID 1963472.1)"? --  7.3.2 Synchronize the Primary and Standby Application Tiers
5)Did you run autoconfig before running fs_clone?
6)Do your configuration align with what is documented in 1963472.1? I mean did you created this standby env using document 1963472.1?

[Zubear]

Hi erman ,

1)But what are these sid/service/globaldb names?
CORPDR  ? DR db name?               ----- Yes database unique name of DR
PPCORP  ?  Primary DB name?       ----- Yes Primary database name
CORPDR1 ? Standby sid? Standby is RAC? Yes Standby RAC

2)Is your primary RAC?  Yes 2 Nodes RAC
3)Is your standby RAC?  Yes 2 Nodes RAC
4)What is your purpose? I think you need to sync standby apps tier with primary, and you also want standby apps run fs to be sync with standby patch fs , am I right? Why do directly you use fs_clone? "Why don't you follow Business Continuity for Oracle E-Business Suite Release 12.2 Using Oracle 12c (12.1.0.2) Physical Standby Database (Doc ID 1963472.1)"? --  7.3.2 Synchronize the Primary and Standby Application Tiers
  I am trying to sync standby run and patch fs . We cannot use dualfs option as we are on AD & TXK 6.
  Recently we have applied patches on Production and we followed the document to recreate the standby run FS. For patch fs i got 1 error for apps.conf not copied in OHS config phase hence to resync
  i ran the fs_clone again on standby.
5)Did you run autoconfig before running fs_clone?
   Yes autoconfig ran fine on run and patch .
6)Do your configuration align with what is documented in 1963472.1? I mean did you created this standby env using document 1963472.1?
  Yes we followed this document correctly to create standby .

  The only thing i am suspecting is ORACLE_SID FOR PRIMARY AND STANDBY SHOULD BE SAME according to the document but
  we have different ORACLE_SID for primary RAC and standby rac.

  Example  -  production - PPCORP1 , PPCORP2  and db_name- PPCORP
                    standby    - CORPDR1 , CORPDR2  and db_name- PPCORP

[ErmanArslansOracleBlog]

it says "The database SID "must" be the same on both the primary and physical standby databases, whereas the DB_UNIQUE_NAME is different on the primary and physical standby database." :)

[ErmanArslansOracleBlog]

Your issue is with the s_dbSid. It is directly related with the SID configuration. You need aligned with the Oracle Support documents to be supported as well.
So, I suggest you to correct your configuration accordingly and retest.