Home » RDBMS Server » Networking and Gateways » Connection fail two database with identical sid name on different hosts (oracle 11.2.0.1 on solaris 10)
Connection fail two database with identical sid name on different hosts [message #577583] Mon, 18 February 2013 17:15 Go to next message
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 #577585 is a reply to message #577583] Mon, 18 February 2013 17:34 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>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/
Re: Connection fail two database with identical sid name on different hosts [message #577592 is a reply to message #577583] Tue, 19 February 2013 00:15 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Post results from both hosts(nodes)

tnsping HOFL


Also Please post how you are trying to connect from both machines.

Sriram Sanka
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 Go to previous messageGo to next message
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 #577625 is a reply to message #577621] Tue, 19 February 2013 03:50 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
--- tnsping HOFL From host client over network => error.


Check your network connection to the host machine from client.

ping <host_name> or ping <host-ip_address>

Sriram Sanka
Re: Connection fail two database with identical sid name on different hosts [message #577629 is a reply to message #577621] Tue, 19 February 2013 04:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
My question is , are there a special configuration to set database with same SID trought the same network ?


Nothing special.

Quote:
May be listener or tnsnames.ora is not well done. ?


tnsnames.ora of client most likely but may also be some environment parameters.

Note that one post you say port 1521 and in another one port 1526.
It is hard to diagnose a problem with false information.

Regards
Michel


Re: Connection fail two database with identical sid name on different hosts [message #577637 is a reply to message #577629] Tue, 19 February 2013 05:17 Go to previous messageGo to next message
koff10
Messages: 58
Registered: December 2006
Location: france
Member
Thanks Michel Cadot ,
Of course I changed the port to 1526.( it's not a wrong information).

May be you can try yourself to change in your tnsname.ora two SID to identical SID and see etc...

Koff
Re: Connection fail two database with identical sid name on different hosts [message #577640 is a reply to message #577637] Tue, 19 February 2013 05:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I have no problem with this.

Regards
Michel
Re: Connection fail two database with identical sid name on different hosts [message #577674 is a reply to message #577640] Tue, 19 February 2013 10:18 Go to previous messageGo to next message
koff10
Messages: 58
Registered: December 2006
Location: france
Member
Hi friends,

I finally find the solution.
It's because the system Administrator didn't allow ping to the second hosts.
Now I connect from client to both databases with same SID.

Thanks a lot.
koff
Re: Connection fail two database with identical sid name on different hosts [message #577676 is a reply to message #577674] Tue, 19 February 2013 10:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks to let us know.

Regards
Michel
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 Go to previous message
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.
Previous Topic: Centralized TNSNAMES.ORA
Next Topic: nText columns not showing up in SELECT
Goto Forum:
  


Current Time: Fri Mar 29 09:43:41 CDT 2024