TNS_ADMIN is used to indicate the folder that contains the tnsnames.ora file. NLS_LANG is used to set the language, territory and character set (the locale) to be used. This file can be used to set additional environment variables required by the Oracle client library.Įdit this file using TextEdit, and locate the "macOS" section which contains a key named "oracle8dam.ini" Users/myUser/Library/Application Support/Omnis/Omnis Studio 10.2 29802/studio/config.json The file can be found in your writable files folder, for example: If you are using a version of Instant Client that is not code-signed, you will need to place clientįiles inside the Omnis Studio.app/Frameworks or Omnis Studio.app/MacOS folder instead. This means that libclntsh.dylib can be placed into the /usr/local/lib folderĪnd Studio is permitted to open it.
Newer releases of Instant Client are code-signed by Oracle. If you download a newer version of Instant Client, then the same principle applies albeit with different file version numbers.
Once created, the Studio 10.2 Oracle DAM (which links against libclntsh.dylib) should load successfully when you open Omnis Studio. To do this, copy the required dylibs (plus the symlink libcntsh.dylib) into the /usr/local/lib folder Download and open the applicable ZIP or DMG archive.įor example: instantclient-basiclite-macos.圆4-19.8.0.0.0dbru.dmg. Care should be taken if creating/editing this file manually as OCI is very particular about syntax. This can be copied from a full client install if necessary (created using a Net ConfigurationĪssistant). In addition to these files one other file may be needed the tnsnames.oraįile- which contains a list of Oracle database connections ( service names). In order to use the Omnis Studio Oracle DAM. Of these, only the files marked in bold are required OCI Instant Client Light Data Shared Library The BasicLite package provides the following files: libclntsh.dylib -> libclntsh.dylib.19.1 The benefits of Instant Client are that it provides all the functionality of the full client with only a fraction Oracle Instant Client is a free, re-distributable version of the Oracle Client which provides the OCI and JDBC client libraries There is also an older version of this technote, in case you are using a version of MacOSX pre-10.15, available here: tnsq0010b.
The procedure outlined here is also relevant to MacOSX 10.15 (Catalina) and MacOSX 11.0 (Big Sur).
This tech note concerns Oracle Instant Client 19.1 for Mac-Intel 64-bit architecture, which at the time of writing is available to download from Omnis Technical Note TNSQ0010c March 2021 Using Oracle Instant Client with macOS 11 "Big Sur" and Later
0 kommentar(er)
