OraFAQ Forum: Networking and Gateways » Connecting 2 databases from SQL8.0 to DB on Oracle 9.2

Home » RDBMS Server » Networking and Gateways » Connecting 2 databases from SQL8.0 to DB on Oracle 9.2 (Oracle 9.2 SQL client 8.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connecting 2 databases from SQL8.0 to DB on Oracle 9.2 [message #294992]

Mon, 21 January 2008 02:04

lokeshonline
Messages: 29
Registered: April 2006

Junior Member

I have created two databases on Oracle 9.2 on Win2000. One is COVTEST and other is COVTEST2 (same instance name). Here I am sending you tnsnames.ora file. This file is opening connections with both the database while connecting from SQL client 9.2. But if I connect from a machine which has only oracle client 8.0 or Form 6 it connects with COVTEST but it does not connect with COVTEST2. It gives error "ORA-12203: TNS:unable to connect to destination"
What can be the reason? Please help

Attachment: tnsnames.ora
(Size: 1.09KB, Downloaded 2020 times)

Report message to a moderator

Re: Connecting 2 databases from SQL8.0 to DB on Oracle 9.2 [message #294997 is a reply to message #294992]

Mon, 21 January 2008 02:11

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-12203: TNS:unable to connect to destination
 *Cause: Invalid address specified or destination is not listening.
 This error can also occur because of underlying network or network
 transport problems.
 *Action: Verify that the net service name you entered was correct.
 Verify that the ADDRESS portion of the connect descriptor which
 corresponds to the net service name is correct.  Ensure that the
 destination process (for example the listener) is running at the
 remote node.

Start with checking that.

Regards
Michel

Report message to a moderator

Re: Connecting 2 databases from SQL8.0 to DB on Oracle 9.2 [message #294998 is a reply to message #294992]

Mon, 21 January 2008 02:15

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

In addition, only client version 8.0.6 was certified to connect to a 9.2 instance.

Regards
Michel

Report message to a moderator

Re: Connecting 2 databases from SQL8.0 to DB on Oracle 9.2 [message #295006 is a reply to message #294992]

Mon, 21 January 2008 02:34

jkirankumar_307@yahoo.com
Messages: 12
Registered: April 2007

Junior Member

Hi Lokesh,

Instead of using SID use SERVICE_NAME...

COVTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = CITRIX10)(Port = 1521))
)
(CONNECT_DATA =
/* (SID = COVTEST) */
(SERVICE_NAME = COVTEST) )
)

COVTEST2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = CITRIX10)(Port = 1522))
)
(CONNECT_DATA =
/* (SID = COVTEST) */
(SERVICE_NAME = COVTEST) )
)

Probably it will work

Please Let me know..

Kiran

Report message to a moderator

Re: Connecting 2 databases from SQL8.0 to DB on Oracle 9.2 [message #295011 is a reply to message #295006]

Mon, 21 January 2008 02:37

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why? What is the rationale in this answer?

Regards
Michel

Report message to a moderator

Re: Connecting 2 databases from SQL8.0 to DB on Oracle 9.2 [message #295015 is a reply to message #294992]

Mon, 21 January 2008 02:46

jkirankumar_307@yahoo.com
Messages: 12
Registered: April 2007

Junior Member

Hi Lokesh,

Can U send the details of listener.ora file..

As per tnsnames you are using two port numbers (1521 and 1522)
let me check...

SID corresponds to Oracle Instance Identifier (usually Database name)Service_Name corresponds to Global Database name in the Oracle9i listener

SERVICE_NAMES specifies one or more names for the database service to which this instance connects. You can specify multiple service names in order to distinguish among different uses of the same database.

Kiran

Report message to a moderator

Re: Connecting 2 databases from SQL8.0 to DB on Oracle 9.2 [message #295074 is a reply to message #295015]

Mon, 21 January 2008 04:42

lokeshonline
Messages: 29
Registered: April 2006

Junior Member

I am sending as an attachment listener.ora. I tried service_name but it did not work. I want to mention again that same tnsnames works fine if I connect through SQL client 9.2 but if I connect through SQL client 8.0.5 it connects only to COVTEST but not COVTEST2. In addition please note that COVTEST and COVTEST2 are two separte databases with instance_name COVTEST and COVTEST2 respectively.

It should either not connect with any database from SQL 8.0 or it should connect with both databases.

Please help.

Attachment: listener.ora
(Size: 0.93KB, Downloaded 1707 times)

Report message to a moderator

Re: Connecting 2 databases from SQL8.0 to DB on Oracle 9.2 [message #295082 is a reply to message #295074]

Mon, 21 January 2008 05:00

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

It should either not connect with any database from SQL 8.0 or it should connect with both databases.

Your assumption is wrong above all in a not supported environment.

Regards
Michel

Report message to a moderator

Previous Topic:	Unable to understand
Next Topic:	USE_SHARED_SOCKET in oracle 9i and 10g release 2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 19 17:21:49 CST 2025