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

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: Mon, 14 Apr 2003 10:48:59 -0800
Message-ID: <F001.00580A5D.20030414104859@fatcity.com>

No idea about the actual problem, but please, please, PLEASE upgrade to at least 9.0.1.3. It appears you're on 9.0.1.0, which has a wee small security problem due to outer joins and ANSI syntax. IIRC, the 9.0.1.3 patch includes the fix - Connor will no doubt correct me if I'm wrong! :)

Pete

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

"Oh no, it's not. It's much harder than that!"

Bruce Pihlamae, long-term Oracle DBA

-----Original Message-----
Sent: Monday, April 14, 2003 9:24 AM
To: Multiple recipients of list ORACLE-L

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: Pete Sharman
  INET: peter.sharman_at_oracle.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 - 13:48:59 CDT