Home > Database, Grid Infrastructure, Oracle > ORA-00600 [kfk_load_by_idx_in_pga9] / ORA-15186 when using sqlplus as none-oracle OS user

ORA-00600 [kfk_load_by_idx_in_pga9] / ORA-15186 when using sqlplus as none-oracle OS user

Problem description:

When executing sqlplus as none-oracle OS user and connecting to the Oracle database using the bequeath protocol (e.g. sys as sysdba), you are receiving the following error messages:

Tue May 02 19:27:06 2011
ERROR: asm_init(): asm_erc:-5 msg:Driver not installed pid:39333
Errors in file /u01/app/oracle/diag/rdbms/mydb/mydb1/trace/mydb1_ora_39333.trc  (incident=13810):
ORA-00600: internal error code, arguments: [kfk_load_by_idx_in_pga9], [1], [0], [], [], [], [], [], [], [], [], []
ORA-15186: ASMLIB error function = [asm_init],  error = [18446744073709551611],  mesg = [Driver not installed]
ERROR: unrecoverable error ORA-600 raised in ASM I/O path; terminating process 11900
Tue May 02 19:27:09 2011
Sweep Incident[13810]: completed

Cause:
You are running your database on Grid Infrastructure/ASM. When connecting for instance as root user and sqlplus/your server process tries to access the datafiles, you will receive above error messages.

Problem resolution:

  • Use sqlplus as the oracle OS user you are running the database
  • Connect via SQL*Net
  • If it’s really necessary to run sqlpus via bequeath protocol with this specific OS user, add him to the OS group configured as asmdba group (e.g. asmdba)

Example connect as root-user after adding the account to the asmadmin group:

[root@linux01 ~]# $ORACLE_HOME/bin/sqlplus "sys as sysdba"
 
SQL*Plus: Release 11.1.0.7.0 - Production on Tue May 2 23:50:10 2011
 
Copyright (c) 1982, 2008, Oracle.  All rights reserved.
 
Enter password:
 
Connected to:
Oracle Database 11g Release 11.1.0.7.0 - 64bit Production
With the Real Application Clusters option
 
SQL>
SQL> select count(*) from dba_segments;
 
  COUNT(*)
----------
     39496
 
SQL> exit
Disconnected from Oracle Database 11g Release 11.1.0.7.0 - 64bit Production
With the Real Application Clusters option
[root@linux01 ~]#
Categories: Database, Grid Infrastructure, Oracle Tags:
  1. No comments yet.
  1. No trackbacks yet.

Connect with Facebook