[20211109]sqlplus本地登入緩慢分析2.txt
[20211109]sqlplus本地登入緩慢分析2.txt
--//昨天測試了18c sqlplus / as sysdba登入緩慢的問題，主要原因是/etc/hosts檔案沒有配置本地的主機名。而登入時使用不正確的dns
--//(注：dns無法連上)，導致每次poll呼叫需要5秒延遲。導致登入緩慢。
--//我的測試在11g下沒有出現這樣的情況，我今天完全模擬18c上的情況重新測試看看。
1.環境：
SYS@book> @ ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
# head -1 /etc/issue
Oracle Linux Server release 5.9
2.測試前準備：
--//A.修改/etc/hosts檔案，註解本地主機名。
--//B.修改/etc/resolv.conf配置,內容如下，該IP無法訪問。
# grep ^name /etc/resolv.conf
nameserver 88.88.88.88
--//C.停止監聽，修改監聽配置檔案listener.ora.
$ lsnrctl stop
--//然後修改配置檔案listener.ora如下：
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxdg4)(PORT = 1521))
# (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
3.監聽測試:
--//重啟監聽。
$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 09-NOV-2021 09:29:44
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/11.2.0.4/dbhome_1/network/log/listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxdg4)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
Linux Error: 110: Connection timed out
Listener failed to start. See the error message(s) above...
--//監聽根本不能啟動。修改會原來配置。
$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 09-NOV-2021 09:34:45
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/11.2.0.4/dbhome_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))
--//停在這裡，不斷要求dns解析主機名。也就是在這樣情況下不能配置IP=0.0.0.0.
--//修改如下：
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
# (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxdg4)(PORT = 1521))
# (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.78)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 09-NOV-2021 09:45:04
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/11.2.0.4/dbhome_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.78)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.78)(PORT=1521)))
--//還是一樣，實際上一樣。如果你修改/etc/hosts檔案。啟動馬上完成。
4.本地連結測試：
--//關閉監聽,本地連線不需要啟動監聽。
$ lsnrctl stop
--//修改/etc/hosts檔案，註解本地主機名。
--//B.修改/etc/resolv.conf配置,內容如下，該IP無法訪問。
# grep ^name /etc/resolv.conf
nameserver 88.88.88.88
$ time strace -f -tTT -e connect,poll,sendto,sendmsg sqlplus -s -l / as sysdba<<<exit
09:52:16 connect(7, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory) <0.000029>
09:52:16 connect(7, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory) <0.000019>
Process 38700 attached
[pid 38700] 09:52:16 connect(6, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory) <0.000028>
[pid 38700] 09:52:16 connect(6, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory) <0.000021>
[pid 38699] 09:52:16 sendto(7, "\24\0\0\0\26\0\1\3P\324\211a\0\0\0\0\0\0\0\0", 20, 0, {sa_family=AF_NETLINK, pid=0, groups=00000000}, 12) = 20 <0.000045>
[pid 38699] 09:52:16 connect(7, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory) <0.000031>
[pid 38699] 09:52:16 connect(7, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory) <0.000028>
[pid 38699] 09:52:16 connect(7, {sa_family=AF_INET, sin_port=htons(53), sin_addr=inet_addr("88.88.88.88")}, 28) = 0 <0.000033>
[pid 38699] 09:52:16 poll([{fd=7, events=POLLOUT}], 1, 0) = 1 ([{fd=7, revents=POLLOUT}]) <0.000023>
[pid 38699] 09:52:16 sendto(7, "]\325\1\0\0\1\0\0\0\0\0\0\10xxxxxdg4\0\0\34\0\1", 26, MSG_NOSIGNAL, NULL, 0) = 26 <0.000037>
[pid 38699] 09:52:16 poll([{fd=7, events=POLLIN}], 1, 5000) = 0 (Timeout) <5.005528>
[pid 38699] 09:52:21 poll([{fd=7, events=POLLOUT}], 1, 0) = 1 ([{fd=7, revents=POLLOUT}]) <0.000029>
[pid 38699] 09:52:21 sendto(7, "]\325\1\0\0\1\0\0\0\0\0\0\10xxxxxdg4\0\0\34\0\1", 26, MSG_NOSIGNAL, NULL, 0) = 26 <0.000041>
[pid 38699] 09:52:21 poll([{fd=7, events=POLLIN}], 1, 5000) = 0 (Timeout) <5.005132>
[pid 38699] 09:52:26 connect(7, {sa_family=AF_INET, sin_port=htons(53), sin_addr=inet_addr("88.88.88.88")}, 28) = 0 <0.000035>
[pid 38699] 09:52:26 poll([{fd=7, events=POLLOUT}], 1, 0) = 1 ([{fd=7, revents=POLLOUT}]) <0.000022>
[pid 38699] 09:52:26 sendto(7, "\263\275\1\0\0\1\0\0\0\0\0\0\10xxxxxdg4\0\0\1\0\1", 26, MSG_NOSIGNAL, NULL, 0) = 26 <0.000033>
[pid 38699] 09:52:26 poll([{fd=7, events=POLLIN}], 1, 5000) = 0 (Timeout) <5.005253>
[pid 38699] 09:52:31 poll([{fd=7, events=POLLOUT}], 1, 0) = 1 ([{fd=7, revents=POLLOUT}]) <0.000029>
[pid 38699] 09:52:31 sendto(7, "\263\275\1\0\0\1\0\0\0\0\0\0\10xxxxxdg4\0\0\1\0\1", 26, MSG_NOSIGNAL, NULL, 0) = 26 <0.000042>
[pid 38699] 09:52:31 poll([{fd=7, events=POLLIN}], 1, 5000) = 0 (Timeout) <5.005164>
[pid 38700] 09:52:36 connect(6, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory) <0.000031>
[pid 38700] 09:52:36 connect(6, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory) <0.000021>
[pid 38700] 09:52:36 connect(6, {sa_family=AF_FILE, path="/dev/log"...}, 110) = 0 <0.000021>
[pid 38700] 09:52:36 sendto(6, "<134>Nov 9 09:52:36 Oracle Audi"..., 225, MSG_NOSIGNAL, NULL, 0) = 225 <0.000091>
Process 38700 detached
real 0m20.203s
user 0m0.068s
sys 0m0.076s
--//遇到前面18c一樣的情況，實際上這個問題的本質無法解析本地主機名。
5.本地連線測試(擴充套件):
--//A.修改/etc/hosts檔案，加入IP與主機名不一致。
# grep 77 /etc/hosts
192.168.100.77 xxxxxdg4
--//注我配置的IP= 192.168.100.78.
--//B.修改/etc/resolv.conf配置,內容如下，該IP無法訪問。
# grep ^name /etc/resolv.conf
nameserver 88.88.88.88
$ time strace -f -tTT -e connect,poll,sendto,sendmsg sqlplus -s -l / as sysdba<<<exit
09:57:10 connect(7, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory) <0.000031>
09:57:10 connect(7, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory) <0.000018>
Process 38722 attached
[pid 38722] 09:57:10 connect(6, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory) <0.000026>
[pid 38722] 09:57:10 connect(6, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory) <0.000020>
[pid 38721] 09:57:10 sendto(7, "\24\0\0\0\26\0\1\3v\325\211a\0\0\0\0\0\0\0\0", 20, 0, {sa_family=AF_NETLINK, pid=0, groups=00000000}, 12) = 20 <0.000040>
[pid 38721] 09:57:10 connect(7, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory) <0.000024>
[pid 38721] 09:57:10 connect(7, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory) <0.000021>
[pid 38722] 09:57:10 connect(8, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory) <0.000025>
[pid 38722] 09:57:10 connect(8, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory) <0.000021>
[pid 38722] 09:57:10 connect(8, {sa_family=AF_FILE, path="/dev/log"...}, 110) = 0 <0.000022>
[pid 38722] 09:57:10 sendto(8, "<134>Nov 9 09:57:10 Oracle Audi"..., 211, MSG_NOSIGNAL, NULL, 0) = 211 <0.000090>
[pid 38722] 09:57:10 sendto(8, "<134>Nov 9 09:57:10 Oracle Audi"..., 210, MSG_NOSIGNAL, NULL, 0) = 210 <0.000062>
[pid 38722] 09:57:10 sendto(8, "<134>Nov 9 09:57:10 Oracle Audi"..., 210, MSG_NOSIGNAL, NULL, 0) = 210 <0.000054>
Process 38722 detached
real 0m0.169s
user 0m0.049s
sys 0m0.063s
--//嘗試在這樣的情況下啟動監聽呢？
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxdg4)(PORT = 1521))
# (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
# (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.78)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
$ time strace -f -e connect,poll,sendto,sendmsg lsnrctl start
connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory)
connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory)
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 09-NOV-2021 09:59:09
Copyright (c) 1991, 2013, Oracle. All rights reserved.
connect(5, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory)
connect(5, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory)
connect(5, {sa_family=AF_INET, sin_port=htons(1521), sin_addr=inet_addr("192.168.100.77")}, 16) = -1 EINPROGRESS (Operation now in progress)
poll([{fd=5, events=POLLOUT}], 1, 60000) = 1 ([{fd=5, revents=POLLOUT|POLLERR|POLLHUP}])
Starting /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/tnslsnr: please wait...
Process 38773 attached
Process 38772 suspended
Process 38774 attached
Process 38772 resumed
Process 38773 detached
[pid 38772] --- SIGCHLD (Child exited) @ 0 (0) ---
[pid 38774] connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory)
[pid 38774] connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory)
[pid 38774] sendto(7, "\24\0\0\0\26\0\1\3\360\325\211a\0\0\0\0\0\0\0\0", 20, 0, {sa_family=AF_NETLINK, pid=0, groups=00000000}, 12) = 20
[pid 38774] connect(8, {sa_family=AF_INET, sin_port=htons(53), sin_addr=inet_addr("88.88.88.88")}, 28) = 0
[pid 38774] poll([{fd=8, events=POLLOUT}], 1, 0) = 1 ([{fd=8, revents=POLLOUT}])
[pid 38774] sendto(8, "\350u\1\0\0\1\0\0\0\0\0\0\10xxxxxdg4\0\0\34\0\1", 26, MSG_NOSIGNAL, NULL, 0) = 26
[pid 38774] poll([{fd=8, events=POLLIN}], 1, 5000) = 0 (Timeout)
[pid 38774] poll([{fd=8, events=POLLOUT}], 1, 0) = 1 ([{fd=8, revents=POLLOUT}])
[pid 38774] sendto(8, "\350u\1\0\0\1\0\0\0\0\0\0\10xxxxxdg4\0\0\34\0\1", 26, MSG_NOSIGNAL, NULL, 0) = 26
[pid 38774] poll([{fd=8, events=POLLIN}], 1, 5000) = 0 (Timeout)
[pid 38774] connect(12, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory)
[pid 38774] connect(12, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory)
[pid 38774] connect(12, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory)
[pid 38774] connect(12, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory)
Process 38775 attached
Process 38776 attached (waiting for parent)
Process 38776 resumed (parent 38774 ready)
TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/11.2.0.4/dbhome_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxdg4)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
[pid 38775] connect(12, {sa_family=AF_INET, sin_port=htons(6150), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxdg4)(PORT=1521)))
[pid 38774] connect(12, {sa_family=AF_INET, sin_port=htons(199), sin_addr=inet_addr("192.168.100.77")}, 16 <unfinished ...>
[pid 38772] connect(6, {sa_family=AF_INET, sin_port=htons(1521), sin_addr=inet_addr("192.168.100.77")}, 16) = -1 EINPROGRESS (Operation now in progress)
[pid 38772] poll([{fd=6, events=POLLOUT}], 1, 60000 <unfinished ...>
[pid 38775] connect(13, {sa_family=AF_INET, sin_port=htons(6150), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)
[pid 38774] <... connect resumed> ) = -1 EHOSTUNREACH (No route to host)
[pid 38772] <... poll resumed> ) = 1 ([{fd=6, revents=POLLOUT|POLLERR|POLLHUP}])
[pid 38774] poll([{fd=7, events=POLLIN|POLLRDNORM}, {fd=10, events=POLLIN|POLLRDNORM}, {fd=11, events=POLLIN|POLLRDNORM}], 3, -1TNS-12543: TNS:destination host unreachable
TNS-12560: TNS:protocol adapter error
TNS-00513: Destination host unreachable
Linux Error: 113: No route to host
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
<unfinished ...>
[pid 38772] connect(6, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"...}, 110 <unfinished ...>
[pid 38774] <... poll resumed> ) = 1 ([{fd=10, revents=POLLIN|POLLRDNORM}])
[pid 38772] <... connect resumed> ) = 0
[pid 38774] poll([{fd=7, events=POLLIN|POLLRDNORM}, {fd=10, events=POLLIN|POLLRDNORM}, {fd=11, events=POLLIN|POLLRDNORM}, {fd=12, events=POLLIN|POLLRDNORM}], 4, 2000) = 1 ([{fd=12, revents=POLLIN|POLLRDNORM}])
[pid 38774] poll([{fd=7, events=POLLIN|POLLRDNORM}, {fd=10, events=POLLIN|POLLRDNORM}, {fd=11, events=POLLIN|POLLRDNORM}], 3, -1 <unfinished ...>
[pid 38772] connect(6, {sa_family=AF_FILE, path="/var/tmp/.oracle/s#38774.2"...}, 110 <unfinished ...>
[pid 38774] <... poll resumed> ) = 1 ([{fd=11, revents=POLLIN|POLLRDNORM}])
[pid 38772] <... connect resumed> ) = 0
[pid 38774] poll([{fd=7, events=POLLIN|POLLRDNORM}, {fd=10, events=POLLIN|POLLRDNORM}, {fd=11, events=POLLIN|POLLRDNORM}, {fd=12, events=POLLIN|POLLRDNORM}], 4, 2000) = 1 ([{fd=12, revents=POLLIN|POLLRDNORM}])
[pid 38774] poll([{fd=7, events=POLLIN|POLLRDNORM}, {fd=10, events=POLLIN|POLLRDNORM}, {fd=11, events=POLLIN|POLLRDNORM}, {fd=12, events=POLLIN|POLLRDNORM}], 4, 2000) = 1 ([{fd=12, revents=POLLIN|POLLRDNORM}])
[pid 38774] poll([{fd=7, events=POLLIN|POLLRDNORM}, {fd=10, events=POLLIN|POLLRDNORM}, {fd=11, events=POLLIN|POLLRDNORM}, {fd=12, events=POLLIN|POLLRDNORM}], 4, 2000) = 1 ([{fd=12, revents=POLLIN|POLLRDNORM}])
STATUS of the LISTENER
------------------------
[pid 38774] poll([{fd=7, events=POLLIN|POLLRDNORM}, {fd=10, events=POLLIN|POLLRDNORM}, {fd=11, events=POLLIN|POLLRDNORM}], 3, -1Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 09-NOV-2021 09:59:12
Uptime 0 days 0 hr. 0 min. 11 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/11.2.0.4/dbhome_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxdg4)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "booK" has 1 instance(s).
Instance "book", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
<unfinished ...>
[pid 38775] connect(12, {sa_family=AF_INET, sin_port=htons(6150), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)
[pid 38775] connect(12, {sa_family=AF_INET, sin_port=htons(6150), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)
[pid 38775] connect(12, {sa_family=AF_INET, sin_port=htons(6150), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)
[pid 38775] connect(12, {sa_family=AF_INET, sin_port=htons(6150), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)
[pid 38775] connect(12, {sa_family=AF_INET, sin_port=htons(6150), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 ECONNREFUSED (Connection refused)
^CProcess 38775 detached
Process 38774 detached
Process 38776 detached
real 0m39.295s
user 0m0.024s
sys 0m0.134s
--//雖然按了ctrl+c中斷，實際上監聽啟動往常了，只不過不斷connect.
--//你還會遇到連結 http://blog.itpub.net/267265/viewspace-2838378/ =>[20211020]奇怪lsnrctl status顯示.txt 一樣的問題。
SYS@book> alter system register ;
System altered.
$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 09-NOV-2021 10:03:38
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxdg4)(PORT=1521)))
TNS-12543: TNS:destination host unreachable
TNS-12560: TNS:protocol adapter error
TNS-00513: Destination host unreachable
Linux Error: 113: No route to host
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 09-NOV-2021 09:59:12
Uptime 0 days 0 hr. 4 min. 26 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/11.2.0.4/dbhome_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxdg4)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "booK" has 1 instance(s).
Instance "book", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
--//oracle 動態服務無法註冊。
6.總結：
--//最近配置新機器給注意這個細節,注意檢查/etc/hosts檔案，加入本地主機名。
--//注意測試收尾工作。修改前面不正確的配置。
--//這樣我自己想起一個問題，前一陣子配置的dg監聽如何啟動的，我還給測試centos7.9上遇到的情況。
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/267265/viewspace-2841226/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- [20211108]sqlplus 本地登入緩慢.txtSQL
- strace解決sqlplus登陸緩慢的問題一例SQL
- PbootCMS登入後頁面載入緩慢怎麼辦boot
- postgresql 匯入緩慢SQL
- sqlplus 登入時快時慢問題診斷SQL
- sqlplus/RMAN/lsnrctl 等工具連線緩慢SQL
- sqlplus本地登入報錯ORA-12545SQL
- aix 遠端登陸緩慢問題AI
- DNS導致資料庫登入緩慢的問題解決DNS資料庫
- sqlplus 可以登入 plsql 不能登入SQL
- sql語句執行緩慢分析SQL
- 已解決，本地 Laravel 的除錯頁面載入緩慢打不開Laravel除錯
- oracle本地登入Oracle
- [20210518]ssh ip登入緩慢問題解決.txt
- 由Linux核心bug引起SSH登入緩慢問題的排查與解決Linux
- 並行查詢緩慢的問題分析並行
- 應用系統登入慢
- linux使用SSH登入慢Linux
- 【LISTENER】Oracle通過監聽連線緩慢分析Oracle
- vue-router懶載入速度緩慢問題Vue
- 前端網頁載入速度緩慢優化策略前端網頁優化
- sqlplus能登入資料庫，但plsql登入不上SQL資料庫
- sqlplus -prelim / as sysdba強制登入SQL
- ssh登入慢問題處理
- job處理緩慢的效能問題排查與分析
- win10怎麼改本地登入 win10如何改本地賬戶登入Win10
- oradebug分析oracle hang或慢_sqlplus_prelimOracleSQL
- sqlplus常用的幾種登入方式SQL
- [20180409]delete刪除緩慢分析.txtdelete
- 關於plsql，crt登入比較慢SQL
- ssh登入慢問題解決方法
- 解決ssh登入慢的問題
- VSFTPD 本地使用者登入。FTP
- selinux導致sqlplus登入失敗LinuxSQL
- sqlplus密碼中帶 @的登入方法。SQL密碼
- AWR收集緩慢、掛起的幾種常見情況分析
- 分析師資料暗示 Apple Music初期發展緩慢APP
- 資料庫連線緩慢資料庫