Linux-UNIX: Finding the Kerberos configuration parameters for Oracle

For Oracle Kerberos, locate the Kerberos keytab and configuration file locations in sqlnet.ora.

About this task

Procedure

  1. Enter: grep –i KERBEROS $ORACLE_HOME/network/admin/sqlnet.ora
    Output is similar to:
    SQLNET.AUTHENTICATION_KERBEROS5_SERVICE = oracle
SQLNET.KERBEROS5_CONF = /home/oracle11/krb5/krb5.conf
SQLNET.KERBEROS5_REALMS = /home/oracle11/krb5/krb.realms
SQLNET.AUTHENTICATION_SERVICES= (BEQ,KERBEROS5)
SQLNET.KERBEROS5_CLOCKSKEW = 600
SQLNET.KERBEROS5_KEYTAB = /home/oracle11/krb5/keytab
SQLNET.KERBEROS5_CONF_MIT = TRUE
  2. To find the Kerberos cache parameter, enter: oklist|grep -i cache

    Output is similar to:

    Ticket cache: /tmp/krb5cc_500