1

Can I create a connection without modifying tnsnames.ora?

I have a db in a remote server which is accesible using ping or telnet. However, I don't have the permissions to modify the tnsnames.ora file.

How could I access the db using PL/SQL Developer?

John Willmer Cubillos Vega
  • 21
  • 1
  • 6
  • Yes you can google "oracle connection string without tnsnames" and you will see some options – OldProgrammer Jul 05 '19 at 17:49
  • 3
    You can create a `tnsnames.ora` file in your home directory. With environment variable `TNS_ADMIN` you can point to any folder. – Wernfried Domscheit Jul 05 '19 at 18:04
  • 2
    You can try something like [this](https://stackoverflow.com/a/1833413/2856136), which basically uses Oracle's [EZCONNECT](http://www.orafaq.com/wiki/EZCONNECT) method. – Shawn Mire Jul 06 '19 at 05:27

1 Answers1

1

You can also write the whole connect string in the "database" field (you must edit it in order to be on a single line of text), instead of using its alias defined in tnsnames.ora

Like in this example: Like this

Carlo Sirna
  • 1,201
  • 6
  • 11