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)
Connecting 2 databases from SQL8.0 to DB on Oracle 9.2 [message #294992] Mon, 21 January 2008 02:04 Go to next message
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 1644 times)
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition, only client version 8.0.6 was certified to connect to a 9.2 instance.

Regards
Michel
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why? What is the rationale in this answer?

Regards
Michel
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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 1338 times)
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 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Unable to understand
Next Topic: USE_SHARED_SOCKET in oracle 9i and 10g release 2
Goto Forum:
  


Current Time: Thu Mar 28 06:38:44 CDT 2024