Skip to content

Oracle Instant Client for macOS (Intel x86)

Oracle does not release anymore full client packages for the Mac clients. Therefore, we need to use the Instant Client from: [https://www.oracle.com/technetwork/topics/intel-macsoft-096467.html](https://www.oracle.com/technetwork/topics/intel-macsoft-096467.html) The installation is quite simple but we need to rememeber that, in order to have a functional client for a DBA we would need to download three packages at least: * Basic Package – All files required to run OCI, OCCI, and JDBC-OCI applications * SQLPlus Package – The SQLPlus command line tool for SQL and PL/SQL queries * Tools Package – Includes Data Pump, SQL*Loader and Workload Replay Client After that, the installation goes as: $ mkdir instantclient $ unzip /Users/radu.parvu/Downloads/instantclient-basic-macos.x64-18.1.0.0.0.zip.download/ $ unzip /Users/radu.parvu/Downloads/instantclient-sqlplus-macos.x64-18.1.0.0.0.zip $ unzip /Users/radu.parvu/Downloads/instantclient-tools-macos.x64-18.1.0.0.0.zip $ cd instantclient_18_1/ $ pwd /Users/radu.parvu/opt/instantclient/instantclient_18_1 $ mkdir -p network/admin Add to the PATH in the .bash_profile: export PATH=$PATH:/Users/radu.parvu/opt/instantclient/instantclient_18_1 set the environment variable TNS_ADMIN: export TNS_ADMIN=/Users/radu.parvu/opt/instantclient/instantclient_18_1/network/admin

Read More →

Remove Last Character of Each Line

I had to modify a file for loading into an Oracle database with SQL*Loader. The file was using as field delimiter the | pipe character and each line was ending in a |. So ideally, I would like to remove the pipe chracter that ends each of the 384 016 850 lines of my text file. One option is to use vim macros but I chose to use sed. The Linux command that would work is: but I noticed with surprise that this command would not work in mac OS!After a bit of investigation, I found out that the sed implementation on macOS is a bit different so the command on macOS is: note the extra characters that make the difference!

Read More →

Disable Mac OS X Gatekeeper

Ocassionally, there is a need to install an app created by a developer that is not identified by the security policy in place on the Firm’s MacBook. Here is the short procedure I identified it works for me: in terminal type: sudo spctl --master-disable verify with: spctl --status open the application and quit it in terminal, type: sudo spctl --master-enable verify the status: spctl --status verify that the policy is restored via: System Prefrerences … -> Security and Privacy  -> General

Read More →

Strange error when renaming a table

ORA-14047: ALTER TABLE INDEX RENAME may not be combined with other operations When we try to rename a table or index name in Oracle, we use a simple command as following ALTER TABLE``[SCHEMA_NAME]``.``[OLD_TABLE_NAME]``RENAME TO``[NEW_TABLE_NAME]``; If we put into schema names to this command, we can deal with ORA-14047 error.This error raise when we put schema name in front of the last_table_name. It is same with Index renaming.

Read More →