Easy Connect Naming Method with PL/SQL Developer possible?

[martchou]

Hello,

is it possible to use Easy Connect Naming Method with PLCSLDeveloper?

CONNECT username/password@[//]host[:port][/service_name]

When yes - how to enter service_name into the "Oracle Logon" Popup-Window?

Thank you.
Valeri

 

[CTzen]

Valeri,

yes, it works with Oracle Client 10g.

In Database field you'll need to enter
//server_host/service_name

 

[martchou]

Originally posted by CTzen:
Valeri,

yes, it works with Oracle Client 10g.

In Database field you'll need to enter
//server_ip/service_name

Hm, work it only with full Oracle Client Installation?...
I'm use Oracle InstantClient 10.2.0.2, and when trying to connect:
ORA-12154: TNSer Servicename konnte nicht aufgel

 

[CTzen]

It should work with instant client too.

Just check service name, connect to db and run query

select * from global_name;

then try returned value as 'service_name'.

 

[martchou]

Originally posted by CTzen:
It should work with instant client too.

Just check service name, connect to db and run query

select * from global_name;

then try returned value as 'service_name'.

Thank you - it work after i set the path to the oci.dll in the settings (path to the 10.2-library was not detected properly from PLSQL-Dev).

Valeri