apply patch on dataguard

[Roshan]

Hi Erman,

I have a patch Patch 21959691: WEB ADI CONSOLIDATED FIXES FOR MICROSOFT OFFICE 2016  to be applied on production where dataguard is configured.

Do I need to apply the patch on standby database also?

Regards,
R

[ErmanArslansOracleBlog]

Hi Roshan,

Please read ->

Business Continuity for Oracle E-Business Release 12.1 Using Oracle 11g Release 2 Physical Standby Database (Doc ID 1070033.1)
"Section 7: Oracle E-Business Suite Maintenance with Standby Database"

7.1 Preparing to Apply the Application Patch
7.2 Patch Primary
7.3 After Applying the Patch

[Roshan]

Thanks a lot Erman.

For step 7.3,

For an Oracle E-Business Suite patch, synchronize the following directories: APPL_TOP, COMMON_TOP, 10.1.2 ORACLE_HOME, and the 10.1.3 ORACLE_HOME.

How do I use rsync to synchronize the above filesytems with standby database?

[Roshan]

applprod_dr>rsync -avz test root@10.210.29.69:/home

?

[ErmanArslansOracleBlog]

You should have a apps standby node in your Disaster site and you should synchronize those directories using your own approach.. you can use rsync or you can use storage replication (if you have any..)

One important thing is, this synchronization should be one way! from prod to standby site.

[Roshan]

Thanks Erman

When using rsync, I am getting error below

root@10.215.27.50's password:

ksh: rsync:  not found.

rsync: connection unexpectedly closed (0 bytes received so far) [sender]

rsync error: remote command not found (code 127) at io.c(226) [sender=3.1.3]

Is there some alternatives to rsync?

[ErmanArslansOracleBlog]

It seems it is not installed in one of your servers in this configuration.
alternative?
I don't recommend one.
Why dont you install rsync..

[Roshan]

Thanks. RSYNC works fine now :)

[Roshan]

The patch was successfully applied on production nd rsync completed successfully.

However, the preclone for DB failed with the error below

    Connection obtained

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

Net8 listener Started...

Connecting to the Database PMTG to create dbinfo.lst and adcrdbclone.sql

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

getConnection() -->
    sDbHost    : ofdb_ip
    sDbDomain  : mauritiustelecom.com
    sDbPort    : 1541
    sDbSid     : PMTG
    sDbUser    : APPS
    Trying to connect using SID...
getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@ofdb_ip.mauritiustelecom.com:1541:PMTG
    Connection obtained

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

/app/PMTG/db/tech_st/11.1.0/appsutil/out/PMTG_ofdb_ip/dbfinfo.lst created Successfully.
Generating /app/PMTG/db/tech_st/11.1.0/appsutil/out/PMTG_ofdb_ip/addbhomsrc.xml which will contain the unique mount points
NODE_ID Column Availability: true
Node Id Column is available. dbfinfo.lst will contain the node list
Host Column Availability: true

RC-50409: Topology information required for cloning not found in the database. Make sure that AutoConfig was run successfully prior to starting Rapid Clone, and try again
Raised by oracle.apps.ad.tools.AdCreateCtlFile
RC-50208: Exception  in method gen_crctrfclone_sql
RC-50208: Exception  in Constructor AdCreateCtlFile
Raised by oracle.apps.ad.tools.AdCreateCtlFile


StackTrace:
java.lang.Exception
        at oracle.apps.ad.tools.AdCreateCtlFile.get_rac_data(AdCreateCtlFile.java:1345)
        at oracle.apps.ad.tools.AdCreateCtlFile.gen_dbhomes_xml(AdCreateCtlFile.java:518)
        at oracle.apps.ad.tools.AdCreateCtlFile.gen_crctrfclone_sql(AdCreateCtlFile.java:614)
        at oracle.apps.ad.tools.AdCreateCtlFile.<init>(AdCreateCtlFile.java:416)
        at oracle.apps.ad.clone.StageDatabase.genRecreateScripts(StageDatabase.java:719)
        at oracle.apps.ad.clone.StageDatabase.doStage(StageDatabase.java:364)
        at oracle.apps.ad.clone.StageDatabase.<init>(StageDatabase.java:295)
        at oracle.apps.ad.clone.StageDBTier.<init>(StageDBTier.java:155)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:56)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:527)
        at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:67)
        at java.lang.Thread.run(Thread.java:736)

RC-40001: Failed to create sql script adcrdbclone.sql for recreating control files at target
Raised by oracle.apps.ad.clone.StageDatabase

I have checked doc  (Doc ID 371438.1)

If I run autoconfig, will there be any risk?

[ErmanArslansOracleBlog]

Probably, your the contents of your fnd_nodes are wrong or missing.
This seems to be a autoconfig related issue.

This is a different problem.
If you want my assistance on this, please create a seperate issue for this, by specifying all your environment specific info (EBS full release, db tier node count, RAC or not, EBS apps tier node count etc..)