This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Aug 23, 2013 12:25 PM by 808758 Branched from an earlier discussion. RSS

EBS R12 DR Setup (DATA GUARD)

808758 Newbie
Currently Being Moderated

I Am having issue with bringing up standby to be primary database for ebs get confuse what should be right value for all below

fnd_database.dbname >> prim or standby

database global name in data base initfile >> prim or standby

db global name in context file >> prim or ststandby

database service_names

 

tnsname.ora in 11.2.0 always reset to Sid=prim when I need it to be service=ststandby and  that make unable tregenerate listener.ora since can not connect to db with invalids entry in tnanames.ora

why I need to run ad config.sh with run=inste8. In standby app tier

 

DO you have good doc for ebs standby ?

thank you

  • 1. Re: EBS R12 DR Setup (DATA GUARD)
    Asif Muhammad Guru
    Currently Being Moderated

    Hi,

     

    Please refer note:

    Business Continuity for Oracle E-Business Release 12 Using Oracle 11g Release 2 and later Physical Standby Database (Doc ID 1070033.1)

    Section 6: Role Transitions

     

    Thanks &

    Best Regards,

  • 2. Re: EBS R12 DR Setup (DATA GUARD)
    808758 Newbie
    Currently Being Moderated

    That what I follow. but not working. and does not have detail of what value should be in each parameter, context file.

  • 3. Re: EBS R12 DR Setup (DATA GUARD)
    808758 Newbie
    Currently Being Moderated

    During run autocontig in appstier... admk80ln.sh unable to generate listener.ora because tnsnames.ora was overwritten with wrong entry.

    Before autoconfig run I make the tnsnames. change to

    QDR55 = (DESCRIPTION=

                    (ADDRESS=(PROTOCOL=tcp)(HOST=QDR55-SCAN)(PORT=1521))

                    (CONNECT_DATA=(SERVICE_NAME=QDR55))

                )

     

    During autoconfig before can generate tlistener.ora, tnsnames.ora change to

    QDR55 = (DESCRIPTION=

                    (ADDRESS=(PROTOCOL=tcp)(HOST=QDR55-SCAN)(PORT=1521))

                    (CONNECT_DATA=(SID=QDR55))

                )

     

    And that make admk80ln.sh.. I been cleanup fnd_nodes, fnd_database, fnd_app_server for multiple time.

  • 4. Re: EBS R12 DR Setup (DATA GUARD)
    Asif Muhammad Guru
    Currently Being Moderated

    Hi,

     

    I Am having issue with bringing up standby to be primary database for ebs get confuse what should be right value for all below

    fnd_database.dbname >> prim or standby

    database global name in data base initfile >> prim or standby

    db global name in context file >> prim or ststandby

    database service_names

    You don't need to bother editing the init parameter values as they remain the same, except for a parameter, please refer section "6.1.5 Switch the selected standby database to the primary role"

    DB NAME is same in all servers

    Global Name remains the same as GLOBAL_DBNAME=<DB_UNIQUE_NAME>.<Domain Name>

     

    Please also refer (as DB concepts remains the same, apart from context file configuration)

    Data Guard Scenarios

     

    Please follow the steps mentioned and if you have issues during any of these steps, do let us know.

     

    Thanks &

    Best Regards

  • 5. Re: EBS R12 DR Setup (DATA GUARD)
    808758 Newbie
    Currently Being Moderated

    Switch to use dataguard is not the issue for me but to get the EBS configure on both DB and Application tier in this standby is the issue.  Autoconfig continue fail (i.e. wrong entry in tnsnames.ora as the first error).

     

    fnd_databases.db_name = standby  >> should it be like this or prim

    fnd_apps_server.name = gdcqxerpdb01_prim_DB, gdcqxerpdb02_prim_DB and gdcqxerpap01_prim_APPS  >> should it be like this or replace prim with standby

     

    Where this entry in NetServiceHandler.log come from "SYS$APPLSYS.WF_CONTROL"

     

    QDR55=

            (DESCRIPTION=

                    (ADDRESS=(PROTOCOL=tcp)(HOST=QDR55-SCAN)(PORT=1521))

                (CONNECT_DATA=

                    (SERVICE_NAME=SYS$APPLSYS.WF_CONTROL.QDR55.DONALDSON.COM)

                    (INSTANCE_NAME=QDR551)

                )

            )


  • 6. Re: EBS R12 DR Setup (DATA GUARD)
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    You don't need to edit any file manually.

     

    Have you tried to deregister the application tier from the Net Services Topology Data Model and run AutoConfig then?

     

    TNS Connectivity With Database Breaks After Running Autoconfig (Doc ID 377764.1)

    Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12 (Doc ID 387859.1)

     

    Thanks,

    Hussein

  • 7. Re: EBS R12 DR Setup (DATA GUARD)
    808758 Newbie
    Currently Being Moderated

    Yes, I remove services, clean up exec fnd_conc_clone.setup_clean;
    Same error.

  • 8. Re: EBS R12 DR Setup (DATA GUARD)
    808758 Newbie
    Currently Being Moderated

    ##########################################################################
                       Generate Tns Names
    ##########################################################################
    Logfile:  /appsQDR55/inst/apps/QDR55_gdcqxerpap01/admin/log/08221032/NetServiceHandler.log
            Classpath                   : /appsQDR55/apps/apps_st/comn/java/lib/appsborg2.zip:/appsQDR55/apps/apps_st/comn/java/classes

    Updating s_tnsmode to 'generateTNS'
    UpdateContext exited with status: 0
    AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.
    Error generating tnsnames.ora from the database, temporary tnsnames.ora will be generated using templates
    Instantiating Tools tnsnames.ora
    Tools tnsnames.ora instantiated
    Web tnsnames.ora instantiated

  • 9. Re: EBS R12 DR Setup (DATA GUARD)
    808758 Newbie
    Currently Being Moderated

    admk80ln.sh started at Thu Aug 22 10:33:28 CDT 2013


    The environment settings are as follows ...

           ORACLE_HOME : /appsQDR55/apps/tech_st/10.1.2
            ORACLE_SID :
              TWO_TASK : QDR55
                  PATH : /appsQDR55/inst/apps/QDR55_gdcqxerpap01/admin/scripts:/appsQDR55/apps/tech_st/10.1.3/perl/bin:/appsQDR55/apps/tech_st/10.1.2/bin:/appsQDR55/apps/apps_st/appl/fnd/12.0.0/bin:/appsQDR55/apps/apps_st/appl/ad/12.0.0/bin:
    /appsQDR55/apps/tech_st/10.1.3/appsutil/jdk/jre/bin::/appsQDR55/apps/tech_st/10.1.2/bin:/appsQDR55/apps/tech_st/10.1.3/appsutil/jdk/jre/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/usr/vacpp/bin:/appsQDR55/apps/tech_st/10.1.3/perl/bin:/appsQDR55
    /inst/apps/QDR55_gdcqxerpap01/admin/scripts:/appsQDR55/apps/tech_st/10.1.3/perl/bin:/appsQDR55/apps/tech_st/10.1.2/bin:/appsQDR55/apps/tech_st/10.1.3/appsutil/jdk/jre/bin:/appsQDR55/apps/tech_st/10.1.2/bin:/appsQDR55/apps/tech_st/10.1.3/
    appsutil/jdk/jre/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/usr/vacpp/bin:/usr/java6_64/bin:/usr/vacpp/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/applmgr/bin:/usr/bin/X11:/sbin:/appsQDR55/apps/tech_st/10.1.2/OPatch:/appsQDR55/apps/tech_st/10.1
    .3/appsutil/jdk/bin:/appsQDR55/apps/tech_st/10.1.3/ant/bin:/appsQDR55/apps/tech_st/10.1.2/OPatch:/appsQDR55/apps/tech_st/10.1.3/appsutil/jdk/bin:/appsQDR55/apps/tech_st/10.1.3/ant/bin
          Library Path : /appsQDR55/apps/tech_st/10.1.2/jdk/jre/bin:/appsQDR55/apps/tech_st/10.1.2/jdk/jre/bin/classic:/appsQDR55/apps/apps_st/appl/cz/12.0.0/bin:/appsQDR55/apps/tech_st/10.1.2/lib32:/appsQDR55/apps/tech_st/10.1.2/lib:/usr/dt
    /lib:/appsQDR55/apps/tech_st/10.1.2/jdk/jre/bin:/appsQDR55/apps/tech_st/10.1.2/jdk/jre/bin/classic:/appsQDR55/apps/apps_st/appl/sht/12.0.0/lib

    SQLPLUS Executable : /appsQDR55/apps/tech_st/10.1.2/bin/sqlplus


    SQL*Plus: Release 10.1.0.5.0 - Production on Thu Aug 22 10:33:28 2013

    Copyright (c) 1982, 2005, Oracle.  All rights reserved.

    Enter value for 1: Enter value for 2: ERROR:
    ORA-12514: TNS:listener does not currently know of service requested in connect
    descriptor


    Unable to generate listener.ora from database
    Using default listener.ora file

  • 10. Re: EBS R12 DR Setup (DATA GUARD)
    Asif Muhammad Guru
    Currently Being Moderated

    Hi,

     

    Can you post the details of tnsnames.ora and listener.ora file after autoconfig run (to better understand what entry is amended by autoconfig).

     

    Also please upload the autoconfig log file and provide the link here.

     

    Thanks &

    Regards,

  • 11. Re: EBS R12 DR Setup (DATA GUARD)
    808758 Newbie
    Currently Being Moderated

    I have found the solution for it already.

    1. makesure db xml file <service_names oa_var="s_dbService">standby</service_names>

    2. ensure database service_name = standby not something like SYS$APPLSYS.WF_CONTROL.PROD

    3. Relink Oracle Home in application tier.

    4. clean up fnd_node, fnd_databases and fnd_app_server

    5. re-run autoconfig db tier and then app tier.

     

    But not sure which step make it work.  Next issue right now is blank login page.

  • 12. Re: EBS R12 DR Setup (DATA GUARD)
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    For the blank page, you need to compile JSP files.

     

    Oracle E-Business Suite R12 - Login Page showing a blank page Occuring Intermittently (Doc ID 1491845.1)

     

    Thanks,

    Hussein

  • 13. Re: EBS R12 DR Setup (DATA GUARD)
    808758 Newbie
    Currently Being Moderated

    I have compile jsp for >1 time, autoconfig db tier and apps tier... clean my internet cache.

     

    some error in oacore but not sure that contribute to this blank page... need to figure out how to set this paypal after clone.

    13/08/22 15:38:57.253 html: Error preloading servlet

    javax.servlet.ServletException: /appsQA55/apps/apps_st/appl/iby/12.0.0/payflow/pfp_oPayments.properties (No such file or directory)

            at com.paypal.oPayments.bizcomp.pfpProcess.init(Unknown Source)

            at com.evermind.server.http.HttpApplication.loadServlet(HttpApplication.java:2528)

            at com.evermind.server.http.HttpApplication.findServlet(HttpApplication.java:5006)

            at com.evermind.server.http.HttpApplication.findServlet(HttpApplication.java:4930)

            at com.evermind.server.http.HttpApplication.initPreloadServlets(HttpApplication.java:5118)

            at com.evermind.server.http.HttpApplication.initDynamic(HttpApplication.java:1283)

            at com.evermind.server.http.HttpApplication.<init>(HttpApplication.java:848)

  • 14. Re: EBS R12 DR Setup (DATA GUARD)
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    Please see if (Submit Offline Transactions Ends With "No such file or directory" Error (pfp_oPayments.properties) (Doc ID 1394987.1)) helps.

     

    Thanks,

    Hussein

1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points