Your question is not exactly clear. If you are asking how to connect to a remote database, you need to add the database information into the tnsnames.ora file found in the Instance_Home\config directory
Thanks to reply,My mean was that.I want to connect remote database(network is client server network created locally using LAN/Wi-Fi). Please give the structure of tnsnames.ora file to connect remote database.
1 person found this helpful
In most cases you can copy the same entry found in the tnsnames.ora file used by the database. In the database home, the file can be found in \network\admin. Open the file and you should find something like this:
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.100)(PORT = 1521))
(SERVICE_NAME = orcl)
So in the above, you would need to set the alias (this can be anything you like), the IP address or hostname of the machine where the database is running, the port number used by the db listener, and the service name used by the db. Most of this will already be set for you if you are copying from the database tnsnames.ora. So you should be able to just copy and paste. More information about the tnsnames.ora file can be found in the db documentation: