Sorry RE: Woopeee and TWO ORA-600's!

2002-02-22 Thread Jamadagni, Rajendra
sorry ... I am trying too fast ... the error parameter was different it wasn't 26599 ... I am heading for a coffee. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is person

RE: Woopeee and TWO ORA-600's!

2002-02-22 Thread Jamadagni, Rajendra
Couple of days ago I have a ORA-600 [26599], it was being signaled during our periodic recompilation cron job. It turned out to be that a clever duheveloper had a hard new line character in an object name. Once we took it out, the error went away. This happened in 9012. Raj __

RE: Woopeee and TWO ORA-600's!

2002-02-22 Thread Connor McDonald
9i starts to use some of the java stuff all by itself which possibly explains the error. For example, there is now a trigger on every create-table to handle the cdc publish/subscribe features. This of course means you typically to allocate something to the java pool (if you have installed java)

RE: Woopeee and TWO ORA-600's!

2002-02-22 Thread Mercadante, Thomas F
Mark, I've had success running removing Java by running the following package: exec sys.rmjvm(true); The package sould have been installed when Java was installed. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, February 22, 2002 6:08 A

RE: Woopeee and TWO ORA-600's!

2002-02-22 Thread Mark Leith
Title: RE: Woopeee and TWO ORA-600's! Thanks John, worked like a charm! Thanks for the pointer too Tom, but thanks to John it's all sorted..   Cheers!   Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Hallas JohnSent: 22 Februa

RE: Woopeee and TWO ORA-600's!

2002-02-22 Thread Hallas John
Title: RE: Woopeee and TWO ORA-600's! Mark, Here are a couple of notes I saved on the subject John rmjvm.sql doesnot remove all the components properly. If your resources sizes are ok, then try following.   If for any reason the installation fails then $ORACLE_HOME/javavm/in

RE: Woopeee and TWO ORA-600's!

2002-02-22 Thread Mark Leith
Ahh well! I have another question following this: I am also getting the following error on startup: Fri Feb 22 09:33:04 2002 Errors in file C:\oracle\admin\ORCL\udump\ORA03028.TRC: ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","unknown object","joxs heap init","ioc_al

RE: Woopeee and TWO ORA-600's!

2002-02-22 Thread Hallas John
Title: RE: Woopeee and TWO ORA-600's! Mark The ora600 lookup  tool on Metalink states that there is no description for this code John -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: 22 February 2002 09:34 To: Multiple recipients of list ORACLE-L Subject: Wo