SqlCl / SdSql on LDAP

At least some of you might have heard about SqlCL. if you don't, you guys know how to find it ..easy ( google it..!! or refer to http://www.thatjeffsmith.com)


SqlCL - In Simple words..works same as sqlplus but with additional (I will say Cool) set of new commands to interact with database.


so how do you install it.


Pre-requisite:
             SQL Developer(latest version)
             Database Client (either Full or Instant Client).
             Correct environment variable.


Download here: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html





unzip the folder , below is the dir structure
                          for eg: C:\Temp\sqlcl
                                                             \bin
                                                                   \sql.bat
                                                                   \sql.exe
                                                                   \sql
                                                             \lib
                                                                    \.. some jar files


 if windows, you will open sql.exe or sql.bat file to open the command line.  if you open up sql.bat file, you'll see two different environment  variables SQL_HOME and ORACLE_HOME make sure those are right. (in my case I edited the file to modify file set SQL_HOME path set to direct sql developer path)

If you've local database or database client with TNS file installation is straightforward.
   
         Click on Sql.exe
                       enter username/password@dbname
                or
         Open Command line:
                       C:\temp\sqlcl\bin>sql /nolog
                       sql>connect test_user\test_pwd@test_servicename
                               connected.


If are using LDAP to sign in Database, below additional to step to follow.


Set the environment LDAPCON (by setting up in windows environment variable or by using set or export command

set LDAPCON jdbc:oracle:thin:@ldap://ldap.test.com:123/#ENTRY#,cn=OracleContext,dc=test1,dc=test1

(All the bold lettered information typically you will find in LDAP.ora file in ORACLE_HOME folder)


         Click on Sql.exe
                       enter username/password@dbname
                or
         Open Command line:
                       C:\temp\sqlcl\bin>sql /nolog
                       sql>connect test_user\test_pwd@test_servicename
                               connected.

for commands help refer to http://www.thatjeffsmith.com blog.

:-)