4 Replies Latest reply on Mar 11, 2015 7:31 AM by HiltonMeyer

    sqlcl connecting but that's about it

    Cliff Mack

      I've downloaded twice, installed in different locations on my Windows 7/64bit box and ensured that I have JRE7 in my PATH env variable and I'm getting the following when trying to use the latest sqlcl (1/30 edition):

       

      c:\>cd sqlcl_4.1\sql*\bin

       

      c:\sqlcl_4.1\sqlcl\bin>dir

      Volume in drive C is OS

      Volume Serial Number is DA45-1667

       

      Directory of c:\sqlcl_4.1\sqlcl\bin

       

      02/03/2015  02:43 PM    <DIR>          .

      02/03/2015  02:43 PM    <DIR>          ..

      02/03/2015  02:43 PM             1,525 sql

      02/03/2015  02:43 PM             1,242 sql.bat

                     2 File(s)          2,767 bytes

                     2 Dir(s)  422,999,871,488 bytes free

       

      c:\sqlcl_4.1\sqlcl\bin>.\sql -optl student/XXXXXXX@//localhost:1521/buddha

       

      SQLcl: Release 4.1.0 Beta on Tue Feb 03 14:48:38 2015

       

      Copyright (c) 1982, 2015, Oracle.  All rights reserved.

       

       

      Feb 03, 2015 2:48:38 PM oracle.dbtools.raptor.newscriptrunner.SQLPlusProviderForSQLPATH getOracleEnv

      INFO: Checking found key for ORACLE_HOME:SOFTWARE\ORACLE\KEY_OraClient11g_home1

      Feb 03, 2015 2:48:38 PM oracle.dbtools.raptor.newscriptrunner.SQLPlusProviderForSQLPATH getOracleEnv

      INFO: Checking found ORACLE_HOME:C:\Oracle\product\11.2.0\client_1\dbs

      Feb 03, 2015 2:48:38 PM oracle.dbtools.raptor.newscriptrunner.SQLPlusProviderForSQLPATH getOracleEnv

      INFO: Checking found key for ORACLE_HOME:null

      Feb 03, 2015 2:48:38 PM oracle.dbtools.raptor.newscriptrunner.SQLPlusProviderForSQLPATH getOracleEnv

      INFO: Checking found key for ORACLE_HOME:null

      Feb 03, 2015 2:48:38 PM oracle.dbtools.raptor.newscriptrunner.SQLPlusProviderForSQLPATH getOracleEnv

      INFO: Checking found key for ORACLE_HOME:SOFTWARE\ORACLE\KEY_OraDb11g_home1

      Feb 03, 2015 2:48:38 PM oracle.dbtools.raptor.newscriptrunner.SQLPlusProviderForSQLPATH getOracleEnv

      INFO: Checking found ORACLE_HOME:C:\Oracle11gR2\product\11.2.0\dbhome_1\dbs

      Feb 03, 2015 2:48:38 PM oracle.dbtools.raptor.newscriptrunner.SQLPlusProviderForSQLPATH getOracleEnv

      INFO: Checking found key for ORACLE_HOME:null

      Feb 03, 2015 2:48:38 PM oracle.dbtools.raptor.newscriptrunner.SQLPlusProviderForSQLPATH getOracleEnv

      INFO: Checking found key for ORACLE_HOME:null

      Feb 03, 2015 2:48:38 PM oracle.dbtools.raptor.utils.TNSHelper checkForTns

      INFO: Checking for tnsnames.* in :C:\Users\cmack.OUHSC

      Feb 03, 2015 2:48:38 PM oracle.dbtools.raptor.utils.TNSHelper checkForTns

      INFO: Checking for tnsnames.* in :C:\Oracle\network\admin

      Feb 03, 2015 2:48:38 PM oracle.dbtools.raptor.utils.TNSHelper getTNSEntries

      INFO: Using TNS info from :C:\Oracle\network\admin

      Feb 03, 2015 2:48:38 PM oracle.dbtools.raptor.newscriptrunner.SQLPLUS logConnectionURL

      INFO: Attempting to connect using URL= "jdbc:oracle:thin:@//localhost:1521/buddha"

      Connected to:

      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

       

      SQL> help

      SQL> show jdbc

      SQL> ?

      SQL> exit

      SQL> quit

      SQL> Terminate batch job (Y/N)? y

       

      as seen above, I get nothing back from the prompt when issuing commands.  Any ideas?

        • 1. Re: sqlcl connecting but that's about it
          Gary Graham-Oracle

          What does the SetJavaHome line in C:\Users\yourusername\AppData\Roaming\sdcli\4.1.0\product.conf contain?

           

          That controls which Java version gets used rather than the value of the JAVA_HOME or PATH environment variables.  The SetJavaHome value should point to a JDK rather than a JRE, but sqlcl (at least when starting up and doing the commands you list above) seems more tolerant of a JRE or older JDK's than SQL Developer 4.1.

           

          Also, you might try overriding the PATH variable so it does not point to your 11.2.0.1 oracle home, but I'm less sure about that since doing "show jdbc" indicates that the 12.1.0.2.0 JDBC driver is used even when PATH and ORACLE_HOME point to some earlier release of Oracle.

          • 2. Re: sqlcl connecting but that's about it
            thatJeffSmith-Oracle

            no debugger, so a JRE is just fine for SQLcl

             

            and it just uses whatever it finds first in your library path I believe...it's easy to confuse our 2 command line interfaces, what Gary says above is true for the other one, sdcli.

            • 3. Re: sqlcl connecting but that's about it
              Cliff Mack

              Yeah, don't know what's up with the windows version.... may be the JRE, however, when running C:\java -XshowSettiongs:all, it would appear I've got all the right information and the PATH variable is pointing

              to the right stuff.

              Just installed the 1/30 version of sqlcl on my VirtBox and it's running just fine.... no problems on OEL5.10.

              • 4. Re: sqlcl connecting but that's about it
                HiltonMeyer

                Seem to be having the same issue on window's. Downloaded the latest version: sqlcl-4.1.0.15.067.0446-no-jre

                Anyone able to solve this issue?