8.1.7 & 9.2.04 co-existence

[ingresman]

Hello all,

This is my first post into the Oracle world, so please be easy on me !.

I've got a situation on XP where I need to have an install of 8.1.7 and 9.2.04.

According to the Oracle documentation these can co-exist in seperate Oracle homes.

My first question is what really is an Oracle Home?. I'm assuming that Oracle home is the default of c:\oracle and so my two installs would look like c:\oracle\ora81 and c:\oracle\ora92. My confusion starts here, the documentation says they have to exist in seperate Oracle homes. Does this meant that the directory structure would like that above or something like:
c:\oracle8\ora8i and c:\oracle9\ora9i

Having got everything installed I need to establish if two seperate process can run concurently one conected to each version. I knw this will need manipulation of the PATH.

I've got a few more questions but I don't want to be cheeky and flood a single post.

Any help is very gratefully recieved

 

[KenCunningham]

Hi and welcome. I'm more familiar with Oracle on unix systems I'm afraid. However, the basic principles are similar in that you will need two Oracle Homes, identified as say c:\oracle\ora817 and c:\oracle\ora92 as you have identified above. These will be where the different versions of the software will be installed. Your PATH will be different for each Oracle Home and you will need listeners set up for each too.

 

[sem]

I suppose that c:\oracle is referred as Oracle Base, not Oracle Home. The recommended folder structure is c:\oracle\product\<specific product name>, but in general you may install them to any separate folders.

Regards, Dima

http://seminihin.narod.ru

 

[Turkbear]

Hi,
Are you installing the client or a full database instance ( not really recommended )?

If just the client, why do you need 2 versions? The 9.2 client ( and its tools) can access all Oracle versions after 8.0...






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[ingresman]

it's only the client.
For many and varied sad reasons we still run 7.3 on NT4.
This will be the position for at least 12 months.
I've got a call open with Oracle, I'll keep you informed

 

[Turkbear]

Hi,
Then, as long as you install the V8 first, then the v9 ( in separate directories ( as has been mentioned), it should work fine..For some actions you will need to change the Default Home that Oracle uses...There will be a utility installed ( with 9) that will allow that( under Oracle Installation Products - called Home Selector)..






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[ingresman]

It seems that a package called ADI is doing something to the install of 8.1.7.

I've written a little C procedure which prepends 8.1.7 to the path and then invokes the windows app, this should work accordign to the documentation but it's this other issue which is doing the damage.

Hopefuly Oracle will save the day !

#include <stdio.h>
#include <string.h>
#include <windows.h>

int main(int argc, char* argv[])
{
 STARTUPINFO si;
 PROCESS_INFORMATION pi;

 int i;													
 BOOL fSuccsess;

 
 char oSystemPath[2000];
 char* pSystemPath;
 char newPath[2000]; 
 char sCommand[1000];

 pSystemPath=oSystemPath;

 fSuccsess = GetEnvironmentVariable("path",oSystemPath,2000);	  
 strcpy(newPath,argv[1]);
 strcat(newPath,";");
 strcat(newPath,pSystemPath);
 ZeroMemory(&pi,sizeof(PROCESS_INFORMATION));
 ZeroMemory(&si,sizeof(STARTUPINFO));
 si.cb = sizeof(STARTUPINFO);
 SetEnvironmentVariable("Path",newPath);
 fSuccsess = CreateProcess(NULL,argv[2],NULL,NULL,TRUE,0,NULL,NULL,&si,&pi);
}