This discussion is archived
1 2 Previous Next 19 Replies Latest reply: May 8, 2013 8:06 AM by Hussein Sawwan-Oracle RSS

Oracle EBS, database health check

873768 Newbie
Currently Being Moderated
Hi, experts:

I was asked to do a database health check on a database and EBS R12. Would you please tell me the steps how to do it?
Thank you very much in advance.
  • 1. Re: Oracle EBS, database health check
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    870765 wrote:
    Hi, experts:

    I was asked to do a database health check on a database and EBS R12. Would you please tell me the steps how to do it?
    Thank you very much in advance.
    Please see old threads for similar topic and discussion -- https://forums.oracle.com/forums/search.jspa?threadID=&q=Database+AND+Health+AND+Check&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001

    Thanks,
    Hussein
  • 2. Re: Oracle EBS, database health check
    873768 Newbie
    Currently Being Moderated
    Hussien and experts:

    Thanks. BTW, Is the following doc good enough to do the health check?
    E-Business Suite Diagnostics 11i Test Catalog [ID 179661.1]
  • 3. Re: Oracle EBS, database health check
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    870765 wrote:
    Hussien and experts:

    Thanks. BTW, Is the following doc good enough to do the health check?
    E-Business Suite Diagnostics 11i Test Catalog [ID 179661.1]
    Yes, it is.

    Thanks,
    Hussein
  • 4. Re: Oracle EBS, database health check
    873768 Newbie
    Currently Being Moderated
    Hussien and experts:

    Thank you.
    I have not done a health check before. I am going to a company to do a health check. What kind of questions I should ask? What things I should look for? I am reading as much as I can ready now. I will appreciated very much if you can give me detailed steps as if you are going to do it.

    Thanks and regards.

    Edited by: 870765 on Apr 28, 2013 7:15 AM
  • 5. Re: Oracle EBS, database health check
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    870765 wrote:
    Hussien and experts:

    Thank you.
    I have not done a health check before. I am going to a company to do a health check. What kind of questions I should ask? What things I should look for? I am reading as much as I can ready now. I will appreciated very much if you can give me detailed steps as if you are going to do it.

    Thanks and regards.

    Edited by: 870765 on Apr 28, 2013 7:15 AM
    Ask if they have any issues/errors and ask for all components log files (Apache, Forms, OPMN, CM, Database, Listeners, Workflow, ..etc).

    You can run the scripts you have then.

    Thanks,
    Hussein
  • 6. Re: Oracle EBS, database health check
    873768 Newbie
    Currently Being Moderated
    Hussien:

    Would you please tell me what tests I should do from [ID 179661.1]?
  • 7. Re: Oracle EBS, database health check
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    870765 wrote:
    Hussien:

    Would you please tell me what tests I should do from [ID 179661.1]?
    Applications Technology diagnostic scripts.

    Thanks,
    Hussein
  • 8. Re: Oracle EBS, database health check
    873768 Newbie
    Currently Being Moderated
    Thx.

    I was told there is a free ebs url link I can use. Do you know? I want to go through the diagnostic tools.
  • 9. Re: Oracle EBS, database health check
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    870765 wrote:
    Thx.

    I was told there is a free ebs url link I can use. Do you know? I want to go through the diagnostic tools.
    Yes, via OAM.

    E-Business Suite Diagnostics Installation Guide [ID 167000.1]
    E-Business Suite Diagnostic Tools FAQ and Troubleshooting Guide for Release 11i and R12 [ID 235307.1]

    Thanks,
    Hussein
  • 10. Re: Oracle EBS, database health check
    873768 Newbie
    Currently Being Moderated
    Hussien:

    I am sorry that I didnot tell you that I am in between jobs and the new job will ask me to do a health check which I have never done before. I want to prepare it right now but I dont have a system and dont have a big enough machine to install one. So I thought, someone told me a long time ago, there is a URL I can go to practice EBS.

    My first question for the diagnostics tool, for example "RDA" test, was that I dont know what to enter for the (* required) and (LOV)*. I thought if I see it may be I can understand. Would you please tell me the following if I cant find a free URL.

    RDA Data Collection Test
    Start Oracle E-Business Suite
    Connect to responsibility Application Diagnostics
    Select the Diagnose menu option
    Click button Select Application and select an appropriate Application
    Scroll down to group "System Snapshot"
    Select test name "RDA"
    Input Parameters (* required)
    Responsibility Id (LOV) *
    Application Shortname (LOV) *
    Mask sensitive data (LOV) *
    APPS Schema Username
    APPS Schema Password

    Thanks and regards
  • 11. Re: Oracle EBS, database health check
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    870765 wrote:
    Hussien:

    I am sorry that I didnot tell you that I am in between jobs and the new job will ask me to do a health check which I have never done before. I want to prepare it right now but I dont have a system and dont have a big enough machine to install one. So I thought, someone told me a long time ago, there is a URL I can go to practice EBS.

    My first question for the diagnostics tool, for example "RDA" test, was that I dont know what to enter for the (* required) and (LOV)*. I thought if I see it may be I can understand. Would you please tell me the following if I cant find a free URL.

    RDA Data Collection Test
    Start Oracle E-Business Suite
    Connect to responsibility Application Diagnostics
    Select the Diagnose menu option
    Click button Select Application and select an appropriate Application
    Scroll down to group "System Snapshot"
    Select test name "RDA"
    Input Parameters (* required)
    Responsibility Id (LOV) *
    Application Shortname (LOV) *
    Mask sensitive data (LOV) *
    APPS Schema Username
    APPS Schema Password

    Thanks and regards
    It depends on what module/application you are running the RDA for.

    Thanks,
    Hussein
  • 12. Re: Oracle EBS, database health check
    873768 Newbie
    Currently Being Moderated
    So what module/Application I should run? Should I ask them (the client)?
  • 13. Re: Oracle EBS, database health check
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    870765 wrote:
    So what module/Application I should run? Should I ask them (the client)?
    Yes. For example, if you want to run it for AP you need to have an AP responsibility assigned to you and you will select Payables.

    Thanks,
    Hussein
  • 14. Re: Oracle EBS, database health check
    873768 Newbie
    Currently Being Moderated
    But if they want to a over all health check, what I should do? What normally a client will ask?
1 2 Previous Next

Legend

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