Warning: skgmdetach - Unable to register unmap, error 4210

[Former Member]

Hi All,

Whenever there a load uploading from R3 to BW acceptances system.System gets hangs and when i check in the log i see below errors

Alert log:

Sun Jun 28 13:00:16 2009

Errors in file f:\oracle\ba1\saptrace\background\ba1_ora_4196.trc:

ORA-00610: Internal error code

====================================================================================================

Dump file f:\oracle\ba1\saptrace\background\ba1_ora_4196.trc

Sun Jun 28 13:00:14 2009

ORACLE V10.2.0.2.0 - Production vsnsta=0

vsnsql=14 vsnxtr=3

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production

With the Partitioning, OLAP and Data Mining options

Windows 2000 Version V5.0 Service Pack 4

CPU : 4 - type 586

Process Affinity : 0x00000000

Memory (Avail/Total): Ph:74M/3583M, Ph+PgF:11281M/17752M, VA:665M/2047M

Instance name: ba1

Redo thread mounted by this instance: 1

Oracle process number: 0

Windows thread id: 4196, image: ORACLE.EXE

error 610 in job queue process

ORA-00610: Internal error code

Died during process startup with error 447 (seq=15075)

OPIRIP: Uncaught error 447. Error stack:

ORA-00447: fatal error in background process

===========================================================================================================

Sun Jun 28 13:00:17 2009

Process J000 died, see its trace file

Sun Jun 28 13:00:17 2009

kkjcre1p: unable to spawn jobq slave process

Sun Jun 28 13:47:54 2009

Warning: skgmdetach - Unable to register unmap, error 4210

Sun Jun 28 13:52:54 2009

Warning: skgmdetach - Unable to register unmap, error 4210

Sun Jun 28 13:57:54 2009

Warning: skgmdetach - Unable to register unmap, error 4210

Sun Jun 28 14:02:54 2009

Warning: skgmdetach - Unable to register unmap, error 4210

Sun Jun 28 14:07:55 2009

Warning: skgmdetach - Unable to register unmap, error 4210

System log:

ORA-12518: TNS:listener could not hand off client connection

================

We are using...

Oracle :10.2.0.2.0

Windows 2000

i have did some ground work from which i tells us the above mentioned errors relates to ORACLE BUG 6087348

checked below parameters set to...

processes=80

Job_queue_processes: 1

Can anyone help me in resolvinf the issue.

Thanks in Advances

[sunny_pahuja2]

Hi

> {> ORA-00610: Internal error code

> Died during process startup with error 447 (seq=15075)

> OPIRIP: Uncaught error 447. Error stack:

> ORA-00447: fatal error in background process

> ===========================================================================================================

Check below link:

http://www.error-code.org.uk/view.asp?e=ORACLE-ORA-00447

Note 541695 - ORA-00470/ORA-00471/ORA-00472/ORA-00473/ORA-00474

Note 1289691 - ORA-610: INTERNAL ERROR CODE if not enough resources

Hope it helps

Thanks

Sunny

[Former Member]

Joshi,

Check SAP Note 1289691 - ORA-610: INTERNAL ERROR CODE if not enough resources

Metalink:-

https://metalink.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bm...

https://metalink.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bm...

Check you DB parameter setting according to SAP Note 830576 - Parameter recommendations for Oracle 10g

SAP Note 1171650 -Automated Oracle DB parameter check

Also try by restarting server once.

Hope this helps

Thanks

Sushil

[Former Member]

Hi Sushil,

Thanks for quick reply.

I have gone through the Note,where it is related to unix as we are on windows2000.

Check SAP Note 1289691 - ORA-610: INTERNAL ERROR CODE if not enough resources

Eariler i mention that the below warning relates to oracle bug 6087348. Please can u post on this whether i am correct or not

Warning: skgmdetach - Unable to register unmap, error 4210

Thanks

[Former Member]

Can you check output of r3trans -d & paste it here.

Check your parameter setting according to SAP note 830576 - Parameter recommendations for Oracle 10g

Mostly check for parameter processes.

You are correct. that is related to Unix but it also says "If the error occurs and the patch required for your platform is not listed,

create an SAP customer message referring to this note".

Can you try by restarting server.

ORA-12518: TNS:listener could not hand off client connection

Check below threads for ORA-12518 log.

Hope it helps

Thanks

Sushil