Re: Dba's i have a problem running dbms packages

  • From: "Vincent verpoort" <vincent.verpoort@xxxxxxxxx>
  • To: paul.baumgartel@xxxxxxxxxxxxxxxxx
  • Date: Fri, 20 Oct 2006 09:31:28 +0200

Well we solved it

Al the help got us in the right direction only it was something totaly else

We use tar files for our server installes dus the version of solaris changed
from 8 to 10 on the server. After a relinking of all oracle files the
problem was gonne.

The wierd thing was that everything worked except the dbms stuff.

On 10/19/06, Baumgartel, Paul <paul.baumgartel@xxxxxxxxxxxxxxxxx> wrote: 

 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
==============================================================================




--
                          Vincent Verpoort

 ,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_
             Communiceren is begrepen worden
^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-.

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2006