RE: Dba's i have a problem running dbms packages
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "'Oracle-L Freelists'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 Oct 2006 15:10:37 +0100
This can also occur if you have migrated a database created with 32-bit Oracle
software to 64-bit Oracle software.
There's a MetaLink note, 62290.1, on this--basically you want to
login as sysdba
startup migrate
@catalog
@catproc
Resolve any invalid objects
@utlirp
Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Ken Naim
Sent: Thursday, October 19, 2006 5:24 AM
To: vincent.verpoort@xxxxxxxxx; 'Oracle-L Freelists'
Subject: RE: Dba's i have a problem running dbms packages
While I don't have experience with this particular issue, based similar issues
though I would guess that your sys/system packages are either corrupt or
uncompiled for whatever reason. I would start by running utlrcmp and if that
doesn't work rerun catalog, catproc, and utlrcmp as sys. Depending on the
version deleting database statistics has been known to help with this type of
issue on occasion.
Ken
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Vincent verpoort
Sent: Thursday, October 19, 2006 4:13 AM
To: Oracle-L Freelists
Subject: Dba's i have a problem running dbms packages
While running dbms stuff im getting this error and well i can find anything on
internet how to solve this only that allot of poeple are having this problem.
Any tips ?
BEGIN DBMS_OUTPUT.ENABLE(100000); END;
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-06553: PLS-801: internal error [56319]
ORA-06553: PLS-801: internal error [56319]
--
Vincent Verpoort
,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_
Communiceren is begrepen worden
^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-.
==============================================================================
Please access the attached hyperlink for an important electronic communications
disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================
Other related posts:
