3

The default Oracle installation for Linux didn't come with the expdp and impdp command line tools. I have trouble finding them on Oracle's website. How could I install them?

laurt
  • 233
  • 2
  • 3
  • 10

3 Answers3

5

Data Pump utilities are installed automatically during the installation of Oracle Database. It should be working without any issues as long as the environment variables(PATH, ORACLE_HOME) are set properly. To set PATH and ORACLE_HOME variable permanently-

1) Log in as oracle user in the OS.

2) [oracle@ora12c Desktop]$ vi ~/.bash_profile

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1; export ORACLE_HOME
PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin

3)[oracle@ora12c Desktop]$ . ~/.bash_profile

4)Check the value of the variables. 

[oracle@ora12c Desktop]$ echo $ORACLE_HOME
/u01/app/oracle/product/12.1.0/db_1
[oracle@ora12c ~]$ echo $PATH
.:/usr/local/java/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin:/u01/app/oracle/product/12.1.0/db_1/bin:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin:/u01/app/common/oracle/bin

5) Try to run expdp

[oracle@ora12c Desktop]$ expdp 

Export: Release 12.1.0.2.0 - Production on Tue Oct 4 16:46:44 2016

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

Username:

Setting Oracle Environment Variables

atokpas
  • 8,680
  • 1
  • 18
  • 27
0

In my case I just needed to log in with "oracle" user instead of root. This user had all the environment variables correctly set.

Paco Abato
  • 116
  • 1
0

If logged in as opc user you'd have to

$sudo su - oracle

first and then the environment has everything you need

crtag
  • 101