Oracle XE 11.2.0 and VW7.10.1 linux setup

Hello,

I'm seeing "Database client libraries are inaccessible" exception and I was wondering what I could be missing in my Oracle database setup. Here is what I did:

- installed oracle-xe-11.2.0-1.0.x86_64.rpm.zip
- installed oracle-instantclient12.1-basic-12.1.0.2.0-1.i386.rpm and oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
- started Oracle and created a new table
- started VW7.10.1 with the following environment variables exported:
    - export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
    - export LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/xe/lib
- loaded OracleEXDI parcel
- executed in Workspace:

conn := OracleConnection new.
conn environment: 'localhost'.
conn username: 'system'.
conn password: '********'.
conn connect.

First of all you should run oracle 64 bit with VW 64 bit and the 32XE with VW 32.

 

The connection string for 11.2 XE is XE and not local host.

 

For login at least the proposed SYSTEM installation login should work.

 

You don't need to specify the exports you stated.

 

Regards,

 

 

Maarten MOSTERT

 

 

28 Av Alphonse Denis

83400 Hyères, France

+33 676411296 

http://stakepoint.com/

 

> "Deyan Yanchev" <[hidden email]> |

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

IIRC, Oracle installs separate 32-bit and 64-bit client directories and there's a trick with how it names them. If you are using a 32-bit version of VisualWorks, you may need to change your path to use "/lib32" instead of "lib".
Dave

-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On Behalf Of Deyan Yanchev
Sent: Tuesday, March 24, 2015 8:30 AM
To: [hidden email]
Subject: [vwnc] Oracle XE 11.2.0 and VW7.10.1 linux setup

Hello,

I'm seeing "Database client libraries are inaccessible" exception and I was
wondering what I could be missing in my Oracle database setup. Here is what
I did:

- installed oracle-xe-11.2.0-1.0.x86_64.rpm.zip
- installed oracle-instantclient12.1-basic-12.1.0.2.0-1.i386.rpm and
oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
- started Oracle and created a new table
- started VW7.10.1 with the following environment variables exported:
    - export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
    - export LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/xe/lib
- loaded OracleEXDI parcel
- executed in Workspace:

conn := OracleConnection new.
conn environment: 'localhost'.
conn username: 'system'.
conn password: '********'.
conn connect.



--
View this message in context: http://forum.world.st/Oracle-XE-11-2-0-and-VW7-10-1-linux-setup-tp4814817.html
Sent from the VisualWorks mailing list archive at Nabble.com.
_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

Sorry, I missed maarten's earlier response where he already indicated my point. To clarify further, it's your LD_LIBRARY_PATH env variable which needs the "32" indicator, if memory serves.

-----Original Message-----
From: Wallen, David
Sent: Tuesday, March 24, 2015 10:22 AM
To: Deyan Yanchev; [hidden email]
Subject: RE: [vwnc] Oracle XE 11.2.0 and VW7.10.1 linux setup

IIRC, Oracle installs separate 32-bit and 64-bit client directories and there's a trick with how it names them. If you are using a 32-bit version of VisualWorks, you may need to change your path to use "/lib32" instead of "lib".
Dave

-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On Behalf Of Deyan Yanchev
Sent: Tuesday, March 24, 2015 8:30 AM
To: [hidden email]
Subject: [vwnc] Oracle XE 11.2.0 and VW7.10.1 linux setup

Hello,

I'm seeing "Database client libraries are inaccessible" exception and I was
wondering what I could be missing in my Oracle database setup. Here is what
I did:

- installed oracle-xe-11.2.0-1.0.x86_64.rpm.zip
- installed oracle-instantclient12.1-basic-12.1.0.2.0-1.i386.rpm and
oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
- started Oracle and created a new table
- started VW7.10.1 with the following environment variables exported:
    - export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
    - export LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/xe/lib
- loaded OracleEXDI parcel
- executed in Workspace:

conn := OracleConnection new.
conn environment: 'localhost'.
conn username: 'system'.
conn password: '********'.
conn connect.



--
View this message in context: http://forum.world.st/Oracle-XE-11-2-0-and-VW7-10-1-linux-setup-tp4814817.html
Sent from the VisualWorks mailing list archive at Nabble.com.
_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc