oracle12远程连接,12c 客户端通过 SQL*Plus 远程连接会有将近 9 - 10秒延迟

12c 客户端通过 SQL*Plus 远程连接会有将近 9 - 10秒延迟

(Doc ID 2469594.1)

Last updated on JULY 31, 2019

适用于:

Oracle Net Services - 版本 12.1.0.2 到 12.2 BETA1 [发行版 12.1 到 12.2]

本文档所含信息适用于所有平台

症状

一个Oracle 12c 客户端(SQL*Plus)花费了将近10秒才连接上12c数据库

在客户端trace中发现hang在了认证阶段，同时发现客户端在端口6200连接ONS：

(2724587008) [22-DEC-2016 17:58:03:577] nsbasic_brc: 0F 00 00 00 0F 41 55 54 |.....AUT|

(2724587008) [22-DEC-2016 17:58:03:577] nsbasic_brc: 48 5F 4F 4E 53 5F 43 4F |H_ONS_CO|

(2724587008) [22-DEC-2016 17:58:03:577] nsbasic_brc: 4E 46 49 47 47 00 00 00 |NFIGG...|

(2724587008) [22-DEC-2016 17:58:03:577] nsbasic_brc: 47 6D 61 78 63 6F 6E 6E |Gmaxconn|

(2724587008) [22-DEC-2016 17:58:03:577] nsbasic_brc: 65 63 74 69 6F 6E 73 2E |ections.|

(2724587008) [22-DEC-2016 17:58:03:577] nsbasic_brc: 30 30 30 31 3D 30 30 30 |0001=000|

(2724587008) [22-DEC-2016 17:58:03:577] nsbasic_brc: 33 0A 6E 6F 64 65 73 2E |3.nodes.|

(2724587008) [22-DEC-2016 17:58:03:577] nsbasic_brc: 30 30 30 31 3D 73 73 30 |0001=any|

(2724587008) [22-DEC-2016 17:58:03:577] nsbasic_brc: 30 37 31 31 31 2E 69 6E |host.here|

(2724587008) [22-DEC-2016 17:58:03:577] nsbasic_brc: 74 72 61 30 31 2E 73 61 |.domain.|

(2724587008) [22-DEC-2016 17:58:03:577] nsbasic_brc: 6E 69 74 61 73 2E 63 6F |world.co|

(2724587008) [22-DEC-2016 17:58:03:577] nsbasic_brc: 6D 3A 36 32 30 30 0A 00 |m:6200..|

10秒之后客户端终止了该尝试，因为：

A)ONS没有运行

B)或者ONS在防火墙后面

连接在10秒后进入数据库：

注意在17:58:13时，提示信息显示客户端已经成功连接数据库

(2724587008) [22-DEC-2016 17:58:13:005] nsprecv: 00 00 00 BE 06 00 00 00 |........|

(2724587008) [22-DEC-2016 17:58:13:005] nsprecv: 00 00 08 A5 00 A5 4F 72 |......Or|

(2724587008) [22-DEC-2016 17:58:13:005] nsprecv: 61 63 6C 65 20 44 61 74 |acle.Dat|

(2724587008) [22-DEC-2016 17:58:13:005] nsprecv: 61 62 61 73 65 20 31 32 |abase.12|

(2724587008) [22-DEC-2016 17:58:13:005] nsprecv: 63 20 45 6E 74 65 72 70 |c.Enterp|

(2724587008) [22-DEC-2016 17:58:13:005] nsprecv: 72 69 73 65 20 45 64 69 |rise.Edi|

(2724587008) [22-DEC-2016 17:58:13:005] nsprecv: 74 69 6F 6E 20 52 65 6C |tion.Rel|

(2724587008) [22-DEC-2016 17:58:13:005] nsprecv: 65 61 73 65 20 31 32 2E |ease.12.|

(2724587008) [22-DEC-2016 17:58:13:005] nsprecv: 31 2E 30 2E 32 2E 30 20 |1.0.2.0.|

(2724587008) [22-DEC-2016 17:58:13:005] nsprecv: 2D 20 36 34 62 69 74 20 |-.64bit.|

更改

新安装或者升级的12c 客户端。

原因To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

文档内容

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit oracle.com.

© Oracle | Contact and Chat | Support | Communities | Connect with us | | | | Legal Notices | Terms of Use