PL/SQl developer via Citrix connection

[Sanjay]

Hi All,

This is my first post in this forum.

I am facing an issue in logging into PL/SQL developer as its showing no database connection strings in the drop down.

My question here is, if I install PL/SQL developer on my machine, then from Oracle home it directly takes the connection string from tnsnames.ora without mentioning explicitly.
Another thing is if I install PL/SQL developer on machine and trying to access via Citrix, then from where it will take the connection strings.

Thanks & Regards
Sanjay

 

[Marco Kalter]

PL/SQL Developer will always extract the database list from the tnsnames.ora file from the Primary Oracle Home. This is no different on a Citrix setup or a local PC.

You can verify this through Help > Support Info.

 

[Sanjay]

Thanks a lot Marco for reply.

Could you please tell, in case of Citrix connection, the tnsnamse.ora file should be on Local machine or Remote machine on which citrix is involved.

Does Oracle client is required on the local machine also or it should be on the remote machine only.

Thanks & Regards

 

[Marco Kalter]

The tnsnames.ora file needs to be on the remote machine, where PL/SQL Developer and the Oracle Client are running.