Linux and UNIX systems: 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