Oracle problem after pushing software with Ignite 4.1.62

[Steven E. Protter]

Finally pushed an ignite image including oracle server 8.1.7.4.0 from a working server to an Ignite client.

We relinked oracle.

We get a hang when we run utlrp.sql

No errors, to nothing. The database does not hang, and can be brought down or up. We need to run this utility as part of change word size from 32 to 64 bit(previously I posted this procedure).

Question: Anyone have problems with Oracle after pushing the the software with Ignite.

Any similar experience, stories, workarounds.

Stories and experience are worth 5-7 points. Workarounds get you a rabbit.

SEP

[James A. Donovan]

Found this on metalink. Involved a 9i upgrade, but it may lead to a resolution for ya.



Oracle Server-Enterprise and Standard Edition Technical Forum



Displayed below are the messages of the selected thread.


Thread Status: Closed

From: Som Vembar 28-Nov-01 21:09
Subject: utlrp.sql script hangs

RDBMS Version: 9i
Operating System and Version: NT Version 4 Service pack 5
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.):
Product Version:

utlrp.sql script hangs

Hi

I have migrated (running the u*.sql) the database from 8.1.7.2.5. to 9i. After migration, I saw few pl/sql objects and java classes as INVALID. So, I started off running utlrp.sql script. Its 4 hours and still running. The CPU shows 50% usage and memmry also shows some significant usage.

Any reason why? Running the script as SYS connected as SYSDBA

The database size is 400MB

Thanks and Regards

Som Vembar






--------------------------------------------------------------------------------

From: Mark Powell 28-Nov-01 21:26
Subject: Re : utlrp.sql script hangs


Just curious as we run the script all the time in 8i and previously in 8.0. -- Mark --





--------------------------------------------------------------------------------

From: Som Vembar 29-Nov-01 14:30
Subject: Re : utlrp.sql script hangs


Thats righht.. it just used to take 15-20 minutes in 816/817. It is close to 24 hours now.. and still running.

I can see activity in V4SQLAREA...





--------------------------------------------------------------------------------

From: Oracle, Ken Robinson 03-Dec-01 06:02
Subject: Re : utlrp.sql script hangs


This problem is reported in an internal bug 2120478. Development agreed in enhancement request 1810131 that a parallel version of this script needs to be made available. From 1810131,

"The new file is called utlrcmp.sql--contains a utility package that supports parallel recompilation of invalid database objects (typically, for objects invalidated after a database upgrade)."

You can request the script through the iTAR process if necessary.



Regards,
Ken Robinson
Oracle Server EE Analyst


--------------------------------------------------------------------------------



--------------------------------------------------------------------------------

Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use.

[James A. Donovan]

Looks like utlrcmp.sql is included in patch 1888560

[Steven E. Protter]

This issue is closed.

As usual, Oracle support was just trying to deny us support. Let me make it clear, Oracle uses Ignite to back up their test HP-UX servers, they even use it to deploy software to multiple machines. Never admit to Oracle support that Ignite was involved, because they will probably read the party line, which is we only support fresh installs.

The problem was fixed by increasing redo space and implementing a few procedures noted in a problem with 64 bit Oracle databases hanging.

An oracle procedure that I've been posting to the forums will be revised and reposted when our dba is done marking up the document.

Thanks a bunch.

SEP

[Ravi_8]

Steven

Thanx for the info, real help for the Forumers