Home » RDBMS Server » Server Administration » version upgrade and utlrp.sql
version upgrade and utlrp.sql [message #185174] Mon, 31 July 2006 06:48 Go to next message
ziggy25
Messages: 206
Registered: July 2005
Senior Member
Just upgraded from 9.2.0.5.0 to 9.2.0.7.0

The upgrade went well but one of the final parts of the patch is to run utlrp.sql to compile any invalids, when i run utlrp.sql it gave this error.


PL/SQL procedure successfully completed.
DECLARE
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel


I have checked all the packages and they were compiled successfully so i cant figure out why this error was raised.

Anyone have any ideas? Is it safe to ignore the error if all packages are valid?

thanks
Re: version upgrade and utlrp.sql [message #185183 is a reply to message #185174] Mon, 31 July 2006 07:32 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Are there any errors logged in the alert log?
Re: version upgrade and utlrp.sql [message #185186 is a reply to message #185174] Mon, 31 July 2006 07:49 Go to previous messageGo to next message
ziggy25
Messages: 206
Registered: July 2005
Senior Member
hi,

No there were no errors in the alert log

--
Re: version upgrade and utlrp.sql [message #185187 is a reply to message #185174] Mon, 31 July 2006 07:51 Go to previous messageGo to next message
ziggy25
Messages: 206
Registered: July 2005
Senior Member
This is in the alert log. Not sure if they are as a result of the upgrade.


Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Sat Jul 29 18:11:01 2006
Errors in file /oracle/syn/ccs/ccsora/admin/ccs/udump/ccs_ora_17264.trc:
ORA-07445: exception encountered: core dump [qmeGetResInternal()+512] [SIGSEGV] [Address not mapped to object] [0x0] [] []
Sat Jul 29 18:12:40 2006
Errors in file /oracle/syn/ccs/ccsora/admin/ccs/udump/ccs_ora_17503.trc:
ORA-07445: exception encountered: core dump [qmeGetResInternal()+512] [SIGSEGV] [Address not mapped to object] [0x0] [] []
Sat Jul 29 18:17:13 2006
Errors in file /oracle/syn/ccs/ccsora/admin/ccs/udump/ccs_ora_17723.trc:
ORA-07445: exception encountered: core dump [qmeGetResInternal()+512] [SIGSEGV] [Address not mapped to object] [0x0] [] []

Re: version upgrade and utlrp.sql [message #185194 is a reply to message #185174] Mon, 31 July 2006 08:07 Go to previous messageGo to next message
ziggy25
Messages: 206
Registered: July 2005
Senior Member
The trace files seem to be pointing to this query..

select 1
      from resource_view 
      where any_path = '/xdbconfig.xml'
Re: version upgrade and utlrp.sql [message #185200 is a reply to message #185174] Mon, 31 July 2006 08:30 Go to previous messageGo to next message
ziggy25
Messages: 206
Registered: July 2005
Senior Member
We dont really use any of they xml features so i dont understand the above error.
Re: version upgrade and utlrp.sql [message #185210 is a reply to message #185174] Mon, 31 July 2006 09:59 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
In some cases its says to
STARTUP UPGRADE
before invoking utlrp
Previous Topic: Problem in Starting Database
Next Topic: how to create tablespace
Goto Forum:
  


Current Time: Thu Dec 12 09:14:35 CST 2024