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

[julian]

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. "

[pando]

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

[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

[julian]

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?

[pando]

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

[julian]

So the process may read the same error several times, right?

[pando]

nop it is controlled with awk and sed

[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

[julian]

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.