我用plsql连接oracle数据库时提示 ORA-12154:TNS:无法解析指定的连接标示符
下面是我tnsname.ora的配置信息
GJJ19 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 196.168.0.19)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)为什么会出现上面12154那个错误?应该怎么修改?
下面是我tnsname.ora的配置信息
GJJ19 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 196.168.0.19)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)为什么会出现上面12154那个错误?应该怎么修改?
我的
tnsname.ora
long =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.100)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
连接数据库是不是对应的long
从你的tnsname.ora 应选GJJ19
要不从sql/plus 那里登陆 主机字符串 Gjj19(tnsname.ora对应的加红色的)
我上周装了10g 服务端和客户端都装在同一台电脑上.配置也搞了一个下午;
百度一下.努力去搞好;
看看结果如何。不行的话,参考 3楼。
或者在host里增加 :
196.168.0.19 你的电脑名称
登入名字用GJJ19