| TNSNAMES.ORA [message #309791] |
Fri, 28 March 2008 17:00  |
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  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
