ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > [20211109]sqlplus本地登录缓慢分析2.txt

[20211109]sqlplus本地登录缓慢分析2.txt

原创 Oracle 作者：lfree 时间：2021-11-09 10:09:55 0 删除 编辑

[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博客 ” ，链接：https://blog.itpub.net/267265/viewspace-2841226/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： [20211108]sqlplus 本地登录缓慢.txt
下一篇： [20211110]oracle数字编码30.txt
请登录后发表评论 登录
全部评论
lfree
专家姓名：张文胜
熟悉oracle相关技术，擅长sql优化，rman备份与恢复，熟悉linux shell编程。

注册时间：2008-01-03

  • 博文量
    4006
  • 访问量
    7970129

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593