[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上遇到的情況。

[20211109]sqlplus本地登入緩慢分析2.txt

相關文章