Oracle TNS:网络服务名称指定不正确 [英] Oracle TNS: net service name is incorrecly specified

问题描述

帮助！我是Oracle的新手，他正在尝试访问我们为客户端继承的旧服务器上的数据库.

Help! I'm a newbie to Oracle who's trying to access a database on an old server we inherited for a client.

我确信我已经启动并运行了oracle数据库和侦听器，但是当尝试访问sqlplus或exp命令时，出现以下错误:

I'm confident I have the oracle database and listener started and working, but when trying to access sqlplus or the exp commands, I'm getting the following error:

ORA-12162:TNS:.net服务名称指定不正确

ORA-12162: TNS:net service name is incorrectly specified

我已经编辑了tnsnames.ora文件，将主机更改为127.0.0.1，而不是将外部URL更改为主机，并且能够成功地tnsping我的连接，但是步伐还远.

I have edited the tnsnames.ora file to change the host to 127.0.0.1 rather than an external url and am able to successfully tnsping my connection, but am not getting much further.

任何建议或帮助将不胜感激.

Any advice or help would be greatly appreciated.

推荐答案

尝试设置Oracle SID

Try setting the Oracle SID

设置ORACLE_SID = 数据库名称

set ORACLE_SID=database name

这篇关于Oracle TNS:网络服务名称指定不正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！