-bash: imp: command not found oracle

Question

I have a centos Linux machine and a oracle server installed on a server which is located at a remote location.

I have installed oracle client on my Linux centos machine using the link :

How to install SQL * PLUS client in linux

It may be noted that while installing client there was no /network/admin directory and hence no tnsnames.ora file. now I have manually created the directories and have have created a tnsnames.ora file. I am able to connect to remote server.

Now when I look into the bin folder I get just three exe

 adrci  genezi  sqlplus.

I cant find the imp.

Hence when I try to import the dump file from centos to oracle , I get the error:

-bash: imp: command not found

I am using the following command to import dump on oracle server:

imp 'rdsuser@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=oracledbrds.cwuabchlhlu.us-east-2.rds.amazonaws.com)(Port=1521))(CONNECT_DAT                                                                                        A(SID=oracledb)))'

Kindly help

Answer 1

The instant client does not include many of the tools from the full client, including imp/exp, their newer data pump equivalents, SQL*Loader etc. See the instant client FAQ, which highlights that it's largely for distribution with your own applications, but can incude SQL*Plus - the only tool mentioned.

If you need to use export/import or any other tools then you will need to install the full client, or run them on the server; which might be an issue with AWS. Amazon have an article on importing data into Oracle.

Incidentally, you can put your tnsnames.ora file anywhere as long as you set TNS_ADMIN to point to that location, but you aren't referring to it in your imp command anyway - you're specifying all the connection data. If you know the service name, which may be different to the SID (you can run lsnrctl services on the server to find the right value) you can use the 'easy connect' syntax:

sqlplus rdsuser@//oracledbrds.cwuabchlhlu.us-east-2.rds.amazonaws.com:1521/your_service_name