1 2 3 4 Previous Next 45 Replies Latest reply: Mar 4, 2013 3:22 AM by 966638 Go to original post RSS
      • 30. Re: EBS R12 migration to 64 bit Linux
        966638
        Thanks Hussein,

        No luck..... I have dropped olapdir and created another directory ...Follwed the steps:


        1- drop directory OLAPDIR;

        SQL> select * from all_directories;
        OWNER DIRECTORY_NAME DIRECTORY_PATH
        ------------------------------ ------------------------------ ----------------------------------------------------------------------
        SYS DATA_PUMP_DIR /u01/oraapps/DEV/db/admin/DEV/dpdump/
        SYS ECX_UTL_LOG_DIR_OBJ /usr/tmp
        SYS ODPDIR /usr/tmp
        SYS APPS_DATA_FILE_DIR /u01/oraapps/DEV/db/11.2.0/appsutil/outbound/DEV_test
        SYS ECX_UTL_XSLT_DIR_OBJ /usr/tmp
        SYS ORACLE_OCM_CONFIG_DIR /u01/oraapps/DEV/db/11.2.0/ccr/state
        SYS EBS_LL_CONFIG_DIR /u01/oraapps/PRD/db/10.2.0/ccr/hosts/prod/state
        SYS CSR_XML_TOP /u01/oraapps/PRD/apps/apps_st/appl/csr/12.0.0/patch/115/xml
        8 rows selected.


        2- mkdir aw -> under '/u01/oraapps/DEV/db'

        3- chmod -R 777 /u01/oraapps/DEV/db/aw/


        4- SQL> create directory IMPAWOLA as '/u01/oraapps/DEV/db/aw';
        Directory created

        SQL> select * from all_directories;

        OWNER DIRECTORY_NAME DIRECTORY_PATH
        ------------------------------ ------------------------------ ----------------------------------------------------------------------
        SYS DATA_PUMP_DIR /u01/oraapps/DEV/db/admin/DEV/dpdump/
        SYS ECX_UTL_LOG_DIR_OBJ /usr/tmp
        SYS IMPAWOLA /u01/oraapps/DEV/db/aw
        SYS ODPDIR /usr/tmp
        SYS APPS_DATA_FILE_DIR /u01/oraapps/DEV/db/11.2.0/appsutil/outbound/DEV_test
        SYS ECX_UTL_XSLT_DIR_OBJ /usr/tmp
        SYS ORACLE_OCM_CONFIG_DIR /u01/oraapps/DEV/db/11.2.0/ccr/state
        SYS EBS_LL_CONFIG_DIR /u01/oraapps/PRO/db/10.2.0/ccr/hosts/prod/state
        SYS CSR_XML_TOP /u01/oraapps/PRO/apps/apps_st/appl/csr/12.0.0/patch/115/xml

        9 rows selected.

        5- SQL> grant all on directory IMPAWOLA to public;
        Grant succeeded.


        6- cp *.eif /u01/oraapps/DEV/db/aw/ and owner of these files is -> dbmgr


        7- SQL> exec dbms_aw.execute('cda IMPAWOLA');
        PL/SQL procedure successfully completed.


        8- SQL> exec dbms_aw.execute('import all from eif file ''IMPAWOLA/olap.eif'' data dfns'); [ all are single quotes]


        BEGIN dbms_aw.execute('import all from eif file ''IMPAWOLA/olap.eif'' data dfns'); END;
        *
        ERROR at line 1:
        ORA-36786: File IMPAWOLA/olap.eif does not exist or cannot be accessed.
        ORA-27300: OS system dependent operation:open failed failed with status: 2
        ORA-27301: OS failure message: No such file or directory
        ORA-27302: failure occurred at: SlfFopen1
        ORA-06512: at "SYS.DBMS_AW", line 93
        ORA-06512: at "SYS.DBMS_AW", line 122
        ORA-06512: at line 1



        Any option?

        Do you suggest to go back and do the same. This is running in VM, so I can revert to last snap. ?



        Thanks,
        Salim
        • 31. Re: EBS R12 migration to 64 bit Linux
          Hussein Sawwan-Oracle
          You are using the correct commands and you should not get this error. However, I would suggest you review these docs.

          How to Recreate an AW Through Export and Import Commands [ID 742375.1]
          How to Setup Trace for an AWM Session of OLAP to Obtain Application Log, DML Log and SQL Trace [ID 740598.1]

          If you still get the same error, then I would suggest you log a SR.

          Thanks,
          Hussein
          • 32. Re: EBS R12 migration to 64 bit Linux
            966638
            Thanks Hussein.

            Temporararily I hv skipped the olap step. Will try during my second iteration.

            I hv done post clone of apps -> admkappsutil -> adbld..xml ->autoconfig

            Now I hv to do post steps:


            1 - Please clarify me how to execute the "Relink AD executables"

            I think I need to run adrelink.sh, but I don't know what values will give for the below commands:

            adrelink force=y [<optional args>] <targets>


            I hv done the below steps:

            su - applmgr

            a) cd $AD_TOP/bin
            b) adrelink.sh force=y "ad all"

            Please let me know the above steps are enough to fulfill the step "Relink AD executables" in note: 471566.1 ? please let me know the extra step which I need to do



            Thanks,
            Salim.
            • 33. Re: EBS R12 migration to 64 bit Linux
              Srini Chavali-Oracle
              You should not skip the olap step as it is required step of the migration process. You can use adadmin to relink needed executables

              HTH
              Srini
              • 34. Re: EBS R12 migration to 64 bit Linux
                Hussein Sawwan-Oracle
                1 - Please clarify me how to execute the "Relink AD executables"

                I think I need to run adrelink.sh, but I don't know what values will give for the below commands:

                adrelink force=y [<optional args>] <targets>


                I hv done the below steps:

                su - applmgr

                a) cd $AD_TOP/bin
                b) adrelink.sh force=y "ad all"

                Please let me know the above steps are enough to fulfill the step "Relink AD executables" in note: 471566.1 ? please let me know the extra step which I need to do
                Use this command --> adrelink.sh force=y "ad all"

                Thanks,
                Hussein
                • 35. Re: EBS R12 migration to 64 bit Linux
                  Hussein Sawwan-Oracle
                  Srini Chavali wrote:
                  You should not skip the olap step as it is required step of the migration process. You can use adadmin to relink needed executables

                  HTH
                  Srini
                  You CANNOT relink AD executable files via adadmin.

                  Thanks,
                  Hussein
                  • 36. Re: EBS R12 migration to 64 bit Linux
                    966638
                    Thanks Hussein and Srini.

                    I have skipped OLAP step as per the note : 579234.1 ( How to verify if the OLAP option was in Use recently)

                    When I query - SQL > select DBID,NAME,VERSION,DETECTED_USAGES,CURRENTLY_USED,FIRST_USAGE_DATE,LAST_USAGE_DATE,DESCRIPTION from dba_feature_usage_statistics where name like 'OL%' , am getting below ouput.
                    SQL> select DBID,NAME,VERSION,DETECTED_USAGES,CURRENTLY_USED,FIRST_USAGE_DATE,LAST_USAGE_DATE,DESCRIPTION from dba_feature_usage_statistics where name like 'OL%';
                    
                          DBID NAME                           VERSION           DETECTED_USAGES CURRE FIRST_USA LAST_USAG DESCRIPTION
                    ---------- ------------------------------ ----------------- --------------- ----- --------- --------- ------------------------------
                     103678515 OLAP - Analytic Workspaces     10.2.0.3.0                    143 TRUE  17-JUL-09 07-APR-12 OLAP - the analytic workspaces
                                                                                                                           stored in the database.
                    
                     103678515 OLAP - Analytic Workspaces     10.2.0.5.0                     38 TRUE  13-APR-12 28-DEC-12 OLAP - the analytic workspaces
                                                                                                                           stored in the database.
                    
                     103678515 OLAP - Cubes                   10.2.0.3.0                      0 FALSE                     OLAP - number of cubes in the
                                                                                                                          OLAP catalog that are fully ma
                                                                                                                          pped and accessible by the OLA
                                                                                                                          P API.
                    
                     103678515 OLAP - Cubes                   10.2.0.5.0                      0 FALSE                     OLAP - number of cubes in the
                                                                                                                          OLAP catalog that are fully ma
                                                                                                                          pped and accessible by the OLA
                                                                                                                          P API.
                    1 - Please correct me on this. ?

                    2- Can I skip the OLAP step as per the above query ?



                    Thanks,
                    Salim
                    • 37. Re: EBS R12 migration to 64 bit Linux
                      Hussein Sawwan-Oracle
                      1 - Please correct me on this. ?

                      2- Can I skip the OLAP step as per the above query ?
                      No, you need to export/import OLAP since you are migrating from 32-bit Linux OS to 64-bit Linux OS.

                      Please refer to (Oracle EBS R12 with Database Tier Only Platform on Oracle Database 11.2.0 [ID 456347.1]) and read the note under "Export OLAP analytical workspaces (conditional)" section.

                      Thanks,
                      Hussein
                      • 38. Re: EBS R12 migration to 64 bit Linux
                        966638
                        Thanks for the reply..


                        Guys, my import AW issue solved. The problem was with file name. There was a space in file name after *.eif. Things cleared and I could import.


                        Thanks a lot for all inputs.


                        Thanks,
                        Salim
                        • 39. Re: EBS R12 migration to 64 bit Linux
                          Hussein Sawwan-Oracle
                          Guys, my import AW issue solved. The problem was with file name. There was a space in file name after *.eif. Things cleared and I could import.
                          Great! Thanka for the update and for sharing the solution!

                          Regards,
                          Hussein
                          • 40. Re: EBS R12 migration to 64 bit Linux
                            966638
                            Hi ...I have migrated to 64 bit sussfully. Application and forms everything working fine.


                            1 - I have run precole on both DB and APPS tier successfully.

                            2 - Copied to server (target)

                            3 - Post clone on DB tier

                            Getting error:


                            APPS Password : Log file located at /u01/ora/TST/db/11.2.0/appsutil/log/TST_ts02/ApplyDBTier_01080826.log
                            - 0% completed RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack

                            ERROR while running Apply...
                            Tue Jan 8 08:26:36 2013

                            ERROR: Failed to execute /u01/ora/TST/db/11.2.0/appsutil/clone/bin/adclone.pl

                            Please check logfile.



                            Contents of Log FIle: /u01/ora/TST/db/11.2.0/appsutil/log/TST_ts02/ApplyDBTier_01080826.log
                            -------------------------------------------------------

                            Log file located at /u01/ora/TST/db/11.2.0//appsutil/log/TST_ts02/make_01080826.log

                            Using make file "ins_emagent.mk" for linking SYSMAN utilities...
                            Error while running adlnkoh.sh.
                            return code = .58
                            Please check logfile located at /u01/ora/TST/db/11.2.0//appsutil/log/TST_ts02/make_01080826.log


                            .end std out.

                            .end err out.
                            ****************************************************


                            [AutoConfig Error Report]
                            The following report lists errors AutoConfig encountered during each
                            phase of its execution. Errors are grouped by directory and phase.
                            The report format is:
                            <filename> <phase> <return code where appropriate>

                            [APPLY PHASE]
                            AutoConfig could not successfully execute the following scripts:
                            Directory: /u01/ora/TST/db/11.2.0/perl/bin/perl -I /u01/ora/TST/db/11.2.0/perl/lib/5.8.3 -I /u01/ora/TST/db/11.2.0/perl/lib/site_perl/5.8.3 -I /u01/ora/TST/db/11.2.0/appsutil/perl /u01/ora/TST/db/11.2.0/appsutil/clone
                            ouicli.pl INSTE8_APPLY 255


                            AutoConfig is exiting with status 1

                            RC-50013: Fatal: Instantiate driver did not complete successfully.
                            /u01/ora/TST/db/11.2.0//appsutil/driver/regclone.drv


                            4 - I have created inventory and mapped this location in oraInst.loc, still same issue


                            5 - I am not sure about this warinig , this could be a reason ? Using make file "ins_emagent.mk" for linking SYSMAN utilities...


                            6 - I am not sure the issue with source server itself ?



                            Please helpe me on this.



                            Thanks,
                            Salim
                            • 41. Re: EBS R12 migration to 64 bit Linux
                              966638
                              Hi All,

                              Kindly anyone help me on this.


                              Thanks,
                              Salim
                              • 42. Re: EBS R12 migration to 64 bit Linux
                                Hussein Sawwan-Oracle
                                Please check logfile located at /u01/ora/TST/db/11.2.0//appsutil/log/TST_ts02/make_01080826.log
                                Please check this log file for more details about the error.

                                Thanks,
                                Hussein
                                • 43. Re: EBS R12 migration to 64 bit Linux
                                  966638
                                  Thanks Hussein,

                                  Issue resolved and I could able to clone now.


                                  For the error:
                                  --------------------
                                  Using make file "ins_emagent.mk" for linking SYSMAN utilities...
                                  Error while running adlnkoh.sh.
                                  return code = .58


                                  After applying the 12686610, issue fixed for the make.Actually this we need to apply during DB upgrade to 11.2.0.3.

                                  and during postclone, need to set path for perl/bin, unzip to avaoid any issues related to these executables.




                                  Thanks,
                                  Salim.
                                  • 44. Re: EBS R12 migration to 64 bit Linux
                                    Hussein Sawwan-Oracle
                                    Salim,
                                    Thanks Hussein,

                                    Issue resolved and I could able to clone now.


                                    For the error:
                                    --------------------
                                    Using make file "ins_emagent.mk" for linking SYSMAN utilities...
                                    Error while running adlnkoh.sh.
                                    return code = .58


                                    After applying the 12686610, issue fixed for the make.Actually this we need to apply during DB upgrade to 11.2.0.3.

                                    and during postclone, need to set path for perl/bin, unzip to avaoid any issues related to these executables.




                                    Thanks,
                                    Salim.
                                    Thanks for the update and for sharing the solution.

                                    Regards,
                                    Hussein