- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle problem after pushing software with Ignite ...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-05-2003 02:02 PM
тАО03-05-2003 02:02 PM
Oracle problem after pushing software with Ignite 4.1.62
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-05-2003 02:53 PM
тАО03-05-2003 02:53 PM
Re: Oracle problem after pushing software with Ignite 4.1.62
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-05-2003 02:59 PM
тАО03-05-2003 02:59 PM
Re: Oracle problem after pushing software with Ignite 4.1.62
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-06-2003 08:09 AM
тАО03-06-2003 08:09 AM
Re: Oracle problem after pushing software with Ignite 4.1.62
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-06-2003 08:19 AM
тАО03-06-2003 08:19 AM
Re: Oracle problem after pushing software with Ignite 4.1.62
Thanx for the info, real help for the Forumers