This discussion is archived
1 2 3 4 Previous Next 45 Replies Latest reply: Mar 4, 2013 1:22 AM by 966638 Go to original post RSS
  • 30. Re: EBS R12 migration to 64 bit Linux
    966638 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Hi All,

    Kindly anyone help me on this.


    Thanks,
    Salim
  • 42. Re: EBS R12 migration to 64 bit Linux
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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

Legend

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