Home » RDBMS Server » Server Administration » Connect to either Oracle 9.2 or Oracle 10g ...
Connect to either Oracle 9.2 or Oracle 10g ... [message #128759] Wed, 20 July 2005 08:26 Go to next message
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 Go to previous messageGo to next message
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.

Re: Connect to either Oracle 9.2 or Oracle 10g ... [message #128784 is a reply to message #128766] Wed, 20 July 2005 10:23 Go to previous messageGo to next message
OracleTest
Messages: 9
Registered: July 2005
Location: Canada
Junior Member
thank you for the information.
Re: Connect to either Oracle 9.2 or Oracle 10g ... [message #128789 is a reply to message #128759] Wed, 20 July 2005 10:53 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Not a problem, and a good question to be asking given your situation.
Previous Topic: What authentication?
Next Topic: Tablespace/Database fragmentation
Goto Forum:
  


Current Time: Fri Jan 10 08:08:37 CST 2025