Instructions on how to get the Oracle errors from the alert.log as email or SMS - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 19 of 19

Thread: Instructions on how to get the Oracle errors from the alert.log as email or SMS

  1. #11
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by pando
    select * from xxx where text like '%ORA-%' :-?
    And if you have already read those errors? Like Patrol, you want to send them to me all the time :-) Because Patrol informs me 10 times for one and the same error.

    According to Oracle "Patrol has a bug, it wakeup once in a few month and scan the whole alertlog and start complaing as it is today's problem, which is not really. "
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  2. #12
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    hmm I dont get it

    I do

    1. load the table
    2. spool and query
    3. quit the session
    4. check spool size in unix, if bigger than 0 bytes mailx the file



  3. #13
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    ah right you mean read the whole alert log
    I dont do that because I rename them at 0:00 so I never load old alert log into the table

  4. #14
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by pando
    ah right you mean read the whole alert log
    I dont do that because I rename them at 0:00 so I never load old alert log into the table
    OK Pando but how often do you read the alert? Ones a day? If you read it twice a day how do you know if the error in alert.log was already read during the first time?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  5. #15
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well that is a problem but anyway the process we have reads alert with OS tools (no Patrol junx, expensive and sad tool)

    The process runs every 30 minutes

  6. #16
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    So the process may read the same error several times, right?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  7. #17
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    nop it is controlled with awk and sed

  8. #18
    Join Date
    May 2002
    Location
    Mumbai, India
    Posts
    27
    Hi,
    Please give me some Idea.
    In step 2 when I'm executing the loadjava , this error is coming .....
    ( Oracle Database 8.1.7 is installed in my PC in d: drive and Oracle 9iAS is also installed in my machine in e: drive)
    ---------------------------------------------------------
    SQL Error while connecting with oci8 driver to conn_str: oracle.aurora.server.tools.
    loadjava.ToolsException: The JDBC OCI8 Driver is not installed properly, use -thin to try the JDBC Thin driver: get_env_handle
    could not open connection
    loadjava: 2 errors

  9. #19
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by Anomitro
    Hi,
    Please give me some Idea.
    In step 2 when I'm executing the loadjava , this error is coming .....
    ( Oracle Database 8.1.7 is installed in my PC in d: drive and Oracle 9iAS is also installed in my machine in e: drive)
    ---------------------------------------------------------
    SQL Error while connecting with oci8 driver to conn_str: oracle.aurora.server.tools.
    loadjava.ToolsException: The JDBC OCI8 Driver is not installed properly, use -thin to try the JDBC Thin driver: get_env_handle
    could not open connection
    loadjava: 2 errors
    I have had this error during one installation. I tried several things but the only thing that worked was to remove JVM first by running rmjvm and starting the installation from the beginning.

    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width