Oracle Data Pump with the 12.2.0.1.0 Instant Client for Linux x86-64

Martin Berger

From the Oracle Database 12c Release 2 (12.2) New Features Guide:

Adding Oracle Data Pump and SQL*Loader Utilities to Instant Client

This feature adds SQL*Loader, expdp, impdp, exp, and imp to the tools for instant client.

Now you can run these utilities on machines that do not have a complete Oracle Database installation.

The newest release of the Oracle Instant Client for Linux x86-64 has an additional package called Tools. This package contains Data Pump, SQL*Loader and the Workload Replay Client for Real Aplication Testing. The good old import export tools is included too. This is very nice.

For example, if you want to load application log files with SQL*Loader into the database which are located on a separate server, there is no need for the client installation anymore. Or if your developers want to export data with Data Pump, all they need is the Instant Client now.

Just install – or better say unzip – the Instant Client basic package and the tools. Set some variables and go for it. The Instant Client packages are available as zip and as rpm for Unix systems. The rpm method requires root access to install.

Sizes of the Zip-Files

  • Instant Client Package – Basic:  66 Megabyte
  • Instant Client Package – Tools:   1 Megabyte

Zip Download URLs

SQL*Plus® User’s Guide and Reference

https://docs.oracle.com/database/122/SQPUG/SQL-Plus-instant-client.htm#SQPUG157

Instant Client Directory Content

Example for the Instant Client directory content on a Oracle Linux 7.2 server – Basic and Tools package installed.

oracle@kestenholz:/u00/app/oracle/product/instantclient_12_2/ [instantclient122] ll
total 221168
drwxr-xr-x. 2 oracle oinstall      4096 Mar 22 12:22 .
drwxr-xr-x. 6 oracle oinstall      4096 Mar 22 12:21 ..
-rw-r--r--. 1 oracle oinstall       363 Mar 22 12:21 BASIC_README
-rw-r--r--. 1 oracle oinstall       363 Mar 22 12:22 TOOLS_README
-rw-r--r--. 1 oracle oinstall     44220 Mar 22 12:21 adrci
-rw-r--r--. 1 oracle oinstall   1067736 Mar 22 12:22 exp
-rw-r--r--. 1 oracle oinstall    231727 Mar 22 12:22 expdp
-rw-r--r--. 1 oracle oinstall     57272 Mar 22 12:21 genezi
-rw-r--r--. 1 oracle oinstall    527125 Mar 22 12:22 imp
-rw-r--r--. 1 oracle oinstall    239564 Mar 22 12:22 impdp
-rw-r--r--. 1 oracle oinstall  71638263 Mar 22 12:21 libclntsh.so.12.1
-rw-r--r--. 1 oracle oinstall   8033199 Mar 22 12:21 libclntshcore.so.12.1
-rw-r--r--. 1 oracle oinstall   2981501 Mar 22 12:21 libipc1.so
-rw-r--r--. 1 oracle oinstall    539065 Mar 22 12:21 libmql1.so
-rw-r--r--. 1 oracle oinstall     77173 Mar 22 12:22 libnfsodm12.so
-rw-r--r--. 1 oracle oinstall   6568149 Mar 22 12:21 libnnz12.so
-rw-r--r--. 1 oracle oinstall   2218687 Mar 22 12:21 libocci.so.12.1
-rw-r--r--. 1 oracle oinstall 124771800 Mar 22 12:22 libociei.so
-rw-r--r--. 1 oracle oinstall    158543 Mar 22 12:22 libocijdbc12.so
-rw-r--r--. 1 oracle oinstall    380996 Mar 22 12:22 libons.so
-rw-r--r--. 1 oracle oinstall    116563 Mar 22 12:22 liboramysql12.so
-rw-r--r--. 1 oracle oinstall   4036257 Mar 22 12:22 ojdbc8.jar
-rw-r--r--. 1 oracle oinstall   1669142 Mar 22 12:22 sqlldr
-rw-r--r--. 1 oracle oinstall    240476 Mar 22 12:22 uidrvci
-rw-r--r--. 1 oracle oinstall    746798 Mar 22 12:22 wrc
-rw-r--r--. 1 oracle oinstall     74230 Mar 22 12:22 xstreams.jar

Let’s Data Pump

Set the environment variables. TNS_ADMIN is where my tnsnames.ora / sqlnet.ora are located.

oracle@kestenholz:~/ [instantclient122] export LD_LIBRARY_PATH=/u00/app/oracle/product/instantclient_12_2:${LD_LIBRARY_PATH}
oracle@kestenholz:~/ [instantclient122] export PATH=/u00/app/oracle/product/instantclient_12_2:${PATH}
oracle@kestenholz:~/ [instantclient122] export TNS_ADMIN=/u00/app/oracle/network/admin
Start a Data Pump Export
oracle@kestenholz:~/ [instantclient122] expdp system/<mypassword>@GEPDB39.jurasuedfuss.com schemas=scott directory=expdp dumpfile=expdpscott.dmp logfile=expdpscott.log
Export: Release 12.2.0.1.0 - Production on Wed Mar 22 12:44:18 2017

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01":  system/********@GEPDB39.jurasuedfuss.com schemas=scott directory=expdp dumpfile=expdpscott.dmp logfile=expdpscott.log
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
  /u00/app/oracle/admin/GECDB32/expdp/expdpscott.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Wed Mar 22 12:44:44 2017 elapsed 0 00:00:25
Permission denied

If you get a permission denied error, change the file properties.

oracle@kestenholz:~/ [instantclient122] expdp system/<mypassword>@GEPDB39.jurasuedfuss.com schemas=scott directory=expdp dumpfile=expdpscott.dmp logfile=expdpscott.log
-bash: /u00/app/oracle/product/instantclient_12_2/expdp: Permission denied

oracle@kestenholz:/u00/app/oracle/product/instantclient_12_2/ [instantclient122] chmod 750 expdp

Operating System Availability of the Tools Package

At the moment – 22th of March 2017 – the tools packages is only available for these operating systems:

  • Microsoft Windows (x64)
  • Linux x86-64
  • Solaris Operating System (SPARC 64-bit)

I hope the AIX release will coming soon 🙂