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

How to load clob data through sql loader
Error converting SQL Server DDL and views to Oracle
Copy views or stored procedures from one schema to another under Oracle 11g
How to increase the maximum automatic open size?
SQL Developer is sometimes stealing focus in Windows 7
Data Export - Export slows and slows until dead
SQL Developer tool question
How do I migrate views from MS SQL 2008 to Oracle 11g through SQL Developer
SQL Developer and Desktop Virtualization
How use SQL Developer
SQL Developer -
Row Count Options
Unable to connect to SQL Server
Unit Test Validation for Output Ref Cursor Not Working
sql developer is not starting
Error Unit Test "argument(s) have unsupported type"

Categories

ORACLE DEV
WebCenter Content
Globalization Support
Oracle Call Interface ...
ODBC
Enterprise Manager [AR...
Procurement
Human Capital Manageme...
Applications Desktop I...
Instant Client
Connector for Outlook
Desktop Datacenter
SQL Developer
Secure Backup
Rules Manager & Expres...
SOA Suite
ODBC (Korean)
Web Service Manager (K...
Technical Bulletin (Ko...
Installation>MS Window...
Oracle Clusterware
Applications Integrati...
Product Hub
Costing
Technology - General D...
Logistics
PeopleSoft Enterprise ...
ServerStats
Test Management/Functi...
WebLogic
WebCenter - Interaction
Application Integratio...
WebLogic Server - JDBC
Packaged Applications
协作套件
weblogic.developer.int...
iStore
AquaLogic User Interac...
Archived Discussion Fo...
Develop Tools (Chinese)
BEA WebLogic Portal (C...
广州 User Group
OVM Templates
Naming and Directory (...
DTrace
JVMTI [ARCHIVE]
New To Java Technology...
WebCenter Archived Forums
Java EE SDK
Sun Java System Access...
Java BluePrints [ARCHIVE]
Sun Java Wireless Toolkit
Java TV
Web Space Server
Workstations General D...
OpenSPARC
Sun ONE Integration Se...
Database Firewall
Oracle Developer Suite...
エンタープライズ管理
PHP (Korean)
Oracle SOA Suite (Japa...
Oracle Database Cloud ...
Oracle JRockit (Japanese)
Primavera Unifier User...
Fusion Applications
HCM Functional Discuss...
Java 8 Questions
WebCenter Portal JSK
Engineered Systems
Oracle Code Online
Influence
Oracle Messaging Cloud...
Node.js
Colorado Eloqua Users
Spotlight on Success W...
Eloqua Users - Virginia
Public Broadcasting
eloquacertified
Oracle Compute Cloud S...
ZFS Storage Appliance
Solaris 中文论坛
Google Adwords Landing...
AIOUG Social Group
OTN Summit Middleware ...
Independent Oracle Use...
Solver
RAC - Real Application...
Global Human Resources
Oracle SOA Suite 12c: ...
Pittsburgh Area Users
Oracle Identity Cloud ...
From MOOC1
Java Microservices
Oracle Insurance Polic...
Java Puzzle Ball
New Zealand Oracle Use...
Markies: Marketing & S...
Eloqua Benelux User Group
Spatial
Data Mining
Order Management
Exchange
BPEL
Upgrades and Migration
새로운 Technical Bulletin
Oracle Authentication ...
Automated Regression T...
bea.guardian
J2ME Development (Chin...
Java Card
Java System Portal Ser...
コミュニティ
Oracle Cloud - General...
Oracle HCM Cloud Service
OTN Garage
Oracle Storage Cloud S...
Oracle Financials Clou...

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