Skip to content
Apple

Oracle Instant Client for macOS (Intel x86)

Leave a Comment

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 →

Apple

Remove Last Character of Each Line

Leave a Comment

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 →

Mac OS X

Disable Mac OS X Gatekeeper

Leave a Comment

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 →

Oracle 11g

Strange error when renaming a table

Leave a Comment

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 →