Home
All Oracle Error Codes
Oracle DBA Forum

Frequent Oracle Errors

TNS:could not resolve the connect identifier specified
Backtrace message unwound by exceptions
invalid identifier
PL/SQL compilation error
internal error
missing expression
table or view does not exist
end-of-file on communication channel
TNS:listener unknown in connect descriptor
insufficient privileges
PL/SQL: numeric or value error string
TNS:protocol adapter error
ORACLE not available
target host or object does not exist
invalid number
unable to allocate string bytes of shared memory
resource busy and acquire with NOWAIT specified
error occurred at recursive SQL level string
ORACLE initialization or shutdown in progress
archiver error. Connect internal only, until freed
snapshot too old
unable to extend temp segment by string in tablespace
Credential retrieval failed
missing or invalid option
invalid username/password; logon denied
unable to create INITIAL extent for segment
out of process memory when trying to allocate string bytes
shared memory realm does not exist
cannot insert NULL
TNS:unable to connect to destination
remote database not found ora-02019
exception encountered: core dump
inconsistent datatypes
no data found
TNS:operation timed out
PL/SQL: could not find program
existing state of packages has been discarded
maximum number of processes exceeded
error signaled in parallel query server
ORACLE instance terminated. Disconnection forced
TNS:packet writer failure
see ORA-12699
missing right parenthesis
name is already used by an existing object
cannot identify/lock data file
invalid file operation
quoted string not properly terminated

p5948242 - 10.2.0.3 patch 4 for MS Win32 - CPUApr2007 - ora-7445 [_kcbzww+329]

Paul Drake

2007-04-17

Replies:
Critical Patch Update for April 2007
p5948242 - 10.2.0.3 patch 4 for MS Win32

I'd think about holding off testing this patch for a few days (wait
for the re-issue).
SMON is taking down the database instance right after startup.
I'll post again if I see what the source of this is but for right now,
this is an opatch rollback and a restore.

ora-7445 lookup and call stack trace lookup are a swing and a miss.

Paul


Dump file d:\oracle\admin\mytest\bdump\mytest_smon_684.trc
Tue Apr 17 17:46:17 2007
ORACLE V10.2.0.3.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3


Oracle Database 10g Release 10.2.0.3.0 - Production
Process Id: 0x00000ffc Thread Id : 0x000002ac   Time : Tue Apr 17 17:46:17
Excp. Code: 0xc0000005 Excp. Type: ACCESS_VIO   Flags: 0x00000000


------------------- Registers ----------------------------
eip = 00498d45 esp = 065ca7c8 ebp = 065ca804 edi = c817d1ac esi = 065ccd50
eax = 6cdba610 ebx = 00000001 ecx = 900029d8 edx = 065ca7e4
ecs = 0000001b eds = 00000023 ees = 00000023 ess = 00000023
egs = 00000000 efs = 0000003b
eflags = 00010a86
------------------- End of Registers ---------------------


Oracle Database 10g Release 10.2.0.3.0 - Production
Windows NT Version V5.2 Service Pack 1
CPU           : 4 - type 586, 2 Physical Cores
Process Affinity   : 0x00000000
Memory (Avail/Total): Ph:6552M/8191M, Ph+PgF:10589M/12076M, VA:1145M/3071M
Instance name: mytest

Redo thread mounted by this instance: 1

Oracle process number: 16

Windows thread id: 684, image: ORACLE.EXE (SMON)


*** SERVICE NAME:() 2007-04-17 17:46:17.458
*** SESSION ID:(51.1) 2007-04-17 17:46:17.458
*** 2007-04-17 17:46:17.458
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION]
[_kcbzww+329] [PC:0x498D45] [ADDR:0x70AFC188] [UNABLE_TO_READ] []
Current SQL statement for this session:
select o.owner#,o.obj#,decode(o.linkname,null,
decode(u.name,null,'SYS',u.name),o.remoteowner),
o.name,o.linkname,o.namespace,o.subname from user$ u, obj$ o where
u.user#(+)=o.owner# and o.type#=:1 and not exists (select p_obj# from
dependency$ where p_obj# = o.obj#) order by o.obj# for update
----- Call Stack Trace -----
calling         call   entry           argument values in hex
location         type   point           (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_kcbzww+329             00000000
_kcbzgb+4728      CALLrel _kcbzww+0        65CCD50
_kcbzib+437       CALLrel _kcbzgb+0
_kcbgtcr+9343     CALLrel _kcbzib+0
_ktrget+445       CALLrel _kcbgtcr+0
_kdifxs1+1879     CALLrel _ktrget+0        970B214 970B0E4 271
_kdifxs+17       CALLrel _kdifxs1+0       970B210 1 0 0 0 0
_qerixtFetch+257   CALLrel _kdifxs+0
_qertbFetchByRowID+ CALL??? 00000000         5A78BEE0 0 65CDB20 1
475
_qerjoFetch+491    CALL??? 00000000         5A78BCC4 0 0 1
_qerflFetchOutside+ CALL??? 00000000         5A755D50 0 0 1
93
_qerfuStart+351    CALL??? 00000000         5A755CD8 0 0 1
_selexe+1568      CALL??? 00000000         5A755C08 1
_opiexe+11440     CALLrel _selexe+0        5AFD24D4 65CE2D0 65CE298
_opiodr+1099      CALLreg 00000000         4 4 65CEC18
_rpidrus+178      CALLrel _opiodr+0        4 4 65CEC18 2
_rpidru+88       CALLrel _rpidrus+0       65CE7A4
_rpiswu2+426      CALLreg 00000000         65CEB6C
_rpidrv+1461      CALLrel _rpiswu2+0       90040490 0 65CEB40 2 65CEB60
                                 0 65CEB40 0 86401C 8640DC
                                 65CEB6C 8
_rpiexe+70       CALLrel _rpidrv+0        2 4 65CEC18 8
_kqlclo1+965      CALLrel _rpiexe+0        2
_kqlclo+155       CALLrel _kqlclo1+0
_ktmmon+5254      CALLrel _kqlclo+0
_ktmSmonMain+21    CALLrel _ktmmon+0        3D49C18
_ksbrdp+808       CALLreg 00000000         3D49C18
_opirip+674       CALLrel _ksbrdp+0
_opidrv+857       CALLrel _opirip+0        32 4 65CFEA8
_sou2o+45        CALLrel _opidrv+0        32 4 65CFEA8
_opimai_real+227   CALLrel _sou2o+0         65CFE9C 32 4 65CFEA8
_opimai+92       CALLrel _opimai_real+0     3 65CFED4
_BackgroundThreadSt CALLrel _opimai+0
art@(protected)
77E66088         CALLreg 00000000
--
http://www.freelists.org/webpage/oracle-l