.ora-code.com

Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
Catupgrd.sql failing.. Any experience

Catupgrd.sql failing.. Any experience

2005-09-21       - By Gogala, Mladen
Reply:     1     2  

Did you increase Java Pool and Shared Pool to match sizes specified in the
document?

--
Mladen Gogala
Ext. 121

-- --Original Message-- --
From: Thakuria, Anjan [mailto:anjan.thakuria@(protected)]
Sent: Wednesday, September 21, 2005 11:10 AM
To: oracle-l
Subject: Catupgrd.sql failing.. Any experience

Hello all...

I am in the middle of a upgrade to 10.2.0.1 and the catupgrd.sql is
failing when it gets to

Cmpdbmig.sql part..

It errors out on the following stmt..


cmpdbmig.sql
and within that almost at the very beginning it does..
SELECT dbms_registry_sys.dbupg_script('JAVAVM') AS dbmig_name FROM DUAL;
and errors out saying
ORA-04063 (See ORA-04063.ora-code.com): package body "SYS.DBMS_REGISTRY_SYS" has errors

I have already tried to run the utlrp.sql but that failed as well.. With


SELECT dbms_registry_sys.time_stamp('utlrp_bgn') as timestamp from dual;


ERROR at line 1:
ORA-04063 (See ORA-04063.ora-code.com): package body "SYS.DBMS_REGISTRY_SYS" has errors

Any help will be appreciated...

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>RE: Catupgrd.sql failing.. Any experience </TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2>Did you increase Java Pool and Shared Pool to match sizes
specified in the document?</FONT>
</P>

<P><FONT SIZE=2>--</FONT>
<BR><FONT SIZE=2>Mladen Gogala</FONT>
<BR><FONT SIZE=2>Ext. 121</FONT>
</P>

<P><FONT SIZE=2>-- --Original Message-- --</FONT>
<BR><FONT SIZE=2>From: Thakuria, Anjan [<A HREF="mailto:anjan.thakuria@(protected)"
>mailto:anjan.thakuria@(protected)</A>] </FONT>
<BR><FONT SIZE=2>Sent: Wednesday, September 21, 2005 11:10 AM</FONT>
<BR><FONT SIZE=2>To: oracle-l</FONT>
<BR><FONT SIZE=2>Subject: Catupgrd.sql failing.. Any experience </FONT>
</P>

<P><FONT SIZE=2>Hello all...</FONT>
</P>

<P><FONT SIZE=2>I am in the middle of a upgrade to 10.2.0.1 and the catupgrd
.sql is</FONT>
<BR><FONT SIZE=2>failing when it gets to </FONT>
</P>

<P><FONT SIZE=2>Cmpdbmig.sql part..</FONT>
</P>

<P><FONT SIZE=2>It errors out on the following stmt..</FONT>
</P>
<BR>

<P><FONT SIZE=2>cmpdbmig.sql</FONT>
<BR><FONT SIZE=2>and within that almost at the very beginning it does..</FONT>
<BR><FONT SIZE=2>SELECT dbms_registry_sys.dbupg_script('JAVAVM') AS dbmig_name
FROM DUAL;</FONT>
<BR><FONT SIZE=2>and errors out saying</FONT>
<BR><FONT SIZE=2>ORA-04063 (See ORA-04063.ora-code.com): package body &quot;SYS.DBMS_REGISTRY_SYS&quot; has
errors</FONT>
</P>

<P><FONT SIZE=2>I have already tried to run the utlrp.sql but that failed as
well.. With</FONT>
</P>
<BR>

<P><FONT SIZE=2>SELECT dbms_registry_sys.time_stamp('utlrp_bgn') as timestamp
from dual;</FONT>
</P>
<BR>

<P><FONT SIZE=2>ERROR at line 1:</FONT>
<BR><FONT SIZE=2>ORA-04063 (See ORA-04063.ora-code.com): package body &quot;SYS.DBMS_REGISTRY_SYS&quot; has
errors</FONT>
</P>

<P><FONT SIZE=2>Any help will be appreciated...</FONT>
</P>

<P><FONT SIZE=2>Anjan</FONT>
<BR><FONT SIZE=2>--</FONT>
<BR><FONT SIZE=2><A HREF="http://www.freelists.org/webpage/oracle-l" TARGET="
_blank">http://www.freelists.org/webpage/oracle-l</A></FONT>
</P>

</BODY>
</HTML>