1 Reply Latest reply on Jun 29, 2016 6:17 PM by Gary Graham-Oracle

    sqlcl (on win7) only works with "easy connect"

    B.Delmée

      I am trying sqlcl and like it a lot.

       

      my environment is win7 64bits, java version "1.8.0_66"

       

      I have an instant client installed, configured to use LDAP(OID) and can connect using "sqlplus UID/PWD@DBALIAS"

       

      the same syntax does not work for "sql UID/PWD@ALIAS", yet i can connect using the "easy connect" method, eg "sql UID/PWD@//server:port/DBALIAS"

       

      from the log (see below), i think the error might be trying to connect to the default 1521 port (we use a different one, but sqlplus still works, as do other OCI applications)

       

      c:\temp>sqlcl UID/PWD@DBALIAS

      Jun 29, 2016 11:24:59 AM java.util.prefs.WindowsPreferences <init>

      WARNING: Could not open/create prefs root node Software\JavaSoft\Prefs at root 0x80000002.

      egCreateKeyEx(...) returned error code 5.

       

      SQLcl: Release 4.2.0.16.131.1023 RC on Wed Jun 29 11:24:59 2016

       

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

       

        USER          = UID

        URL           = jdbc:oracle:thin:@DBALIAS

        Error Message = IO Error: The Network Adapter could not establish the connection

        USER          = UID

        URL           = jdbc:oracle:thin:@DBALIAS:1521/DBALIAS

        Error Message = IO Error: The Network Adapter could not establish the connection

        USER          = UID

        URL           = jdbc:oracle:thin:@:servername:1521/servername

        Error Message = IO Error: Invalid connection string format, a valid format is: "host:port:sid"

        USER          = UID

        URL           = jdbc:oracle:thin:@servername:1521/servername.domainname

        Error Message = IO Error: Invalid connection string format, a valid format is: "host:port:sid"

      Username? (RETRYING) ('UID/*********@DBALIAS'?)