Hello everyone,
Just grabbed the new version of sqlcl (sqlcl-4.2.0.16.112.0616-no-jre) from OTN, and local DB connections appear to no longer work.
I have a 12.1.0.2 standard edition database running (SID is XE, but it's not Oracle XE ) locally on Windows. I am not running a listener. When I try to connect locally with the new release, I get an error: Incompatible version of libocijdbc[Jdbc:121010, Jdbc-OCI:121020. It works with the previous version.
Here's the proof (yes, it's really Windows. I'm using ConEMU as my command line, so don't be fooled into thinking it's *nix):
stegemanj@MY_MACHINE C:\o\sqlcl\bin
$ set ORACLE_SID=XE
stegemanj@MY_MACHINE C:\o\sqlcl\bin
$ sql scott/tiger
SQLcl: Release 4.2.0.16.112.0616 RC on Fri Apr 22 08:48:12 2016
Copyright (c) 1982, 2016, Oracle. All rights reserved.
USER = scott
URL = jdbc:oracle:oci8:@
Error Message = Incompatible version of libocijdbc[Jdbc:121010, Jdbc-OCI:121020
USER = scott
URL = jdbc:oracle:thin:@127.0.0.1:1521:XE
Error Message = IO Error: The Network Adapter could not establish the connection
USER = scott
URL = jdbc:oracle:thin:@localhost:1521/orcl
Error Message = IO Error: The Network Adapter could not establish the connection
Username? (RETRYING) ('scott/*********'?)
Warning: You are no longer connected to ORACLE.
stegemanj@MY_MACHINE C:\o\sqlcl\bin
$ cd ..\..\sqlcl.old\bin
stegemanj@MY_MACHINE C:\o\sqlcl.old\bin
$ sql scott/tiger
SQLcl: Release 4.2.0.16.049.0842 RC on Fri Apr 22 08:48:31 2016
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
SQL>
Edit:
Just for additional information, in case it's pertinent:
Microsoft Windows [Version 10.0.10586]
stegemanj@MY_MACHINE C:\Users\stegemanj
$ java -version
java version "1.8.0_66"
Java(TM) SE Runtime Environment (build 1.8.0_66-b18)
Java HotSpot(TM) 64-Bit Server VM (build 25.66-b18, mixed mode)
A further edit:
I never asked my questions
Is this a known issue, and are there any workarounds? Yes, I can always fire up the listener and connect that way, but I tend not to have my listener running on my laptop - it's just for playing around/testing.