Search code examples
oracleimportredhatimpdpimp

How to have oracle imp 11gr2 and 12cr2 on the same machine and just choose the one that I want to use


I'm currently developing an application to import oracle dbs. In order to do that I'm using Data Pump and the original imp client (version 12.2.0.1). However I cannot use that imp client against an 11gr2 database, I need to use the 11gr2 imp client.

I already have the client and libraries that I got from one of my 11gr2 DBs however, if I try to execute it I'm getting the following error:

Message 100 not found; No message file for product=RDBMS, facility=IMP: Release 11.2.0.3.0 - Production on Fri Jan 5 18:28:21 2018

Copyright (c) 1982, 2011, Oracl

Invalid format of Import utility name

Verify that ORACLE_HOME is properly set

Import terminated unsuccessfully

IMP-00000: Message 0 not found; No message file for product=RDBMS, facility=IMP

Can someone point how to have both clients working on the same machine? Thanks in advance.

[UPDATE] I'm using Red Hat OS and this is the output of $ORACLE_HOME: /root/oracle/instantclient_12_2

I tried using the full path and placing the files in ORACLE_HOME but I still get the same error. Thanks!!!


Solution

  • After researching, I did not copy all the required files when trying to copy the imp client version 11cr2. I solved this issue by copying all the files in $ORACLE_HOME and making that location my new $ORACLE_HOME. After that, just copied the lib files and the imp from the 12cr2 client installation to $ORACLE_HOME and renamend imp 12cr2 to "imp12cr2".

    Now if I want to use the 11.2 I use imp and if want to use the 12cr2 one I use imp12cr2