PL/SQL not getting connected 12

[QAKS]

Hi, I am able to connect remote database by using sql*plus. But by PL/SQL developer i am getting error "ORA12154"
PL/SQL version is 12.

 

[Marco Kalter]

Can you start PL/SQL Developer without connecting, go to Help > Support Info and copy the text from the "Info" tab page?

 

[QAKS]

Yes without connecting I can start PL/SQL developer.
once i keep the path path to oracle home and OCI library as
C:\oracle
C:\oracle\instantclient_12_2 resp.
and then closed and restarted. I am getting error ORA 12514

 

[QAKS]

The content from support info ------------
PL/SQL Developer
Version 12.0.7.1837 (32 bit)
01.118304 - 50 user license
Service Contract: 3/1/2019
Windows 7 Build 7601 (Service Pack 1)

Physical memory : 2,867,592 kB (711,868 available)
Paging file : 5,733,468 kB (2,002,004 available)
Virtual memory : 2,097,024 kB (1,907,024 available)

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

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

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

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

Debug file
C:\Users\qaks\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

TNS File
%C:\oracle\instantclient_12_2\tnsnames.ora

Using
Home: C:\oracle
DLL: C:\oracle\instantclient_12_2\oci.dll
OCI: version 12.1 (12.2.0.1.0)

Process
Working Set = 145,354,752
Memory = 34,019,580
GDI Objects = 637
User Objects = 344
Handles = 201

Monitor
PixelsPerInch = 96

Id = 0
Primary = True
Handle = 65537
Left = 0
Top = 0
Width = 1366
Height = 768

MainFormOnTaskbar = False

 

[QAKS]

Hi I am waiting for your response. I have attached the support info in previous post. Please look into the issue

 

[Marco Kalter]

The TNS_ADMIN variable seems to be set to:

%C:\oracle\instantclient_12_2

Note the % at the begin. Can you check the TNS_ADMIN environment variable and correct it?

 

[QAKS]

Hi,
Somehow I added SQLNET.ORA file, which was missing at >network>admin
folder. Issue resolved by adding that file.