Hi,
We recently upgraded to Oracle 7.3.2 version on NCR unix and facing
problems with respect to SQL*PLUS connections. Suddenly the SQL*PLUS
connections take longer time to connect and after some time, system almost
hangs by creating Core files for each of these connection. The error in alert
log file shows as follws.
- Fri
May 7 15:27:41 1999 Thread 1 advanced to log sequence 502 Current log# 1
seq# 502 mem# 0: /rel3db/dbs/redo1.dbf Fri May 7 15:27:57 1999 Errors in
file /o732/app/oracle/product/732/rdbms/log/ora_tcr3_22466.trc: ORA-00600:
internal error code, arguments: [17113], [0], [], [], [], [], [], [] Fri May
7 15:27:57 1999 Errors in file
/o732/app/oracle/product/732/rdbms/log/ora_tcr3_22466.trc: ORA-07445:
exception encountered: core dump [SIGSEGV] [Address not mapped to obj ect]
[2147741720] [] [] [] ORA-00600: internal error code, arguments: [17113],
[0], [], [], [], [], [], [] Fri May 7 15:29:50 1999
Once we shutdown and start the database it seems to be working fine. Does any
one has similar experience, please share your views.
The above mentioned trace file shows the following message.
Dump file /o732/app/oracle/product/732/rdbms/log/ora_tcr3_22466.trc
Oracle7 Server Release 7.3.2.1.0 - Production Release
With the distributed, replication and parallel query options
PL/SQL Release 2.3.2.0.0 - Production
ORACLE_HOME = /o732/app/oracle/product/732
System name: tc4hq
Node name: tc4hq
Release: 4.0
Version: 3.0
Machine: 4850
Instance name: tcr3
Redo thread mounted by this instance: 1
Oracle process number: 0
Unix process pid: 22466, image: ora_s008_tcr3
- Internal heap ERROR 17113 addr=0x0 *********
****************************************************** HEAP DUMP heap name=""
desc=0x0 extent sz=0x0 alt=0 het=0 rec=0 flg=0 opc=0 parent=0 owner=0
nex=0 xsz=0x0 Hla: 0 Fri May 7 15:27:57 1999 ksedmp: internal or fatal
error ORA-00600: internal error code, arguments: [17113], [0], [], [], [],
[], [], [] Current SQL information unavailable - no session. ----- Call Stack
Trace ----- Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to
object), addr: 0x 8003f018 ORA-07445: exception encountered: core dump
[SIGSEGV] [Address not mapped to obj ect] [2147741720] [] [] [] ORA-00600:
internal error code, arguments: [17113], [0], [], [], [], [], [], [] -----
Call Stack Trace -----
Thanks in advance
Sujatha
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sat May 08 1999 - 01:25:33 CDT