步骤大致是：1.配置一个非默认的动态监听，运行在1525端口 2.默认动态监听同时要运行 3.配置一个静态监听，运行在1526端口 4.打开这些监听，并使用sqlplus登陆测试 数据库内一些参数： sys@ bys3show parameter service name type value --------------------
步骤大致是：1.配置一个非默认的动态监听，运行在1525端口
2.默认动态监听同时要运行
3.配置一个静态监听，运行在1526端口
4.打开这些监听，并使用sqlplus登陆测试
数据库内一些参数：
sys@ bys3>show parameter service
name type value
------------------------------------ ----------- ------------------------------
service_names string bys3
sys@ bys3>show parameter db_na
name type value
------------------------------------ ----------- ------------------------------
db_name string bys3
sys@ bys3>show parameter db_unique
name type value
------------------------------------ ----------- ------------------------------
db_unique_name string bys3
sys@ bys3>show parameter db_domain
name type value
------------------------------------ ----------- ------------------------------
db_domain string
sys@ bys3>show parameter instance_na
name type value
------------------------------------ ----------- ------------------------------
instance_name string bys3
关于这几个参数的设置及替换，详见：oracle监听之动态监听与静态监听特点
配置默认及非默认动态监听1.配置listener.ora，增加非默认动态监听的地址、端口条目[oracle@bys3 admin]$ more listener.ora
# listener.ora network configuration file: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# generated by oracle configuration tools.
listener =
(description_list =
(description =
(address = (protocol = tcp)(host = bys3.bys.com)(port = 1525))
(address = (protocol = tcp)(host = bys3.bys.com)(port = 1521))
)
)
adr_base_listener = /u01
2.在数据库中配置 local_listener参数,语句如下：--就是把listener.ora中的几行复制过来，注意换行的括号不要少了。alter system set local_listener='(description =
(address = (protocol = tcp)(host = bys3.bys.com)(port = 1525))
(address = (protocol = tcp)(host = bys3.bys.com)(port = 1521)))';
sys@ bys3>alter system register; --手动注册，或者等上一分钟，让pmon自动进行动态监听注册。
3.查看监听状态，动态监听已经注册成功：[oracle@bys3 ~]$ lsnrctl status
lsnrctl for linux: version 11.2.0.4.0 - production on 14-jan-2014 22:20:16
copyright (c) 1991, 2013, oracle. all rights reserved.
connecting to (description=(address=(protocol=tcp)(host=bys3.bys.com)(port=1525)))
status of the listener
------------------------
alias listener
version tnslsnr for linux: version 11.2.0.4.0 - production
start date 14-jan-2014 22:02:22
uptime 0 days 0 hr. 17 min. 54 sec
trace level off
security on: local os authentication
snmp off
listener parameter file /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
listener log file /u01/diag/tnslsnr/bys3/listener/alert/log.xml
listening endpoints summary...
(description=(address=(protocol=tcp)(host=bys3.bys.com)(port=1525)))
(description=(address=(protocol=tcp)(host=bys3.bys.com)(port=1521)))
services summary...
service bys3 has 1 instance(s).
instance bys3, status ready, has 1 handler(s) for this service...
the command completed successfully4.使用sqlplus进行登陆测试：[oracle@bys3 admin]$ cat tnsnames.ora
bys3 =
(description =
(address = (protocol = tcp)(host = bys3.bys.com)(port =1521))
(connect_data =
(server = dedicated)
(service_name = bys3)
)
)
test =
(description =
(address = (protocol = tcp)(host = bys3.bys.com)(port =1525))
(connect_data =
(server = dedicated)
(service_name = bys3)
)
)
[oracle@bys3 admin]$ tnsping test
tns ping utility for linux: version 11.2.0.4.0 - production on 14-jan-2014 22:30:42
copyright (c) 1997, 2013, oracle. all rights reserved.
used parameter files:
used tnsnames adapter to resolve the alias
attempting to contact (description = (address = (protocol = tcp)(host = bys3.bys.com)(port =1525)) (connect_data = (server = dedicated) (service_name = bys3)))
ok (0 msec)
[oracle@bys3 admin]$ tnsping bys3
tns ping utility for linux: version 11.2.0.4.0 - production on 14-jan-2014 22:30:46
copyright (c) 1997, 2013, oracle. all rights reserved.
used parameter files:
used tnsnames adapter to resolve the alias
attempting to contact (description = (address = (protocol = tcp)(host = bys3.bys.com)(port =1521)) (connect_data = (server = dedicated) (service_name = bys3)))
ok (10 msec)
[oracle@bys3 admin]$ sqlplus bys/bys@bys3
sql*plus: release 11.2.0.4.0 production on tue jan 14 22:32:02 2014
copyright (c) 1982, 2013, oracle. all rights reserved.
connected to:
oracle database 11g enterprise edition release 11.2.0.4.0 - production
with the partitioning, olap, data mining and real application testing options
bys@ bys3>exit
[oracle@bys3 admin]$ sqlplus bys/bys@test
bys@ test>exit
###############################################################
配置静态监听：1.配置listener.ora，增加相应条目[oracle@bys3 admin]$ cat listener.ora
# listener.ora network configuration file: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# generated by oracle configuration tools.
listener =
(description_list =
(description =
(address = (protocol = tcp)(host = bys3.bys.com)(port = 1525))
(address = (protocol = tcp)(host = bys3.bys.com)(port = 1521))
)
)
l3 =
(description_list =
(description =
(address = (protocol = tcp)(host = bys3.bys.com)(port = 1526))
)
)
sid_list_l3=
(sid_list=
(sid_desc=
(global_dbname=bys9)
(sid_name=bys3)
(oracle_home=/u01/app/oracle/product/11.2.0/dbhome_1)))
adr_base_listener = /u012.启动监听，查看状态：[oracle@bys3 ~]$ lsnrctl status l3
lsnrctl for linux: version 11.2.0.4.0 - production on 14-jan-2014 22:19:49
copyright (c) 1991, 2013, oracle. all rights reserved.
connecting to (description=(address=(protocol=tcp)(host=bys3.bys.com)(port=1526)))
status of the listener
------------------------
alias l3
version tnslsnr for linux: version 11.2.0.4.0 - production
start date 14-jan-2014 22:15:15
uptime 0 days 0 hr. 4 min. 34 sec
trace level off
security on: local os authentication
snmp off
listener parameter file /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
listener log file /u01/diag/tnslsnr/bys3/l3/alert/log.xml
listening endpoints summary...
(description=(address=(protocol=tcp)(host=bys3.bys.com)(port=1526)))
services summary...
service bys9 has 1 instance(s).
instance bys3, status unknown, has 1 handler(s) for this service...
the command completed successfully
#################3.使用sqlplus进行登陆测试[oracle@bys3 admin]$ cat tnsnames.ora
test9 =
(description =
(address = (protocol = tcp)(host = bys3.bys.com)(port =1526))
(connect_data =
(server = dedicated)
(service_name = bys9)
)
)
[oracle@bys3 ~]$ tnsping test9
tns ping utility for linux: version 11.2.0.4.0 - production on 14-jan-2014 22:37:56
copyright (c) 1997, 2013, oracle. all rights reserved.
used parameter files:
used tnsnames adapter to resolve the alias
attempting to contact (description = (address = (protocol = tcp)(host = bys3.bys.com)(port =1526))(connect_data = (server = dedicated) (service_name = bys9)))
ok (10 msec)
[oracle@bys3 ~]$ sqlplus bys/bys@test9
sql*plus: release 11.2.0.4.0 production on tue jan 14 22:38:05 2014
copyright (c) 1982, 2013, oracle. all rights reserved.
connected to:
oracle database 11g enterprise edition release 11.2.0.4.0 - production
with the partitioning, olap, data mining and real application testing options
bys@ test9>