OraFAQ Forum: Server Administration » Invalid Packages After Restarting Instance

Home » RDBMS Server » Server Administration » Invalid Packages After Restarting Instance (oracle 9.2.0.5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Invalid Packages After Restarting Instance [message #314089]

Tue, 15 April 2008 15:20

azeem87
Messages: 116
Registered: September 2005
Location: dallas

Senior Member

Hi,

We got a error message shared pool out of memory for the TEST datbase
and DBA did change the parameter and has restarted the DB Instance,
But as a result few packages got Invalid,
The Question is since it was a Valid Functional Database, Testing team was using it
after restart the code is Invalid, does restarting a instance with Normal method also invalidates some Code.

It's on 9i rel 2.

Thanks

[Updated on: Tue, 15 April 2008 15:23]

Report message to a moderator

Re: Invalid Packages After Restarting Instance [message #314092 is a reply to message #314089]

Tue, 15 April 2008 15:25

Michel Cadot
Messages: 68676
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Starting a database does not validate or invalidate procedures.

Regards
Michel

Report message to a moderator

Re: Invalid Packages are Restarting Instance [message #314094 is a reply to message #314089]

Tue, 15 April 2008 15:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>We got a error message shared pool out of memory for the TEST datbase

Are we supposed to guess the specific error?

>and DBA did change the parameter and has restarted the DB Instance,

Are we supposed to guess what was changed?

>after restart the code is Invalid, does restarting a instance with Normal method also invalidates some Code.

The answer is a definite, maybe or it depends.

Typically invalid packages get automagically recompiled when touched.

Report message to a moderator

Re: Invalid Packages are Restarting Instance [message #314099 is a reply to message #314094]

Tue, 15 April 2008 15:33

azeem87
Messages: 116
Registered: September 2005
Location: dallas

Senior Member

Thanks for Quick response,
Here is the answer's for Anacedent Qst

Quote:

[Exception: ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","unknown object","library cache","kkslpkp - literal info.")
]

SGA and Shared pool were changed.

Thanks All, but as i said before no body knows the Owner password to compile the code, DBA just restarted and handed over, So the mystery is then how did 8 packages out of 40 got invalid.

Thanks

[Updated on: Wed, 16 April 2008 00:48] by Moderator

Report message to a moderator

Re: Invalid Packages After Restarting Instance [message #314108 is a reply to message #314089]

Tue, 15 April 2008 15:46

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

ALTER OWNER.PACKAGE PACKAGE COMPILE;

Report message to a moderator

Previous Topic:	Automatic Shared Memory Management - Configuration
Next Topic:	Starting and Stopping Database using a script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 09 17:50:30 CDT 2024