patternMinor
Oracle 12c: installing expdp and impdp on Linux
Viewed 0 times
12cimpdpinstallinglinuxandoracleexpdp
Problem
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?
Solution
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(
1) Log in as oracle user in the OS.
2)
3)
4)Check the value of the variables.
5) Try to run expdp
Setting Oracle 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_profileORACLE_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/bin3)
[oracle@ora12c Desktop]$ . ~/.bash_profile4)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/bin5) 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
Code Snippets
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[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[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:Context
StackExchange Database Administrators Q#151387, answer score: 5
Revisions (0)
No revisions yet.