Oracle-L: RE: Oracle Error ORA-07445 on InterText

From: NEU <neu_at_25by8.com>
Date: Mon, 14 Apr 2003 08:23:51 -0800
Message-ID: <F001.00580771.20030414082351@fatcity.com>

Hi Guys,

Our Oracle 9.0.1 on SUN Solaris 5.8 does a core dump and hangs (cannot log on via sqlplus and have to kill process). The alert log on bdump has this entry:

Mon Apr 14 18:07:25 2003
found dead shared server 'S001', pid = (9, 6) Mon Apr 14 18:07:38 2003
Errors in file
/opt/app/oracle/product/9.0.1/admin/secdb/bdump/secdb_s003_2505.trc: ORA-07445: exception encountered: core dump [kghalf()+604] [SIGSEGV] [Address not mapped to object] [0xFFFFFFF8] [][]

The trace file entry is this:

Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production With the Partitioning option
JServer Release 9.0.1.0.0 - Production
ORACLE_HOME = /opt/app/oracle/product/9.0.1 System name: SunOS

Node name:      secora1
Release:        5.8
Version:        Generic_108528-13
Machine:        sun4u

Instance name: secdb
Redo thread mounted by this instance: 1
Oracle process number: 11
Unix process pid: 2505, image: oracle_at_secora1 (S003)

2003-04-14 18:07:38.380
SESSION ID:(335.6) 2003-04-14 18:07:38.286 Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0xfffffff8, PC: [0x1544f64, kghalf()+ 604]
2003-04-14 18:07:38.406 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [kghalf()+604] [SIGSEGV] [Address not mapped to object] [0xFFFFFFF8] [] [] Current SQL statement for this session: SELECT DISTINCT nam_enty_long FROM tb_entity WHERE (statusid<>5 or statusid<>7) AND ( CONTAINS(nam_enty_long, 'VISION') > 0) ORDER BY nam_enty_long ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- --------------------
ksedmp()+256 CALL ksedst()+0 229A508 ? 229A4E4 ? C
? 0 ?
FFBEB004 ? 229A400 ? ssexhd()+488 CALL ksedmp()+0 2480C00 ? 1 ? C ? FFBEB52C ? 1 ? 7 ? sigacthandler()+40 PTR_CALL 00000000 B ? FFBEBC08 ? FFBEB950 ? FF1BA008 ? 0 ? 0 ? kghalf()+604 PTR_CALL 00000000 B ? FFBEBC08 ? FFBEB950 ? 841A4E10 ? 0 ? 0 ? kghubatchalloc()+11 CALL kghalf()+0 0 ? 259A9F8 ? 400 ? 0 ? 2 246D2A8 ? 23D6A1C ? kghualloc()+712 CALL kghubatchalloc()+0 247E5C8 ? 259A9E8 ? 20 ? 23D6A1C ? 0 ? C4204A90 ? kohalmc()+180 CALL kghualloc()+0 247E5C8 ? 259A9E8 ? 10 ? 0 ? 23D6A1C ? 8 ? kohalc()+88 CALL kohalmc()+0 83A583E8 ? C ? E ? 0 ? 23D6A1C ? 0 ? kpmalloc()+1580 CALL kohalc()+0 247E5C8 ? C ? E ? 0 ? 23D6A1C ? 0 ? drumcri()+332 CALL OCIMemoryAlloc()+0 C42048A0 ? C4204A90 ? FFBEC144 ? E ? C ? 0 ? drexuinit()+280 PTR_CALL 00000000 2585090 ? 4 ? 244F350
? 0 ?
7 ? C4204A90 ? drexrclose()+68 CALL drexuinit()+0 C42050AC ? 2585090 ? 1 ? 841A4E10 ? 0 ? 0 ? qeroifcc()+368 PTR_CALL 00000000 C42050AC ? C41DDC4C ? C41DDC08 ? C41DDA4C ? C41DDA08 ? 247E400 ? qeroifcsu()+336 PTR_CALL 00000000 841A4D7C ? 0 ? 800000
? 0 ?
0 ? 0 ?

Any ideas? It seems that there is a problem with the shared server when returning a fragment of the resultset.

Here are some of the values in my pfile.

###########################################

# Cache and I/O

###########################################

db_block_size=8192
db_cache_size=128M

###########################################

# Cursors and Library Cache

###########################################

open_cursors=600

###########################################

# Pools

###########################################

java_pool_size=67108864
large_pool_size=20971520
shared_pool_size=1024M
shared_servers=4
max_shared_servers=100

###########################################

# Processes and Sessions

###########################################

processes=800

###########################################

# Redo Log and Recovery

###########################################

fast_start_mttr_target=300

###########################################

# Sort, Hash Joins, Bitmap Indexes

###########################################

sort_area_size=524288

###########################################

# System Managed Undo and Rollback Segments

###########################################

max_dispatchers=100

session_cached_cursors=400

Any feedback would be greatly appreciated.

Cheers!
Norwen

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: NEU
  INET: neu_at_25by8.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Apr 14 2003 - 11:23:51 CDT