Does anyone know how to install BO 5.0 in Win95 environment using Personal Oracle8?? I think the problem I am having is due to the fact that ‘Personal Oracle’ does not use a ‘connect string’ and this seems to be important in installing/setting up BO in secure/supervisor mode. I want to be able to have client and server on the same machine — this works fine for Personal Oracle and Oracle Developer/Designer.
Any help getting around the ‘connect string’ issue would be greatly appreciated.
Wayne wrote
Does anyone know how to install BO 5.0 in Win95 environment using Personal
Oracle8?? I think the problem I am having is due to the fact that ‘Personal
Oracle’ does not use a ‘connect string’ and this seems to be important in
installing/setting up BO in secure/supervisor mode. I want to be able to
have client and server on the same machine — this works fine for Personal
Oracle and Oracle Developer/Designer.
Any help getting around the ‘connect string’ issue would be greatly appreciated.
Have had similar problems with Personal 7.3.4 and BO 4.1.3 although these were solved by installing Net8. What worked then was running the Net8 Easyconfig (or create the TNSNAMES directly), create an alias for beq_local.world as whatever and put that alias in the connect string. I am finding BO 5.0 less happy about connecting to Oracle Personal than BO 4.x. Am currently in the process of installing Personal 8.0.4 so may find out myself.
Jonathan Bliss, Product Consultant
McKessonHBOC Computer Centre, Harold Wood Hospital site, Gubbins Lane, Romford, RM3 0NE
mobile:0498 668084, tel 01708 336135 (direct line with voicemail), fax 01708 376270
Does anyone know how to install BO 5.0 in Win95 environment using Personal
Oracle8?? I think the problem I am having is due to the fact that ‘Personal
Oracle’ does not use a ‘connect string’ and this seems to be important in
installing/setting up BO in secure/supervisor mode. I want to be able to
have client and server on the same machine — this works fine for Personal
Oracle and Oracle Developer/Designer.
Have you set up a listener. I have now managed to set up a working listener with an alias, although I have used the TCP-Loopback not the BEQ.local. I am having a problem that I cannot solve now (anyone else?) I get ORA-01019 when I try and connect using Business Objects 5.0. This doesn’t happen with Oracle client tools. The error text is
ORA-01019: unable to allocate memory in the user side Cause: The user side memory allocator returned an error. Action: Increase the size of the process heap or switch to the old set of calls.
This means nothing to me. If you can get this any further it would be great.
Jonathan Bliss, Product Consultant
McKessonHBOC Computer Centre, Harold Wood Hospital site, Gubbins Lane, Romford, RM3 0NE
mobile:0498 668084, tel 01708 336135 (direct line with voicemail), fax 01708 376270
With Personal Oracle 7.x, using the following as the connection string for the server worked:
2:
(a number two followed by a colon).
I suspect it will also work with Oracle 8, but I haven’t tried.
In a message dated Tue, 18 Jan 2000 12:40:27 PM Eastern Standard Time, Luis Gonzalez LGonzalez@BUSINESSOBJECTS.COM writes:
Hi, Wayne.
With Personal Oracle 7.x, using the following as the connection string for the server worked:
2:
(a number two followed by a colon).
I suspect it will also work with Oracle 8, but I haven’t tried.
Cheers,
Luis Gonzalez
Hi, Luis:
I have tried this with Personal Oracle 8, and it didn’t work. However, I only tried once.
I ended up reinstalling Personal Oracle 7 which works just fine with the connection 2: as you suggested.
Wayne wrote:
Does anyone know how to install BO 5.0 in Win95 environment using Personal Oracle8?? I think the problem I am having is due to the fact that ‘Personal Oracle’ does not use a ‘connect string’ and this seems to be important in installing/setting up BO in secure/supervisor mode. I want to be able to have client and server on the same machine — this works fine for Personal Oracle and Oracle Developer/Designer.
I replied
Have you set up a listener. I have now managed to set up a working listener with an alias, although I have used the TCP-Loopback not the BEQ.local. I am having a problem that I cannot solve now (anyone else?) I get ORA-01019 when I try and connect using Business Objects 5.0. This doesn’t happen with Oracle client tools. The error text is ORA-01019: unable to allocate memory in the user side.
I now have learned the following from Oracle and BO help desks. With oracle bequeath local will work with a single home but with multiple homes (which I need as Personal 8.0 for Win95 is only available in 8.0.4 while Developer6 comes as 8.0.5) you must use TCP lookup which requires a listener to be set up and started. The ORA-01019 is because there is more than one copy of the ociw32.dll, rename ociw32.dll in the windows\system so the system uses the one in the Oracle bin directory.
Jonathan Bliss, Product Consultant
McKessonHBOC Computer Centre, Harold Wood Hospital site, Gubbins Lane, Romford, RM3 0NE
mobile:0498 668084, tel 01708 336135 (direct line with voicemail), fax 01708 376270
