Quantcast

Connecting to Oracle

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Connecting to Oracle

Justin Dennis-3
Hi -

Does anyone know the secret to connecting to an Oracle datasource from Mac
Lasso 9.2?

Following these instructions, I added the Oracle instant client:
http://lassoguide.com/server/datasource-setup.html?
highlight=oracle#datasource-setup-oracle

(The docs reference 10.0.2.4, but I think is should read 10.2.0.4?)

After installing the files, I attempted to adding the datasource in Lasso
Admin. On save, Lasso crash. I then tried using just inline with the host
parameter specifying the connection. Same result - Lasso crash.

I then tried downloading and using the latest instant client for 64-bit
intel. Same result - Lasso crash.

The last line I saw in the log file had something to do with "JVM".

I am on Mac OS X 10.8 with Lasso 9.2.7. I do have another Lasso instance on
Mac OS X 10.11 with Lasso 9.3 if that might help anything.

Thanks in advance for any pointers.

- Justin

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Connecting to Oracle

Eric Knibbe-2
Oracle libs have been troublesome, to say the least. Fortunately things seem to have improved with the release of Instant Client 12.

There's four versions of the Basic libs for Mac at the download page <http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html>:
        - instantclient-basic-10.2.0.4.0-macosx-x64.zip
        - instantclient-basic-macos.x64-11.2.0.3.0.zip
        - instantclient-basic-macos.x64-11.2.0.4.0.zip
        - instantclient-basic-macos.x64-12.1.0.2.0.zip

v10 has the crashing problem you mentioned, and while both v11 versions work, you need to pass the DYLD_LIBRARY_PATH environment variable to a process for them to be found. So far, v12 libs seem to load, but this is as far as I've tested them.

So, working off an OS X 10.9 VM with 9.2.7 installed, here's the steps I took:

- create /usr/local and ensure it's writable to the current user
        sudo mkdir /usr/local
        sudo chgrp admin /usr/local
        sudo chmod 775 /usr/local
- create an "oracle" folder and move the libs archive to it
        mkdir /usr/local/oracle
        cd /usr/local/oracle
        mv ~/Downloads/instantclient-basic-macos.x64-12.1.0.2.0.zip .
- expand the archive to create the folder "instantclient_12_1"
        unzip instantclient-basic-macos.x64-12.1.0.2.0.zip
- create a "lib" folder in /usr/local, which is already automatically searched for libs by the system
        mkdir /usr/local/lib
        cd /usr/local/lib
- symlink the required libs from the instant client folder
        ln -s /usr/local/oracle/instantclient_12_1/libclntsh.dylib.12.1 libclntsh.dylib
        ln -s /usr/local/oracle/instantclient_12_1/libocci.dylib.12.1 libocci.dylib
- test that the Oracle libs load
        lasso9 -s "database_initialize"

Restart Lasso and you should now be able to add an Oracle datasource.

If for some reason you need to use v11 of the libs, try not to, because Oracle did a terrible job of linking them[1]. To make them work, I had to:
- expand the archives as before, then cd into instantclient_11_2/ and symlink libclntsh.dylib & libocci.dylib to the equivalent files that end in the version number
- symlink /usr/local/oracle/lib to /usr/local/oracle/instantclient_11_2
- add the env var "DYLD_LIBRARY_PATH=/usr/local/oracle/lib" to the instance

[1] https://blog.caseylucas.com/2013/03/03/oracle-sqlplus-and-instant-client-on-mac-osx-without-dyld_library_path/

‐‐‐‐‐‐‐‐‐‐✂‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
Eric3
 

> On Aug 12, 2016, at 1:21 PM, Justin Dennis <[hidden email]> wrote:
>
> Hi -
>
> Does anyone know the secret to connecting to an Oracle datasource from Mac
> Lasso 9.2?
>
> Following these instructions, I added the Oracle instant client:
> http://lassoguide.com/server/datasource-setup.html?
> highlight=oracle#datasource-setup-oracle
>
> (The docs reference 10.0.2.4, but I think is should read 10.2.0.4?)
>
> After installing the files, I attempted to adding the datasource in Lasso
> Admin. On save, Lasso crash. I then tried using just inline with the host
> parameter specifying the connection. Same result - Lasso crash.
>
> I then tried downloading and using the latest instant client for 64-bit
> intel. Same result - Lasso crash.
>
> The last line I saw in the log file had something to do with "JVM".
>
> I am on Mac OS X 10.8 with Lasso 9.2.7. I do have another Lasso instance on
> Mac OS X 10.11 with Lasso 9.3 if that might help anything.
>
> Thanks in advance for any pointers.
>
> - Justin
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>  the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Connecting to Oracle

Justin Dennis-3
Thank you for this info! Will try it ASAP. -Justin

On Monday, August 15, 2016, Eric Knibbe <[hidden email]> wrote:

> Oracle libs have been troublesome, to say the least. Fortunately things
> seem to have improved with the release of Instant Client 12.
>

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Loading...