Re: Invalid objects

From: Brian Rasmusson <br_at_belle.dk>
Date: 1997/10/07
Message-ID: <343A3734.58D44172@belle.dk>#1/1

Hi,

> I just finished building a database. After checking for invalid
> objects I found dbms that DBMS_SNAPSHOT is invalid.
> Looked it up it said that dbmssnap.sql and prvtsnap.plb have to
> be run.
> I did so and got more errors. That I decided to rerun catalog.sql
> + catdbsyn.sql
> hoping to get rid of errors alas I got even more invalid objects.

I had exactly the same problem. It is a known bug, here is the solution:

Article-ID:         <PrSol:2077468.6>
For-Problem:        <Pr:1030033.6>
Subject:            YOU HAVE HIT BUG 389795, SIMPLE WORKAROUND AVAILABLE
Circulation:         ** PUBLIC **

Affected-Platforms:       - Generic: not platform specific

Affected-Products: Oracle Server - Enterprise Edition V7

Solution Description:

---

You have encountered Bug 389795. You need to verify your resources and recompile the package.

Solution Explanation:

---

This is bug 389795. The issue exists in version 7.2.X and 7.3.X.The bug is currently being resolved.

Check the value of the shared_pool_size parameter.

Often having a shared_pool_size of 10M or lower can cause this. Shared_pool_size should be 30M or higher in a replicated environment. A simple workaround will solve the problem.

Please do the following:

svrmgr> CONNECT INTERNAL
svrmgr> ALTER PACKAGE DBMS_SNAPSHOT COMPILE BODY;

The you should rerun the above query again to check for INVALID objects. All objects should be VALID prior to configuring the replicated environment.

Hope it helped.

Brian

--
------------------------------------------------------------------------
Brian Rasmusson, Software engineer & analyst     e-mail: brianr_at_belle.dk
Belle Systems A/S                                web   : www.belle.dk
Network, Internet and communication specialists  phone : +45 59442500
------------------------------------------------------------------------

Received on Tue Oct 07 1997 - 00:00:00 CDT