Oracle数据库连接问题 [英] Oracle database connectivity issue

问题描述

我在本地计算机上有一个oracle数据库实例，我尝试将其连接到.

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

使用SQL Developer，我可以连接到它.但是当我使用sqlplus时，我无法连接到实例.

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

我收到的错误消息是

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

我尝试重新启动TNS服务，但问题仍然存在.

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

我需要连接到sqlplus，因为我需要使用

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

谢谢

推荐答案

您是否为SQL * Plus使用与SQL Developer相同的tnsnames.ora文件?

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

还尝试将SQL_AUTHENTICATION_SERVICES = (NONE)添加到您的sqlnet.ora文件中.

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

这篇关于Oracle数据库连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！