10 Replies Latest reply: Jun 7, 2013 10:52 AM by Hussein Sawwan-Oracle Branched to a new discussion. RSS

    EBS R12 DR Setup (DATA GUARD)

    John Hartford
      Hi All experts in ORacle DBA world,

      I have a a situation here.

      I am doing r12 data gaurd setup.

      1) Completed the database part data guard setup
      2) What is the step that i need to take care on application side.


      If anybody ther can show me the whole steps u r welcomed.

      Thanks,
      Vipul
        • 1. Re: EBS R12 DR Setup (DATA GUARD)
          Srini Chavali-Oracle
          I believe all of the steps are documented in

          Business Continuity for Oracle E-Business Release 12 Using Oracle 11g Release 2 and later Physical Standby Database [ID 1070033.1]

          HTH
          Srini
          • 2. Re: EBS R12 DR Setup (DATA GUARD)
            Hussein Sawwan-Oracle
            1010147 wrote:
            Hi All experts in ORacle DBA world,

            I have a a situation here.

            I am doing r12 data gaurd setup.

            1) Completed the database part data guard setup
            2) What is the step that i need to take care on application side.


            If anybody ther can show me the whole steps u r welcomed.

            Thanks,
            Vipul
            Please refer to (Oracle E-Business Suite Release 12 High Availability Documentation Roadmap [ID 1072636.1] -- Section 2: Oracle Physical Standby Database) for the list of docs. The steps are covered in details under (Configuration on Application Tiers After Standby Database is Enabled) section.

            Thanks,
            Hussein
            • 3. Re: EBS R12 DR Setup (DATA GUARD)
              Ravi EBS Support Engineer - Oracle
              Hi Vipul,

              Please check the below URL, which shall be of some help.

              http://rkorclappsdbastuff.blogspot.in/2013/06/data-guard-physical-standby-setup-in.html

              Thanks
              RK
              • 4. Re: EBS R12 DR Setup (DATA GUARD)
                John Hartford
                Hi RK,

                Found your link quite helpful.

                The place I am stuck is with Application Side.

                I have completed the Data Guard Setup for Database.

                Need help regards Data Gauard Setup for Application.

                Regards,
                Vipul
                • 5. Re: EBS R12 DR Setup (DATA GUARD)
                  ;) ApPsMasTi ;)
                  HI Vipul
                  please share where are you struck at application side

                  ;) AppsMasti :)
                  sharing is Caring
                  • 6. Re: EBS R12 DR Setup (DATA GUARD)
                    John Hartford
                    Hi ,

                    As I said earlier done with DG setup for database side. Till then application URL work fine.

                    But on switchover the application URL throws java exception error
                    • 7. Re: EBS R12 DR Setup (DATA GUARD)
                      ;) ApPsMasTi ;)
                      1010147 wrote:
                      Hi ,

                      As I said earlier done with DG setup for database side. Till then application URL work fine.

                      But on switchover the application URL throws java exception error
                      please post the complete error

                      ;) AppsMasti :)
                      sharing is Caring
                      • 8. Re: EBS R12 DR Setup (DATA GUARD)
                        John Hartford
                        RAN :- ./adconfig.sh contextfile=/u02/home/PROD/inst/apps/STAND_pansoft61/appl/admin/STAND_pansoft61.xml run=INSTE8



                        Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
                        Trying to connect using SID as ServiceName.DomainName
                        getConnectionUsingServiceName() -->
                        JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=pansoft61.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=STAND.com)))
                        Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
                        Connection could not be obtained; returning null

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

                        Verifying connection to the Database : Could not be stablished
                        No Restore Profile file created.


                        Restore Profile utility ran successfully

                        ===========================================================================


                        adcvmlog.xml renamed to /u02/home/PROD/inst/apps/STAND_pansoft61/admin/log/06071604/adcvmlog.xml.06071605


                        [CVM Error Report]
                        The following report lists errors encountered during CVM Phase
                        <filename> <return code where appropriate>
                        /u02/home/PROD/apps/apps_st/appl/ad/12.0.0/bin/adgentns.pl 25600

                        No of scripts failed in CVM phase: 1


                        AutoConfig is exiting with status 1
                        • 9. Re: EBS R12 DR Setup (DATA GUARD)
                          ;) ApPsMasTi ;)
                          1010147 wrote:
                          RAN :- ./adconfig.sh contextfile=/u02/home/PROD/inst/apps/STAND_pansoft61/appl/admin/STAND_pansoft61.xml run=INSTE8



                          Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
                          Trying to connect using SID as ServiceName.DomainName
                          getConnectionUsingServiceName() -->
                          JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=pansoft61.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=STAND.com)))
                          Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
                          Connection could not be obtained; returning null

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

                          Verifying connection to the Database : Could not be stablished
                          No Restore Profile file created.
                          Please make sure database is up and running
                          are you able to connect to database remotely?

                          >
                          ===========================================================================


                          adcvmlog.xml renamed to /u02/home/PROD/inst/apps/STAND_pansoft61/admin/log/06071604/adcvmlog.xml.06071605


                          [CVM Error Report]
                          The following report lists errors encountered during CVM Phase
                          <filename> <return code where appropriate>
                          /u02/home/PROD/apps/apps_st/appl/ad/12.0.0/bin/adgentns.pl 25600

                          No of scripts failed in CVM phase: 1


                          AutoConfig is exiting with status 1
                          its a generic error
                          please search for adgentns.pl and scroll up to get the details error from the log file
                          please also see perl variables are in path
                          echo $PERL5LIB
                          echo $ADPERLPRG


                          ;) AppsMasti :)
                          Sharing is Caring
                          • 10. Re: EBS R12 DR Setup (DATA GUARD)
                            Hussein Sawwan-Oracle
                            JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=pansoft61.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=STAND.com)))
                            Please make sure you have proper entry in the /etc/hosts file.
                            /u02/home/PROD/apps/apps_st/appl/ad/12.0.0/bin/adgentns.pl 25600
                            Once you can connect to the database, please make sure you clean FND_NODES table as per (How to Clean Nonexistent Nodes or IP Addresses From FND_NODES [ID 260887.1]).

                            Thanks,
                            Hussein