ora-22923 after 11.1.0.7 upgrade
- From: Kumar Madduri <ksmadduri@xxxxxxxxx>
- To: oracle Freelists <Oracle-L@xxxxxxxxxxxxx>
- Date: Fri, 20 Nov 2009 00:23:15 -0800
We are seeing those errors after the 11.1.0.7 upgrade. This happens for both
custom and standard objects.
So we enabled trace for the event 22923 and and one of the things I noticed
in the trace apart from the plsql stack which I dont understand is this
peshmmps_Open_And_Map_Shm_Object:
Object_Name = /PESHM_EXT_388_OF2_DEV_39
Object_Size = 266208
Access_Flags = 2
Creation_Disposition = 0
Creation_Mode = 504
Map_Protection = 7
Shared_Memory_Object = 1
Op Name = shm_open failed
Location = peshmops_Ope
Error Number = 2
error message:No such file or directory
*** 2009-11-19 22:27:12.097
----- Error Stack Dump -----
ORA-22923: amount of data specified in streaming LOB write is 0
shm_unlink failed with error 2
error message:No such file or directory
Is there anyway to find out what file it is trying to read or complain
about?
Thank you
Kumar
Other related posts:
- » ora-22923 after 11.1.0.7 upgrade - Kumar Madduri
