[20151023]不啟動監聽遠端能連線資料庫嗎?
[20151023]不啟動監聽遠端能連線資料庫嗎？.txt
--如果有人問你不啟動監聽遠端能連線資料庫嗎？我想我開始的回答不行。
--但是不要忘了,oracle支援專有伺服器以及共享伺服器模式，而共享伺服器模式可以不使用1521埠，這樣就可以不用啟動監聽遠端連
--接伺服器。
--透過測試來說明問題。
1.測試環境：
SYS@test> @ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- ----------------------------------------------------------------
x86_64/Linux 2.4.xx 10.2.0.4.0 Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
SYS@test> show parameter shared
NAME TYPE VALUE
------------------------------------ ------------- ----------
hi_shared_memory_address integer 0
max_shared_servers integer
shared_memory_address integer 0
shared_pool_reserved_size big integer 13421772
shared_pool_size big integer 0
shared_server_sessions integer
shared_servers integer 1
SYS@test> show parameter dispatchers
NAME TYPE VALUE
------------------------------------ -------------- --------------------------------
dispatchers string (PROTOCOL=TCP) (SERVICE=testXDB)
max_dispatchers integer
$ ps -ef | grep ora_d00[0]
oracle 7697 1 0 08:28 ? 00:00:00 ora_d000_test
--這是一個安裝好以後沒有改動以上引數的設定。可以發現預設就啟動一個ora_d000_test.這個就是用於共享伺服器的連線，預設僅僅啟
--動1個,如果多個是ora_d001_test....
$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 23-OCT-2015 08:54:02
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.89)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
$ netstat -na | grep 1521
--可以發現監聽沒有啟動。
2.修改遠端的client,在tnsnames.ora加入如下：
89S =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.89)(PORT = 1521))
)
(CONNECT_DATA =
(SID = test)
(SERVER = SHARED)
)
)
--很明顯這樣是無法連線資料庫的，因為1521埠沒有開啟。
--我們必須要要知道程式ora_d000_test開啟的埠號。
$ netstat -tnlp
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN -
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN -
tcp 0 0 0.0.0.0:29018 0.0.0.0:* LISTEN 7697/ora_d000_test
tcp 0 0 0.0.0.0:51206 0.0.0.0:* LISTEN -
tcp 0 0 :::111 :::* LISTEN -
tcp 0 0 :::22 :::* LISTEN -
--從以上輸出可以知道遠端埠29018(對應ora_d000_test程式)。修改tnsnames.ora檔案如下：
89S =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.89)(PORT = 29018))
)
(CONNECT_DATA =
(SID = test)
(SERVER = SHARED)
)
)
d:\tools\rlwrap>sqlplus scott/btbtms@89s
SQL*Plus: Release 12.1.0.1.0 Production on Fri Oct 23 08:59:14 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SCOTT@89s> @spid
SID SERIAL# SPID C50
---------- ---------- ------ --------------------------------------------------
146 21 7699 alter system kill session '146,21' immediate;
SCOTT@89s> select sysdate from dual ;
SYSDATE
-------------------
2015-10-23 09:07:33
SCOTT@89s> select sid, serial#,server from v$session where sid = ( select sid from v$mystat where rownum=1);
SID SERIAL# SERVER
---------- ---------- ---------
146 21 SHARED
--這樣遠端就可以連線資料庫。注意上面的配置只能使用(SID = test),因為dispatchers預設配置僅僅支援SERVICE=testXDB。
$ ps -ef | egrep "ora_d000|7699" | grep -v egrep
oracle 7697 1 0 08:28 ? 00:00:00 ora_d000_test
oracle 7699 1 0 08:28 ? 00:00:00 ora_s000_test
--再啟動一個會話：
SCOTT@89s> @spid
SID SERIAL# SPID C50
---------- ---------- ------ --------------------------------------------------
142 32 7699 alter system kill session '142,32' immediate;
--依舊使用程式號(ora_s000_test)是7699.這也是共享的含義，節約了伺服器記憶體的使用。特別適合連線非常巨大，執行sql語句完成很快的情況。
3.我的測試client是12c，11gR2開始增強了簡易連線魔術：
d:\tools\rlwrap>sqlplus scott/btbtms@192.168.100.89:29018/test:shared
SQL*Plus: Release 12.1.0.1.0 Production on Fri Oct 23 09:17:16 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
--因為不支援服務名test(主要是沒有配置)。執行如下：
d:\tools\rlwrap>sqlplus scott/btbtms@192.168.100.89:29018/testXDB:shared
SQL*Plus: Release 12.1.0.1.0 Production on Fri Oct 23 09:18:32 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SCOTT@192.168.100.89:29018/testXDB:shared> @spid
SID SERIAL# SPID C50
---------- ---------- ------ --------------------------------------------------
142 40 7699 alter system kill session '142,40' immediate;
SCOTT@192.168.100.89:29018/testXDB:shared> select sid, serial#,server from v$session where sid = ( select sid from v$mystat where rownum=1);
SID SERIAL# SERVER
---------- ---------- ---------
142 40 SHARED
4.修改引數dispatchers:
SYS@test> alter system set dispatchers='(PROTOCOL=TCP) (DISP=2)(SERVICE=test,testXDB)' scope=memory;
System altered.
$ ps -ef | egrep "ora_d00|7699" | grep -v egrep
oracle 7697 1 0 08:28 ? 00:00:00 ora_d000_test
oracle 7699 1 0 08:28 ? 00:00:00 ora_s000_test
oracle 8793 1 0 09:21 ? 00:00:00 ora_d001_test
--修改引數加入DISP=2，這樣dispatchers啟動了2個。另外我還增加服務名test，下面測試使用test服務的情況：
d:\tools\rlwrap>sqlplus scott/btbtms@192.168.100.89:29018/test:shared
SQL*Plus: Release 12.1.0.1.0 Production on Fri Oct 23 09:24:17 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
--ok透過。
5.修改tnsnames.ora配置：
--說明：採用SERVICE_NAME ，不使用sid。
89S =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.89)(PORT = 29018))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
(SERVER = SHARED)
)
)
d:\tools\rlwrap>sqlplus scott/btbtms@89s
...
SCOTT@89s> @spid
SID SERIAL# SPID C50
---------- ---------- ------ --------------------------------------------------
142 48 7699 alter system kill session '142,48' immediate;
SCOTT@89s> select sid, serial#,server from v$session where sid = ( select sid from v$mystat where rownum=1);
SID SERIAL# SERVER
---------- ---------- ---------
142 48 SHARED
d:\tools\rlwrap>sqlplus scott/btbtms@192.168.100.89:29018/test:shared
...
SCOTT@192.168.100.89:29018/test:shared> select sid, serial#,server from v$session where sid = ( select sid from v$mystat where rownum=1);
SID SERIAL# SERVER
---------- ---------- ---------
142 50 SHARED
6.當然共享伺服器的埠隨資料庫啟動動態變化的。
--也可以透過檢視v$dispatcher知道對應的埠號。
SYS@test> select * from v$dispatcher;
NAME NETWORK PADDR STATUS ACC MESSAGES BYTES BREAKS OWNED CREATED IDLE BUSY LISTENER CONF_INDX
----- --------------------------------------------------- ---------------- ------ --- -------- ------ ------ ----- ------- ------ ---- -------- ---------
D000 (ADDRESS=(PROTOCOL=tcp)(HOST=icaredg3)(PORT=29018)) 000000007C262C40 WAIT YES 348 133567 0 2 10 380509 2 0 0
D001 (ADDRESS=(PROTOCOL=tcp)(HOST=icaredg3)(PORT=22202)) 000000007C266398 WAIT YES 0 0 0 0 0 59654 0 0 0
7.現在啟動監聽修改tnsnames.ora檔案埠號為1521：
89S =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.89)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
(SERVER = SHARED)
)
)
$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 23-OCT-2015 09:35:31
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.4.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.89)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.89)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date 23-OCT-2015 09:35:33
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.89)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
Instance "test", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
$ netstat -tnlp
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN -
tcp 0 0 192.168.100.89:1521 0.0.0.0:* LISTEN 8931/tnslsnr
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN -
tcp 0 0 0.0.0.0:22202 0.0.0.0:* LISTEN 8793/ora_d001_test
tcp 0 0 0.0.0.0:29018 0.0.0.0:* LISTEN 7697/ora_d000_test
tcp 0 0 0.0.0.0:51206 0.0.0.0:* LISTEN -
tcp 0 0 :::111 :::* LISTEN -
tcp 0 0 :::22 :::* LISTEN -
--可以發現啟動了1521埠。
d:\tools\rlwrap>sqlplus scott/btbtms@89s
....
SCOTT@89s> select sid, serial#,server from v$session where sid = ( select sid from v$mystat where rownum=1);
SID SERIAL# SERVER
---------- ---------- ---------
142 54 SHARED
SCOTT@89s> @spid
SID SERIAL# SPID C50
---------- ---------- ------ --------------------------------------------------
142 54 7699 alter system kill session '142,54' immediate;
--很明顯這種模式透過1521埠，因為使用共享伺服器模式，然後再轉到29018埠。我們前面的情況僅僅繞過了1521埠，也就是不通
--過監聽，而直接透過共享模式開啟的埠來連線資料庫。實際上還是透過伺服器開啟的埠來訪問伺服器的，或者用一句安全的術語講
--"蒼蠅不叮無縫的蛋"。
--如果有人問你不啟動監聽遠端能連線資料庫嗎？我想我開始的回答不行。
--但是不要忘了,oracle支援專有伺服器以及共享伺服器模式，而共享伺服器模式可以不使用1521埠，這樣就可以不用啟動監聽遠端連
--接伺服器。
--透過測試來說明問題。
1.測試環境：
SYS@test> @ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- ----------------------------------------------------------------
x86_64/Linux 2.4.xx 10.2.0.4.0 Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
SYS@test> show parameter shared
NAME TYPE VALUE
------------------------------------ ------------- ----------
hi_shared_memory_address integer 0
max_shared_servers integer
shared_memory_address integer 0
shared_pool_reserved_size big integer 13421772
shared_pool_size big integer 0
shared_server_sessions integer
shared_servers integer 1
SYS@test> show parameter dispatchers
NAME TYPE VALUE
------------------------------------ -------------- --------------------------------
dispatchers string (PROTOCOL=TCP) (SERVICE=testXDB)
max_dispatchers integer
$ ps -ef | grep ora_d00[0]
oracle 7697 1 0 08:28 ? 00:00:00 ora_d000_test
--這是一個安裝好以後沒有改動以上引數的設定。可以發現預設就啟動一個ora_d000_test.這個就是用於共享伺服器的連線，預設僅僅啟
--動1個,如果多個是ora_d001_test....
$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 23-OCT-2015 08:54:02
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.89)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
$ netstat -na | grep 1521
--可以發現監聽沒有啟動。
2.修改遠端的client,在tnsnames.ora加入如下：
89S =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.89)(PORT = 1521))
)
(CONNECT_DATA =
(SID = test)
(SERVER = SHARED)
)
)
--很明顯這樣是無法連線資料庫的，因為1521埠沒有開啟。
--我們必須要要知道程式ora_d000_test開啟的埠號。
$ netstat -tnlp
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN -
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN -
tcp 0 0 0.0.0.0:29018 0.0.0.0:* LISTEN 7697/ora_d000_test
tcp 0 0 0.0.0.0:51206 0.0.0.0:* LISTEN -
tcp 0 0 :::111 :::* LISTEN -
tcp 0 0 :::22 :::* LISTEN -
--從以上輸出可以知道遠端埠29018(對應ora_d000_test程式)。修改tnsnames.ora檔案如下：
89S =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.89)(PORT = 29018))
)
(CONNECT_DATA =
(SID = test)
(SERVER = SHARED)
)
)
d:\tools\rlwrap>sqlplus scott/btbtms@89s
SQL*Plus: Release 12.1.0.1.0 Production on Fri Oct 23 08:59:14 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SCOTT@89s> @spid
SID SERIAL# SPID C50
---------- ---------- ------ --------------------------------------------------
146 21 7699 alter system kill session '146,21' immediate;
SCOTT@89s> select sysdate from dual ;
SYSDATE
-------------------
2015-10-23 09:07:33
SCOTT@89s> select sid, serial#,server from v$session where sid = ( select sid from v$mystat where rownum=1);
SID SERIAL# SERVER
---------- ---------- ---------
146 21 SHARED
--這樣遠端就可以連線資料庫。注意上面的配置只能使用(SID = test),因為dispatchers預設配置僅僅支援SERVICE=testXDB。
$ ps -ef | egrep "ora_d000|7699" | grep -v egrep
oracle 7697 1 0 08:28 ? 00:00:00 ora_d000_test
oracle 7699 1 0 08:28 ? 00:00:00 ora_s000_test
--再啟動一個會話：
SCOTT@89s> @spid
SID SERIAL# SPID C50
---------- ---------- ------ --------------------------------------------------
142 32 7699 alter system kill session '142,32' immediate;
--依舊使用程式號(ora_s000_test)是7699.這也是共享的含義，節約了伺服器記憶體的使用。特別適合連線非常巨大，執行sql語句完成很快的情況。
3.我的測試client是12c，11gR2開始增強了簡易連線魔術：
d:\tools\rlwrap>sqlplus scott/btbtms@192.168.100.89:29018/test:shared
SQL*Plus: Release 12.1.0.1.0 Production on Fri Oct 23 09:17:16 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
--因為不支援服務名test(主要是沒有配置)。執行如下：
d:\tools\rlwrap>sqlplus scott/btbtms@192.168.100.89:29018/testXDB:shared
SQL*Plus: Release 12.1.0.1.0 Production on Fri Oct 23 09:18:32 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SCOTT@192.168.100.89:29018/testXDB:shared> @spid
SID SERIAL# SPID C50
---------- ---------- ------ --------------------------------------------------
142 40 7699 alter system kill session '142,40' immediate;
SCOTT@192.168.100.89:29018/testXDB:shared> select sid, serial#,server from v$session where sid = ( select sid from v$mystat where rownum=1);
SID SERIAL# SERVER
---------- ---------- ---------
142 40 SHARED
4.修改引數dispatchers:
SYS@test> alter system set dispatchers='(PROTOCOL=TCP) (DISP=2)(SERVICE=test,testXDB)' scope=memory;
System altered.
$ ps -ef | egrep "ora_d00|7699" | grep -v egrep
oracle 7697 1 0 08:28 ? 00:00:00 ora_d000_test
oracle 7699 1 0 08:28 ? 00:00:00 ora_s000_test
oracle 8793 1 0 09:21 ? 00:00:00 ora_d001_test
--修改引數加入DISP=2，這樣dispatchers啟動了2個。另外我還增加服務名test，下面測試使用test服務的情況：
d:\tools\rlwrap>sqlplus scott/btbtms@192.168.100.89:29018/test:shared
SQL*Plus: Release 12.1.0.1.0 Production on Fri Oct 23 09:24:17 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
--ok透過。
5.修改tnsnames.ora配置：
--說明：採用SERVICE_NAME ，不使用sid。
89S =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.89)(PORT = 29018))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
(SERVER = SHARED)
)
)
d:\tools\rlwrap>sqlplus scott/btbtms@89s
...
SCOTT@89s> @spid
SID SERIAL# SPID C50
---------- ---------- ------ --------------------------------------------------
142 48 7699 alter system kill session '142,48' immediate;
SCOTT@89s> select sid, serial#,server from v$session where sid = ( select sid from v$mystat where rownum=1);
SID SERIAL# SERVER
---------- ---------- ---------
142 48 SHARED
d:\tools\rlwrap>sqlplus scott/btbtms@192.168.100.89:29018/test:shared
...
SCOTT@192.168.100.89:29018/test:shared> select sid, serial#,server from v$session where sid = ( select sid from v$mystat where rownum=1);
SID SERIAL# SERVER
---------- ---------- ---------
142 50 SHARED
6.當然共享伺服器的埠隨資料庫啟動動態變化的。
--也可以透過檢視v$dispatcher知道對應的埠號。
SYS@test> select * from v$dispatcher;
NAME NETWORK PADDR STATUS ACC MESSAGES BYTES BREAKS OWNED CREATED IDLE BUSY LISTENER CONF_INDX
----- --------------------------------------------------- ---------------- ------ --- -------- ------ ------ ----- ------- ------ ---- -------- ---------
D000 (ADDRESS=(PROTOCOL=tcp)(HOST=icaredg3)(PORT=29018)) 000000007C262C40 WAIT YES 348 133567 0 2 10 380509 2 0 0
D001 (ADDRESS=(PROTOCOL=tcp)(HOST=icaredg3)(PORT=22202)) 000000007C266398 WAIT YES 0 0 0 0 0 59654 0 0 0
7.現在啟動監聽修改tnsnames.ora檔案埠號為1521：
89S =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.89)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
(SERVER = SHARED)
)
)
$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 23-OCT-2015 09:35:31
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.4.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.89)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.89)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date 23-OCT-2015 09:35:33
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.89)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
Instance "test", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
$ netstat -tnlp
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN -
tcp 0 0 192.168.100.89:1521 0.0.0.0:* LISTEN 8931/tnslsnr
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN -
tcp 0 0 0.0.0.0:22202 0.0.0.0:* LISTEN 8793/ora_d001_test
tcp 0 0 0.0.0.0:29018 0.0.0.0:* LISTEN 7697/ora_d000_test
tcp 0 0 0.0.0.0:51206 0.0.0.0:* LISTEN -
tcp 0 0 :::111 :::* LISTEN -
tcp 0 0 :::22 :::* LISTEN -
--可以發現啟動了1521埠。
d:\tools\rlwrap>sqlplus scott/btbtms@89s
....
SCOTT@89s> select sid, serial#,server from v$session where sid = ( select sid from v$mystat where rownum=1);
SID SERIAL# SERVER
---------- ---------- ---------
142 54 SHARED
SCOTT@89s> @spid
SID SERIAL# SPID C50
---------- ---------- ------ --------------------------------------------------
142 54 7699 alter system kill session '142,54' immediate;
--很明顯這種模式透過1521埠，因為使用共享伺服器模式，然後再轉到29018埠。我們前面的情況僅僅繞過了1521埠，也就是不通
--過監聽，而直接透過共享模式開啟的埠來連線資料庫。實際上還是透過伺服器開啟的埠來訪問伺服器的，或者用一句安全的術語講
--"蒼蠅不叮無縫的蛋"。
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/267265/viewspace-1816211/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 啟動資料庫監聽資料庫
- MySQL資料庫遠端連線開啟方法MySql資料庫
- spring boot 不連線資料庫啟動Spring Boot資料庫
- 遠端連線mysql資料庫MySql資料庫
- 資料庫遠端連線失敗資料庫
- ORACLE 配置連線遠端資料庫Oracle資料庫
- 用SQLyog或Navicat遠端連線資料庫SQL資料庫
- PHP 遠端使用 PDO 連線 access 資料庫PHP資料庫
- PL/SQL Developer連線遠端Oracle資料庫SQLDeveloperOracle資料庫
- linux配置mysql資料庫遠端連線失敗LinuxMySql資料庫
- Linux下安裝redis資料庫服務，並開啟遠端連線LinuxRedis資料庫
- [20190102]連線串不配置服務名能連線資料庫嗎.txt資料庫
- 117 遠端連線mysql資料庫的幾種方式MySql資料庫
- mysql開啟遠端連線MySql
- 成為MySQL DBA後，再看ORACLE資料庫（二、監聽與連線）MySqlOracle資料庫
- Liunx開啟ssh遠端連線
- 如何遠端連線 遠端桌面軟體連線
- vps如何遠端連線,遠端桌面連線vps
- Mysql資料庫監聽binlogMySql資料庫
- PostgreSQL15開啟遠端連線SQL
- 怎麼開啟遠端桌面連線 專業遠端桌面
- git連線遠端倉庫的方式Git
- [20211012]測試遠端監聽.txt
- 解決navicat遠端連線資料庫報2059錯誤的方法資料庫
- Navicat 連線遠端資料庫及 SSH 預設埠號的修改資料庫
- python遠端連線mysql以及pandas.DataFrame.to_sql寫入資料庫PythonMySql資料庫
- 如何快速讓MySQL資料庫伺服器支援遠端連線MRMySql資料庫伺服器
- win10為什麼遠端桌面連線不上 win10遠端桌面連線不上解決方法Win10
- 遠端桌面連線怎麼開啟 win7遠端桌面開啟Win7
- 分支資料監測終端（啟動）
- 如何遠端連線 桌面設定遠端桌面連線
- win10遠端桌面連線在哪裡開啟 win10開啟遠端桌面連線的方法Win10
- ORACLE rac資料庫監聽與應用TNS連線串配置與ORA12519Oracle資料庫
- win10 mstsc遠端連線不上怎麼設定_win10 mstsc遠端連線不上解決方法Win10
- win10遠端桌面連線不上怎麼辦_window10遠端桌面連線不上如何解決Win10
- win10遠端桌面連線不上 伺服器批次遠端Win10伺服器
- mysql 開放遠端連線許可權連不上MySql
- 遠端連線軟體有哪些，遠端連線軟體有哪些能批次操控伺服器的伺服器
- vnc遠端連線工具，vnc遠端連線工具如何監控多臺員工電腦螢幕？VNC