| Connection fail two database with identical sid name on different hosts [message #577583] |
Mon, 18 February 2013 17:15  |
koff10
Messages: 58
Registered: December 2006
Location: france
|
Member |
|
|
Hi friends,
I know, there is topic like this in this forum but may be I didn't understand .
Here is the situation:
My production database server is cloned for test environnement .
I kept the same name of SID for both environnement but on different hosts.
I got error when try to connect to test database : TNS:protocol adapter error.
Is somebody can help me to solve this problem ?
Below the the TNSNAMES.ORA files:
----- production host ---
HOFL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = asus-sol)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = HOFL.ACC.com)
)
)
---- test host---
HOFL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = asus-sol2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = HOFL.ACC.com)
)
)
Thanks
koff
|
|
|
|
|
|
|
|
| Re: Connection fail two database with identical sid name on different hosts [message #577621 is a reply to message #577585] |
Tue, 19 February 2013 03:05  |
koff10
Messages: 58
Registered: December 2006
Location: france
|
Member |
|
|
BlackSwan wrote on Tue, 19 February 2013 00:34>I got error when try to connect to test database : TNS:protocol adapter error.
so you say.
We don't know from which system you claim the error occurred.
I don't know what you have.
I don't know what you do.
I don't know what you see.
It is really, Really, REALLY difficult to fix a problem that can not be seen.
use COPY & PASTE so we can see what you do & how Oracle responds.
Please read and follow the forum guidelines, to enable us to help you:
http://www.orafaq.com/forum/t/88153/0/
Thanks for reply BlackSwan,
Everything work fine when I try to connect to every database with sqlplus on every host.
But i got erreur when I use external client( sqldeveloper, sqldbx etc ...) to connect to each database (over the network).
My question is , are there a special configuration to set database with same SID trought the same network ? May be listener or tnsnames.ora
is not well done. ?
--tnsping HOFL from the host is OK.
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = asus-sol2)(Port = 1526))) (CONNECT_DATA = (SID = HOFL)))
OK (10 msec)
--- tnsping HOFL From host client over network => error.
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = asus-sol2)(Port = 1526))) (CONNECT_DATA = (SID = HOFL)))
TNS-12560: TNS:protocol adapter error.
koff
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Connection fail two database with identical sid name on different hosts [message #593089 is a reply to message #577583] |
Wed, 14 August 2013 00:40 |
 |
jbarnard
Messages: 2
Registered: August 2013
Location: New Zealand
|
Junior Member |
|
|
----- production host ---
HOFL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = asus-sol)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = HOFL.ACC.com)
)
)
---- test host---
HOFL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = asus-sol2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = HOFL.ACC.com)
)
)
The first parameter ( HOFL =) is an alias so just make the alias different.
----- production host ---
HOFL_PROD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = asus-sol)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = HOFL.ACC.com)
)
)
---- test host---
HOFL_TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = asus-sol2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = HOFL.ACC.com)
)
)
If there are 2 or more same named aliases in tnsnames.ora, the last one will be used.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
