Links
• Home
• 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
core dumps

core dumps

2005-10-24       - By raja rao

Reply:     1     2     3     4     5  

when we are trying to perofrm inserts (parallelly 6 jobs),
out of theose, 2 jobs are getting succeeded. and rest 4 are failing
and we are getting a trace file (as well core file)
trace output is like this:
Redo thread mounted by this instance: 1
Oracle process number: 22
Unix process pid: 11366, image: oracle@(protected) (TNS V1-V3)
*** 2005-10-23 06:53:38.653
*** SESSION ID:(49.46806) 2005-10-23 06:53:38.648
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr:
0xffffffff7bf00000, PC: [0x100602000, 0000000100
602000]
*** 2005-10-23 06:53:38.658
ksedmp: internal or fatal error
ORA-07445 (See ORA-07445.ora-code.com): exception encountered: core dump [0000000100602000] [SIGSEGV]
[Address not mapped to object] [0xFFFFFFFF7BF00000] [
] []
Current SQL statement for this session:
INSERT INTO ifdata
   SELECT
      rpad('B230', 4),                                        /*   Record Type
 */
      rpad(item_id, iffun.get_sysparmlength(519)),            /*   Part Number
*/
      rpad('RepCsgn', iffun.get_sysparmlength(500)) ||        /*   Schedule
Type AbbreviationID */
      rpad(location, iffun.get_sysparmlength(513)) ||     /*   Location  */
      rpad(' ', iffun.get_sysparmlength(511))      ||         /*   Detail Key
*/
      to_char(sysdate,'YYYYMMDD')         ||                    /*   Period  
*/
      rpad('O', 1)                                 ||         /*   Increment
/Override  */
      rpad(on_hold_qty, 10)                               /*   Quantity */
   FROM gemed_prt_qty
   WHERE item_id in (select partnum from GEMED_B100_ITEM WHERE repairable = 'Y
')
-- -- PL/SQL Call Stack -- --
 object      line  object
 handle    number  name
3a1d6c690      2511  package body IFGEMED.GEMED_PLAN_PROC
3a12ea2d8         5  anonymous block
3a1d92518      1120  package body SYS.DBMS_SYS_SQL
3a1da46a0       323  package body SYS.DBMS_SQL
3a1e708f8       712  package body IFGEMED.IFRUN
3a1e708f8       566  package body IFGEMED.IFRUN
3a1e3abb0         1  anonymous block
-- -- Call Stack Trace -- --
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-- ---- ---- ---- -- -- ----- -- ---- ---- ---- -- -- ---- ---- ---- ---- -----
ksedmp()+328         CALL     ksedst()+0           00000000B ? 000000000 ?
                                                  000000000 ? 00000004A ?
                                                  FFFFFFFF7FFEEB78 ?
BD11EFBF:000027D2    77     0 10280   1 0x000000000000004D
BD19F30C:000027D3    77     0 10280   1 0x000000000000004D
KSTDUMP: End of in-memory trace dump
ssexhd: crashing the process...
Shadow_Core_Dump = PARTIAL
~
~
can someone throw some light on this, why we are getting the core when running
6 parallel inserts.
Thanks and regards,
Raj

   
-- ---- ---- ---- ---- ---- -----
Yahoo! FareChase - Search multiple travel sites in one click.  
<DIV>when we are trying to perofrm inserts (parallelly 6 jobs),<BR>out of
theose, 2 jobs are getting succeeded. and rest 4 are failing<BR>and we are
getting a trace file (as well core file)</DIV>
<DIV>trace output is like this:</DIV>
<DIV>Redo thread mounted by this instance: 1<BR>Oracle process number: 22<BR
>Unix process pid: 11366, image: <A href="mailto:oracle@(protected)">oracle@(protected)</A
> (TNS V1-V3)</DIV>
<DIV>*** 2005-10-23 06:53:38.653<BR>*** SESSION ID:(49.46806) 2005-10-23 06:53
:38.648<BR>Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object
), addr: 0xffffffff7bf00000, PC: [0x100602000, 0000000100<BR>602000]<BR>*** 2005
-10-23 06:53:38.658<BR>ksedmp: internal or fatal error<BR>ORA-07445 (See ORA-07445.ora-code.com): exception
encountered: core dump [0000000100602000] [SIGSEGV] [Address not mapped to
object] [0xFFFFFFFF7BF00000] [<BR>] []<BR>Current SQL statement for this
session:<BR>INSERT INTO ifdata<BR>&nbsp;&nbsp;&nbsp; SELECT<BR>&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp; rpad('B230', 4),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /*&nbsp;&nbsp; Record Type&nbsp; */
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rpad(item_id,
iffun.get_sysparmlength(519)),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; /*&nbsp;&nbsp; Part Number */<BR>&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp; rpad('RepCsgn', iffun.get_sysparmlength(500)) ||&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp; /*&nbsp;&nbsp; Schedule Type AbbreviationID */<BR>&nbsp
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rpad(location, iffun.get_sysparmlength(513)) ||
&nbsp;&nbsp;&nbsp;&nbsp; /*&nbsp;&nbsp; Location&nbsp; */<BR>&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; rpad(' ', iffun.get_sysparmlength(511))&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp; ||&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /*&nbsp;&nbsp;
Detail Key&nbsp; */<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; to_char(sysdate,
'YYYYMMDD')&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ||&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; /*&nbsp;&nbsp; Period&nbsp;&nbsp; */<BR>&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; rpad('O',
1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ||&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp
;&nbsp;&nbsp; /*&nbsp;&nbsp; Increment/Override&nbsp; */<BR>&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; rpad(on_hold_qty, 10)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /*&nbsp;&nbsp
; Quantity */<BR>&nbsp;&nbsp;&nbsp; FROM gemed_prt_qty<BR>&nbsp;&nbsp;&nbsp;
WHERE item_id in (select partnum from GEMED_B100_ITEM WHERE repairable = 'Y')
<BR>-- -- PL/SQL Call Stack -- --<BR>&nbsp; object&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
line&nbsp; object<BR>&nbsp; handle&nbsp;&nbsp;&nbsp; number&nbsp; name<BR
>3a1d6c690&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2511&nbsp; package body
IFGEMED.GEMED_PLAN_PROC<BR>3a12ea2d8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp; 5&nbsp; anonymous block<BR>3a1d92518&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1120
&nbsp; package body SYS.DBMS_SYS_SQL<BR>3a1da46a0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp; 323&nbsp; package body SYS.DBMS_SQL<BR>3a1e708f8&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp; 712&nbsp; package body IFGEMED.IFRUN<BR>3a1e708f8&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; 566&nbsp; package body IFGEMED.IFRUN<BR>3a1e3abb0&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; anonymous block<BR>-- -- Call Stack
Trace -- --<BR>calling&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp; call&nbsp;&nbsp;&nbsp;&nbsp; entry&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
argument values in hex<BR>location&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; type&nbsp;&nbsp;&nbsp;&nbsp;
point&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; (? means dubious value)<BR>-- ---- ---- ---- -- -- ----- ----
-- ---- ---- --- -- ---- ---- ---- ---- -----<BR>ksedmp()+328&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CALL&nbsp;&nbsp;&nbsp;&nbsp; ksedst()+0&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 00000000B ? 000000000 ?
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
000000000 ? 00000004A
?<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
FFFFFFFF7FFEEB78 ?</DIV>
<DIV>BD11EFBF:000027D2&nbsp;&nbsp;&nbsp; 77&nbsp;&nbsp;&nbsp;&nbsp; 0 10280
&nbsp;&nbsp; 1 0x000000000000004D<BR>BD19F30C:000027D3&nbsp;&nbsp;&nbsp; 77&nbsp
;&nbsp;&nbsp;&nbsp; 0 10280&nbsp;&nbsp; 1 0x000000000000004D<BR>KSTDUMP: End of
in-memory trace dump<BR>ssexhd: crashing the process...<BR>Shadow_Core_Dump =
PARTIAL<BR>~<BR>~</DIV>
<DIV>can someone throw some light on this, why we are getting the core when
running<BR>6 parallel inserts.</DIV>
<DIV>Thanks and regards,<BR>Raj</DIV><p>
    <hr size=1> <a href="http://us.lrd.yahoo.com/_ylc
=X3oDMTFqODRtdXQ4BF9TAzMyOTc1MDIEX3MDOTY2ODgxNjkEcG9zAzEEc2VjA21haWwtZm9vdGVyBHN
sawNmYw--/SIG=110oav78o/**http%3a//farechase.yahoo.com/">Yahoo! FareChase -
Search multiple travel sites in one click.</a>