Ask the Expert

Different applications to connect to different Oracle versions

There are about three different applications that I use to connect with Oracle. The problem is that each one is required to connect with a different Oracle version (8i, 9i and 10g). Is there a way to have all three applications running on the same computer?

    Requires Free Membership to View

If each application requires a different version of Oracle, then you can install all three versions of Oracle on the same server. Just make sure you install each software version in their own, separate ORACLE_HOME directory. You can then create three databases, one of each of the three versions. You will want to make sure that you follow the Optimal Flexible Architecture (OFA) guidelines to ensure that each version does not interfere with the other versions. You can find a copy of the OFA here.

This was first published in February 2006

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: