Pl_Sql_Developer throw ORA12154 (Oracle Serv x64 with x32 Oracle Client)

sashasave

Member
Hi,
I use PL/SQL Developer version 8.0.2.1505. Recently I've instlalled Oracle Server x64 at OS Win7x64 and x32 Oracle Client, but when I try to connect to my database PL/SQL throws error "ORA-12154 TNS:could not resolve the connect identifier specified" .
After several hours a internet surfing the problem is actually

What already done:
1) reinstalled ORacle into 2 separated folders:
Server x64(G:\oracle) and Oracle Client x32(G:\oracleclient)
2) Reinstall PL/SQL Developer into folder C:\PL SQL Developer
3) tnsping and slqplus connects are OK.
4) set the Enviroments variable TNS_ADMIN with value "G:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN"

Please help, any suggestion.

below information from Help - Support Info
 
Last edited:
PL/SQL Developer
Version 8.0.2.1505
18253.6877 - Unlimited user license
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

Parameters
C:\PL_SQL_Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library: G:\oracleclient\product\11.2.0\client_1\bin\oci.dll
Use OCI7: False

Preference Files
C:\PL_SQL_Developer\Preferences\Default\Default.ini
C:\Users\Alex\AppData\Roaming\PLSQL Developer\Preferences\Alex\default.ini

Plug-Ins

Aliases
ORACLR_CONNECTION_DATA
ORADBASE

Homes
OraClient11g_home5 (G:\oracleclient\product\11.2.0\client_1)

DLLs
G:\oracleclient\product\11.2.0\client_1\bin\oci.dll

TNS File
G:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora

Using
Home: OraClient11g_home5
DLL: G:\oracleclient\product\11.2.0\client_1\bin\oci.dll
OCI: version 11.1
 
Last edited:
Yes , connection is successful.

SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 18 15:08:55 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: system/sys@oradbase

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
 
It's work!!
While reinstalling Oracle Server I changed the database name , but in the login developer frame I staticly wrote the old service_name.
I'm crazy )
 
Back
Top