Skip to Main Content
  • Questions

  • ERROR WITH IMPORT OPERATION IN DATABASE 11G RELEASE 1 AND DEVELOPER 10G

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Bassim.

Asked: September 18, 2018 - 7:09 am UTC

Last updated: September 19, 2018 - 1:15 am UTC

Version: oracle database 11g & developer 10g

Viewed 1000+ times

You Asked

Hi Tom,
I installed Oracle Database 11G in the folder (E:\DB11)and successfully imported a user to it.
But when you install the developer 10G IN FOLDER(E:\DEV10). and TRY TO DO a user import into the database ORACLE 11G, i am receiving the following error message below . In addition, there is no possibility to run this command : /as sysdba in SQL Plus.

error message 1: "sqlplusw.exe - Entry point Not Found
the procedure entry point longjmp could not be located in the dynamic link library
e:\db11\PRODUCT\11.1.0\DB_1\BIN\ORACORE11.DLL"

error message 2: "IMP.exe - Entry point Not Found
the procedure entry point longjmp could not be located in the dynamic link library
e:\db11\PRODUCT\11.1.0\DB_1\BIN\ORANLS11.DLL"

and Connor said...

Make sure you set your environment and path correctly each time you want to run something from each installation.

eg I have several database versions on my machine. I have a user called "SCOTT" but on in my 12.2 instance.

--
-- setup for version 18
--
C:\>set ORACLE_HOME=C:\oracle\product\18

C:\>set PATH=C:\oracle\product\18\bin;%PATH%

C:\>sqlplus scott/tiger

SQL*Plus: Release 18.0.0.0.0 - Production on Wed Sep 19 09:11:23 2018
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

--
-- but works if I setup for version 12
--

C:\>set ORACLE_HOME=C:\oracle\product\12.2

C:\>set PATH=C:\oracle\product\12.2\bin;%PATH%

C:\>sqlplus scott/tiger

SQL*Plus: Release 12.2.0.1.0 Production on Wed Sep 19 09:11:47 2018

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Last Successful login time: Thu Aug 23 2018 20:56:16 +08:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production


Your "developer 10" is a *client* to your database.

So under your *database* installation, with your path and home set, you can do (say):

connect myuser/mypassword

but under your *developer* installation, you are a client so you would do:

connect myuser/mypassword@my_database_name

where 'my_database_name' is a TNS name defined in E:\DEV10\NETWORK\ADMIN\TNSNAMES.ORA (or you could fire up the Network Config Assistant under developer 10 start menu) to add one.

Rating

  (4 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

IMPORT OPERATION

Bassim Salikh, September 19, 2018 - 8:44 am UTC

THANK YOU FOR RESPONSE....
BUT THE IMPORT OPERATION DON'T WORK ...
APPEAR AN ERROR :
error message 1: "sqlplusw.exe - Entry point Not Found
the procedure entry point longjmp could not be located in the dynamic link library
e:\db11\PRODUCT\11.1.0\DB_1\BIN\ORACORE11.DLL"

error message 2: "IMP.exe - Entry point Not Found
the procedure entry point longjmp could not be located in the dynamic link library
e:\db11\PRODUCT\11.1.0\DB_1\BIN\ORANLS11.DLL"


IMPORT OPERATION

Bassim Salikh, September 19, 2018 - 8:51 am UTC

IN ADDITION TO , ALSO THE ERROR MESSAGE WAS APPEAR :
IMP-00010: not a valid export file, header failed verification

Version mismatch?

paul, September 19, 2018 - 3:18 pm UTC

sqldeveloper 10g may not be upward compatible to 11g.
It is expecting specific versions of DLLs that it can't find because the user's environment seems to be pointing to 11g first in the path or in the ORA%_% environment variables.

You should use a *higher* version tool with a *lower* version DB, not the other way around.

I expect if you exported something from 11g and tried to import using 10g you may see similar problems. The older tool does not understand anything the newer tool may have introduced.

To Paul

J. Laurindo Chiappa, September 20, 2018 - 12:05 pm UTC

Yes, I agree : to me, the line :

error message 1: "sqlplusw.exe - Entry point Not Found

clearly refers to sqlplusw , the awkful Windows-only version of sqlplus, existing only in database 10g... For sure, that grumpy old SQLDEVELOPER10g is looking for sqlplusw, what is gone in database 11g....
Solution : the questioner must stop the use that old thing...

Regards,

Chiappa
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database