- #Oracle 12c instant client sqlldr for mac install
- #Oracle 12c instant client sqlldr for mac zip file
- #Oracle 12c instant client sqlldr for mac full
- #Oracle 12c instant client sqlldr for mac zip
bash_profile: export TNS_ADMIN=/opt/oracle/instantclient_11_2/ So, for UNIX and Linux systems set the variable TNS_ADMIN like so in your. This practice will ensure that you are using the appropriate tnsnames.ora for your application when running with Instant Client. So how do you specify the location of your TNSNAMES.ORA file?Īlways set the TNS_ADMIN environment variable or registry to the location of the tnsnames.ora file (full directory path only, do not include the file name).
#Oracle 12c instant client sqlldr for mac install
Fortunately it looks like you don't need to worry about that with the 12c client - they've fixed the way it's built.When you install the InstantClient binaries, you often want to use your existing TNSNAMES.ORA file containing all your databases. The installation notes at the bottom of the download page have changed since I last did this, and it now says to hard link the library files to the user's ~/lib directory to avoid that issue. There are workarounds for the 11g instant client. That could affect running SQL*Plus from a shell script, for example. All rights reserved.Įl Capitan added system integrity protection (SIP), and one side effect of that is that exporting DYLD_LIBRARY_PATH doesn't work. Users/alex/Downloads/instantclient_12_1/sqlplus MacBook:Downloads alex$ export PATH=$HOME/Downloads/instantclient_12_1:$PATH Optionally rename and/or move the instantclient_12_1 directory to somewhere more permanent.Īdd the location to your path in your current session, and also in your shell profile/resource file to make it take effect on every login: export PATH=$HOME/Downloads/instantclient_12_1:$PATHĮnjoy. Inflating: instantclient_12_1/libsqlplusic.dylib Inflating: instantclient_12_1/libsqlplus.dylib Inflating: instantclient_12_1/SQLPLUS_README MacBook:Downloads alex$ unzip instantclient-sqlplus-macos.圆4-12.1.0.2.0.zipĪrchive: instantclient-sqlplus-macos.圆4-12.1.0.2.0.zip Inflating: instantclient_12_1/xstreams.jar Inflating: instantclient_12_1/liboramysql12.dylib Inflating: instantclient_12_1/libons.dylib Inflating: instantclient_12_1/libocijdbc12.dylib Inflating: instantclient_12_1/libociei.dylib Inflating: instantclient_12_1/libocci.dylib.12.1
Inflating: instantclient_12_1/libnnz12.dylib Inflating: instantclient_12_1/libclntshcore.dylib.12.1 Inflating: instantclient_12_1/libclntsh.dylib.12.1 Inflating: instantclient_12_1/BASIC_README Unzip both files: MacBook:Downloads alex$ unzip instantclient-basic-macos.圆4-12.1.0.2.0.zipĪrchive: instantclient-basic-macos.圆4-12.1.0.2.0.zip In Terminal go to your Downloads directory.
#Oracle 12c instant client sqlldr for mac zip
If you're using Safari, disable automatic opening of the zip files from Safari->Preferences->General untick the 'Open "safe" files after downloading' checkbox.ĭownload instantclient-basic-macos.圆4-12.1.0.2.0.zip and instantclient-sqlplus-macos.圆4-12.1.0.2.0.zip Once you've done that you can execute sqlplus from anywhere. bash_profile so you don't need to do it manually.
#Oracle 12c instant client sqlldr for mac full
You then need to add the full path to that folder to your PATH and environment variable - you can add that to your. You can put that combined folder anywhere you like. You may also need to create a symbolic link for the main client library from inside that folder (in Terminal) you would do: ln -s libclntsh.dylib.12.1 libclntsh.dylib You can either disable that automatic unzipping and do it manually, or copy the files from the individual folders into a common one.
#Oracle 12c instant client sqlldr for mac zip file
Unfortunately that doesn't quite work if you use Safari and have it set to open certain downloaded files each zip file is expanded into a separate folder, with incremented names. The packages are arranged such that if you unzip all the ones you need from the same place they all put their files in the same directory.
To run the CLI (by which I assume you mean SQL*Plus) you need that package as well - the fourth in the list, titled "Instant Client Package - SQL*Plus: Additional libraries and executable for running SQL*Plus with Instant Client". From the files you listed you have only downloaded and unzipped the 'basic' package.
There are multiple files available for download.
0 kommentar(er)
