Oracle LDAP connection String in context.xml

Connection string format to connect to Oracle DB through LDAP

If your an Oracle database and its details are configured in LDAP.

Rename or delete tnsnames.ora
(default location in most cases is at C:\Oracle\product\11.2.0\client_1\NETWORK\ADMIN\)

Ask for Directory Servers, Default Admin Context and server type information from DBA.


You need to configure the LDAP.ORA and SQLNET.ORA files appropriately.

#########################################################################
# Filename......: ldap.ora                                              #
# Version: 10.x.X.1                                                     #
# Create Date...: 05.04.2014 00:00:00 -                                 #
# ALL OID ALIASES POINT TO GSLB ENTRY THAT ROUND ROBINS         #
#########################################################################

DIRECTORY_SERVERS=(brahma.decimalSolutions.com:9901:9911,brahma.decimalSolutions.com:9901:9911,brahma.decimalSolutions.com:9901:9911)

DEFAULT_ADMIN_CONTEXT = "dc=decimalSolutions, dc=com"

DIRECTORY_SERVER_TYPE = OID



#########################################################################
# Filename......: sqlnet.ora                                              #
#########################################################################
# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)

#NAMES.DIRECTORY_PATH = (TNSNAMES)
#NAMES.DIRECTORY_PATH = (LDAP)
#NAMES.DIRECTORY_PATH = (TNSNAMES,LDAP)
NAMES.DIRECTORY_PATH = (LDAP,TNSNAMES)






                auth="Container"
                type="javax.sql.DataSource"
                factory="com.decimalSolutions.launchpad.encryption.EncryptedDataSourceFactory"
                driverClassName="oracle.jdbc.OracleDriver"
                url="jdbc:oracle:thin:@ldap://brahama.decimalSolutions.com:9901/hlpd1,cn=OracleContext,dc=decimalSolutions,dc=com ldap://brahama.decimalSolutions.com:9901/hlpd1,cn=OracleContext,dc=decimalSolutions,dc=com ldap://brahama.decimalSolutions.com:9901/hlpd1,cn=OracleContext,dc=decimalSolutions,dc=com"
                username="FT_GUEST"
                password="Rnl1eF82MTI="
                maxActive="400"
                maxIdle="25"
                maxWait="5000"
                removeAbandoned="true"
                removeAbandonedTimeout="120"
                logAbandoned="true"/>

How to Add Power button and the Shut Down, Restart, Sleep, and Hibernate

1. Press the Windows key + R to bring up the Run box. Type gpedit.msc and press Enter to open the Local Group Policy Editor.
2. In left-side pane, navigate to Computer Configuration -> User Configuration  -> Administrative Template -> Start Menu and Taskbar.
3. In the right pane select the “Remove and prevent users from access to Shut Down, Restart, Sleep, and Hibernate commands” double-click on it. Select Disable and click Apply and OK.