Identity Management (MOSC)

MOSC Banner

Database authentication through OID users

edited Apr 4, 2018 5:44AM in Identity Management (MOSC) 9 commentsAnswered

Hi ,

I have OID 11g   configured for TNS names resolutions. And I want to use the same OID for Database login  authentications.

I followed the below steps to  register  DB to use  OID for user authentication

1.  I  updated the sqlnet.ora with following contents

          NAMES.DEFAULT_DOMAIN = <domain.com>

          NAMES.DIRECTORY_APTH  = (LDAP,TNSNAMES)

2.  Updated the ldap.ora with the following contents 

          DIRECTORY_SERVERS = (oid.domain.com:3060:3131)

          DIRECTORY_SERVER_TYPE = OID

          DEFAULT_ADMIN_CONTEXT = "dc=domain, dc=com"

3.  Set the TNS Admin  variable and ran the 12c DBCA and  selected the following options to register the database with OID.

          --> Configure Database Options

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center