Solved

Oracle compatability

Posted on 2012-03-21
4
382 Views
Last Modified: 2012-04-26
I am going to be setting up a Windows 2008 R2 server with Oracle 11g Release 2 on it (database and probably client also).

I also have a second application that will run on the same new server which currently uses 9i Client to connect to a remote database (which is 8i).

Is it ok to have both 11g client and database plus the 9i client installed on the same machine? I assume also that the 9i client should be installed in a separate home directory.

Thanks.
0
Comment
Question by:Gandharva_Guy
4 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 37747493
I'm not sure if 9i will install on 2008R2 but if it does, there should be no problems with two clients.  Yes, they need to be in different homes.
0
 
LVL 48

Expert Comment

by:schwertner
ID: 37747856
If you have 11g installed on the windows 2008 server then yo definitelly do not need to install 11g client. 11g client functionalities are part of 11g server.

I will suggest first to check if 11g will be able to connect to remote 8i (add entry in tnsnames.ora, check if the remote node is reachable, if there are no firewalls between).

If the attempt is not successful, then try to install 9i client, or alternativelly 10g client.
Distinguish the tnsnames.ora files in the two separate homes.

Good luck!
0
 
LVL 4

Expert Comment

by:ytarkan
ID: 37753551
Never mentioned the Windows 32/64 bit, but I would like to remind that if the secondary application (the one already uses 9i client assuming to be an older software) is 32 bit, it can only make use of 32-bit 11g,10g or 9i client. just a remark.
0
 

Author Comment

by:Gandharva_Guy
ID: 37898261
Well, as it turns out, 9i Client gave a warning about known issues when attempting to install on 2008 R2 so we cancelled it and ended up installing 9i Client on another server with 2003 R2 on it instead. Thanks for all the comments, all very good. I'll give the points to the first poster since it was closest to what actually happened.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question