oracle11 windows版安装后默认通过计算机名"windows-tom"进行监听,连接时,只能用服务名进行连接如windows-tom:1521/orcl,对开发来说十分不便,需要改为通过IP监听和通过sid进行连接。
[img]http://dl2.iteye.com/upload/attachment/0126/6516/0ce6df16-d7a4-3862-abe4-378b2398d35a.jpg[/img]
配置过程如下:
[img]http://dl2.iteye.com/upload/attachment/0126/6518/030dfbea-9543-3ba3-b44c-5d2165c02641.jpg[/img]
[img]http://dl2.iteye.com/upload/attachment/0126/6520/9243083e-36b3-319f-a97f-4779b74c1466.jpg[/img]
[img]http://dl2.iteye.com/upload/attachment/0126/6522/8fb9dcbd-4737-3702-8989-bb62d1b171a7.jpg[/img]
oracle主目录为E:\oracle\product\11.2.0\dbhome_1
[img]http://dl2.iteye.com/upload/attachment/0126/6524/a4b471b4-3633-3270-a6fa-b8d84e6b5af4.jpg[/img]
重启listener服务
[img]http://dl2.iteye.com/upload/attachment/0126/6526/f610ff39-43df-35d1-be30-6d54464d6131.jpg[/img]
配好的listener.ora文件内容为
[img]http://dl2.iteye.com/upload/attachment/0126/6516/0ce6df16-d7a4-3862-abe4-378b2398d35a.jpg[/img]
配置过程如下:
[img]http://dl2.iteye.com/upload/attachment/0126/6518/030dfbea-9543-3ba3-b44c-5d2165c02641.jpg[/img]
[img]http://dl2.iteye.com/upload/attachment/0126/6520/9243083e-36b3-319f-a97f-4779b74c1466.jpg[/img]
[img]http://dl2.iteye.com/upload/attachment/0126/6522/8fb9dcbd-4737-3702-8989-bb62d1b171a7.jpg[/img]
oracle主目录为E:\oracle\product\11.2.0\dbhome_1
[img]http://dl2.iteye.com/upload/attachment/0126/6524/a4b471b4-3633-3270-a6fa-b8d84e6b5af4.jpg[/img]
重启listener服务
[img]http://dl2.iteye.com/upload/attachment/0126/6526/f610ff39-43df-35d1-be30-6d54464d6131.jpg[/img]
配好的listener.ora文件内容为