Oracle TNSNAMES.ORA Network Configuration

Oracle TNSNAMES.ORA Network Configuration

Well ... to start I give greetings to all ... I'm going to explain below is nothing new but I hope that will be helpful to whoever finds here ..

Enough blah blah and let us ...

There are several configuration files Oracle network , varying the type of network configuration that is modified use one or the other files ..

I will declare the most typical case ... if we want to be able to connect to the database through the PL / SQL Developer or Oracle SQL DEVELOPER the only file you have to modify is the TNSNAMES ...

As we modify it ? very easy ... open it with any text editor (by the way I recommend notepad + + ) , and what you find will be something like this :

# E: \ V8I \ NETWORK \ ADMIN \ TNSNAMES.ORA Configuration File: E: \ v8i \ network \ admin \ tnsnames.ora

# Generated by Oracle Net8 Assistant

V8I.WORLD =

( DESCRIPTION =

( ADDRESS_LIST =

(ADDRESS = ( PROTOCOL = TCP ) (HOST = CLASSROOM_SERVER ) (PORT = 1521 ) )

)

( CONNECT_DATA =

( SERVICE_NAME = V8I.WORLD )

)

)

REPSERVER1 , REPSERVER1.world = (ADDRESS = ( PROTOCOL = tcp) (HOST = CLASSROOM_SERVER ) (PORT = 1949 ) )

These are the parameters received :

HOST : IP address of the server you want to connect

PORT: Port of the database listener

SERVICE_NAME : name service database to which you want to connect

DESCRIPTION OF CONNECTION : connection description ( in this case is V8I.WORLD )

What we will do is add a new configuration block leaving intact the former , would be more or less as follows:

# E: \ V8I \ NETWORK \ ADMIN \ TNSNAMES.ORA Configuration File: E: \ v8i \ network \ admin \ tnsnames.ora

# Generated by Oracle Net8 Assistant

V8I.WORLD =

( DESCRIPTION =

( ADDRESS_LIST =

(ADDRESS = ( PROTOCOL = TCP ) (HOST = CLASSROOM_SERVER ) (PORT = 1521 ) )

)

( CONNECT_DATA =

( SERVICE_NAME = V8I.WORLD )

)

)

MiConexion =

( DESCRIPTION =

( ADDRESS_LIST =

(ADDRESS = ( PROTOCOL = TCP ) (HOST = xxx.xxx.xxx.xxx ) (PORT = 1521 ) )

)

( CONNECT_DATA =

( SERVICE_NAME = MiConexion )

)

)

REPSERVER1 , REPSERVER1.world = (ADDRESS = ( PROTOCOL = tcp) (HOST = CLASSROOM_SERVER ) (PORT = 1949 ) )

In this case the CONNECT DESCRIPTOR is MiConexion .

Once done nothing more remains for us to test our connection settings ... we can do it using the command TNSPING or trying to make a connection from the PL / SQL or SQL DEVELOPER to the database ...

I hope it was useful ... = )

See Also:

Methods connection to Oracle Database with C# .NET