FORUM

Erman Arslan's Oracle Forum

51 comments :

  1. HI ,

    1. How to increase the size of existing shared repository.
    2. Deployed the DB template on oda1-dom0, but need to increase the space of /u01. How can we increase the size of it. /u01 is on oda1.
    2. How to create a new mount point (e.g. /u02 ) using disk space from shared repository?
    3. What happens if one of the Node on ODA goes down? How easy will it be to start a VM on the second node?

    ReplyDelete
  2. in RAC services failover to other node only they are configured to available node is automatic happen or need to relocate manually when we stop all services in single node

    Also what all services by default will failover to other node when cluster services in single node are brought down

    please share your views on these...
    Thanks a lot!!!!

    ReplyDelete
  3. Please use the link "http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/RAC-f7.html" to create an issue into the RAC category.

    ReplyDelete
  4. Hi

    I installed oracle ebs 12.2.0 asuccessfully abd then try to do database patches according to the consolited list of patches and technology bug fixes(Doc ID: 1594274.1)

    But I have some prerequisite patches (p10831683 and up to the p20760997).
    So I try to apply the patch (20760997) with so many conflicts.
    I rollbacked all of the conflict patches and then applied the patch 20760997.

    but in the other database patch like 18614015, that patch has the conflict with the patch 20760997.

    so what do I have to do in this situation?

    Thanks


    ReplyDelete
  5. Please use the link and create an issue into EBS 12.2 category: http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/EBS-12-2-f6.html

    ReplyDelete
  6. Dear Erman,

    Kindly I would like to ask a question, If oracle E-business R 12.2.4 certified with oracle database 12.1.2.4.0 ?

    thank you

    ReplyDelete
  7. At the moment No . EBS 12.2.4 is not certified with 12.1.2.4.0 .

    ReplyDelete
  8. Hi Erman, i have performed 12.2.4 cloning, it was done successfully, what are the post cloning steps to be performed on application tier and how to add the custom top to the clone instance which is already existing on the production.Thank you

    ReplyDelete
  9. Hi Uknown, Please use the link and create an issue into EBS 12.2 category: http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/EBS-12-2-f6.html

    ReplyDelete
  10. Hello Erman,
    I am able to login into oracle apps with valid user but for invalid user its giving error saying dat request uri is too large.
    need help its very urgent

    ReplyDelete
  11. You dont provide any details, also please open an "issue".
    Please open an issue in my forum and attach a screenshot representing the error. Attach apache log and oacore log as well. Also describe any recent changes, State if the issue is on an SSL enabled EBS or not as well.
    http://ermanarslan.blogspot.com.tr/p/forum.html

    ReplyDelete
  12. Dear Erman,
    I would like to ask a question,
    on ODA X4-2 System , The problem is that the Oakcli commands hang when executed. No errors are shown, the commands simply do not complete,
    I can't stop , start , create repository or VM.
    only oakcli show commands is working well.

    thanks in advance

    ReplyDelete
  13. Hi Amr,

    Please use my forum and create a new topic in the related category.

    ReplyDelete
  14. Hi Emran,

    While creating a custom top in 12.2, I'm getting below error
    AD Splicer error:
    Error: Unable to run enable_custom_user

    AD Splicer - aiuoraEnableCustom: INFO: ORA-20006: Can not enable user for editions. ORA-0000: normal, successful completion
    ORA-06512: at "APPS.AD_ZD_PREP", line 2235
    ORA-06512: at line 1


    AD Splicer error:
    Error calling aiuoraEnableCustom.
    ===========

    I used the patch Patch 13725897: CLE: Adsplice Patch for R12.2 as suggested by you.

    I would appreciate if you can help me to resolve this issue.

    Regards,
    Wasim

    ReplyDelete
  15. Hi Wasim,

    Don't ask your questions by making comments here.
    As for EBS 12.2, please use the link and create an issue into EBS 12.2 category: http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/EBS-12-2-f6.html

    ReplyDelete
  16. Oracle EBS 12.2.0 Error: (please notify me: sathishr723@gmail.com)

    Cannot install Web Tier Utilities

    RW-50010: Error: - script has returned an error: 1
    RW-50004: Error code received when running external process. Check log file for details.
    Running APPL_TOP Install Driver for BILLT instance

    ReplyDelete
  17. You don't give any details about your platform, but still I will try to help you.

    Check this document:

    R12.2.0 Installation Error : Cannot install WebLogic Server RW-50010: Error: - script has returned an error: RW-50004: Error code received when running external process. (Doc ID 1942379.1)

    I will remind it once again:
    Don't ask your questions by making comments here.
    As for EBS 12.2, please use the link and create an issue into EBS 12.2 category: http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/EBS-12-2-f6.html

    ReplyDelete
  18. Hi. I am following the note (Doc ID 2090393.1) , but in step number 4 fail:

    SQL> select distinct(PATH) from FND_OAM_CONTEXT_FILES where NAME not in ('TEMPLATE','METADATA','config.txt') and CTX_TYPE='A' and (status is null or upper(status) in ('S','F')) and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type') = 'patch';
    select distinct(PATH) from FND_OAM_CONTEXT_FILES where NAME not in ('TEMPLATE','METADATA','config.txt') and CTX_TYPE='A' and (status is null or upper(status) in ('S','F')) and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type') = 'patch'
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist

    ReplyDelete
  19. Now, i have this error:

    Validating system setup.
    [UNEXPECTED]Duplicate rows found for host preprod in FND_OAM_CONTEXT_FILES table
    *******FATAL ERROR*******
    PROGRAM : (/u01/install/APPS/fs2/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
    TIME : Wed Feb 1 13:54:33 2017
    FUNCTION: ADOP::CommonUtil::getAppltopId [ Level 1 ]
    ERRORMSG: Duplicate rows found for host preprod in FND_OAM_CONTEXT_FILES table

    adopscanlog -latest=yes
    Lines #(129-134):
    [PROCEDURE] Calling: /u01/install/APPS/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl
    [EVENT] Log: /u01/install/APPS/fs_ne/EBSapps/log/adop/70/20170201_130234/prepare/validate/preprod
    [UNEXPECTED]Error occurred running "perl /u01/install/APPS/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile=/u01/install/APPS/fs2/inst/apps/OEBT1N_preprod/appl/admin/OEBT1N_preprod.xml -patchctxfile=/u01/install/APPS/fs1/inst/apps/OEBT1N_preprod/appl/admin/OEBT1N_sebs4101lx.xml -phase=prepare -logloc=/u01/install/APPS/fs_ne/EBSapps/log/adop/70/20170201_130234/prepare/validate/sebs4101lx -promptmsg=hide"
    [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on preprod
    [PROCEDURE] [START 2017/02/01 13:03:10] Unlocking sessions table
    [STATEMENT] Unlocking ad_adop_sessions table for sebs4101lx with wait interval of 60 seconds and number of tries 2

    ReplyDelete
  20. backup FND_OAM_CONTEXT_FILES

    create table FND_OAM_CONTEXT_FILES_BK as select * from FND_OAM_CONTEXT_FILES;

    Clear data from FND_OAM_CONTEXT_FILES table.

    delete from FND_OAM_CONTEXT_FILES;

    Execute autoconfig from all nodes. (including db )

    retest your issue.

    "Next time, don't ask your questions by making comments here"
    Use my Forum!
    As for EBS 12.2, please use the link and create an issue into EBS 12.2 category: http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/EBS-12-2-f6.html

    ReplyDelete
  21. database on oracle database appliance and DR on HP UX if it's possible .


    ReplyDelete
  22. No. It is not possible and not supported.

    "Next time, don't ask your questions by making comments here"
    Use my Forum!

    ReplyDelete
  23. This comment has been removed by the author.

    ReplyDelete
    Replies
    1. This comment has been removed by the author.

      Delete
    2. Mohammed, use my forum to ask question. You can attach file as well.
      Don't ask your questions by making comments here

      Use my Forum!
      As for EBS 12.2, please use the link and create an issue into EBS 12.2 category: http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/EBS-12-2-f6.html

      Delete
  24. Hi Erman, how many scans i can create in a RAC exadata 6-x2 8th ?

    ReplyDelete
  25. Use my Forum!
    As for EBS 12.2, please use the link and create an issue into EBS 12.2 category: http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/EBS-12-2-f6.html

    This is your first time it seems, so I'll answer for this time.

    You should create 3 scan listener (if your asking the scan listener)
    If you are asking scan, check 12c: "How to create additional SCAN/SCAN VIP (Doc ID 2138078.1)"

    You should for what each interface is used in your environment and which is free to add as additional public network.

    The count of your additional scan can be equal to your free interface count.
    Check the machine.

    ReplyDelete
  26. is webcenter 11.1.1.8 is certified with EBS 12.2.6 ?

    ReplyDelete
  27. is webcenter content imaging 11.1.1.8 is certified with EBS 12.2.6 ?

    ReplyDelete
  28. Hi,

    I am facing an issue related to the upgrade of R12.2.0 to R12.2.4.The Database is 12.1.0.2, OS Linux 7.3 and Application 12.2.0. As per Oracle doc. id 1617458.1 we need to Apply Consolidated Seed Table Upgrade Patch 17204589:12.2.0 which we applied successfully, then we tested the application with all forms opening. Then we applied the AD and TXK Delta 10 Release Update Pack. This was also without any error. After this we tested the application but the forms are not opening. The error it showed was "In order to access this application, you must install J2SE plugin version 1.6.0_27". We raised the SR with MOS and the asked us to execute the following commands which we did. The commands are
    1. Stop the application tier services
    + Run adadmin regenerate JAR file
    + Compile all the forms.
    + cd $ORACLE_HOME/forms/lib
    make -f ins_forms.mk install

    2. Run autoconfig on apps tiers
    3. Bring up the services and test issue
    This time after going thru System Administrator > Concurrent > Manager > Administer, The window with Oracle EBS Logo appeared.

    I would highly appreciate solution which can fix this issue.

    Thanks.

    ReplyDelete
  29. Open the "java console" on your client, reproduce the problem and send me the logs/traces that are written there.
    Please use my forum to ask your question and upload your outputs. You can attach files as well.
    Don't ask your questions by making comments here

    Use my Forum!
    As for EBS 12.2, please use the link and create an issue into EBS 12.2 category: http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/EBS-12-2-f6.html

    ReplyDelete
  30. Erman,
    I followed your post on "FMW -- 12C Forms and Reports Cluster installation (2 node, High Available)" However, you did not mention any requirement that needed to be met in other for this to happen. Could you make available the prerequisite, like shared storage, and loadbalancer configuration and HA failover requirements for forms and reports.

    ReplyDelete
  31. No shared storage is required.
    ofcourse, you can put a Load balancer in front of the Oracle HTTP Servers.
    This conf is HA.

    If you have specific questions : Use my Forum!
    As for EBS 12.2, please use the link and create an issue into middleware category: http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Middleware-Weblogic-f10.html

    ReplyDelete
  32. im facing the problem when installing EBS on Oracle linux 7.4


    Rapid Install Wizard is validating your file system......

    CMDDIR=/home/stageR1226/startCD/Disk1/rapidwiz

    Rapid Install Wizard will now launch the Java Interface.....

    [root@erp-database rapidwiz]# Error: no `server' JVM at `/home/stageR1226/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0/lib/i386/server/libjvm.so'.

    ReplyDelete
  33. im facing the problem when installing EBS on Oracle linux 7.4


    Rapid Install Wizard is validating your file system......

    CMDDIR=/home/stageR1226/startCD/Disk1/rapidwiz

    Rapid Install Wizard will now launch the Java Interface.....

    [root@erp-database rapidwiz]# Error: no `server' JVM at `/home/stageR1226/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0/lib/i386/server/libjvm.so'.

    ReplyDelete
  34. Read this:

    http://ermanarslan.blogspot.com.tr/2016/11/ebs-122-problem-installing-ebs-on-xfs.html

    Next time, please use my forum to ask your question and upload your outputs. You can attach files as well.
    Don't ask your questions by making comments here

    Use my Forum!
    As for EBS 12.2, please use the link and create an issue into EBS 12.2 category: http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/EBS-12-2-f6.html

    ReplyDelete
  35. HI, How to create in-process report server in oracle forms and reports 12c R2 Cluster Setup.

    ReplyDelete
  36. What do you mean by "in-process report server"?

    ReplyDelete
  37. Hi Erman,

    As per document on E-Business R12.2 Installation on Linux 6.7 I exactly followed all steps

    completing all the pre-requsites with RPM’s, yum install oracle-ebs-server-R12-preinstall, successful
    ./buildstage.sh.

    When I start installation I reach upto pre-requisite checks and get the error as
    “web server pre install checks failed”

    This error goes into the endless loop and continues
    till I close the system detail checks window. Even I do
    not get Pre-Install Checks page.

    I have attached the 2 log files of each version for reference

    Note : I tried both the versions of 12.2 with sucessful
    buildstage and pre-requisites.

    For 12.2.5 (Your document Installation)
    12.2.0.46_startCD

    For 12.2.6
    12.2.0.51_startCD

    I am getting the same error as

    web server pre install checks failed

    Please correct me where I am wrong. What is the
    possible root cause of this error. Please advice.

    Thanks and Regards

    Ajaz Ahmed
    Senior Oracle Corporate Trainer
    Bombat(Mumbai)
    +919967890118

    ReplyDelete
  38. Review the 12.2 Installation and Upgrade Notes and ensure that all of the prerequisites such as kernel settings and OS package requirements have been met.

    Review note: Troubleshooting Rapid Install for E-Business Suite Release 12.2 (Doc ID 1378579.1)

    Ensure directory permissions of the stage are correct.

    Also, check the log file for that prereq chek:
    $TMP/wtprechk.xxxx/wtprechk.xxxx.log

    ReplyDelete
  39. Hi Erman,

    I am trying to adop phase=prepare in EBS R12.2.0.
    Giving me below error.


    *** Log File = /d01/appl_prod/fs_ne/EBSapps/log/adop/3/prepare_20180426_194025/PROD_erpnode2/TXK_SYNC_create_Thu_Apr_26_19_44_55_2018/txkADOPPreparePhaseSynchronize_Thu_Apr_26_19_44_55_2018.log

    *******FATAL ERROR*******
    PROGRAM : (/d01/appl_prod/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl)
    TIME : Thu Apr 26 19:45:08 2018
    FUNCTION: TXK::FileSys::getDirList [ Level 3 ]
    MESSAGES:
    No read access for directory /d01/_prod/fs2/EBSapps
    Access permission error on /d01/_prod/fs2/EBSapps
    Directory /d01/_prod/fs2/EBSapps not readable


    STACK TRACE
    at /d01/appl_prod/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168
    TXK::Error::abort('TXK::Error', 'HASH(0x282eaf8)') called at /d01/appl_prod/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 299
    TXK::Common::doError('TXK::FileSys=HASH(0x3c47de0)', 'No read access for directory /d01/_prod/fs2/EBSapps', undef) called at /d01/appl_prod/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314
    TXK::Common::setError('TXK::FileSys=HASH(0x3c47de0)', 'No read access for directory /d01/_prod/fs2/EBSapps') called at /d01/appl_prod/fs1/EBSapps/appl/au/12.0.0/perl/TXK/FileSys.pm line 735
    TXK::FileSys::getDirList('TXK::FileSys=HASH(0x3c47de0)', 'HASH(0x3c41b48)') called at /d01/appl_prod/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl line 2593
    main::getBackupCount('/d01/_prod/fs2/EBSapps', 'appl') called at /d01/appl_prod/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl line 2646
    main::getBackupsAvailable() called at /d01/appl_prod/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl line 1475
    main::checkSpaceAvailability() called at /d01/appl_prod/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl line 1756
    main::createPatchApplTop() called at /d01/appl_prod/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl line 537
    [ERROR] Error occurred while executing
    [ERROR] Error occurred while CLONE PATCH FS with RUN FS using command: .
    [STATEMENT] fs_clone phase completed with errors/warnings. Please check logfiles
    [ERROR] Error while runPendingClone sub-routine is called
    [STATEMENT] [START 2018/04/26 19:45:13] Check and Stop Patch Admin Server
    [STATEMENT] There is a pending clone session for /d01/appl_prod/fs2.
    [STATEMENT] Skipping Check and Stop Patch Admin Server Step.
    [STATEMENT] [END 2018/04/26 19:45:17] Check and Stop Patch Admin Server
    [STATEMENT] Prepare phase completed with errors/warnings. Please check logfiles
    [STATEMENT] PREPARE Phase END TIME: 26-04-2018 19:45:20
    [STATEMENT] [START 2018/04/26 19:45:22] Unlocking sessions table
    [STATEMENT] [END 2018/04/26 19:45:23] Unlocking sessions table
    [STATEMENT] Log file: /d01/appl_prod/fs_ne/EBSapps/log/adop/3/adop_20180426_194025.log

    adop exiting with status = 1 (Fail)



    Please help me resolving this..

    ReplyDelete
  40. Hi Glory,

    The error is clear. It is a permission error. You should configure the directory permissions properly. (No read access for directory /d01/_prod/fs2/EBSapps)

    ReplyDelete
  41. Hi Emran,

    I am following Doc ID 1367293.1 to implement TLS in EBS R12.5 and stuck at Step 5 while executing below command :

    . /u01/oracle/apps/EBSapps.env patch
    $ORACLE_HOME/opmn/bin/opmnctl redeploy -adminHost apps.abc-group.com -adminPort 7002 -adminUsername weblogic

    usage: /u01/oracle/apps/fs2/EBSapps/10.1.2/opmn/bin/opmnctl [verbose] [] []

    verbose: print detailed execution message if available

    Permitted // combinations are:

    scope command options
    ------- --------- ---------
    start - Start opmn
    startall - Start opmn & all managed processes
    stopall - Stop opmn & all managed processes
    shutdown - Shutdown opmn & all managed processes
    [] startproc [= ..] - Start opmn managed processes
    [] restartproc [= ..] - Restart opmn managed processes
    [] stopproc [= ..] - Stop opmn managed processes
    [] reload - Trigger opmn to reread opmn.xml
    [] status [] - Get managed process status
    [] dmsdump [=&..] - Get DMS stats
    ping [] - Ping local opmn
    validate [] - Validate the given xml file
    help - Print brief usage description
    usage [] - Print detailed usage description

    Regards,
    Shahid

    ReplyDelete
  42. Hi Erman - thanks for sharing the knowledge and your time to support others.

    We have a single node ebs application running on rac database and we have a plan to add another node. Could you please help me with the best approach or any useful blog from your repository.

    Thanks,

    ReplyDelete
  43. Hi,

    Question:: For cloning ebs 12.2 RAC DB 2 nodes/app server. Do I need to do any additional pre-requisite checks on the target RAC db server other than "cluvfy stage -pre dbinst -n all > $HOME/cluvfymmddyy.txt". Am I good if this passes or do I need additional prereq checks. Cluster is up and running on the target server with additional databases

    Thank you

    ReplyDelete
  44. Good afternoon Erman,
    You have an excellent post named "FMW -- 12C Forms and Reports Cluster installation (2 node, High Available)", but the pictures of the post do'nt appear. Please can you reshare the post the images.
    Best regard

    ReplyDelete
  45. Obviously you have a wonderful blog. I upgraded 11107 CRS to 11204 GI successfully. the listener and ASM upgraded and under control by GI. database is still on 11107. 11204 listener does not register 11107 database. My question is how do i configure 11204 listener to listen 11107 database?
    thank you
    Andrew

    ReplyDelete
  46. OAM logo has been changed but weblogic is not going to change after replacing login_logo.png with new one.

    please suggestion needed to resolve this issue.

    ReplyDelete
  47. How can I find these software in oracle edelivery.com for EBS12.2.5
    V100078-01.zipOracle E-Business Suite Release 12.2 Supplemental Documentation - REVIEW FIRST 21.6 MB
    V100079-01.zipOracle E-Business Suite Release 12.2 Supplemental Media 603.2 MB
    V77840-01_1of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 514.5 MB
    V77840-01_2of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 527.6 MB
    V77840-01_3of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 459.4 MB
    V77840-01_4of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 530.4 MB
    V77840-01_5of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 571.4 MB
    V77840-01_6of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 554.9 MB
    V77840-01_7of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 526.7 MB
    V77840-01_8of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 596.3 MB
    V77840-01_9of9.zipOracle E-Business Suite Release 12.2.5 Update Pack for Linux x86-64 100.5 MB
    V77972-01.zipOracle E-Business Suite Release 12.2.5 Documentation Library 730.2 MB
    I am not able to find these documents under 12.2.0 and 12.2.5

    ReplyDelete

  48. Hi Emran,

    I am facing same issue as following directories not exist in my server. Please help me I am trying to upgrade from 12.2.0 to 12.2.3


    PROGRAM : (/u01/app/applmgr/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl)
    TIME : Sun Nov 24 11:43:23 2019
    FUNCTION: TXK::FileSys::getDirList [ Level 3 ]
    MESSAGES:
    No read access for directory /u01/app/mgr/fs2/EBSapps
    Access permission error on /u01/app/mgr/fs2/EBSapps
    Directory /u01/app/mgr/fs2/EBSapps not readable

    ReplyDelete

If you will ask a question, please don't comment here..

For your questions, please create an issue into my forum.

Forum Link: http://ermanarslan.blogspot.com.tr/p/forum.html

Register and create an issue in the related category.
I will support you from there.