Vadim Lejnin, у меня такая же проблема с SQL Developer 19.4 + Oracle Database 9.2.0.8. Непобедимо?

Vadim Lejnin, клиент именно этой версии. Ошибка остаётся. Попробовал последние версии SQL Developer и Data Modeler, та же ошибка.

Vadim Lejnin, нашёл SQL Developer Data Modeler Fails to connect to Database With "ORA-00604: Error Occurred at Recursive SQL Level 1 ORA-12705: Cannot Access NLS Data Files or Invalid Environment Specified" (Doc ID 2539348.1).
Эта статья помогла мне соединиться из Oracle SQL Developer Data Modeler с БД Oracl Database 9.2.0.8,
дальше у меня другая проблема, которую решаю с Oracle Support.

Ответ Oracle:
Hi Igor,

If we check the documents
Starting With Oracle JDBC Drivers - Installation, Certification, and More! ( Doc ID 401934.1 )
Client / Server Interoperability Support Matrix for Different Oracle Versions ( Doc ID 207303.1 )

We will see that last JDBC driver version was 11.2.0 and it was certified with Database 9.2.0
The same for Oracle Client where Client 11.2.0 and lower was certified with Database 9.2.0

Unfortunately , older versions of Data Modeler are not available for normal download anymore.
You can try to use older version of Oracle SQL Developer Data Modeler or Oracle SQL Developer version 3.x or 4.0

Ответ техподдержки Oracle помог [скрестить коня и трепетную лань] запустить Oracle SQL Developer 20.2 + Oracle Database 9.2.0.8.

Hello,

Unfortunately, older versions of Data Modeler are not available for normal download anymore.
As a solution / workaround I suggest the following steps:
A. Install Oracle SQL Developer 20.2 which contains Data Modeler also
B. By default, SQL Developer is using a JDBC Driver to connect to Database. Is possible also to switch this mechanism and to use Oracle Call Interface (OCI) Thick drivers instead of the default JDBC drivers . These OCI drivers are used by SQL*Plus
And we will make possible to use OCI drivers from instant client 11gR2 (11.2.0.4) that are certified to connect to Database 9.2

So, here are the detailed steps

A. Install Oracle SQL Developer 20.2 which contains Data Modeler also available here:

SQL Developer 20.2 Downloads Version 20.2.0.175.1842 - June 25,2020
https://www.oracle.com/tools/downloads/sqldev-downloads.html

For Windows download the version for Windows 64-bit with JDK included.

B. By default, SQL Developer is using a JDBC Driver to connect to Database. Is possible also to switch this mechanism and to use Oracle Call Interface (OCI) Thick drivers instead of the default JDBC drivers . These OCI drivers are used by SQL*Plus
I suggest these exact steps for this solution:

1. Download instant client 11gR2 : 11.2.0.4 from these location

- For Windows 64-bit with SQL Developer 64-bit use
http://www.oracle.com/technetwork/topics/winx64soft-089540.html and Option to download:
instantclient-basic-windows.x64-11.2.0.4.0.zip (54,956,947 bytes)

2. Unzip this on machine hosting SQL developer to any location. (e.g D:\instantclient_11_2)

3. Add this location (D:\instantclient_11_2) to the system PATH environment variable (as first entry).
E.g. Control Panel -> System -> Advanced.. > Environment Variables
Save the settings

4. Start SQL Developer. Go to menu Tools -> Preferences -> Database->Advanced.
- Click the "Configure...." button for the Oracle Client.
- Pick the instant client directory (D:\instantclient_11_2) for Client Location, select "Instant Client" as the Client Type
More details in the following note:

How To Integrate the Oracle Client and OCI Thick Drivers with SQL Developer ( Doc ID 2121278.1 )
Note. Make sure to not get errors for the step 4) Test the integration of the Client by hitting the Test button

- Also, make sure that
a. "Use oracle client" is checked and complete path specified.
b. "Use OCI/Thick Client" checked
- Click OK to close the Preferences. SQL Developer will need to restart to switch to the instant client install (the user is prompted to do so immediately,
but can defer if they need to save work, etc. )

5) When SQL Developer restarts, OCI support via the specified instant client will be available.
- Test again this issue

Regards,
Dorin