PLSQL登录时报 ORA12521 TNS无监听程序

在用PL/SQL Developer等客户端工具连接oracle服务器时出现ORA-12541:TNS:无监听程序的错误,如下图:


[img]http://dl2.iteye.com/upload/attachment/0121/7934/0b8fa8b5-2094-3cf5-a5f2-6e7f11fe060c.png[/img]


发现原来是oracle的监听没有启动,重启监听后就连接成功了,下面跟大家分享一下如何启动oracle的监听。


[b].在安装Oracle服务器的主机上，在cmd环境下输入 Net Configuration Assistant，出现如下界面：[/b]


[img]http://dl2.iteye.com/upload/attachment/0121/7936/43a7c374-f4d3-36b9-9f0b-19a7c2c3761f.png[/img]


[b]选择监听程序配置，下一步[/b]

[img]http://dl2.iteye.com/upload/attachment/0121/7938/956d8b8c-817d-3019-880d-8853950b1983.png[/img]


[b]选择重新配置，下一步
[/b]


[img]http://dl2.iteye.com/upload/attachment/0121/7940/34eabe3f-fbde-3ae7-8e3e-7e901603e09d.png[/img]


[b]选择监听程序，默认，下一步[/b]


[img]http://dl2.iteye.com/upload/attachment/0121/7942/fa3fb362-6897-38c4-9070-a0ca196d7e00.png[/img]


注：如果你的监听已启动，则出现提示框，[b]选择是[/b]


[img]http://dl2.iteye.com/upload/attachment/0121/7944/b6b70f08-fbfa-3474-8451-0a1ecc1d1fd8.png[/img]


[b]选择协议，使用默认的TCP协议，下一步[/b]


[img]http://dl2.iteye.com/upload/attachment/0121/7946/cd3e4f6d-1e28-31e5-82d8-0cb40f1aaa95.png[/img]


[b]选择端口号，使用标准端口号1521，下一步[/b]


[img]http://dl2.iteye.com/upload/attachment/0121/7952/b5957670-ae50-3181-92d9-d03c9d20663a.png[/img]


[color=red][b]不配置另一个监听程序，选择否，下一步[/b][/color]


[img]http://dl2.iteye.com/upload/attachment/0121/7956/e962a96c-a890-371b-83bd-bd84a4076ab6.png[/img]


[b]监听程序配置完成，下一步[/b]


[img]http://dl2.iteye.com/upload/attachment/0121/7958/7ef7df6e-f2e6-360e-8360-8fb4f4931f96.png[/img]


[b]选择Net服务器配置，下一步[/b]


[img]http://dl2.iteye.com/upload/attachment/0121/7962/fa58e408-eeb5-3dd5-a9f3-a713b0f322d8.png[/img]


[b]选择重新配置，下一步[/b]


[img]http://dl2.iteye.com/upload/attachment/0121/7964/092506e8-a380-3331-966c-72be37f059dd.png[/img]


[b]选择数据库名，下一步[/b]


[img]http://dl2.iteye.com/upload/attachment/0121/7970/dc8f8085-3c38-3e2d-8450-e0a23fd3de80.png[/img]


[b]填写服务名，也就是你创建数据库时的全数据库名，下一步[/b]

[img]http://dl2.iteye.com/upload/attachment/0121/7972/0f3a74f5-03b3-3b6e-9979-ed71f5e53de2.png[/img]


[b]选择TCP协议，下一步[/b]


[img]http://dl2.iteye.com/upload/attachment/0121/7974/1e0ccbf6-50b4-3dc0-a8d7-c5c2f8758cc0.png[/img]


[b]填写主机名(可填写你的IP地址，也可填写你的主机名)，使用标准端口号1521，下一步[/b]

[img]http://dl2.iteye.com/upload/attachment/0121/7976/d900fb8c-3d23-3660-8f53-f3fb731786d8.png[/img]


[b]进行测试，下一步[/b]

[img]http://dl2.iteye.com/upload/attachment/0121/7978/a1114f23-77f6-37cc-9c78-baf5ac6f93be.png[/img]


[b]选择更改登录[/b]


[img]http://dl2.iteye.com/upload/attachment/0121/7978/a1114f23-77f6-37cc-9c78-baf5ac6f93be.png[/img]


[b]填写用户名和口令，确定[/b]

[img]http://dl2.iteye.com/upload/attachment/0121/7980/b5dbd2e8-ec2a-3cf2-a31a-4613ff94aabd.png[/img]


[b]测试连接成功，下一步[/b]

[img]http://dl2.iteye.com/upload/attachment/0121/7982/9501931d-1258-3cb5-8fd6-9d3c4e31e81a.png[/img]


[b]网络服务名，默认(和之前的数据库名一样)，下一步[/b]


[img]http://dl2.iteye.com/upload/attachment/0121/7986/fcccad7e-a73e-3524-b3f0-c79e7bc5098a.png[/img]


[b]不配置另一个Net服务名，选择否，下一步[/b]

[img]http://dl2.iteye.com/upload/attachment/0121/7988/549d71f6-c2d2-3b78-be87-1fd2c31a3cde.png[/img]


[b]Net服务名配置完毕，下一步，完成[/b]


[img]http://dl2.iteye.com/upload/attachment/0121/7990/f8065e98-c7ac-3fe4-b179-7e6b6c13220a.png[/img]


[b]启动PL/SQLDeveloper，输入用户名和口令，登录成功[/b]


[img]http://dl2.iteye.com/upload/attachment/0121/7968/edd4272e-ab37-3d3a-af65-474ac3d988fd.png[/img]


[img]http://dl2.iteye.com/upload/attachment/0121/7966/abe0bd57-c562-30b2-9568-9835f58322e5.png[/img]