-
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
-
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
-
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
-
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
-
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
-
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
-
nop it is controlled with awk and sed
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|