"//localhost/testdb" in tnsnames.ora [message #619710] |
Thu, 24 July 2014 12:32 |
PMSLIC
Messages: 1 Registered: March 2009
|
Junior Member |
|
|
We've been setting up a backup system in our environment. Most databases connect fine. There are some that dont and we were told to use the following entry in our tnsnames.ora and it works fine. I've been trying to find documentation to explain it so I understand it but can't find it. Can someone here explain it to me or point me to the right documentation?
What work on some but not in other:
TESTDB.MYDOMAIN.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MYSERVER)(PORT = 1521))
)
(CONNECT_DATA =
(SID = TESTDB)
)
)
This is what they used for those not working:
//localhost/TESTDB.MYDOMAIN.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MYSERVER)(PORT = 1521))
)
(CONNECT_DATA =
(SID = TESTDB)
)
)
|
|
|
|
|