Connecting to Oracle 10RAC from Orace 9 client 2005-03-23 - By Robert Scheckle
Paul;
The following is my tnsnames entries from 9.2.0.5 Client to a 2 node
9.2.0.5 RAC Cluster:
## PROPBM Production. Load Balanced.
PROD (DESCRIPTION (LOAD_BALANCE=ON)
(FAILOVER=ON)
(ADDRESS_LIST (ADDRESS = (PROTOCOL = TCP)(HOST = hostnameN1)(PORT =
xxxxx))
(ADDRESS = (PROTOCOL = TCP)(HOST = hostnameN2)(PORT = yyyyy))
)
(CONNECT_DATA (SERVER = DEDICATED)
(SERVICE_NAME = prod.mxgroup.co.za)
(FAILOVER_MODE = (TYPE = select)(METHODēsic))
)
)
## PROPBM Production instance on mxpbmdbn1
PRODN1 (DESCRIPTION (ADDRESS_LIST (ADDRESS = (PROTOCOL = TCP)(HOST
= hostnameN1)(PORT = xxxxxx))
)
(CONNECT_DATA (SERVER = DEDICATED)
(SERVICE_NAME = prod.mxgroup.co.za)
(INSTANCE_NAME = prodN1)
)
)
## PROPBM Production instance on mxpbmdbn2
PRODN2 (DESCRIPTION (ADDRESS_LIST (ADDRESS = (PROTOCOL = TCP)(HOST
= hostnameN2)(PORT = yyyyyy))
)
(CONNECT_DATA (SERVER = DEDICATED)
(SERVICE_NAME = prod.mxgroup.co.za)
(INSTANCE_NAME = prodN2)
)
)
Robert Scheckle
Database Administrator
__ ____ ____ ____ ____
MxO Information Systems
T: +27 (0)12 673 8139
E: roberts@(protected)
-- --Original Message-- --
From: Paul [mailto:paul@(protected)]
Sent: 23 March 2005 08:48
To: suse-oracle@(protected)
Subject: [suse-oracle] Connecting to Oracle 10RAC from Orace 9 client
Hi All,
We are doing some pelminary testing on some new hardware/software and we
are
hoping to be able to connect to an Oracle 10RAC from our standard Oracle
9
Libraries.
We have a large number of systems that have the Oracle 9.2 client
install
and is working on our current Oracle9 installation. We are trying to
connect
to the cluster with the Oracle9 client and not having succcess, we
generally
just get the TNS error saying "ORA-12154 (See ORA-12154.ora-code.com): TNS:could not resolve service
name". Has anyone had any sucess connecting to a 10 (or even 9 RAC) from
their standard Oracle 9 runtime libaries, if so what do you have in your
tnsnames.ora file?
Thanks
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
>>>
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
