Unable to clone RAC to non-RAC database ora-01003 no statement parsed

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem Description: Unable to clone RAC to non-RAC database ora-01003 no statement parsed

Clone the database gave the below error:

It errors ora-01003 error.

Solution:

Set

_no_recovery_through_resetlogs=TRUE

References:

Note 409045.1 - How To Clone From Rac To Non-Rac In Oracle Applications 11i. .
Note 334899.1 - RMAN Duplicate from RAC backup fails ORA-38856

Get Oracle Certifications for all Exams
Free Online Exams.com

ORA-00600: internal error code, arguments: [kgl_max_opr_exceeded]

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

### Detailed Problem Statement ###
ORA-00600: internal error code, arguments: [kgl_max_opr_exceeded],

PMON: terminating instance due to error 474
Tue Mar 31 00:33:51 2009
Errors in file sid_lms0_21814.trc:
ORA-00474: SMON process terminated with error
Tue Mar 31 00:33:51 2009
Errors in file sid_lmon_21782.trc:
ORA-00474: SMON process terminated with error
Tue Mar 31 00:33:51 2009
Errors in file sid_dbw0_21820.trc:
ORA-00474: SMON process terminated with error

ALERT LOG
-------------------

Tue Mar 31 00:33:41 2009
Errors in file /u01/ptyp/ptypdb/10.2.0/admin/PTYP2_pebpdb02/udump/ptyp2_ora_21976.trc:
ORA-00600: internal error code, arguments: [kgl_max_opr_exceeded], [], [], [], [], [], [], []


TRACE FILE
------------
sid_ora_21976.trc


Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORACLE_HOME =

System name: HP-UX
Node name:
Release: B.11.23
Version: U
Machine: 9000/800
Instance name:
Redo thread mounted by this instance: 2
Oracle process number: 0
Unix process pid: 21976, image: oracle@
*** SERVICE NAME:(PTYP) 2009-03-31 00:33:41.008
*** SESSION ID:(1423.10903) 2009-03-31 00:33:41.008
*** 2009-03-31 00:33:41.008
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kgl_max_opr_exceeded], [], [], [], [], [], [], []



STACK TRACE
------------
kglobf0 <- kglhpd_internal

----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
Error from U_get_previous_frame_x is 1
Stack is not Windable
Stack has no Unwind_descriptor
sdsnm: dlmodinfo failed for address : 0x40000000
ksedst()+40 ? ksedst1() 090072FFF ?
80000001000164D8 ?
80000001000164D8 ?
800000010012D388 ?
ksedmp()+168 ? ksedst() 80000001000164D8 ?
800000010012D388 ?
C0000001F0B55478 ?
4000000001B5446F ?
ksfdmp()+32 ? ksedmp() 80000001000164D8 ?
800000010013F6D8 ?
80000001000164D8 ?
00000000C ?
kgerinv()+152 ? ksfdmp() 80000001000164D8 ?
00000000C ?
4000000004E70BE7 ?
1700016098 ?
kgeasnmierr()+88 ? kgerinv() C0000001B8503080 ?
000000000 ?
C0000001FF92E798 ?
800000010012D388 ?
kglobf0()+992 ? kgeasnmierr() A9A00000000 ?
80000001000165B0 ?
4000000001AB89EB ?
000000000 ?
kglhpd_internal()+2 ? kglobf0() C000000100E0BB60 ?
92 4000000004E7368B ?
000000000 ?
800000010012D388 ?
0x0000000040000000 ? kglhpd_internal() 80000001000165B0 ?
C0000001B1D5DC98 ?
000000000 ?
4000000001B374F3 ?

--------------------- Binary Stack Dump ---------------------


SQL
-----
No current SQL statement being executed.


PROCESS STATE
---------------
user: 44/APPS
O/S info: user: applptyp, term: unknown, ospid: , machine: pebpap05.dubaiworld.ae
program: JDBC Thin Client
client info: 104 0
application name: JDBC Thin Client, hash value=0
last wait for 'SQL*Net message from client' blocking sess=0x0000000000000000 seq=46 wait_time=326 seconds since wait started=3
driver id=28444553, #bytes=1, =0
Dumping Session Wait History
for 'SQL*Net message from client' count=1 wait_time=326
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=2
driver id=28444553, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=53405
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=2
driver id=28444553, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=302
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=3
driver id=28444553, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=626
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=2
driver id=28444553, #bytes=1, =0
for 'SQL*Net message from client' count=1 wait_time=10639
driver id=28444553, #bytes=1, =0
for 'SQL*Net message to client' count=1 wait_time=3
driver id=28444553, #bytes=1, =0
temporary object counter: 0
----------------------------------------
******************** Session Cursor Dump **********************
Current cursor: 19, pgadep: 0
Open cursors(pls, sys, hwm, max): 19(13, 2, 64, 2500)
NULL 3 SYNTAX 0 PARSE 0 BOUND 16 FETCH 0 ROW 0
----------------------------------------
Cursor#19(800003ffbfdc1f78) state=NULL curiob=800003ffbfc2da80
curflg=44 fl2=0 par=0000000000000000 ses=c0000001fedbeee8
sqltxt(c0000001e752ad38)=SELECT SERVER_ID,TYPE_ID,MEMBER_SVR_GROUP_ID, DNS_NAME,IP_ADDRESS,LOCATION FROM IEO_SVR_SERVERS WHERE SERVER_NAME = :1
hash=befdfc91dcf1de63a98a59741d85d682
parent=c0000001e951d278 maxchild=02 plk=c0000001d8af18e0 ppn=n
cursor instantiation=800003ffbfc2da80 used=1238445218
child#0(c0000001e74fd758) pcs=c0000001e74fda88
clk=c0000001bfed4500 ci=c0000001b859aa38 pn=c0000001c96dc160 ctx=c0000001e949fd38
kgsccflg=0 llk[800003ffbfc2da88,800003ffbfc2da88] idx=0
xscflg=20028 fl2=0 fl3=2022000 fl4=0
Bind bytecodes
Frames pfr 0000000000000000 siz=0 efr 0000000000000000 siz=0
Cursor frame dump
enxt: 1.0x00000000
pnxt: 1.0x00000000
Session cached cursors
-----------------------------------------------------------

Solution:

If you see the call stack information in the trace file : -

Error from U_get_previous_frame_x is 1
Stack is not Windable
Stack has no Unwind_descriptor

Please refer the Note below : -

Article-ID: Note 73835.1
Circulation: PUBLISHED (EXTERNAL)
Folder: ST.Server.DBA.Admin
Topic: Archives
Title: ALERT:HP-UX: ORA-7445 and Core Dump Generating Oracle Stack Trace .

This patch is very, very old. Release date was: 1998/11/30
This patch is not appropriate for 11.23. 11.23 was released September 2003!

Please go back to Oracle and ask for more details and a fix for 11.23.

---------------------------------

This patch as per HP is for 11.00 Platform and we are having 11.23 release

Article-ID: Note 43507.1
Circulation: PUBLISHED (EXTERNAL)
Folder: ST.Platform.Unix.HPUX
Topic: Configuration
Title: HP-UX: Patch Levels Advised

Check with HP for details and do the needful.

Oracle must be relinked after applying this patch, as follows:
%cd $ORACLE_HOME/rdbms/lib
%make -f ins_rdbms.mk ioracle
The instance needs to be shutdown when relinking.

Get Oracle Certifications for all Exams
Free Online Exams.com

LGWR Posting Slow Write Times, Low IO Waits

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

/orasys/admin/bdump/ecs_lgwr_3492.trc:"
LGWR trace files;

ecs_lgwr_3492.trc

LGWR trace is filled up with the messages like:

*** 2011-05-29 08:14:52.315
Warning: log write time 650ms, size 36KB
*** 2011-05-29 08:14:55.507
Warning: log write time 1110ms, size 8KB
*** 2011-05-29 08:14:57.783
Warning: log write time 2270ms, size 39KB
*** 2011-05-29 08:14:58.810
Warning: log write time 1030ms, size 67KB
*** 2011-05-29 08:15:02.055
Warning: log write time 1730ms, size 79KB
*** 2011-05-29 08:15:04.723
Warning: log write time 2670ms, size 88KB
*** 2011-05-29 08:15:07.057
Warning: log write time 2340ms, size 63KB
*** 2011-05-29 08:15:08.414
Warning: log write time 1350ms, size 53KB
*** 2011-05-29 08:15:10.902
Warning: log write time 2490ms, size 65KB
*** 2011-05-29 08:15:13.763
Warning: log write time 2860ms, size 99KB
*** 2011-05-29 08:15:16.373
Warning: log write time 2590ms, size 103KB
*** 2011-05-29 08:15:17.908
Warning: log write time 1540ms, size 169KB

 Solution:

This message shows we have a very slow Log writing . We are seeing this is manifested in log file sync waits.
Please involve your storage admin to verify slow performance due to redo writing on the disk where redo log files are present.

Refer:
LGWR Is Generating Trace file with "Warning: Log Write Time 540ms, Size 5444kb" In 10.2.0.4 Database (Doc ID 601316.1)
High Log File Sync Wait Events, LGWR Posting Slow Write Times, Low IO Waits (Doc ID 1278149.1)


    

Get Oracle Certifications for all Exams
Free Online Exams.com

Getting ORA-07445: exception encountered: core dump [drurnew()+184] [SIGSEGV] when running Gather DB Statistics

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:


Problem Description: Getting ORA-07445: exception encountered: core dump [drurnew()+184] [SIGSEGV] when running Gather DB Statistics


Errors in file /orasys/admin/udump/addev_ora_730.trc:
ORA-07445: exception encountered: core dump [drurnew()+184] [SIGSEGV] [Address not mapped to object]
[0x000000040] [] []


Stack Trace: drurnew draccbi drexumcx drexostatscoll spefcpfa spefmccallstd peftrusted psdexsp rpiswu2 psdextp pefccal pefcal pevm_FCAL pfrinstr_FCAL pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe opipls opiodr rpidrus skgmstack rpidru rpiswu2 rpidrv psddr0 psdnal pevm_EXIM pfrinstr_EXIM pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real main start


Explanation:


Bug 5587976


Solution:


the core dump while gathering statistics is caused by one of your interim patches (see also the ORA-60 errors) applied and is fixed by patch 5160122, available as one-off on top of 10.2.0.4.
To resolve the problem execute below action plan:

1. upgrade to 10.2.0.5, apply patch 8202632, since 10.2.0.5 includes the fix for bug 5160122
or
2. upgrade to 10.2.0.4, apply patch 6810189 and on top of 10.2.0.4 apply one-off patch 5160122

3.
Patch is available for solaris on 10.2.0.3.
Download and apply the patch for bug 5587976


please relink the oracle executable and check whether this
fixes the problem.

-- Be sure to shutdown all databases and listeners in this $ORACLE_HOME
-- Then as software owner relink:

cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk ioracle

For more information on this please see:

Note 131321.1 : How to Relink Oracle Database Software on UNIX




    

Get Oracle Certifications for all Exams
Free Online Exams.com

ORA-07445[kksParseChildCursor], ORA-04030, Swap space realted issue. ora-600[17059]

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Database Alert Log file:


Sat Jan 23 20:21:53 2010
Errors in file /orasys/ipay/udump/ipay_ora_12022.trc:
ORA-07445: exception encountered: core dump [kksParseChildCursor()+1180] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7FFF25C0] [] []
Sat Jan 23 20:24:43 2010
Errors in file /orasys/ipay/bdump/ipay_j000_11350.trc:
ORA-12012: error on auto execute of job 263
ORA-04030: out of process memory when trying to allocate 127512 bytes (QERHJ hash-joi,kllcqas:kllsltba)
ORA-06512: at "WTR.TRANSFER_INTERNET_WEB_PAYMENTS", line 17
ORA-06512: at line 1
Sat Jan 23 20:26:36 2010
Process startup failed, error stack:
Sat Jan 23 20:26:43 2010
Errors in file /orasys/ipay/bdump/ipay_psp0_2813.trc:
ORA-07445: exception encountered: core dump [_ndoprnt()+4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7FFF9D60] [] []
Sat Jan 23 20:26:53 2010
Errors in file /orasys/ipay/bdump/ipay_pmon_2811.trc:
ORA-00490: PSP process terminated with error
Sat Jan 23 20:26:53 2010
PMON: terminating instance due to error 490
Sat Jan 23 20:26:53 2010
Errors in file /orasys/ipay/bdump/ipay_lgwr_2825.trc:
ORA-00490: PSP process terminated with error
Sat Jan 23 20:26:53 2010
Errors in file /orasys/ipay/udump/ipay_ora_3185.trc:
ORA-00490: PSP process terminated with error
Sat Jan 23 20:26:53 2010
Error occured while spawning process J001; error = 490
Sat Jan 23 20:26:53 2010
Errors in file /orasys/ipay/bdump/ipay_cjq0_2833.trc:
ORA-00490: PSP process terminated with error
Sat Jan 23 20:26:59 2010
Instance terminated by PMON, pid = 2811


Trace files shows:


ERROR in TRACE FILE
----------------
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
*** 2010-02-01 04:31:47.660
Process startup failed, error stack:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
*** 2010-02-01 04:32:05.713
error 472 detected in background process
ORA-00472: PMON process terminated with error


Solution:
It is matching an  unpublished Bug 6471770
++ Set the following parameter _gby_hash_aggregation_enabled = false : -
SQL> alter system set "_gby_hash_aggregation_enabled"=false scope=both;

++ Also set the following event along with the above parameter, same time : -
SQL> alter system set events '4030 trace name errorstack level 3;name HEAPDUMP level 536870917';


    

Get Oracle Certifications for all Exams
Free Online Exams.com

ORA-07445: exception encountered: core dump [_memcmp()+92] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7FFEB030] [] []

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Alert Log file shows:


Errors in file /orasys/ipay/udump/ipay_ora_4814.trc:
ORA-07445: exception encountered: core dump [_memcmp()+92] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7FFEB030] [] []
and
ORA-07445: exception encountered: core dump [kksParseChildCursor()+1180] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7FFF2E00] [] []
and
Errors in file /orasys/ipay/bdump/ipay_psp0_6679.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3


Solution:


 Bug 6680588 - ORA-600: INTERNAL ERROR CODE, ARGUMENTS: [17059], [0X6993E6A8],
--> Base Bug 5705795 - MANY CHILD CURSORS CREATED FOR HIGH WORKLOAD IN 10.2.0.3, fixed in 10.2.0.4
 Note 5705795.8 - Bug 5705795 - Many child cursors possible for SQL using BINDS
 Note 403616.1 - Many Child Cursors create in 10.2.0.3 on Windows and Linux


    

Get Oracle Certifications for all Exams
Free Online Exams.com

OPatch failed with error code 73

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem Explanation:


Apply Database patches using OPatch failed with " failed with OPatch failed with error code 73 "


Solution:


Missing operating System Patch


applying SUN patch 123908-01 (or later) and relink oracle binaries




Reference:


Note 353150.1 - OPatch Failing Validation Phase When Archiving Really Did Not Fail


     

Get Oracle Certifications for all Exams
Free Online Exams.com

ORA-30926: unable to get a stable set of rows in the source

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem Description: 


Alert Log files show the the following:


ORA-12012: error on auto execute of job 101491
ORA-30926: unable to get a stable set of rows in the source tables
ORA-06512: at "Procedure", line 15


Trace File shows:


/oradg2/orasys/admin/adp2/udump/adp_ora_19344.trc

Comments
--------
*** ACTION NAME:() 2010-01-05 08:15:38.214
*** MODULE NAME:(TOAD 8.5.0.50) 2010-01-05 08:15:38.214
*** SERVICE NAME:(SYS$USERS) 2010-01-05 08:15:38.214
*** SESSION ID:(1509.9559) 2010-01-05 08:15:38.214
*** 2010-01-05 08:15:38.214
ksedmp: internal or fatal error
ORA-30926: unable to get a stable set of rows in the source tables
Current SQL statement for this session:
MERGE INTO HR_IMAGE_IDCARDS D USING (SELECT * FROM ADP_TO_HR_V ) S ON (D.EMP_ID = S.EMP_ID) WHEN MATCHED THEN UPDATE SET D.EMP_PHOTO = S.EMP_PHOTO , D.PERS_ID = S.PERS_ID , D.OBSOLFLAG = S.OBSOLFLAG WHEN NOT MATCHED THEN INSERT (D.EMP_ID, D.EMP_PHOTO , D.PERS_ID, D.OBSOLFLAG) VALUES (S.EMP_ID, S.EMP_PHOTO , S.PERS_ID, S.OBSOLFLAG)
----- PL/SQL Call Stack -----
object line object
handle number name
3cd8b43a0 3 procedure HR.UPDATE_EMP_CARD_PHOTO
3ccaff628 1 anonymous block


Explanation:


You can not update LOB objects remotely throw Database Links
ORA-22992: cannot use LOB locators selected from remote tables


Solution:


Change Business Logic




   

Get Oracle Certifications for all Exams
Free Online Exams.com

TNS-12545-12560-00515, Solaris Error : 126: Cannot assign requested address

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:


Starting Database Listener  for and ACTIVE/PASSIVE cluster setup throw the following errors:


TNS-12545: Connect failed because target host or object does not exist

TNS-12560: TNS:protocol adapter error

TNS-00515: Connect failed because target host or object does not exist

Solaris Error: 126: Cannot assign requested address




Explanation:


We have active-passive 10g database under Sun Solaris 10 operating system cluster.

We tried to switch the database to work on the passive node.

when we tried to start the passive node, we got the following errors:
..................................................................
TNSLSNR for Solaris: Version 10.2.0.3.0 - Production

System parameter file is /oracle/aderp/10.2.0/network/admin/aderp_erp-lh/listener.ora

Log messages written to /oracle/aderp/10.2.0/network/admin/aderp.log

Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=erp-lh.auh.police)(PORT=1521)))

TNS-12545: Connect failed because target host or object does not exist

TNS-12560: TNS:protocol adapter error

TNS-00515: Connect failed because target host or object does not exist

Solaris Error: 126: Cannot assign requested address


Solution:


Active/Passive databases and listeners under operating system cluster setup should NOT be stopped or started manually, it should be throw the cluster.


    

Get Oracle Certifications for all Exams
Free Online Exams.com

ORA-00600: internal error code, arguments: [17059], [0x4633429D8], [], [], [], [], [], []

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem Description: Patch 4367986 conflicting with already installed Patch 5705795.


Getting ORA-600 [17059] on the database alert log file


Problem Explanation:


ORA-600 [17059] is a memory corruption error that occurs while building a table to hold the list of child cursor dependencies relating to a given parent cursor and we exceed the maximum possible size of the table.


 identify why so many child cursors have been created, can you please check V$SQLAREA for a statement using a excessive number of child cursors, e.g.:

connect / as sysdba
spool cursor_info.txt
select version_count, sql_id, sql_text from v$sqlarea
where version_count > 5000 order by version_count;

and then for the statement with the largest version count, identify why they are not getting shared from V$SQL_SHARED_CURSOR, e.g.:

select * from v$sql_shared_cursor where address in (
select address from v$sqlarea where sql_id = '<SQL_ID from above>');


Alert Log File shows;


Mon Jan 18 16:32:47 2010
Errors in file /orasys/ipay/udump/ipay_ora_24069.trc:
ORA-00600: internal error code, arguments: [17059], [0x4633429D8], [], [], [], [], [], []
Mon Jan 18 16:32:52 2010
Errors in file /orasys/ipay/udump/ipay_ora_24071.trc:
ORA-00600: internal error code, arguments: [17059], [0x4633429D8], [], [], [], [], [], []
Mon Jan 18 16:32:55 2010
Errors in file /orasys/ipay/udump/ipay_ora_24117.trc:
ORA-00600: internal error code, arguments: [17059], [0x4633429D8], [], [], [], [], [], []
Mon Jan 18 16:32:58 2010
Errors in file /orasys/ipay/udump/ipay_ora_24073.trc:


Trace Files Shows:


parent=463342af0 maxchild=32770 plk=46e81ca48 ppn=n
cursor instantiation=ffffffff7a730318 used=1263817964
child#32769(0) pcs=40d6be768
 clk=0 ci=0 pn=0 ctx=0
kgsccflg=0 llk[ffffffff7a730320,ffffffff7a730320] idx=0
xscflg=28 fl2=0 fl3=82080 fl4=0
sharing failure(s)=400
No bind info: cannot access child information block
and the oacdefs are not stored in the instantiation
Frames pfr 0 siz=0 efr 0 siz=0
Cursor frame dump
Session cached cursors


Workaround:


you can stop the ORA-600 [17059] errors occurring by flushing the shared pool using:

connect / as sysdba
alter system flush shared_pool;
alter system flush shared_pool;
alter system flush shared_pool;
exit


Solution:


Patch 5705795 would rectify the issue however it conflicts with patch 4367986.


A merged version of the patches is available for download from My Oracle Support as patch 7007477

    

Get Oracle Certifications for all Exams
Free Online Exams.com

ORA-07445: exception encountered: core dump [ddfnetCFull()+2040] [SIGSEGV] [Address not mapped to o bject] [0xFFFFFFFF7B4800A0] [] []

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem Description: 


Getting the following error while inserting the records over the dblink:

ORA-07445: exception encountered: core dump [ddfnetCFull()+2040] [SIGSEGV] [Address not mapped to o
bject] [0xFFFFFFFF7B4800A0] [] []


Symptoms:


Database Alert Files shows:


Errors in file /oradg2/orasys/admin/adp2/udump/adp_ora_6440.trc:
ORA-07445: exception encountered: core dump [ddfnetCFull()+2040] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7B1800A0] [] []


Database Trace File shows:


*** SERVICE NAME:(SYS$USERS) 2009-12-22 07:29:48.796
*** SESSION ID:(2256.34220) 2009-12-22 07:29:48.796
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0xffffffff7b4800a0, PC: [0x102450e98, ddfnetCFull()+2040]
*** 2009-12-22 07:29:48.840
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [ddfnetCFull()+2040] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7B4800A0] [] []
Current SQL statement for this session:


INSERT INTO Table_Name From Table_Name@DBLINK


Explanation:


Problem caused due to in-doubt transactions exists in the database.


Solution:


purging pending transactions would rectify  ora-7445


1. Identify the id of the transaction:

SQL> SELECT LOCAL_TRAN_ID, GLOBAL_TRAN_ID FROM DBA_2PC_PENDING;

If there are entries returned by the above query then,

2. Try to commit/ rollback these failed transactions :

To Commit:

SQL>commit force;

To Rollback :

SQL> rollback force;

3. If still no success, then you need to purge these transactions:

SQL> alter system enable distributed recovery;

SQL> alter system set "_smu_debug_mode" = 4;
SQL> EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('<transaction_id>');
SQL> COMMIT;

4. Confirm that the transaction has been purged:

SQL> SELECT LOCAL_TRAN_ID, GLOBAL_TRAN_ID FROM DBA_2PC_PENDING;


Reference :

Note.126069.1 Manually Resolving In-Doubt Transactions Different Scenarios
Note.401302.1 How To Resolve Stranded DBA_2PC_PENDING Entries
Note.100664.1 How to Troubleshoot Distributed Transactions 


     

Get Oracle Certifications for all Exams
Free Online Exams.com

ORA-00600: internal error code, arguments: [17059], [0x4633429D8]

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem Description: Database Crashes

Symptoms:

Database hangs frequently, Database Alert Log file shows "ORA-00600: internal error code, arguments: [17059], [0x4633429D8]"

Many trace files generated causing shortage on storage.

Alert Log file shows:

Mon Jan 18 08:02:21 2010
Errors in file /orasys/ipay/bdump/ipay_j000_12065.trc:
ORA-12012: error on auto execute of job 263
ORA-04030: out of process memory when trying to allocate 127512 bytes (QERGH hash-agg,kllcqas:kllsltba)
ORA-06512: at "WTR.TRANSFER_INTERNET_WEB_PAYMENTS", line 17
ORA-06512: at line 1
Mon Jan 18 08:03:32 2010
Errors in file /orasys/ipay/bdump/ipay_j000_12065.trc:
ORA-12012: error on auto execute of job 1
ORA-04030: out of process memory when trying to allocate bytes (,)
ORA-06512: at "SYSMAN.EMD_MAINTENANCE", line 947
ORA-06512: at line 1
Mon Jan 18 08:03:33 2010
Errors in file /orasys/ipay/bdump/ipay_j000_12065.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-04030: out of process memory when trying to allocate 72 bytes (kxs-heap-d,allocator state)
ORA-12012: error on auto execute of job 1
ORA-04030: out of process memory when trying to allocate bytes (,)
ORA-06512: at "SYSMAN.EMD_MAINTENANCE", line 947
ORA-06512: at line 1

Trace files shows :

Errors in file /orasys/ipay/udump/ipay_ora_4868.trc:
ORA-07445: exception encountered: core dump [kksParseChildCursor()+1180] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7FFF2E00] [] []
and
Errors in file /orasys/ipay/bdump/ipay_psp0_6679.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3

System Error Log shows:

Jan 19 05:58:29 Gateway2 last message repeated 22 times
Jan 19 06:09:59 Gateway2 ufs: [ID 845546 kern.notice] NOTICE: alloc: /orasys: file system full
Jan 19 06:14:45 Gateway2 last message repeated 2 times
Jan 19 06:15:59 Gateway2 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 5420 (oracle)
Jan 19 06:16:00 Gateway2 last message repeated 1 time
Jan 19 06:16:01 Gateway2 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 4363 (oracle)
Jan 19 06:16:01 Gateway2 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 5420 (oracle)
Jan 19 06:16:02 Gateway2 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 4363 (oracle)
Jan 19 06:16:02 Gateway2 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 5420 (oracle)
Jan 19 06:16:02 Gateway2 ufs: [ID 845546 kern.notice] NOTICE: alloc: /orasys: file system full
Jan 19 06:16:03 Gateway2 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 4363 (oracle)
Jan 19 06:16:06 Gateway2 last message repeated 2 times
Jan 19 06:16:07 Gateway2 ufs: [ID 845546 kern.notice] NOTICE: alloc: /orasys: file system full
Jan 19 06:17:41 Gateway2 last message repeated 1 time
Jan 19 06:24:42 Gateway2 ufs: [ID 845546 kern.notice] NOTICE: alloc: /orasys: file system full
Jan 19 06:26:15 Gateway2 genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 5486 (oracle)
Jan 19 06:26:18 Gateway2 last message repeated 3 times

Solution:

1. From the error log, it is clear that there is no swap space, thats the reason for getting the error. involve your system administrators to resolve this problem

2. set the stack size to unlimited

3. Apply Interim patch 5705795 

Get Oracle Certifications for all Exams
Free Online Exams.com