Oracle XE 11.2.0 and VW7.10.1 linux setup

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Oracle XE 11.2.0 and VW7.10.1 linux setup

Deyan Yanchev
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.
Reply | Threaded
Open this post in threaded view
|

Re: Oracle XE 11.2.0 and VW7.10.1 linux setup

Maarten Mostert

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]> |

> 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
Reply | Threaded
Open this post in threaded view
|

Re: Oracle XE 11.2.0 and VW7.10.1 linux setup

Wallen, David
In reply to this post by Deyan Yanchev
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
Reply | Threaded
Open this post in threaded view
|

Re: Oracle XE 11.2.0 and VW7.10.1 linux setup

Wallen, David
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