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

    EBS R12 DR Setup (DATA GUARD)

    808758

      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

          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

            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

              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

                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

                  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

                    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

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

                      • 8. Re: EBS R12 DR Setup (DATA GUARD)
                        808758

                        ##########################################################################
                                           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

                          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

                            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

                              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

                                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

                                  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

                                    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