Not logged on PL/SQL Developer

[juyoung]

Dear all,

I got a error message that '(Not logged on)-PL/SQL Developer' when I login to DB.

detail of meaasge is

Initialization error
Could not initialize "C:\orant\bin\oci.dll"
Make sure you have the 64bits Oracle Client installed.

OracleHomeKey:
OracleHomeDir: C\orant
Found: oci.dll
Found ORA803.DLL
Found ora805.dll
Using: C\orant\bin\oci.dll
LoadLibrary(C:\orant\bin\oci.dll) returned 0

I've update TNSnames file also,
please let me know how to logon to DB.

and here is my Info.
---------------
PL/SQL Developer
Version 12.0.5.1828 (64 bit)
31.111159 - 10 user license
Service Contract: 2018-01-01
Windows 7 Build 7601 (Service Pack 1)

Physical memory : 16,695,972 kB (13,111,892 available)
Paging file : 33,390,084 kB (29,633,996 available)
Virtual memory : 8,589,934,464 kB (8,589,630,296 available)

Parameters
C:\Program Files\PLSQL Developer 12\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Program Files\PLSQL Developer 12\Preferences\Default\Default.ini
C:\Users\Juyoung\AppData\Roaming\PLSQL Developer 12\Preferences\Juyoung\default.ini

License File
C:\ProgramData\PLSQL Developer\aalf.dat

Debug file
C:\Users\Juyoung\AppData\Roaming\PLSQL Developer 12\PlSqlDev.elf

Plug-Ins
*Active Query Builder (C:\Program Files\PLSQL Developer 12\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer 12\PlugIns\plsqldoc.dll)
*Red Gate Deployment Plug-In 1.3.0 (C:\Program Files\PLSQL Developer 12\PlugIns\RedGate.dll)
(* is Active)

Aliases

Homes

DLLs
C:\orant\bin\oci.dll
C:\orant\bin\ORA803.DLL
C:\orant\bin\ORA804.DLL
C:\orant\bin\ora805.dll

TNS File

Using
Home:
DLL:
OCI: not initialized

Process
Working Set = 127,819,776
Memory = 46,144,216
GDI Objects = 798
User Objects = 402
Handles = 166

Monitors
PixelsPerInch = 96

Id = 0
Primary = True
Handle = 65537
Left = 0
Top = 0
Width = 1920
Height = 1080

Id = 1
Primary = False
Handle = 65539
Left = 1920
Top = 0
Width = 1920
Height = 1080

MainFormOnTaskbar = False

 

[Marco Kalter]

For the 64 bit version of PL/SQL Developer you will need to install a 64 bit Oracle Client. 64 bit applications cannot use the 32 bit Oracle Client you have installed.

 

[chi]

Hi Marco,

I too have a similar problem. We installed 64 bit PL SQL Developer v12 and oracle instantclient_12_2 64 bit in 64 bit Windows 10 OS. When I logon to the SQL Developer, it doesn't show the databases in the dropdown even though TNS_ADMIN path is correct and tnsnames.ora has connection details.

Below is the support info from SQL developer when logon is cancelled.

--- Info ---

PL/SQL Developer
Version 12.0.4.1826 (64 bit)
02.113083 - Unlimited user license
Service Contract: 6/1/2018
Windows 10 Build 14393

Physical memory : 16,636,012 kB (12,990,036 available)
Paging file : 19,126,380 kB (15,121,684 available)
Virtual memory : 137,438,953,344 kB (137,438,645,560 available)

Parameters
C:\Program Files\PLSQL Developer 12\plsqldev.exe

Preferences
Session mode: Multi
OCI Library: C:\Projects\Oracle\instantclient_12_2\oci.dll
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Users\e1234567\AppData\Roaming\PLSQL Developer 12\Preferences\default\Default.ini
C:\Users\e1234567\AppData\Roaming\PLSQL Developer 12\Preferences\e1234567\default.ini

License File
C:\Users\e1234567\AppData\Roaming\PLSQL Developer\aalf.dat

Debug file
C:\Users\e1234567\AppData\Roaming\PLSQL Developer 12\PlSqlDev.elf

Plug-Ins
*Active Query Builder (C:\Program Files\PLSQL Developer 12\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer 12\PlugIns\plsqldoc.dll)
(* is Active)

Aliases

Homes

DLLs
C:\Projects\Oracle\instantclient_12_2\oci.dll

TNS File

Using
Home:
DLL: C:\Projects\Oracle\instantclient_12_2\oci.dll
OCI: not initialized

Process
Working Set = 120,160,256
Memory = 45,953,288
GDI Objects = 615
User Objects = 347
Handles = 301

Monitor
PixelsPerInch = 96

Id = 0
Primary = True
Handle = 65537
Left = 0
Top = 0
Width = 1680
Height = 1050

MainFormOnTaskbar = False

--- Registry ---

SOFTWARE\ORACLE

--- Path ---

C:\Projects\Oracle\instantclient_12_2
C:\ProgramData\Oracle\Java\javapath
C:\windows\system32
C:\windows
C:\windows\System32\Wbem
C:\windows\System32\WindowsPowerShell\v1.0\
C:\Program Files\PuTTY\
C:\Users\e1234567\AppData\Local\Microsoft\WindowsApps
C:\Projects\Oracle\instantclient_12_2
.

--- TNS names ---

 

[Marco Kalter]

It seems that PL/SQL Developer cannot find your tnsnames.ora file, which is used to populate the database list. Did you define a TNS_ADMIN environment variable? It should point to the directory where the tnsnames.ora file is located.