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!!!
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