Connect to either Oracle 9.2 or Oracle 10g ... [message #128759] |
Wed, 20 July 2005 08:26 |
OracleTest
Messages: 9 Registered: July 2005 Location: Canada
|
Junior Member |
|
|
Hi,
I am an application tester and not Oracle savvy. We have to test the application works fine on both Oracle 9.2 and Oracle 10g. Both Oracle versions instances (DB92 & DB10g) are in another external machine. I have both Oracle clients installed on my machine. To test my application, I have to first copy the classes12.jar (either the 9.2 or 10g) to my application folder. Both tnsnames.ora files have the same entries.
When I connect my application to Oracle 9.2 using the service name from my tnsnames.ora, how can I be certain that Oracle 9.2 is the default 'Oracle' running and the application is using this version's lib and stuff ????
Any help is appreciated.
Thank you.
|
|
|
Re: Connect to either Oracle 9.2 or Oracle 10g ... [message #128766 is a reply to message #128759] |
Wed, 20 July 2005 09:14 |
smartin
Messages: 1803 Registered: March 2005 Location: Jacksonville, Florida
|
Senior Member |
|
|
MYDBA@ORCL > select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Prod
PL/SQL Release 10.1.0.4.0 - Production
CORE 10.1.0.4.0 Production
TNS for 32-bit Windows: Version 10.1.0.4.0 - Production
NLSRTL Version 10.1.0.4.0 - Production
5 rows selected.
|
|
|
|
|