oracle配置多網(wǎng)絡(luò)接口多端口listener
環(huán)境：oracle 11.2.0.4
天峨網(wǎng)站制作公司哪家好，找創(chuàng)新互聯(lián)！從網(wǎng)頁(yè)設(shè)計(jì)、網(wǎng)站建設(shè)、微信開(kāi)發(fā)、APP開(kāi)發(fā)、響應(yīng)式網(wǎng)站設(shè)計(jì)等網(wǎng)站項(xiàng)目制作，到程序開(kāi)發(fā)，運(yùn)營(yíng)維護(hù)。創(chuàng)新互聯(lián)從2013年成立到現(xiàn)在10年的時(shí)間，我們擁有了豐富的建站經(jīng)驗(yàn)和運(yùn)維經(jīng)驗(yàn)，來(lái)保證我們的工作的順利進(jìn)行。專(zhuān)注于網(wǎng)站建設(shè)就選創(chuàng)新互聯(lián)。
兩個(gè)數(shù)據(jù)庫(kù)實(shí)例:orcl test
主機(jī)名解析：192.168.1.30 orcl.lineqi.com orcl
[oracle@orcladmin]$ ifconfig
eth0 Link encap:Ethernet HWaddr 00:0C:29:40:07:9A
inetaddr:192.168.1.30 Bcast:192.168.1.255 Mask:255.255.255.0
inet6 addr:fe80::20c:29ff:fe40:79a/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:2548 errors:0 dropped:0overruns:0 frame:0
TX packets:1875 errors:0 dropped:0overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:262084 (255.9 KiB) TX bytes:263913 (257.7 KiB)
eth2 Link encap:Ethernet HWaddr 00:0C:29:40:07:A4
inet addr:192.168.1.31 Bcast:192.168.1.255 Mask:255.255.255.0
inet6 addr:fe80::20c:29ff:fe40:7a4/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:297 errors:0 dropped:0overruns:0 frame:0
TX packets:11 errors:0 dropped:0overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:21490 (20.9 KiB) TX bytes:746 (746.0 b)
一、在兩個(gè)網(wǎng)絡(luò)接口的不同端口監(jiān)聽(tīng)一個(gè)實(shí)例
1、配置listener
[oracle@orcl 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.
LIST4 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.31)(PORT = 1524))
)
)
LIST3 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.30)(PORT = 1523))
)
)
LIST2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.30)(PORT = 1522))
)
)
LIST1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.30)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
2、接著配置tnsname.ora
在/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsname.ora添加如下內(nèi)容。
ALL_LISTENER =
(
DESCRIPTION=
(ADDRESS_LIST =
(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.1.30)(PORT = 1521))
(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.1.30)(PORT = 1522))
(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.1.30)(PORT = 1523))
(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.1.31)(PORT = 1524))
)
(
CONNECT_DATA=
(SERVICE_NAME = orcl)
)
)
3、啟動(dòng)并查看各監(jiān)聽(tīng)狀態(tài)
[oracle@orcladmin]$lsnrctl start list1
[oracle@orcladmin]$lsnrctl start list2
[oracle@orcladmin]$lsnrctl start list3
[oracle@orcladmin]$lsnrctl start list4
[oracle@orcladmin]$lsnrctl status list1
[oracle@orcladmin]$lsnrctl status list2
[oracle@orcladmin]$lsnrctl status list3
[oracle@orcladmin]$lsnrctl status list4
說(shuō)明：正常情況下orcl實(shí)例會(huì)被注冊(cè)到list1，其余監(jiān)聽(tīng)上沒(méi)有任何服務(wù)與實(shí)例。
執(zhí)行下面操作
SQL> alter system set local_listener=' ALL_LISTENER’;
SQL> alter system register;
再次查看各偵聽(tīng)器狀態(tài)
[oracle@orcl admin]$ lsnrctl status list2
LSNRCTLfor Linux: Version 11.2.0.4.0 - Production on 17-MAY-2015 19:35:57
Copyright(c) 1991, 2013, Oracle. All rightsreserved.
Connectingto (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.30)(PORT=1522)))
STATUSof the LISTENER
------------------------
Alias list2
Version TNSLSNR for Linux: Version11.2.0.4.0 - Production
StartDate 17-MAY-2015 17:02:56
Uptime 0 days 2 hr. 33 min. 1 sec
TraceLevel off
Security ON: Local OS Authentication
SNMP OFF
ListenerParameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
ListenerLog File /u01/app/oracle/diag/tnslsnr/orcl/list2/alert/log.xml
ListeningEndpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl.lineqi.com)(PORT=1522)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance"orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance"orcl", status READY, has 1 handler(s) for this service...
Thecommand completed successfully
[oracle@orcl admin]$ lsnrctl status list3
LSNRCTLfor Linux: Version 11.2.0.4.0 - Production on 17-MAY-2015 19:35:55
Copyright(c) 1991, 2013, Oracle. All rightsreserved.
Connectingto (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.30)(PORT=1523)))
STATUSof the LISTENER
------------------------
Alias list3
Version TNSLSNR for Linux: Version11.2.0.4.0 - Production
StartDate 17-MAY-2015 19:16:16
Uptime 0 days 0 hr. 19 min. 38 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
ListenerParameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
ListenerLog File /u01/app/oracle/diag/tnslsnr/orcl/list3/alert/log.xml
ListeningEndpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.30)(PORT=1523)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance"orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance"orcl", status READY, has 1 handler(s) for this service...
Thecommand completed successfully
[oracle@orcl admin]$ lsnrctl status list4
LSNRCTLfor Linux: Version 11.2.0.4.0 - Production on 17-MAY-2015 19:35:59
Copyright(c) 1991, 2013, Oracle. All rightsreserved.
Connectingto (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.31)(PORT=1524)))
STATUSof the LISTENER
------------------------
Alias list4
Version TNSLSNR for Linux: Version11.2.0.4.0 - Production
StartDate 17-MAY-2015 19:16:14
Uptime 0 days 0 hr. 19 min. 45 sec
TraceLevel off
Security ON: Local OS Authentication
SNMP OFF
ListenerParameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
ListenerLog File /u01/app/oracle/diag/tnslsnr/orcl/list4/alert/log.xml
ListeningEndpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.31)(PORT=1524)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance"orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance"orcl", status READY, has 1 handler(s) for this service...
Thecommand completed successfully
4、通過(guò)客戶(hù)端測(cè)試
C:\Users\Administrator>sqlpluslineqi/lineqi@192.168.1.30:1521/orcl
SQL*Plus:Release 11.2.0.1.0 Production on 星期日 5月 17 19:38:38 2015
Copyright(c) 1982, 2010, Oracle. All rightsreserved.
連接到:
OracleDatabase 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With thePartitioning, OLAP, Data Mining and Real Application Testing options
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
orcl
C:\Users\Administrator>sqlpluslineqi/lineqi@192.168.1.30:1522/orcl
SQL*Plus:Release 11.2.0.1.0 Production on 星期日 5月 17 19:38:55 2015
Copyright(c) 1982, 2010, Oracle. All rightsreserved.
連接到:
OracleDatabase 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With thePartitioning, OLAP, Data Mining and Real Application Testing options
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
orcl
C:\Users\Administrator>sqlpluslineqi/lineqi@192.168.1.30:1523/orcl
SQL*Plus:Release 11.2.0.1.0 Production on 星期日 5月 17 19:39:08 2015
Copyright(c) 1982, 2010, Oracle. All rightsreserved.
連接到:
OracleDatabase 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With thePartitioning, OLAP, Data Mining and Real Application Testing options
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
orcl
C:\Users\Administrator>sqlpluslineqi/lineqi@192.168.1.31:1524/orcl
SQL*Plus:Release 11.2.0.1.0 Production on 星期日 5月 17 19:41:11 2015
Copyright(c) 1982, 2010, Oracle. All rightsreserved.
連接到:
OracleDatabase 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With thePartitioning, OLAP, Data Mining and Real Application Testing options
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
orcl
上面是通過(guò)EZCONNECT方式來(lái)測(cè)試的，也可以在客戶(hù)端配置來(lái)測(cè)試，在tnsname.ora添加如下內(nèi)容。
orcl=
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE=ON)
(FAILOVER=ON)
(ADDRESS= (PROTOCOL = TCP)(HOST = 192.168.1.30)(PORT = 1521))
(ADDRESS= (PROTOCOL = TCP)(HOST = 192.168.1.30)(PORT = 1522))
(ADDRESS= (PROTOCOL = TCP)(HOST = 192.168.1.30)(PORT = 1523))
(ADDRESS= (PROTOCOL = TCP)(HOST = 192.168.1.31)(PORT = 1524))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
二、在一個(gè)網(wǎng)接口的不同端口監(jiān)聽(tīng)多個(gè)實(shí)例
說(shuō)明：192.168.1.30:1521監(jiān)聽(tīng)orcl實(shí)例
192.168.1.30:1522監(jiān)聽(tīng)test實(shí)例
目前是1521這個(gè)端口監(jiān)聽(tīng)著兩個(gè)實(shí)例
[oracle@orcl admin]$ lsnrctl status list1
LSNRCTLfor Linux: Version 11.2.0.4.0 - Production on 17-MAY-2015 17:00:27
Copyright(c) 1991, 2013, Oracle. All rightsreserved.
Connectingto (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl.lineqi.com)(PORT=1521)))
STATUSof the LISTENER
------------------------
Alias list1
Version TNSLSNR for Linux: Version11.2.0.4.0 - Production
StartDate 17-MAY-2015 15:45:52
Uptime 0 days 1 hr. 14 min. 35 sec
TraceLevel off
Security ON: Local OS Authentication
SNMP OFF
ListenerParameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
ListenerLog File /u01/app/oracle/diag/tnslsnr/orcl/list1/alert/log.xml
ListeningEndpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl.lineqi.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
ServicesSummary...
Service "orcl" has 1 instance(s).
Instance"orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance"orcl", status READY, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
Instance"test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
Instance"test", status READY, has 1 handler(s) for this service...
Thecommand completed successfully
1、配置listener
這里配置list2監(jiān)聽(tīng)即可，可以通過(guò)netca工具，也可直接編輯listener.ora文件
[oracle@orcl 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.
LIST2 =
(DESCRIPTION_LIST =
(DESCRIPTION=
(ADDRESS =(PROTOCOL = TCP)(HOST =orcl.lineqi.com)(PORT = 1522))
)
)
LIST1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =orcl.lineqi.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY =EXTPROC1521))
)
)
ADR_BASE_LIST2 = /u01/app/oracle
ADR_BASE_LIST1= /u01/app/oracle
[oracle@orcl admin]$ lsnrctl start list2
LSNRCTLfor Linux: Version 11.2.0.4.0 - Production on 17-MAY-2015 17:02:56
Copyright(c) 1991, 2013, Oracle. All rightsreserved.
Starting/u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNRfor Linux: Version 11.2.0.4.0 - Production
Systemparameter file is/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Logmessages written to /u01/app/oracle/diag/tnslsnr/orcl/list2/alert/log.xml
Listeningon: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl.lineqi.com)(PORT=1522)))
Connectingto (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl.lineqi.com)(PORT=1522)))
STATUSof the LISTENER
------------------------
Alias list2
Version TNSLSNR for Linux: Version11.2.0.4.0 - Production
StartDate 17-MAY-2015 17:02:56
Uptime 0 days 0 hr. 0 min. 0 sec
TraceLevel off
Security ON: Local OS Authentication
SNMP OFF
ListenerParameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
ListenerLog File /u01/app/oracle/diag/tnslsnr/orcl/list2/alert/log.xml
ListeningEndpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl.lineqi.com)(PORT=1522)))
Thelistener supports no services
Thecommand completed successfully
此時(shí)沒(méi)有監(jiān)聽(tīng)任何服務(wù)或?qū)嵗?/p>
2、接著配置tnsname.ora
[oracle@orcl admin]$ cat tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.30)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.1.30)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)
執(zhí)行下面操作
SQL> alter system set local_listener='test';
SQL> alter system register;
接著查看list2狀態(tài)發(fā)現(xiàn)實(shí)例已經(jīng)注冊(cè)成功了
[oracle@orcladmin]$ lsnrctl status list2
LSNRCTLfor Linux: Version 11.2.0.4.0 - Production on 17-MAY-2015 17:06:04
Copyright(c) 1991, 2013, Oracle. All rightsreserved.
Connectingto (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl.lineqi.com)(PORT=1522)))
STATUSof the LISTENER
------------------------
Alias list2
Version TNSLSNR for Linux: Version11.2.0.4.0 - Production
StartDate 17-MAY-2015 17:02:56
Uptime 0 days 0 hr. 3 min. 7 sec
TraceLevel off
Security ON: Local OS Authentication
SNMP OFF
ListenerParameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
ListenerLog File /u01/app/oracle/diag/tnslsnr/orcl/list2/alert/log.xml
ListeningEndpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl.lineqi.com)(PORT=1522)))
ServicesSummary...
Service"test" has 1 instance(s).
Instance "test", status READY, has1 handler(s) for this service...
Service"testXDB" has 1 instance(s).
Instance "test", status READY, has1 handler(s) for this service...
Thecommand completed successfully
現(xiàn)在查看list1發(fā)現(xiàn)1521這個(gè)商品只監(jiān)聽(tīng)orcl實(shí)例
[oracle@orcladmin]$ lsnrctl status list1
LSNRCTLfor Linux: Version 11.2.0.4.0 - Production on 17-MAY-2015 17:06:47
Copyright(c) 1991, 2013, Oracle. All rightsreserved.
Connectingto (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl.lineqi.com)(PORT=1521)))
STATUSof the LISTENER
------------------------
Alias list1
Version TNSLSNR for Linux: Version11.2.0.4.0 - Production
StartDate 17-MAY-2015 15:45:52
Uptime 0 days 1 hr. 20 min. 54 sec
TraceLevel off
Security ON: Local OS Authentication
SNMP OFF
ListenerParameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
ListenerLog File /u01/app/oracle/diag/tnslsnr/orcl/list1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl.lineqi.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance"orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance"orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
3、通過(guò)客戶(hù)端測(cè)試
C:\Users\Administrator>sqlplussystem/test@192.168.1.30:1522/test
SQL*Plus:Release 11.2.0.1.0 Production on 星期日 5月 17 17:09:52 2015
Copyright(c) 1982, 2010, Oracle. All rightsreserved.
連接到:
OracleDatabase 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With thePartitioning, OLAP, Data Mining and Real Application Testing options
SQL>select instance_name from v$instance;
INSTANCE_NAME
----------------
Test
C:\Users\Administrator>sqlpluslineqi/lineqi@192.168.1.30:1521/orcl
SQL*Plus:Release 11.2.0.1.0 Production on 星期日 5月 17 17:09:34 2015
Copyright(c) 1982, 2010, Oracle. All rightsreserved.
連接到:
OracleDatabase 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With thePartitioning, OLAP, Data Mining and Real Application Testing options
SQL>select instance_name from v$instance;
INSTANCE_NAME
----------------
orcl
三、在兩個(gè)網(wǎng)絡(luò)接口上分別配置監(jiān)聽(tīng)器監(jiān)聽(tīng)兩個(gè)實(shí)例
說(shuō)明：192.168.1.30:1521監(jiān)聽(tīng)orcl實(shí)例
192.168.1.31:1522監(jiān)聽(tīng)test實(shí)例
實(shí)例orcl創(chuàng)建好list1監(jiān)聽(tīng)后已經(jīng)被監(jiān)聽(tīng)了，這里直接配置list2監(jiān)聽(tīng)即可。
[oracle@orcl admin]$ lsnrctl status list1
LSNRCTL for Linux: Version 11.2.0.4.0 -Production on 17-MAY-2015 16:41:25
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl.lineqi.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias list1
Version TNSLSNR for Linux: Version11.2.0.4.0 - Production
Start Date 17-MAY-2015 15:45:52
Uptime 0 days 0 hr. 55 min. 32 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/app/oracle/diag/tnslsnr/orcl/list1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl.lineqi.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service"orcl" has 1 instance(s).
Instance "orcl", status READY, has1 handler(s) for this service...
Service"orclXDB" has 1 instance(s).
Instance "orcl", status READY, has1 handler(s) for this service...
Thecommand completed successfully
1、配置listener
這里配置list2監(jiān)聽(tīng)即可，可以通過(guò)netca工具，也可直接編輯listener.ora文件
[oracle@orcl 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.
LIST2 =
(DESCRIPTION_LIST =
(DESCRIPTION=
(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.1.31)(PORT = 1522))
)
)
LIST1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =orcl.lineqi.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY =EXTPROC1521))
)
)
ADR_BASE_LIST2 = /u01/app/oracle
ADR_BASE_LIST1= /u01/app/oracle
2、接著配置tnsname.ora
[oracle@orcl admin]$ cat tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.30)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.1.31)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)
3、啟動(dòng)list2并查看狀態(tài)
[oracle@orcl admin]$ lsnrctl startlist2
[oracle@orcl admin]$ lsnrctl status list2
LSNRCTLfor Linux: Version 11.2.0.4.0 - Production on 17-MAY-2015 16:06:55
Copyright(c) 1991, 2013, Oracle. All rightsreserved.
Connectingto (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.31)(PORT=1522)))
STATUSof the LISTENER
------------------------
Alias LIST2
Version TNSLSNR for Linux: Version11.2.0.4.0 - Production
StartDate 17-MAY-2015 15:57:56
Uptime 0 days 0 hr. 8 min. 58 sec
TraceLevel off
Security ON: Local OS Authentication
SNMP OFF
ListenerParameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
ListenerLog File /u01/app/oracle/diag/tnslsnr/orcl/list2/alert/log.xml
ListeningEndpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl.lineqi.com)(PORT=1522)))
Thelistener supports no services
Thecommand completed successfully
這里發(fā)現(xiàn)沒(méi)任何服務(wù)或?qū)嵗槐O(jiān)聽(tīng)
執(zhí)行下面操作
SQL>alter system set local_listener='test';
SQL>alter system register;
接著查看list2狀態(tài)發(fā)現(xiàn)實(shí)例已經(jīng)注冊(cè)成功了
[oracle@orcl admin]$ lsnrctl status list2
LSNRCTLfor Linux: Version 11.2.0.4.0 - Production on 17-MAY-2015 16:08:03
Copyright(c) 1991, 2013, Oracle. All rightsreserved.
Connectingto (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.31)(PORT=1522)))
STATUSof the LISTENER
------------------------
Alias LIST2
Version TNSLSNR for Linux: Version11.2.0.4.0 - Production
StartDate 17-MAY-2015 15:57:56
Uptime 0 days 0 hr. 10 min. 7 sec
TraceLevel off
Security ON: Local OSAuthentication
SNMP OFF
ListenerParameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
ListenerLog File /u01/app/oracle/diag/tnslsnr/orcl/list2/alert/log.xml
ListeningEndpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl.lineqi.com)(PORT=1522)))
ServicesSummary...
Service"test" has 1 instance(s).
Instance "test", status READY, has1 handler(s) for this service...
Service"testXDB" has 1 instance(s).
Instance "test", status READY, has1 handler(s) for this service...
Thecommand completed successfully
4、通過(guò)客戶(hù)端測(cè)試
C:\Users\Administrator>sqlplussystem/test@192.168.1.31:1522/test
SQL*Plus:Release 11.2.0.1.0 Production on 星期日 5月 17 16:21:09 2015
Copyright(c) 1982, 2010, Oracle. All rightsreserved.
連接到:
OracleDatabase 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With thePartitioning, OLAP, Data Mining and Real Application Testing options
SQL>select instance_name from v$instance;
INSTANCE_NAME
----------------
test
標(biāo)題名稱(chēng)：oracle配置多網(wǎng)絡(luò)接口多端口listener
分享路徑：http://bm7419.com/article4/isgjoe.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供商城網(wǎng)站、靜態(tài)網(wǎng)站、網(wǎng)站營(yíng)銷(xiāo)、網(wǎng)站制作、App開(kāi)發(fā)、面包屑導(dǎo)航
聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶(hù)投稿、用戶(hù)轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話(huà)：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)
- 用戶(hù)體驗(yàn)其實(shí)就這么簡(jiǎn)單！ 2022-06-07
- 品牌網(wǎng)站設(shè)計(jì)優(yōu)越性提升企業(yè)建站水平 2021-04-18
- 如何制作自己的網(wǎng)站 品牌網(wǎng)站設(shè)計(jì)技巧 2021-05-28
- 理解透公司品牌內(nèi)涵后才能做好品牌網(wǎng)站設(shè)計(jì)制作 2022-04-05
- 如何才能做好品牌網(wǎng)站設(shè)計(jì)與建設(shè) 2023-03-19
- 網(wǎng)站制作專(zhuān)業(yè)公司更相符公司的成長(zhǎng)請(qǐng)求 2022-06-04
- 品牌網(wǎng)站設(shè)計(jì)中運(yùn)用到的首頁(yè)色彩和框架 2023-02-16
- 品牌網(wǎng)站設(shè)計(jì)如何在同行業(yè)中脫穎而出？ 2016-01-18
- 品牌網(wǎng)站設(shè)計(jì)有哪些問(wèn)題要注意？ 2020-12-26
- 品牌網(wǎng)站設(shè)計(jì)如何達(dá)到展示目的 2022-12-14
- 常見(jiàn)的營(yíng)銷(xiāo)網(wǎng)站類(lèi)型你了解嗎 企業(yè)品牌網(wǎng)站設(shè)計(jì)思路 2021-05-11
- 品牌網(wǎng)站設(shè)計(jì)：如何制作設(shè)計(jì)一個(gè)好的網(wǎng)站？ 2016-10-06