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

    Oracle EBS, database health check

    873768
      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
          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
            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
              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
                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
                  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
                    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
                      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
                        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
                          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
                            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
                              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
                                So what module/Application I should run? Should I ask them (the client)?
                                • 13. Re: Oracle EBS, database health check
                                  Hussein Sawwan-Oracle
                                  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
                                    But if they want to a over all health check, what I should do? What normally a client will ask?
                                    1 2 Previous Next