Operating System - HP-UX
1748169 Members
4361 Online
108758 Solutions
New Discussion юеВ

Re: ORA-600 with argument [kksscl-inf-inl-loop]

 
Sanjay Kumar Suri
Honored Contributor

ORA-600 with argument [kksscl-inf-inl-loop]

We are running SAP R/3 472 with Oracle 9.2.0.5 on HP_UX 11i.

During last week Oracle Alert log has many ORA-600 with argument [kksscl-inf-inl-loop].

ORA-00604: error occurred at recursive SQL level
ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","unknown object","sga heap(2,0)","kglsim obje
ORA-00600: internal error code, arguments: [kksscl-inf-inl-loop], [2500], [3], [30], [709], [709], [], []

This lead system to stand still as users were not able to login into the system.

This forced us to shutdown the system. After restarting system there is no occurance of above ORA is observed.

Does anyone has a solution to above problem?

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
10 REPLIES 10
Indira Aramandla
Honored Contributor

Re: ORA-600 with argument [kksscl-inf-inl-loop]

Hi Sanjay,

Were there any recent changes to the system Were there any recent changes to the system environment, eg. hardware modifications, operating system upgrades, restore of datafiles, power failures, etc.
ORA-600 [kksscl-inf-inl-loop] are also caused due to many BUGS that were fixed from 9.2 onwards.

May be it is due to the Bug:3336674 ORA-4031 ("SHAREDPOOL","UNKNOWN OBJECT","KGL SIMULATOR ","KGLSIM HEAP

This may be related to Shared Pool. May be your shared_pool_size is too small. How much physical memeory on the system? how manay processes or connections you have. Issues which affect the shared pool may lead to wider problems for other users such as ORA-4031 errors, very slow performance, increased CPU etc├в ┬ж├в ┬ж..

Or may be the java_pool_size needs to be set properly. The problem may be resolved by setting the java_pool_size greater then 4M. In fact a value of 4194305 (4M + 1 byte) would be sufficient, since the java_pool_size is adjusted to a multiple of 4M. There is a threshold of java_pool_size of 5M based on v$sgastat.

Oracle says several bugs have been fixed since 9.2.0.4/9.2.0.5 that are related to ORA-4031's:

Ind
Never give up, Keep Trying
renarios
Trusted Contributor

Re: ORA-600 with argument [kksscl-inf-inl-loop]

Hi Sanjay,

According Oracle, you have to open an iTar at metalink.oracle.com.
This is the what Oracle says about ORA-600 errors:

What is an ORA-600 Internal Error?
ORA-600 errors are raised from the kernel code of the Oracle RDBMS software when an internal inconsistency is detected or an unexpected condition is met. This situation is not necessarily a bug as it might be caused by problems with the Operating System, lack of resources, hardware failures, etc.

With the ORA-600 error comes a list of arguments in square brackets. The first of these arguments tells us from where in the code the error was caught and thus is the key information in identifying the problem. This argument is either a number or a character string. The remaining arguments are used to supply further information eg. values of internal variables etc.

Whenever an ORA-600 error is raised a trace file is generated in either USER_DUMP_DEST or BACKGROUND_DUMP_DEST depending on whether the error was caught in a user or a background process. The error is also written in the alert log and so is the name of the trace file. The trace file contains vital information about what led to the error condition.

In the forum on Oracle metalink, there is a same question (http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FOR&p_id=554616.996) and the recommendation of Oracle support: "I suggest you raise an iTAR, so that Oracle Support team can better assist you in resolving the issue "

Hope that helps,

Renarios
Nothing is more successfull as failure
Eric Antunes
Honored Contributor

Re: ORA-600 with argument [kksscl-inf-inl-loop]

Hi Sanjay,

Did you read Metalink Note 244210.1??

Best Regards,

Eric Antunes
Each and every day is a good day to learn.
Sanjay Kumar Suri
Honored Contributor

Re: ORA-600 with argument [kksscl-inf-inl-loop]

Ind:

Oracle version is 9.2.0.5.
shared_pool_size = 1792 MB
processes=1034
RAM=16 GB
java_pool_size=0

Renario:

Since we don't have access to Metalink, can you please attached the question posted there?

Eric: Please attach the Metalink Note 244210.1.

Thanks.

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Indira Aramandla
Honored Contributor

Re: ORA-600 with argument [kksscl-inf-inl-loop]

Hi Sanjay,

Try seting your JAVA_POOL_SIZE at least 20m and see.


Indira A
Never give up, Keep Trying
Yogeeraj_1
Honored Contributor

Re: ORA-600 with argument [kksscl-inf-inl-loop]

hi,

if you had the error stack, metalink has a lookup facility that allow to further diag the error..

attached the doc you need.

regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Jean-Luc Oudart
Honored Contributor

Re: ORA-600 with argument [kksscl-inf-inl-loop]

Hi Sanjay,

we experienced in the past ORA-4031. From investigation there were 3 possibilities:
- bug
- shared memory fragmented
- shared memory too small
Regarding the version we were on there was noo none bug. We then ran a few scripts and concluded it was the size.
we doubled the size (so we have some room for new shared code) and the error is gone since.
Your shared memory is fairly big already.

check attached document

Regards
Jean-Luc
fiat lux
Jean-Luc Oudart
Honored Contributor

Re: ORA-600 with argument [kksscl-inf-inl-loop]

Sanjay,

you may use attached script

Regards
Jean-Luc
fiat lux
Eric Antunes
Honored Contributor

Re: ORA-600 with argument [kksscl-inf-inl-loop]

Sanjay,

The Note refers to bugs for previous versions than yours. I found some info about similar issues but no resolutions:

Bug.2894714 (35) SERVER COREDUMPS WHEN EXECUTING QUERY WITH GROUPING SETS/SUBQUERY ORA-03113 RDBMS-9203:
10 Bug.2165266 (91) XT UPDATEXML CORE DUMP IN LNXNUCOPT WHILE UPDATING NESTED SCHEMA ELEMENT

Bug.3327679/3317168 (80) FXD REL6 RAC ORA-00600 [KKSSCL-INF-INL-LOOP] RDBMS-1010:
1 {Bug.2539791 (80) ORA-00600 [KKSSCL-INF-INL-LOOP], [1500] AND ORA-07445 [KXSDMP()+200] [SIGSEGV]

DESCRIPTION:
ORA-600 [kksscl-inf-inl-loop]

ARGUMENTS:
There will be no arguments to this error

FUNCTIONALITY:
Kernel Kompile Shared

During heavy load server processes will be waiting for the completion of a child cursor, while one process is building it.
If another process wants to execute the same child then it will fail to pin this child

IMPACT:
NON CORRUPTIVE - No underlying data corruption.

Best Regards,

Eric Antunes
Each and every day is a good day to learn.