Custom Search . . .
Wednesday, February 20, 2008
ORA-00600: internal error code, arguments: [krbrckhr_fail]
OS : Windows 2003 R2
While createing database using DBCA, I got below error. I can't able to create database using dbca and manually also
ORA-00600: internal error code, arguments: [krbrckhr_fail]
Solution:
I think it's bug, that's why i installed patch set 10.2.0.3. After installing patch set i can able to create database.
Thursday, February 14, 2008
ORA-24324 & ORA-24323
OS : Windows 2000 SP4
During database creation time(DBCA) i got the follow error message.
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-28547: connection to server failed, probable Oracle Net admin error
There is no problem in my database. Finally i change the below parameter after only i can able to create database.
Solution:
SQLNET.AUTHENTICATION_SERVICES = (NONE)
Wednesday, February 13, 2008
Memory Notification: Library Cache Object loaded into SGA
In 10g we have a new undocumented parameter that sets the KGL heap size warning threshold. This parameter was not present in 10gR1. Warnings are written if heap size exceeds this threshold.
Set _kgl_large_heap_warning_threshold to a reasonable high value or zero to prevent these warning messages. Value needs to be set in bytes.
If you want to set this to 8192 (8192 * 1024) and are using an spfile:
(logged in as "/ as sysdba")
SQL> alter system set "_kgl_large_heap_warning_threshold"=8388608 scope=spfile ;
SQL> shutdown immediate SQL> startup
SQL> show parameter _kgl_large_heap_warning_threshold
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_kgl_large_heap_warning_threshold integer 8388608
If using an "old-style" init parameter,
Edit the init parameter file and add
_kgl_large_heap_warning_threshold=8388608
NOTE: The default threshold in 10.2.0.1 is 2M. So these messages could show up frequently in some application environments.
In 10.2.0.2, the threshold was increased to 50MB after regression tests, so this should be a reasonable and recommended value. If you continue to see the these warning messages in the alert log after applying 10.2.0.2 or higher, an SR may be in order to investigate if you are encountering a bug in the Shared Pool.
