Home » RDBMS Server » Networking and Gateways » TNSNAMES.ORA (ORACLE 10G)
TNSNAMES.ORA [message #309791] Fri, 28 March 2008 17:00 Go to next message
softfarr
Messages: 1
Registered: March 2008
Junior Member
Dear Sirs & Mrs's:

My scenario: I have a laptop with WXPPRO + Ora10gEnterprise + 1 local instance and a server with W2003SRV + Ora10gEnterprise + 4 remote instances.

I can´t work simultaneously with 5 instances. I patched tnsnames.ora to work with 1 instance at a time, commenting lines, something like this:

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

Sorem =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
# (ADDRESS = (PROTOCOL = TCP)(HOST = orion)(PORT = 1521))
# (ADDRESS = (PROTOCOL = TCP)(HOST = castor)(PORT = 1521))
# (ADDRESS = (PROTOCOL = TCP)(HOST = polux)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = Sorem)
# (SERVICE_NAME = instant1)
# (SERVICE_NAME = instant2)
# (SERVICE_NAME = ada_orion)
# (SERVICE_NAME = ada_sicof)
)
)

This because of the clients must have named Sorem, as a fix term, but service_name not. Developers design bug; they must have used a .INI file to surpass this.

How can I have multiple tnsnames.ora files, to work simultaneously with my 5 instances?

Thanks in advance.

SoftFARR
Re: TNSNAMES.ORA [message #309793 is a reply to message #309791] Fri, 28 March 2008 18:35 Go to previous message
BlackSwan
Messages: 22790
Registered: January 2009
Senior Member
Sorem=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT =1521)))(CONNECT_DATA=(SERVICE_NAME=Sorem)))
Instant1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=orion)(PORT =1521)))(CONNECT_DATA=(SERVICE_NAME=Instant1)))
etc........

All databases are specified in a single TNSNAMES.ORA file.

[Updated on: Fri, 28 March 2008 18:36] by Moderator

Report message to a moderator

Previous Topic: SID
Next Topic: CMAN parameters meaning (was: "Would you like to explain more?")
Goto Forum:
  


Current Time: Thu Sep 18 23:26:56 CDT 2014

Total time taken to generate the page: 0.12515 seconds