1 2 3 4 Previous Next 58 Replies Latest reply: Jan 11, 2013 3:42 PM by Hussein Sawwan-Oracle RSS

    Moving EBS database to different node

    970261
      Hello All

      I am following metalink note 362205.1 for moving database from HP-UX to Linux.
      The export has completed to the new server and the post import steps needs to be run

      The post import steps are on metalink note 362203.1. Some of the steps are below

      1. Deregister the database server
      exec fnd_conc_clone.setup_clean;

      2. Implement and run autoconfig
      Create appsutil.zip and generate database context file
      cd <RDBMS ORACLE_HOME>/appsutil/bin
      perl adbldxml.pl tier=db appsuser=apps

      3. Generate and apply autoconfig configuration files
      ./adconfig.sh contextfile=/db_findbd/app/oracle/product/10.2.0.5/appsutil/FINT_ofindbq.xml


      4. Run autoconfig on application tier

      Here i have doubt. The application server is still pointing to HP-UX database server according to its context file
      <dbhost oa_var="s_dbhost">findbqa</dbhost>
      <dbc_file_name oa_var="s_dbc_file_name">findbqa_fint</dbc_file_name>
      <jdbc_url oa_var="s_apps_jdbc_connect_descriptor">jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=findbqa.hq.bn-corp.com)(PORT=1523)))(CONNECT_DATA=(SID=FINT)))</jdbc_url>


      Do i have to change anything manually ?
      If i run autoconfig how will the application tier pick up the new Linux server ?

      I do not want to screw after two weeks of work.

      Thanks
      Chirag
        • 1. Re: Moving EBS database to different node
          Hussein Sawwan-Oracle
          I am following metalink note 362205.1 for moving database from HP-UX to Linux.
          The export has completed to the new server and the post import steps needs to be run

          The post import steps are on metalink note 362203.1. Some of the steps are below

          1. Deregister the database server
          exec fnd_conc_clone.setup_clean;

          2. Implement and run autoconfig
          Create appsutil.zip and generate database context file
          cd <RDBMS ORACLE_HOME>/appsutil/bin
          perl adbldxml.pl tier=db appsuser=apps

          3. Generate and apply autoconfig configuration files
          ./adconfig.sh contextfile=/db_findbd/app/oracle/product/10.2.0.5/appsutil/FINT_ofindbq.xml


          4. Run autoconfig on application tier

          Here i have doubt. The application server is still pointing to HP-UX database server according to its context file
          <dbhost oa_var="s_dbhost">findbqa</dbhost>
          <dbc_file_name oa_var="s_dbc_file_name">findbqa_fint</dbc_file_name>
          <jdbc_url oa_var="s_apps_jdbc_connect_descriptor">jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=findbqa.hq.bn-corp.com)(PORT=1523)))(CONNECT_DATA=(SID=FINT)))</jdbc_url>


          Do i have to change anything manually ?
          If i run autoconfig how will the application tier pick up the new Linux server ?

          I do not want to screw after two weeks of work.
          You need to complete the steps under (Reconfigure the application tier to connect to the target database machine) section as per (Using Oracle Applications with a Split Configuration Database Tier on Oracle 10g Release 2 [ID 369693.1])

          Thanks,
          Hussein
          • 2. Re: Moving EBS database to different node
            970261
            Ok finally i have moved the database and Application tier to Linux
            Followed note 238276.1 for the app tier and 362205.1 for the database tier

            Brought the application up

            My home_url is pointing to
            SQL> select home_url from icx_parameters;

            HOME_URL
            --------------------------------------------------------------------------------
            http://ofinapq.hq.bn-corp.com:8005/OA_HTML/US/ICXINDEX_FINT_ofinapq.htm

            Should be

            http://ofinapq.hq.bn-corp.com:8005/OA_HTML/AppsLocalLogin.jsp

            How do i correct this ?
            • 3. Re: Moving EBS database to different node
              Hussein Sawwan-Oracle
              967258 wrote:
              Ok finally i have moved the database and Application tier to Linux
              Followed note 238276.1 for the app tier and 362205.1 for the database tier

              Brought the application up

              My home_url is pointing to
              SQL> select home_url from icx_parameters;

              HOME_URL
              --------------------------------------------------------------------------------
              http://ofinapq.hq.bn-corp.com:8005/OA_HTML/US/ICXINDEX_FINT_ofinapq.htm

              Should be

              http://ofinapq.hq.bn-corp.com:8005/OA_HTML/AppsLocalLogin.jsp

              How do i correct this ?
              Edit the table manually.
              SQL> update icx_parameters
              set home_url='http://ofinapq.hq.bn-corp.com:8005/OA_HTML/AppsLocalLogin.jsp'
              where home_url = 'http://ofinapq.hq.bn-corp.com:8005/OA_HTML/US/ICXINDEX_FINT_ofinapq.htm';
              
              SQL> commit;
              Bounce the services and check then.

              Thanks,
              Hussein
              • 4. Re: Moving EBS database to different node
                970261
                I tried that not working

                I even changed in the Context file and ran autoconfig
                Still the same

                Should i change to http://ofinapq.hq.bn-corp.com:8005/oa_servlets/AppsLogin

                instead of OA_HTML to oa_servlets
                • 5. Re: Moving EBS database to different node
                  970261
                  Under $IAS_ORACLE_HOME/Apache/Apache/logs

                  cat error_log

                  [Tue Dec 11 10:29:24 2012] [warn] pid file /orappl_finapd/fint_appl/finqora/iAS/Apache/Apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
                  [Tue Dec 11 10:29:24 2012] [error] OPM:Fail to open file /tmp//Apache/Apache/logs/opm_sys_mtx.pid.10387
                  [Tue Dec 11 10:29:24 2012] [error] OPM:Fail to create mutex
                  [Tue Dec 11 10:29:24 2012] [error] OPM: process manager could not create internal tables
                  [Tue Dec 11 10:29:24 2012] [crit] (2)No such file or directory: Apache JServ encountered a fatal error; check your ApJServLogFile for details if none are present in this file. Exiting.

                  [appfint@ofinapq logs]$ cd $IAS_ORACLE_HOME/Apache/Jserv/logs
                  [appfint@ofinapq logs]$ ls -lrt
                  total 8
                  drwxr-xr-x 2 appfint dba 4096 Sep 14 2006 jvm
                  -rw-r--r-- 1 appfint dba 345 Dec 11 10:29 mod_jserv.log

                  [appfint@ofinapq logs]$ cat mod_jserv.log
                  [10/12/2012 18:25:21:035] (EMERGENCY) Error adding with mod_oprocmgr
                  [11/12/2012 09:50:10:038] (EMERGENCY) Error adding with mod_oprocmgr
                  [11/12/2012 10:08:09:036] (EMERGENCY) Error adding with mod_oprocmgr
                  [11/12/2012 10:19:14:038] (EMERGENCY) Error adding with mod_oprocmgr
                  [11/12/2012 10:29:24:036] (EMERGENCY) Error adding with mod_oprocmgr

                  Not sure what is wrong ?
                  • 6. Re: Moving EBS database to different node
                    Hussein Sawwan-Oracle
                    967258 wrote:
                    Under $IAS_ORACLE_HOME/Apache/Apache/logs

                    cat error_log

                    [Tue Dec 11 10:29:24 2012] [warn] pid file /orappl_finapd/fint_appl/finqora/iAS/Apache/Apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
                    [Tue Dec 11 10:29:24 2012] [error] OPM:Fail to open file /tmp//Apache/Apache/logs/opm_sys_mtx.pid.10387
                    [Tue Dec 11 10:29:24 2012] [error] OPM:Fail to create mutex
                    [Tue Dec 11 10:29:24 2012] [error] OPM: process manager could not create internal tables
                    [Tue Dec 11 10:29:24 2012] [crit] (2)No such file or directory: Apache JServ encountered a fatal error; check your ApJServLogFile for details if none are present in this file. Exiting.

                    [appfint@ofinapq logs]$ cd $IAS_ORACLE_HOME/Apache/Jserv/logs
                    [appfint@ofinapq logs]$ ls -lrt
                    total 8
                    drwxr-xr-x 2 appfint dba 4096 Sep 14 2006 jvm
                    -rw-r--r-- 1 appfint dba 345 Dec 11 10:29 mod_jserv.log

                    [appfint@ofinapq logs]$ cat mod_jserv.log
                    [10/12/2012 18:25:21:035] (EMERGENCY) Error adding with mod_oprocmgr
                    [11/12/2012 09:50:10:038] (EMERGENCY) Error adding with mod_oprocmgr
                    [11/12/2012 10:08:09:036] (EMERGENCY) Error adding with mod_oprocmgr
                    [11/12/2012 10:19:14:038] (EMERGENCY) Error adding with mod_oprocmgr
                    [11/12/2012 10:29:24:036] (EMERGENCY) Error adding with mod_oprocmgr

                    Not sure what is wrong ?
                    This indicates that one (or more) of Apache services are up. Please shutdown Apache then kill the processes from the OS manually and try then. You may also reboot the server and start Apache as well.

                    Thanks,
                    Hussein
                    • 7. Re: Moving EBS database to different node
                      970261
                      Ok solved the problem with metalink note Error Adding With Mod_oprocmgr [ID 738612.1]     

                      Thanks
                      Chirag
                      • 8. Re: Moving EBS database to different node
                        Hussein Sawwan-Oracle
                        967258 wrote:
                        Ok solved the problem with metalink note Error Adding With Mod_oprocmgr [ID 738612.1]     

                        Thanks
                        Chirag
                        Thanks for the update and for sharing the solution.

                        Regards,
                        Hussein
                        • 9. Re: Moving EBS database to different node
                          970261
                          Ok finally moved sucessfully both DB tier and APP tier to Linux
                          Verified everything and so far good.

                          Now from here i would like to upgrade to R12.1.3 and the database to 11.2.0.3
                          I was reading the forums and found upgrading the application to R12.1.3 should be done first.

                          What documents should i follow
                          I know my first step which is converting to OATM.

                          Thanks
                          • 10. Re: Moving EBS database to different node
                            Hussein Sawwan-Oracle
                            967258 wrote:
                            Ok finally moved sucessfully both DB tier and APP tier to Linux
                            Verified everything and so far good.

                            Now from here i would like to upgrade to R12.1.3 and the database to 11.2.0.3
                            I was reading the forums and found upgrading the application to R12.1.3 should be done first.

                            What documents should i follow
                            I know my first step which is converting to OATM.

                            Thanks
                            Oracle E-Business Suite Release 12.1.3 Now Available
                            https://blogs.oracle.com/stevenChan/entry/ebs_1213_available

                            Interoperability Notes EBS R12 with Database 11gR2 [ID 1058763.1]

                            Thanks,
                            Hussein
                            • 11. Re: Moving EBS database to different node
                              970261
                              I am at the OATM migration step
                              I had couple of questions
                              My database is 1 TB and the OATM migration has consumed almost another 3 TB space
                              I will be soon running out of space. The migration report says only 50% complete.

                              Not sure why the size is three times more than the original database.

                              Also for reducing the tablespace size do i have to apply any patches
                              How do i reduce the size of old tablespaces and the new OATM tablespaces ?

                              Thanks
                              • 12. Re: Moving EBS database to different node
                                Srini Chavali-Oracle
                                Pl post output of storage parameters from DBA_TABLESPACES (blocksize, initial extent, mininum extents, next extent and pctincrease) for the old and new tablespaces.

                                HTH
                                Srini
                                • 13. Re: Moving EBS database to different node
                                  970261
                                  TABLESPACE_NAME                BLOCK_SIZE INITIAL_EXTENT MIN_EXTENTS NEXT_EXTENT PCT_INCREASE
                                  ------------------------------ ---------- -------------- ----------- ----------- ------------
                                  SYSTEM                               8192          16384           1       16384           50
                                  SYSAUX                               8192          65536           1
                                  AKD                                  8192          65536           1
                                  AKX                                  8192          65536           1
                                  AMAGENTD_4M                          8192          65536           1
                                  AMAGENTX_128K                        8192          65536           1
                                  AMRELOCD_4M                          8192          65536           1
                                  AMSD                                 8192          65536           1
                                  AMWD                                 8192          65536           1
                                  AMWX                                 8192          65536           1
                                  APD                                  8192          65536           1
                                  APD_128BN                            8192          65536           1
                                  APPLSYSD                             8192          65536           1
                                  APPLSYSX                             8192          65536           1
                                  APPLSYSX_4M                          8192        4194304           1     4194304            0
                                  APPS_TS_TX_128K_DATA                 8192         131072           1      131072            0
                                  APPS_TS_TX_128K_IDX                  8192         131072           1      131072            0
                                  APPS_TS_TX_128M_DATA                 8192      134217728           1   134217728            0
                                  APPS_TS_TX_128M_IDX                  8192      134217728           1   134217728            0
                                  APPS_TS_TX_4M_DATA                   8192        4194304           1     4194304            0
                                  APPS_TS_TX_4M_IDX                    8192        4194304           1     4194304            0
                                  APPS_TS_TX_64K_IDX                   8192          65536           1       65536            0
                                  ARD                                  8192          65536           1
                                  ARX                                  8192          65536           1
                                  ASOD                                 8192          65536           1
                                  ASOX                                 8192          65536           1
                                  CND                                  8192          65536           1
                                  CSCD                                 8192          65536           1
                                  CSCX                                 8192          65536           1
                                  CSD                                  8192          65536           1
                                  CSDD                                 8192          65536           1
                                  CSDX                                 8192          65536           1
                                  CSFD                                 8192          65536           1
                                  CSFX                                 8192          65536           1
                                  CSID                                 8192          65536           1
                                  CSIX                                 8192          65536           1
                                  CSLD                                 8192          65536           1
                                  CSLX                                 8192          65536           1
                                  CSMD                                 8192          65536           1
                                  CSMX                                 8192          65536           1
                                  CSPD                                 8192          65536           1
                                  CSPX                                 8192          65536           1
                                  CSRD                                 8192          65536           1
                                  CSRX                                 8192          65536           1
                                  CSSD                                 8192          65536           1
                                  CSSX                                 8192          65536           1
                                  CSX                                  8192          65536           1
                                  ECXD                                 8192          65536           1
                                  EULD                                 8192         131072           1      131072            0
                                  FAD                                  8192          65536           1
                                  FPAD                                 8192          65536           1
                                  GCSD                                 8192          65536           1
                                  GCSX                                 8192          65536           1
                                  GLD                                  8192          65536           1
                                  GLD_128BN                            8192      134217728           1   134217728            0
                                  GLD_4BN                              8192        4194304           1     4194304            0
                                  GLX                                  8192          65536           1
                                  GLX_4BN                              8192        4194304           1     4194304            0
                                  GMAD                                 8192          65536           1
                                  GMAX                                 8192          65536           1
                                  HRD                                  8192          65536           1
                                  HRID                                 8192          65536           1
                                  HRIX                                 8192          65536           1
                                  HRX                                  8192          65536           1
                                  IAD                                  8192          65536           1
                                  IAX                                  8192          65536           1
                                  ICXD                                 8192          65536           1
                                  ICXX                                 8192          65536           1
                                  IESD                                 8192          65536           1
                                  IMTD                                 8192          65536           1
                                  JTFD                                 8192          65536           1
                                  MSTD                                 8192          65536           1
                                  MSTX                                 8192          65536           1
                                  OKCD                                 8192          65536           1
                                  OKCX                                 8192          65536           1
                                  OKRD                                 8192          65536           1
                                  PAD                                  8192          65536           1
                                  POD                                  8192          65536           1
                                  PORTAL                               8192          65536           1
                                  POX                                  8192          65536           1
                                  TEMP                                 8192        5242880           1     5242880            0
                                  UNDOTBS                              8192          65536           1
                                  USERS                                8192         131072           1      131072            0
                                  XDOD                                 8192         131072           1      131072            0
                                  XDOX                                 8192         131072           1      131072            0
                                  XNPD                                 8192          65536           1
                                  XNPX                                 8192          65536           1
                                  XXBND                                8192        4194304           1     4194304            0
                                  XXBNX                                8192        4194304           1     4194304            0
                                  XXORAPPD_64K                         8192          65536           1       65536            0
                                  PAX_128K                             8192          65536           1
                                  APPS_TS_TX_DATA                      8192       51200000           1    51200000            0
                                  APPS_TS_TX_IDX                       8192       51200000           1    51200000            0
                                  APPS_TS_SEED                         8192       51200000           1    51200000            0
                                  APPS_TS_INTERFACE                    8192       51200000           1    51200000            0
                                  APPS_TS_SUMMARY                      8192       51200000           1    51200000            0
                                  APPS_TS_NOLOGGING                    8192       51200000           1    51200000            0
                                  APPS_TS_ARCHIVE                      8192       51200000           1    51200000            0
                                  APPS_TS_QUEUES                       8192       51200000           1    51200000            0
                                  APPS_TS_MEDIA                        8192       51200000           1    51200000            0
                                  APPS_TS_TOOLS                        8192       51200000           1    51200000            0
                                  • 14. Re: Moving EBS database to different node
                                    Hussein Sawwan-Oracle
                                    Your initial_extents and next_extents are relatively high and I would suggest you use the same values you have in the old tablespace model.

                                    Thanks,
                                    Hussein
                                    1 2 3 4 Previous Next