ORA-12154 connect failed because target host or object does not exist

[Account007]

ora-12154 connect failed because target host or object does not exist

安装oracle数据库到,编辑配置参数页面了,输入了用户密码,
服务输入的是orange:1521:orcl

点击下一步时总是提示ora-12154 connect failed because target host or object does not exist


在网上找了很多方法,但都没解决,请教应该要怎么解决啊?

网上看了资料大多都是说修改tnsnames.ora和listener.ora,
原文件的内容如下,
tnsnames.ora文件的内容是这样的

# TNSNAMES.ORA Network Configuration File: E:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SAP)(PORT = 1521))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

listener.ora文件的内容是

# LISTENER.ORA Network Configuration File: E:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
)
)
)

[huadis]

用orange代替ip做host确实有好处，但是有时会因某种原因不起作用，具体没有深究过，你可以换成机器的ip试一下

[真的不知道取什么名]

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SAP)(PORT = 1521))
)--你连自己电脑上的、还是服务器的？两个文件 host= 主机名 或者ip地址
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

[bzr2004]

首先确认你要连接机器的hostname或IP,然后在tnsname.ora文件中的HOST后加入IP或机器名

[tangren]

使用Net configuration Assistant来配置一个服务名，或者直接修改tnsnames.ora文件，增加：
test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
注意红色部分一定要正确，然后测试一下连接
c:\>tnsping test