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

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_at_credit-suisse.com> 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_at_credit-suisse.com
> www.credit-suisse.com
>
> -----Original Message-----
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org]*On Behalf Of *Ken Naim
> *Sent:* Thursday, October 19, 2006 5:24 AM
> *To:* vincent.verpoort_at_gmail.com; '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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *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
^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-.

--
http://www.freelists.org/webpage/oracle-l