8 Replies Latest reply: Nov 11, 2009 5:00 AM by userxyz1234 RSS

    sanity check on server

    723711
      Hi All,

      We have Linux server with oracle 10g(R2) database in it.My client asked us to perform a sanity check on this server.
      since i am new to this work,I have no idea what it is.So,Please someone help me with this thing.

      Tell me what and how to do it and how the report should be.

      If any one have report of this kind please paste it here,that would be really helpful.

      Thanks in advance....
        • 1. Re: sanity check on server
          SatishKandi
          Search for "database health check" in this very forum. You will find a lot of threads discussing the same.
          • 2. Re: sanity check on server
            723711
            Hi Satish,

            I browsed with the info you gave but haven't found anything useful for me........Please see if there is anything you could do to help me on this.......

            Thanks
            • 3. Re: sanity check on server
              Girish Sharma
              Defination of sanity check :
              http://encyclopedia2.thefreedictionary.com/sanity+check

              Now, what does it mean to check programming / logical error on server; it is confusing.

              Regards
              Girish Sharma
              • 4. Re: sanity check on server
                Niall Litchfield
                Take definition 1 not 2 then. A check of the database server for stupid or common errors. That's why the earlier poster correctly pointed you towards the term health check. Here is the table of content from a health check that our customers might get if they'd not expressed any specific concerns ahead of time. Note that I won't give you the content or sections 1-5 :(

                6     DATABASE HEALTH CHECK     
                6.1     Space Management     
                6.2     Backup Management     
                6.3     Security     
                6.4     Transaction Management     
                6.5     Statistics Management     
                6.6     Errors     
                6.7     Performance Management     
                7     CONCLUSIONS:     


                Regards

                Niall Litchfield
                http://www.orawin.info/
                • 5. Re: sanity check on server
                  Girish Sharma
                  Actually i was confused that OP is asking database health check script or is there any difference between sanity check and database health check. So i googled "sanity check" and found the above link; which is saying different defination i.e. any stupid mistake related to programming code called sanity check. For an oracle dba; sanity check, which you elaborated; now clear my doubts.

                  @OP
                  Now you have got replied in your linux forum thread too....!
                  http://www.linuxforums.org/forum/misc/155600-sanity-check-server.html

                  Thank you.
                  Regards
                  Girish Sharma

                  Edited by: Girish Sharma on Nov 11, 2009 2:58 PM
                  • 6. Re: sanity check on server
                    userxyz1234
                    I heartily recommend using Grid Control: it does 99% of the legwork for you.
                    • 7. Re: sanity check on server
                      723711
                      Hi,

                      What is that Grid control thing and just tell how can I get my hands on it? Please tell me..

                      Thanks
                      • 8. Re: sanity check on server
                        userxyz1234
                        Overview:
                        http://www.oracle.com/technology/products/oem/index.html

                        Demos:
                        http://www.oracle.com/technology/products/oem/tutorials/index.html

                        This is a good demo for "Health Checking/Monitoring":
                        http://download.oracle.com/technology/products/oem/screenwatches/monitoring_templates/index.html