Home » SQL & PL/SQL » SQL & PL/SQL » Cause of Invalid package (Oracle , 9.2.0.8)
| Cause of Invalid package [message #546677] |
Thu, 08 March 2012 02:04  |
 |
savugar
Messages: 33
Registered: February 2012
|
Member |
|
|
Hi,
There are 4 packages got invalid 2 days back. when I analyze the database I came to know that there are 5 tables got truncated and 2 tables got altered during the issue period through the code. Those truncated tables have the indirect relationship with these 4 packages.but there is no any relation between these packages and altered table.
Also during that time I got the below error in my alert log.I am sure the cause this error is the invalid packages.
ORA-00600: internal error code, arguments: [kkxprpic8], [], [], [], [], [], [], []
I know if any alteration happens in a table, the refrence package will be getting as invalid. Apart from this, is there anyother cause to bring the package into invalid status?
How to proceed further to find the root cause of thses invalid package?
|
|
|
|
|
|
| Re: Cause of Invalid package [message #546685 is a reply to message #546680] |
Thu, 08 March 2012 02:27  |
|
savugar
Messages: 33
Registered: February 2012
|
Member |
|
|
Thanks Michel. I checked the metalink note 549637.1 for this error. It is clearly saying that we will be facing this error when a statement is trying to access an INVALID object.
Also I found the below information from the trace file. from this we can understand that, oracle is throwing this ora 600 error while it is refering invalid packages.
I am sure the cause this error is the invalid packages mentioned in the trace file.Also I found these packages as invalid status during the issue period. Pls correct me If I am wrong in anything.
I dont know how these packages went to invalid status.
LIBRARY OBJECT LOCK: lock=59f82ff8 handle=4eb88f54 mode=N
call pin=502CB108 session pin=00000000
htl=59F83034[5A730344,5A75D4A8] htb=5A730344
user=4b5be918 session=4b5be918 count=1 flags=PNC/[04] savepoint=741055
LIBRARY OBJECT HANDLE: handle=4eb88f54
name=FAST_USER.PKG_JEOPARDY_V2
hash=3b6ba8ae timestamp=02-10-2012 19:09:06
namespace=BODY/TYBD flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0031-00bf lock=X pin=S latch#=2
lwt=4EB88F6C[4EB88F6C,4EB88F6C] ltm=4EB88F74[4EB88F74,4EB88F74]
pwt=4EB88F84[56746598,56746598] ptm=4EB88FDC[4EB88FDC,4EB88FDC]
ref=4EB88F5C[4EB88F5C, 4EB88F5C] lnd=4EB88FE8[4EB88FE8,4EB88FE8]
LIBRARY OBJECT: object=51b1f240
type=PKBD flags=EXS/LOC[0005] pflags=NST/DBG [03] status=INVL load=0
DEPENDENCIES: count=41 size=48
LIBRARY OBJECT LOCK: lock=520296b4 handle=4d74d3cc mode=N
call pin=5411409C session pin=00000000
htl=520296F0[4CF92E40,5A72FE04] htb=5A72FE04
user=4b5be918 session=4b5be918 count=1 flags=[00] savepoint=740665
LIBRARY OBJECT HANDLE: handle=4d74d3cc
name=FAST_USER.PKG_FS_TIMELINE
hash=9047b206 timestamp=02-29-2012 08:51:02
namespace=BODY/TYBD flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0031-00bf lock=X pin=S latch#=5
lwt=4D74D3E4[4D74D3E4,4D74D3E4] ltm=4D74D3EC[4D74D3EC,4D74D3EC]
pwt=4D74D3FC[5A23622C,54C60ECC] ptm=4D74D454[4D74D454,4D74D454]
ref=4D74D3D4[4D74D3D4, 4D74D3D4] lnd=4D74D460[4D74D460,4D74D460]
LIBRARY OBJECT: object=5a0e63c4
type=PKBD flags=EXS/LOC[0005] pflags=NST/DBG [03] status=INVL load=0
DEPENDENCIES: count=26 size=32
LIBRARY OBJECT LOCK: lock=4fd703f8 handle=4e26d088 mode=N
call pin=570A5918 session pin=00000000
htl=4FD70434[4CF6A138,5A7301EC] htb=5A7301EC
user=4b5be918 session=4b5be918 count=1 flags=PNC/[04] savepoint=465130
LIBRARY OBJECT HANDLE: handle=4e26d088
name=FAST_USER.PKG_TIMELINE_V2
hash=7b550583 timestamp=02-29-2012 08:50:57
namespace=BODY/TYBD flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0031-00bf lock=X pin=S latch#=3
lwt=4E26D0A0[528DE0B8,57E67B40] ltm=4E26D0A8[4E26D0A8,4E26D0A8]
pwt=4E26D0B8[4FD4E384,5811EDD0] ptm=4E26D110[4E26D110,4E26D110]
ref=4E26D090[4E26D090, 4E26D090] lnd=4E26D11C[4E26D11C,4E26D11C]
LIBRARY OBJECT: object=5b295b4c
type=PKBD flags=EXS/LOC[0005] pflags=NST/DBG [03] status=INVL load=0
DEPENDENCIES: count=42 size=48
LIBRARY OBJECT LOCK: lock=51d939bc handle=4d0afb90 mode=N
call pin=4CFDDCB4 session pin=00000000
htl=51D939F8[5A72FFB4,54A89364] htb=5A72FFB4
user=4b5be918 session=4b5be918 count=1 flags=PNC/[04] savepoint=145
LIBRARY OBJECT HANDLE: handle=4d0afb90
name=FAST_USER.PKG_FS_COSMOSS
hash=7faae83c timestamp=02-10-2012 19:00:25
namespace=BODY/TYBD flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0011-00bf lock=X pin=S latch#=3
lwt=4D0AFBA8[4D0AFBA8,4D0AFBA8] ltm=4D0AFBB0[4F60689C,51443A74]
pwt=4D0AFBC0[4CE479A0,4CE479A0] ptm=4D0AFC18[4D0AFC18,4D0AFC18]
ref=4D0AFB98[4D0AFB98, 4D0AFB98] lnd=4D0AFC24[4D0AFC24,4D0AFC24]
LIBRARY OBJECT: object=55621204
type=PKBD flags=EXS/LOC[0005] pflags=NST/DBG [03] status=INVL load=0
DEPENDENCIES: count=31 size=32
[Updated on: Thu, 08 March 2012 02:29] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Cause of Invalid package [message #546880 is a reply to message #546711] |
Fri, 09 March 2012 10:23 |
|
savugar
Messages: 33
Registered: February 2012
|
Member |
|
|
I just want to explain what had happened on that day. So that you can help me on this.
There is an application is using the gateway to process the orders. On that day the gateway got hanged up. The application team restarted the gateway.After
restarting the gateway the flags were not populated. When they checked the database they found that there were some invalid packages used for this gateway.Also they found the below ora-00600 in the alert log.
They tried to compile the packages. but they got failed out. Then they restarted the database server(windows). After that the issue was resolved.
I feel the root cause of this issue is the LOCK on some tables. Because there are many updates firing on some tables frequently. the gateway got hanged up because of the locks. Also the issue was cleared only after restarting the server. Also they are facing dead lock issue many times. But during the issue period there were no deadlocks.
yesterday also they faced the same issue. Some packages were in invalid status. same ora-600 error. After restarting the server the issue was cleared.
So somewhat I can confidently say here the root cause of the issue is LOCK.What is your openion?
But still I dont know how some packages went into invalid status? There were no change happened in database.
Can we relate anything here for the cause of invalid package?
I need your valuable input here. Pls help me. it is putting high pressure on me.
Error occured during the issue period.
Error 1:(occured more than 50 times)
=======
ORA-00600: internal error code, arguments: [kkxprpic8], [], [], [], [], [], [], []
Error 2:(occured only 1 time)
========
Fri Mar 02 08:42:20 2012
Errors in file i:\oraadmin\fastserv\udump\fastserv_j000_7976.trc:
ORA-12012: error on auto execute of job 21
ORA-04021: timeout occurred while waiting to lock object FAST_USER.PKG_FS_COSMOSS
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1 [Updated on: Fri, 09 March 2012 10:26] Report message to a moderator |
|
|
|
|
|
Goto Forum:
Current Time: Mon Sep 08 06:38:56 CDT 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
