Oracle database connectivity issue

Question

I have a oracle database instance on my local machine , which i try to connect to .

Using SQL Developer , i can connect to it . But when i use sqlplus i cannot connect to the instance.

The error message i get is

ORA-28547:connection to server failed,probable oracle net admin error.

I tried restarting my TNS service but still the issue persists.

And i need to connect to sqlplus because i need to import the dumps using

impdp system/***** schemas=abcd dumpfile=DUMP_500.dmp 

Please let me know what other information is needed , so that i can post

Thanks

Answer 1

Are you using the same tnsnames.ora file for your SQL*Plus that your SQL Developer is using?

Also try adding SQL_AUTHENTICATION_SERVICES = (NONE) to your sqlnet.ora file.