My Oracle Support Banner

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.