- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: ORA-600 with argument [kksscl-inf-inl-loop]
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-11-2005 05:54 PM
тАО04-11-2005 05:54 PM
ORA-600 with argument [kksscl-inf-inl-loop]
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-11-2005 07:24 PM
тАО04-11-2005 07:24 PM
Re: ORA-600 with argument [kksscl-inf-inl-loop]
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-11-2005 08:04 PM
тАО04-11-2005 08:04 PM
Re: ORA-600 with argument [kksscl-inf-inl-loop]
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-11-2005 08:10 PM
тАО04-11-2005 08:10 PM
Re: ORA-600 with argument [kksscl-inf-inl-loop]
Did you read Metalink Note 244210.1??
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-11-2005 08:37 PM
тАО04-11-2005 08:37 PM
Re: ORA-600 with argument [kksscl-inf-inl-loop]
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-11-2005 08:51 PM
тАО04-11-2005 08:51 PM
Re: ORA-600 with argument [kksscl-inf-inl-loop]
Try seting your JAVA_POOL_SIZE at least 20m and see.
Indira A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-11-2005 09:05 PM
тАО04-11-2005 09:05 PM
Re: ORA-600 with argument [kksscl-inf-inl-loop]
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-11-2005 09:18 PM
тАО04-11-2005 09:18 PM
Re: ORA-600 with argument [kksscl-inf-inl-loop]
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-11-2005 09:22 PM
тАО04-11-2005 09:22 PM
Re: ORA-600 with argument [kksscl-inf-inl-loop]
you may use attached script
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-11-2005 09:38 PM
тАО04-11-2005 09:38 PM
Re: ORA-600 with argument [kksscl-inf-inl-loop]
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