Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ocilib for MacOSX/9iR2
Kent Brockman <Brockman_at_channelsix.news> wrote in message news:<3DD96489.2030809_at_channelsix.news>...
> Hi,
>
> I have succesfully installed the developer release of oracle 9iR2 on
> MacOSX 10.2 "Jaguar".
>
> I want to use this database from ODBC clients. When looking into one of
> the options for ODBC (from OpenLink) I noticed that their lite driver
> depends on ocilib. According to OpenLink is this a part that is missing
> in the 9i distribution and I should get it from th 8i distribution.
> Problem is: where do I get it?
There are a few possible answers, Eddy.
First, the OpenLink Oracle Lite drivers, both 8 and 9, ship with the necessary base OCI library, libclntsh.dylib. All you need to do is create a directory to be used as ORACLE_HOME, create subdirectories $ORACLE_HOME/network/ and $ORACLE_HOME/network/admin, and touch $ORACLE_HOME/network/admin/tnsnames.ora. Set the privileges on these directories and that file to 775 or 777 (`chmod 777 $ORACLE_HOME/network/admin/tnsnames.ora`), and you're good to go.
The DNS configuration panel for Oracle Lite incudes a TNS Names Editor, which will work with this file, once you specify ORACLE_HOME in that panel.
This installation does not include the complete set of Oracle Client Libraries, so error messages will be of the form `could not find text for ORA-#####`. You can search the web or your Oracle documentation for the meaning of the ORA-##### error, or you can download the complete Oracle Client and configure things slightly differently --
Second answer -- Oracle provides the `Oracle8i OCI driver for Mac OS X` through their OTN site, but they do require that you register with their Developer Network before downloading. It's mis-filed, but you can (as of posting date) access it through this page --
<http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html>
Install these components according to the Oracle instructions, and set the destination directory as ORACLE_HOME in the DSN configuration dialog, as above. The only benefit you get from this installation is full-text Oracle error messages.
> Does anyone know where and how to get this? Either from the Oracle site
> or someplace else.
>
> I need to review the ODBC connection for a project that I am
> negotiating. The customer wants to run oracle on Windows and the clients
> on MacOSX. Without this part I (and I think no-one) can build what the
> customer is asking.
I think the above information should cover your needs. Please feel free to open a support case through the OpenLink website, if you need further information. This is a free service.
Be seeing you,
Ted Thibodeau Jr
Consultant
OpenLink Software, Inc. // <http://www.openlinksw.com/>
ODBC, XML & E-Business Infrastructure Technology Providers
Received on Mon Dec 16 2002 - 15:55:22 CST