changing tnsnames.ora from within PLSQL Dev

[ken ortiz]

Hi,
It's always been easy for me to directly change my tnsnames.ora file if needed. However, due to recent policy and network changes in our environment, I no longer have certain configuration privileges on my PC, and that apparently includes editing my local tnsnames.ora file. Is there a way for me to make changes to the tnsnames settings within PL/SQL, without directly editing the file? In this instance, I need to change a host name and port number.

 

[Marco Kalter]

You can create a local directory and copy the tnsnames.ora and sqlnet.ora file. To use this directory in PL/SQL Developer you can edit the Params.ini file in the PL/SQL Developer installation directory and add the following line:

TNS_ADMIN=your_local_TNS_directory

Now you can edit your local tnsnames.ora file as needed.