SQL Developer


sqldeveloper.oci.available false


I am attempting to configure Oracle SQL Developer 4.0.1.14 to use an Oracle 11.2.0.4 instant client and the OCI/Thick driver in order to reset expired passwords within the password expiration grace period.  I have defined the location of the instant client in the Tools\preferences\Database\advanced dialog panel.  Use Oracle Client and Use OCI/Thick driver boxes are checked.  The tnsnames.ora file location is also entered.  Connection targets are Oracle 11.2.0.3 and Oracle 10.2.0.4 databases.  There are two other Oracle clients installed on the same Windows XP SP3 desktop. Testing the Instant Client located at C:\app\oracle\product\11.2.0\instantclient-basic-nt-11.2.0.4.0\instantclient_11_2Testing client directory ... OKTesting loading Oracle JDBC driver ... OKTesting checking Oracle JDBC driver version ... OK  Driver version: 11.2.0.3.0Testing testing native OCI library load ... OKSuccess! Despite the apparent OCI success, I searched the Oracle installation directories, but I find no oci.sym file in any Oracle home as suggested by the following link. http://www.thatjeffsmith.com/archive/2014/01/oracle-sql-developer-4-and-the-oracle-client/ When I validate the configuration changes via Help\About\properties tab, the sqldeveloper.oci.available setting is still showing false. What needs to happen before sqldeveloper.oci.available becomes true?
p.s., the Windows PATH environment variable was also revalued with the Oracle instant client location at the front.
Do you get a connection error when you try to login?  Also, in the Configure dialog, you set the client type to 'Instant Client?' 
Yes, Client Type is Instant Client. I (re)extracted the instantclient-basic-nt-11.2.0.4.0.zip file.  Now, sqldeveloper.oci.file is true, but connections generate an ORA-12705 Cannot access NLS data files or invalid environment specified.  I am one step closer. I altered the bin directory sqldeveloper.conf file to IncludeConfFile sqldeveloper-debug.conf.  Not sure that helped, error did not change. Note, I also abandoned the Microsoft explorer search engine and performed a manual search for the oci.sym file.  Found it.  So, that is not an issue.
Some good ideas hereRe: ORA-12705: Cannot access NLS data files or invalid environment specified
After I set NLS_LANG=AMERICAN_AMERICA.US7ASCII from the Windows command prompt and rebooted the machine, the Oracle instant client connected Oracle SQL Developer 4 with the database.  I also did not find a way to dynamically set this value inside Oracle SQL Developer 4.  Would I need to perform a similar exercise for each connection to another target database with a different character set?
Tools > Preferences. You can set your NLS parameters there. 
Under Tools\Preferences\Environment, I set ENCODING to US-ASCII as a substitute for setting character set in NLS_LANG as an environment variable in Windows XP.  Oracle SQL Developer Help suggested ENCODING had a different purpose.  Under Tools\Preferences\Database\NLS, LANGUAGE and TERRITORY were present, but not CHARACTER SET.  Target database character set is US7ASCII.  Rebooted, now it is working without the environment variable set at the system level in Windows XP.  Your help was really beneficial in getting this install up and running.  Thanks again.

Related Links

Structured Type body code changed in the physical model (V. 3.0.0.665)
SQL Dev 3.0: How to move User Defined Reports to another computer
Generate DB DoC
Opening sql scripts
SQLdeveloper connection issue.
Crash on retrieve/'unload' large data set
Unable to find a java virtual machine.
sqldeveloper.exe has stopped working
Install Oracle XE, SQL Developer, and Toad on the same machine?
Privileges to view packages in Sql Developer
Insert with Select and Subquery inside the Trigger (insert)
Script Output (F5) fails to display result set
Password expired - First attempt to logging
Migrate peoplesoft sybase HRMS database to oracle 11g
Function Based Index
auto execute SQL when connecting?

Categories

ORACLE DEV
Fusion Middleware
Oracle Community (OTN)
Community Feedback (No...
JHeadstart
Database Mobile Server...
Heterogeneous Connecti...
ODP.NET
Business Intelligence ...
OLAP
Calendar
PL/SQL XML Programming
SQL Developer
Berkeley DB XML
Korean
Other Languages
BPEL PM (Korean)
SQL*Net (Korean)
Business Process Analy...
Smart Space
BPA Suite (Korean)
Upgrades
WebCenter - Interaction
Communications Presence
Hyperion DRM/Analytica...
Archived BEA Dev2Dev F...
weblogic.developer.int...
weblogic.developer.int...
weblogic.developer.int...
Tuxedo Newsgroups
weblogic.developer.int...
JRockit Newsgroups
小憩一会
EJB Development (Chinese)
BEA WebLogic Server (C...
程序人生
WebLogic Server - JMS
Naming and Directory (...
Java Applet Development
CLDC and MIDP
Kerberos & Java GSS (J...
Systems Development an...
Solaris 9
AVK Portability
Sun Web Developer Pack...
Java Enterprise System...
ONE Application Server 6
Japanese
NoSQL Database
Oracle Database Cloud ...
Customer Advisory Board
Module Extension (Korean)
My Oracle Support Comm...
Israel Oracle User Gro...
Daily Notifications
Peer_Review
Discuss
Oracle Marketing Cloud...
Bulk API
E10
Eloqua Users - San Diego
Pittsburgh, PA Eloqua ...
Oracle Marketing Cloud...
Oracle Marketing Apps
Oracle Process Cloud S...
Getting Started
Responsys UK User Foru...
Oracle Mobile Cloud Se...
Oracle Virtual Networking
IT Strategies from Oracle
Java SE [ARCHIVE]
AROUG
Article Archive
Oracle Database In-Memory
Marketing Elo[q]ution ...
Oracle Cloud Machine
Containers, Docker, an...
Nebraska Eloqua User G...
Eloqua Benelux User Group
Database Application D...
Business Intelligence ...
Order Management
Oracle on Apple Mac OS X
Application Server - G...
Database - General (Ko...
Oracle Modernization
Long Messages Forum
EPM System Management ...
Swing
Technical Questions
Oracle Cloud - General...
Payroll
English
Parallel Graph Analytics
Do It

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App