10 Replies Latest reply on Nov 28, 2016 7:52 AM by 984556

    Apps Tier - how to connect with DB Tier

    984556

      Oracle EBS 11.5.9
      Platform AIX 5.3

       

      I have two tiered Oracle EBS
      APPS TIER on one Server --- cloapp2
      DB TIER on another Server ---- clodb2


      Now my APPS TIER server crashed, but I another APPS Tier but another hostname and pointing to another DB Tier, so this one, is called APPS --> cloapp and pointing to DB Tier --> clodb

       

      how can I point CLOAPP to CLODB2 instead of CLODB and also change the name from CLOAPP to CLOAPP2

       

      Any quick way

       

      Thanks

        • 1. Re: Apps Tier - how to connect with DB Tier
          Shaik

          Hi

           

          on Apps Tier CLOAPP perform pre clone  and stop the apps services in cloapp

           

          Then change the hostname from CLOAPP to COAPP2

           

          Once hostname changed perform the post clone in new host cloapp2.

           

           

          Regards

          Shaik

          • 2. Re: Apps Tier - how to connect with DB Tier
            984556

            Thanks Shaik, slightly different scenario, I have, this is the new scenario,

             

             

            Here is the existing problem

            APPS Tier - - CLOAPP2 --> DB2 (DBTIER )
            CLOAPP2 <-- Crashed
            DB2 (DB TIER) is working fine

             

             

            Another Machine has this

            CLOAPP ---> DB (DB TIER)
            DB <-- Crashed
            CLOAPP (APP TIER) server is fine.

             

             

             

            Now I cannot run pre-clone scripts on CLOAPP because there is no DATABASE Connected to it since the Database system crashed which was DB (DB Tier)

             

             

             

            I want to connect CLOAPP with DB

             

             

             

            What would be the easiest and fastest way ? Thanks

            • 3. Re: Apps Tier - how to connect with DB Tier
              Shaik

              Hi

               

              Check clone directory existing under $COMMON_TOP of CLOAPP  then try to run adcgclone and pass the db information of DB2 (DB TIER)

               

              You dont have any other ways to achieve

               

              Regards

              Shaik

              • 4. Re: Apps Tier - how to connect with DB Tier
                RameshPatel

                Change the dbc file on the server that you want to use, pointing to database you want to connect and then run autoconfig on that node.

                you will need to get dbid of the database. You can grab this from the working webtier.

                 

                I hope this help. I have done this in past  and work fine.

                • 5. Re: Apps Tier - how to connect with DB Tier
                  984556

                  Thank you both Shaikh and Ramesh,

                   

                   

                   

                  I am a beginner and having a hard time,

                   

                  Let's start with Shaik:

                  Check clone directory existing under $COMMON_TOP of CLOAPP  then try to run adcgclone

                   

                  so i will just run adcfclone

                   

                  cd /oratech/prodcomn/clone/bin
                  perl adcfgclone.pl appsTier


                   

                  $ perl adcfgclone.pl appsTier

                  Enter the APPS password [APPS]:

                  apps

                   

                   

                  Now, Ramesh, can you please layout the steps for your procedure, so that would help me and others.

                  How to do it ?


                  Thanks

                  • 6. Re: Apps Tier - how to connect with DB Tier
                    984556

                    Hello,
                    I tried to run post clone script on the DB Tier to change the name but it failed and same thing happened at APPS Tier

                     

                     

                     

                     

                     

                    Provide the values required for creation of the new Database Context file.

                     

                     

                    Do you want to use a virtual hostname for the target node (y/n) [n] ?:

                     

                     

                    Target System database name [PROD]:

                     

                     

                    Target instance is a Real Application Cluster (RAC) instance (y/n) [n]:

                     

                     

                    Target system RDBMS ORACLE_HOME directory [/oratech/proddb/9.2.0]:

                     

                     

                    Target system utl_file accessible directories list [/usr/tmp]:

                     

                     

                    Number of DATA_TOP's on the target system [4]:2

                     

                     

                    Target system DATA_TOP 1:/oradata/proddata

                     

                     

                    Target system DATA_TOP 2:/oradata2/data

                     

                     

                    Do you want to preserve the Display set to oradb:0.0 (y/n) [y] ?:n

                     

                     

                    Target system Display [clodb2:0.0]:aaa-support:0.0

                     

                     

                    Do you want to preserve the port values from the source system on the target system (y/n) [y] ?:

                    Database port is 1521

                     

                     

                    Backing up /oratech/proddb/9.2.0/appsutil/PROD_clodb2.xml to /oratech/proddb/9.2.0/appsutil/PROD_clodb2.xml.bak

                     

                     

                    Creating the new Database Context file from :

                      /oratech/proddb/9.2.0/appsutil/template/adxdbctx.tmp

                     

                     

                    The new database context file has been created :

                      /oratech/proddb/9.2.0/appsutil/PROD_clodb2.xml

                     

                     

                    Log file located at /oratech/proddb/9.2.0/appsutil/clone/bin/CloneContext_11270612.log

                     

                     

                    Running Rapid Clone with command:

                            perl adclone.pl java=../jre/1.3.1/jre mode=apply stage=/oratech/proddb/9.2.0/appsutil/clone/bin/.. component=dbTier method=CUSTOM dbctxtg=/oratech/proddb/9.2.0/appsutil/PROD_clodb2.xml  showProgress contextValidated=true

                     

                     

                    Beginning database tier Apply - Sun Nov 27 06:13:54 2016

                    Log file located at /oratech/proddb/9.2.0/appsutil/log/PROD_clodb2/ApplyDBTier_11270613.log

                      |     50% completed     

                     

                     

                    AC-00402: Unable to read driver file: /oratech/proddb/9.2.0/appsutil/clone/bin/../data/driver/data.drv

                     

                     

                    ERROR while running Apply...

                     

                     

                    ERROR: Failed to execute adclone.pl

                     

                     

                    Please check logfile.

                     

                     

                     

                    trying to start the DATABASE = CLODB2

                     

                     

                     

                     

                     

                    SQL*Plus: Release 9.2.0.3.0 - Production on Sun Nov 27 08:43:43 2016

                     

                     

                    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

                     

                     

                    Connected to an idle instance.

                    ORACLE instance started.

                     

                     

                    Total System Global Area  615482512 bytes

                    Fixed Size                   742544 bytes

                    Variable Size             436207616 bytes

                    Database Buffers          167772160 bytes

                    Redo Buffers               10760192 bytes

                    ORA-00205: error in identifying controlfile, check alert log for more info

                     

                     

                     

                     

                    Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production

                    With the Partitioning, OLAP and Oracle Data Mining options

                    JServer Release 9.2.0.3.0 - Production

                     

                     

                    addbctl.sh: exiting with status 0

                     

                    • 7. Re: Apps Tier - how to connect with DB Tier
                      984556


                      Recap

                       

                      I want to connect APPS TIER-- CLOAPP  which is now point to CLODB  with CLODB1 (DB TIER)

                       

                      Three solutions were given:

                       

                      Solution 1

                      1. If CLOAPP and CLODB is up and running, then run PRE-CLONE Scripts on DB TIER / APPS TIER

                      change the hostname of APPS TIER (if you want to change from CLOAPP to CLOAPP1)
                      the run post clone script on Apps Tier

                       

                       

                      Solution 2

                      2. If no preclone scripts were run on APPS tier, because the Database Tier has crashed or whatever reason, then as Shaikh suggested

                       

                      Check clone directory existing under $COMMON_TOP of CLOAPP  then try to run adcgclone and pass the db information of DB2 (DB TIER)

                       

                      You dont have any other ways to achieve

                       

                      Then in my case that would be


                      cd /oratech/prodcomn/clone/bin

                      perl adcfgclone.pl appsTier

                       

                      But this resulted in errors as mentioned above

                       

                       

                       

                      Solution 3

                      3. This was suggested by Ramesh

                      Change the dbc file on the server that you want to use, pointing to database you want to connect and then run autoconfig on that node.

                      you will need to get dbid of the database. You can grab this from the working webtier.

                       

                      which dbc file ?

                       

                      (Hostname_SID).dbc or (Context Name).dbc file exist on on application Tier.

                      This File exists in $FND_TOP/secure

                       

                      applprod@cloapp:/home/applprod>cd /oraapp/prodappl

                      applprod@cloapp:/oraapp/prodappl>. ./APPSPROD_cloapp.env

                      applprod@cloapp:/oraapp/prodappl>cd $FND_TOP

                      applprod@cloapp:/oraapp/prodappl/fnd/11.5.0>cd secure

                      applprod@cloapp:/oraapp/prodappl/fnd/11.5.0/secure>ls

                      clodb.aaa.aaa.com_prod.dbc   support.cfg

                      clodb_prod.dbc                                        template.dbc

                       

                       

                      applprod@cloapp:/oraapp/prodappl/fnd/11.5.0/secure>cat clodb_prod.dbc

                      #DB Settings

                      #Sun May 29 22:22:06 2016

                      FND_JDBC_USABLE_CHECK=false

                      APPL_SERVER_ID=340391863C5B0006E0530A01017B000626402151001445823320325924557192

                      APPS_JDBC_DRIVER_TYPE=THIN

                      TWO_TASK=PROD

                      FND_JDBC_STMT_CACHE_SIZE=0

                      FND_JDBC_CONTEXT_CHECK=true

                      FND_JDBC_BUFFER_DECAY_SIZE=5

                      FND_JDBC_BUFFER_DECAY_INTERVAL=300

                      FND_JDBC_BUFFER_MAX=5

                      GUEST_USER_PWD=GUEST/ORACLE

                      FND_JDBC_STMT_CACHE_FREE_MEM=TRUE

                      FND_JDBC_BUFFER_MIN=1

                      DB_HOST=clodb.aaa.aaa.com

                      DB_NAME=PROD

                      FND_JDBC_PLSQL_RESET=false

                      FNDNAM=apps

                      FND_MAX_JDBC_CONNECTIONS=500

                      GWYUID=APPLSYSPUB/PUB

                      DB_PORT=1521

                       

                      applprod@cloapp:/oraapp/prodappl/fnd/11.5.0/secure>cat clodb.aaa.aaa.com_prod.dbc

                      #DB Settings

                      #Sun May 29 22:22:02 GMT 2016

                      FND_JDBC_USABLE_CHECK=false

                      APPS_JDBC_DRIVER_TYPE=THIN

                      APPL_SERVER_ID=340391863C5B0006E0530A01017B000626402151001445823320325924557192

                      TWO_TASK=PROD

                      FND_JDBC_STMT_CACHE_SIZE=0

                      FND_JDBC_CONTEXT_CHECK=true

                      FND_JDBC_BUFFER_DECAY_SIZE=5

                      FND_JDBC_BUFFER_DECAY_INTERVAL=300

                      FND_JDBC_BUFFER_MAX=5

                      GUEST_USER_PWD=GUEST/ORACLE

                      FND_JDBC_STMT_CACHE_FREE_MEM=TRUE

                      FND_JDBC_BUFFER_MIN=1

                      DB_HOST=clodb.aaa.aaa.com

                      DB_NAME=PROD

                      FND_JDBC_PLSQL_RESET=false

                      FNDNAM=apps

                      FND_MAX_JDBC_CONNECTIONS=500

                      GWYUID=APPLSYSPUB/PUB

                      DB_PORT=1521

                       

                       

                      Which one the DB ID in the above parameters and do I need to make change in both dbc files ?

                      Please advice. Thanks

                      • 8. Re: Apps Tier - how to connect with DB Tier
                        984556

                        quick question

                         

                        can I run post clone scripts without running preclone scripts ? would there be any issues ?

                        • 9. Re: Apps Tier - how to connect with DB Tier
                          Shaik

                          Hi

                           

                          if you can see common_top/clone directory means previously executed preclone e

                           

                          But from that period to till , if you done changes like applied major patches , then preclone script will be invalid

                           

                           

                          Regards

                          Shaik

                          1 person found this helpful
                          • 10. Re: Apps Tier - how to connect with DB Tier
                            984556

                            Thank you successfully completed the task

                             

                            applprod@cloapp1:/oraapp/prodcomn/clone/bin>perl adcfgclone.pl appsTier

                            Enter the APPS password [APPS]:

                            apps

                             

                             

                            First Creating a new context file for the cloned system.

                            The program is going to ask you for information about the new system:

                             

                             

                             

                             

                            Provide the values required for creation of the new APPL_TOP Context file.

                             

                             

                            Do you want to use a virtual hostname for the target node (y/n) [n] ?:

                             

                             

                            Target system database SID [PROD]:

                             

                             

                            Target system database server node [clodb]:clodb1

                             

                             

                            Target system database domain name [aaa.aaa.com]:

                             

                             

                            Does the target system have more than one application tier server node (y/n) [y] ?:n

                             

                             

                            Is the target system APPL_TOP divided into multiple mount points (y/n) [n] ?:n

                             

                             

                            Target system APPL_TOP mount point [/oraapp/prodappl]:

                             

                             

                            Target system COMMON_TOP directory [/oraapp/prodcomn]:

                             

                             

                            Target system 8.0.6 ORACLE_HOME directory [/oraapp/prodora/8.0.6]:

                             

                             

                            Target system iAS ORACLE_HOME directory [/oraapp/prodora/iAS]:

                             

                             

                            Do you want to preserve the Display set to aaa-support:0.0 (y/n) [y] ?:

                             

                             

                            Location of the JDK on the target system [/usr/java131]:

                             

                             

                            Do you want to preserve the port values from the source system on the target system (y/n) [y] ?:

                            Web Listener port is 8000

                            Complete port information available at /oraapp/prodappl/admin/out/PROD_cloapp1/portpool.lst

                             

                             

                            UTL_FILE_DIR on database tier consists of the following directories.

                             

                             

                            1. /usr/tmp

                            2. /oratech/proddb/9.2.0/appsutil/outbound/PROD_clodb1

                            Choose a value which will be set as APPLPTMP value on the target node [1]:1

                             

                             

                            Creating the new APPL_TOP Context file from :

                              /oraapp/prodappl/ad/11.5.0/admin/template/adxmlctx.tmp

                             

                             

                            The new APPL_TOP context file has been created :

                              /oraapp/prodappl/admin/PROD_cloapp1.xml

                             

                             

                            Log file located at /oraapp/prodcomn/clone/bin/CloneContext_11270955.log

                             

                             

                            Running Rapid Clone with command:

                                    perl adclone.pl java=../jre/1.3.1/jre mode=apply stage=/oraapp/prodcomn/clone/bin/.. component=appsTier method=CUSTOM appctxtg=/oraapp/prodappl/admin/PROD_cloapp1.xml  showProgress contextValidated=true

                             

                             

                            Beginning application tier Apply - Sun Nov 27 21:58:50 2016

                            Log file located at /oraapp/prodappl/admin/PROD_cloapp1/log/ApplyAppsTier_11270958.log

                             

                             

                             

                             

                            Completed Apply...

                            Sun Nov 27 22:26:36 2016

                             

                             

                            Beginning APPSIAS_PROD registration to central inventory...

                             

                             

                            ORACLE_HOME NAME   : APPSIAS_PROD

                            ORACLE_HOME PATH   : /oraapp/prodora/iAS

                            INVENTORY LOCATION : /etc/oraInst.loc

                             

                             

                            Log file located at /home/applprod/oraInventory/logs/OracleHomeCloner_11271026.log

                            RC-00123: ORACLE_HOME APPSIAS_PROD already exists inside the inventory

                             

                             

                            Starting application Services for PROD:

                            Running:

                            /oraapp/prodcomn/admin/scripts/PROD_cloapp1/adstrtal.sh apps/<appspwd>

                             

                             

                            You are running adstrtal.sh version 115.14

                             

                             

                            Executing service control script:

                            /oraapp/prodcomn/admin/scripts/PROD_cloapp1/adapcctl.sh start

                            script returned:

                            ****************************************************

                             

                             

                            adapcctl.sh version 115.43

                             

                             

                            Starting Apache Web Server Listener (dedicated HTTP) ...

                            Starting Apache Web Server Listener (dedicated PLSQL) ...

                             

                             

                            adapcctl.sh: exiting with status 0

                             

                             

                             

                             

                            .end std out.

                             

                             

                            .end err out.

                             

                             

                            ****************************************************

                             

                             

                             

                             

                            Executing service control script:

                            /oraapp/prodcomn/admin/scripts/PROD_cloapp1/adalnctl.sh start

                            script returned:

                            ****************************************************

                             

                             

                            adalnctl.sh version

                             

                             

                            Checking for FNDFS executable.

                            Starting listener process APPS_PROD.

                             

                             

                            adalnctl.sh: exiting with status 0

                             

                             

                             

                             

                            .end std out.

                             

                             

                            .end err out.

                             

                             

                            ****************************************************

                             

                             

                             

                             

                            Executing service control script:

                            /oraapp/prodcomn/admin/scripts/PROD_cloapp1/adcmctl.sh start

                            script returned:

                            ****************************************************

                             

                             

                            You are running adcmctl.sh version 115.19

                             

                             

                            Starting concurrent manager for PROD ...

                            Starting PROD_1127@PROD Internal Concurrent Manager

                            Default printer is noprint

                             

                             

                            adcmctl.sh: exiting with status 0

                             

                             

                             

                             

                            .end std out.

                             

                             

                            .end err out.

                             

                             

                            ****************************************************

                             

                             

                             

                             

                            Executing service control script:

                            /oraapp/prodcomn/admin/scripts/PROD_cloapp1/adfrmctl.sh start

                            script returned:

                            ****************************************************

                             

                             

                            You are running adfrmctl.sh version 115.33

                             

                             

                            Starting forms server for PROD on port 9000.

                             

                             

                            adfrmctl.sh: exiting with status 0

                             

                             

                             

                             

                            .end std out.

                             

                             

                            .end err out.

                             

                             

                            ****************************************************

                             

                             

                             

                             

                            Executing service control script:

                            /oraapp/prodcomn/admin/scripts/PROD_cloapp1/adrepctl.sh start

                            script returned:

                            ****************************************************

                             

                             

                            You are running adrepctl.sh version 115.29

                             

                             

                            starting Reports Server for PROD on port 7000.

                             

                             

                            adrepctl.sh: exiting with status 0

                             

                             

                             

                             

                            .end std out.

                             

                             

                            .end err out.

                             

                             

                            ****************************************************

                             

                             

                             

                             

                            Executing service control script:

                            /oraapp/prodcomn/admin/scripts/PROD_cloapp1/adfmcctl.sh start

                            script returned:

                            ****************************************************

                             

                             

                            You are running adfmcctl.sh version 115.16

                             

                             

                            Starting forms load balancing client for PROD.

                             

                             

                            adfmcctl.sh: exiting with status 0

                             

                             

                             

                             

                            .end std out.

                             

                             

                            .end err out.

                             

                             

                            ****************************************************

                             

                             

                             

                             

                            Executing service control script:

                            /oraapp/prodcomn/admin/scripts/PROD_cloapp1/adfmsctl.sh start

                            script returned:

                            ****************************************************

                             

                             

                            You are running adfmsctl.sh version 115.12

                             

                             

                            starting forms  metrics server for PROD.

                             

                             

                            adfmsctl.sh: exiting with status 0

                             

                             

                             

                             

                            .end std out.

                             

                             

                            .end err out.

                             

                             

                            ****************************************************

                             

                             

                             

                             

                            Executing service control script:

                            /oraapp/prodcomn/admin/scripts/PROD_cloapp1/jtffmctl.sh start

                            script returned:

                            ****************************************************

                             

                             

                            You are running jtffmctl.sh version 115.7

                             

                             

                            Starting Fulfillment Server for PROD on port 9300 ...

                             

                             

                            jtffmctl.sh: exiting with status 0

                             

                             

                             

                             

                            .end std out.

                             

                             

                            .end err out.

                             

                             

                            ****************************************************

                             

                             

                             

                             

                            Executing service control script:

                            /oraapp/prodcomn/admin/scripts/PROD_cloapp1/addisctl.sh start

                            script returned:

                            ****************************************************

                             

                             

                            addisctl.sh version 115.8

                             

                             

                            /oraapp/prodora/8.0.6/vbroker/bin/osagent

                            Started osagent.

                            Osagent logs messages to the file /oraapp/prodora/8.0.6/discwb4/util/osagent.log.

                            Waiting for OAD to start...

                            Started OAD.

                            OAD logs messages to the file /oraapp/prodora/8.0.6/discwb4/util/oad.log.

                            Discoverer Locator Started.

                            Locator logs messages to the file /oraapp/prodora/8.0.6/discwb4/util/locator.log.

                            Registering Discoverer Session

                            Completed registration of repository_id     =   IDL:DCISessionManager:1.0

                            object_name       =   cloapp1.aaa.aaa.com_8000OracleDiscovererSession4

                            reference data    =

                            path_name         =   /oraapp/prodora/8.0.6/discwb4/util/runses.sh

                            activation_policy =   UNSHARED_SERVER

                            args              =   (length=4)[-session; cloapp1.aaa.aaa.com_8000OracleDiscovererSession4; -preference; cloapp1.aaa.aaa.com_8000OracleDiscovererPreferences4; ]

                            env               =   NONE

                            for OAD on host 10.1.1.127

                            Registering the Collector

                            Completed registration of repository_id     =   IDL:DCICollector:1.0

                            object_name       =   cloapp1.aaa.aaa.com_8000OracleDiscovererCollector4

                            reference data    =

                            path_name         =   /oraapp/prodora/8.0.6/discwb4/util/runcol.sh

                            activation_policy =   SHARED_SERVER

                            args              =   (length=2)[-collector; cloapp1.aaa.aaa.com_8000OracleDiscovererCollector4; ]

                            env               =   NONE

                            for OAD on host 10.1.1.127

                            Applying preferences from file : /oraapp/prodora/8.0.6/discwb4/util/pref.txt

                            Finished applying preferences

                             

                             

                            Closing down registry..

                            Registry File sync...

                            Registering Discoverer Preference Repository

                            Completed registration of repository_id     =   IDL:DCICORBAInterface:1.0

                            object_name       =   cloapp1.aaa.aaa.com_8000OracleDiscovererPreferences4

                            reference data    =

                            path_name         =   /oraapp/prodora/8.0.6/discwb4/util/runpref.sh

                            activation_policy =   SHARED_SERVER

                            args              =   (length=2)[-preference; cloapp1.aaa.aaa.com_8000OracleDiscovererPreferences4; ]

                            env               =   NONE

                            for OAD on host 10.1.1.127

                             

                             

                            addisctl.sh: exiting with status 0

                             

                             

                             

                             

                            .end std out.

                             

                             

                            .end err out.

                             

                             

                            ****************************************************

                             

                             

                             

                             

                            All enabled services for this node are started.

                            Check logfile /oraapp/prodcomn/admin/log/PROD_cloapp1/11272228.log for details

                             

                             

                            Exiting with status 0

                            applprod@cloapp1:/oraapp/prodcomn/clone/bin>