首页 新闻 会员 周边 捐助

请教ORA-12154: TNS: could not resolve the connect id

0
悬赏园豆:5 [已关闭问题]

用Toad 连接Server时出现以下错误

ORA-12154: TNS: could not resolve the connect identifier specified 

请教是何原因?

hovering的主页 hovering | 初学一级 | 园豆:38
提问于:2009-08-03 22:02
< >
分享
其他回答(1)
0

Steps:
1. Open Net Manager.
2. go to Local > Service Naming.
3. After selecting Service Naming, click on Edit menu > Create
4. Give a Net Service Name (any user defined name)
5. Select TCP/IP (Internet Protocol)
6. give the Host Name (IP Address or Host machine name)
7. Service Name : (it should be the global_name of the database)
select * from global_name
8. After completing it, go to File and save Network configuration.
9. Select the connection string created and clikck on command menu > test service.
10. Give the valid user name and password for connecting.

winzheng | 园豆:8797 (大侠五级) | 2009-08-03 22:20
0

增加环境变量试试,假设你把oracle装入c:\oracle,就在环境变量里也加上

Gnie | 园豆:468 (菜鸟二级) | 2009-08-04 11:08
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册