Slow Login To Oracle 19c DB Server Using HPUX Itanium 19c Client (Doc ID 2673496.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

• Connecting into Oracle database using 19c Client for HP-UX Itanium takes about 1 second longer than using Oracle 12.1 Client:
  
  
  > cat exit.sql
  exit
  
  > time sqlplus / as sysdba @exit.sql
  
  SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jan 3 00:39:18 2020
  Version 19.5.0.0.0
  
  Copyright (c) 1982, 2019, Oracle.  All rights reserved.
  
  Connected to an idle instance.
  
  Disconnected
  
  real    0m1.68s <<<<<<<<<<<<
  user    0m0.03s
  sys     0m0.06s
• In 19c, it seems that uses "/dev/random" instead of "/dev/urandom".
  
  sqlplus_19c.txt:
  
  
  1570504210.802185 [sqlplus cybo][4941]{1916903} #1 open("/dev/random",
  O_RDONLY|O_NONBLOCK, 066340) = 10 <<<<<<<<<<<
  1570504210.802226 [sqlplus cybo][4941]{1916903} #1 read(10, "0 ", 1)
  ...................... = 1
  1570504210.802260 [sqlplus cybo][4941]{1916903} #1 close(10)
  .............................. = 0
  1570504210.811962 [sqlplus cybo][4941]{1916903} #1 sigtimedwait(0x7fffd310,
  NULL, 0x7fffd300) ERR#11 EAGAIN <<<<<<<<<<<
  1570504210.811987 [sqlplus cybo][4941]{1916903} #1 gettimeofday(0x7fffd448,
  0x7fffd450) ... = 0
  1570504210.812016 [sqlplus cybo][4941]{1916903} #1 open("/dev/random",
  O_RDONLY|O_NONBLOCK, 066340) = 10 <<<<<<<<<<<
  1570504210.812048 [sqlplus cybo][4941]{1916903} #1 read(10, "ee", 1)
  ...................... = 1
  1570504210.812082 [sqlplus cybo][4941]{1916903} #1 close(10)
  .............................. = 0
  1570504210.821962 [sqlplus cybo][4941]{1916903} #1 sigtimedwait(0x7fffd310,
  NULL, 0x7fffd300) ERR#11 EAGAIN <<<<<<<<<<<
  1570504210.821990 [sqlplus cybo][4941]{1916903} #1 gettimeofday(0x7fffd448,
  0x7fffd450) ... = 0
  1570504210.822017 [sqlplus cybo][4941]{1916903} #1 open("/dev/random",
  O_RDONLY|O_NONBLOCK, 066340) = 10 <<<<<<<<<<<
  1570504210.822061 [sqlplus cybo][4941]{1916903} #1 read(10, "17", 1)
  ...................... = 1
  1570504210.822094 [sqlplus cybo][4941]{1916903} #1 close(10)
  .............................. = 0
  1570504210.831972 [sqlplus cybo][4941]{1916903} #1 sigtimedwait(0x7fffd310,
  NULL, 0x7fffd300) ERR#11 EAGAIN <<<<<<<<<<<
  1570504210.832003 [sqlplus cybo][4941]{1916903} #1 gettimeofday(0x7fffd448,
  0x7fffd450) ... = 0
  ... ...
  1570504211.131966 [sqlplus cybo][4941]{1916903} #1 open("/dev/random",
  O_RDONLY|O_NONBLOCK, 066340) = 10 <<<<<<<<<<<
  1570504211.132011 [sqlplus cybo][4941]{1916903} #1 read(10, "# ", 1)
  ...................... = 1
  1570504211.132044 [sqlplus cybo][4941]{1916903} #1 close(10)
  .............................. = 0
  1570504211.141887 [sqlplus cybo][4941]{1916903} #1 sigtimedwait(0x7fffd390,
  NULL, 0x7fffd380) ERR#11 EAGAIN <<<<<<<<<<<
  1570504211.141928 [sqlplus cybo][4941]{1916903} #1 gettimeofday(0x7fffd4c8,
  0x7fffd4d0) ... = 0
  1570504211.142009 [sqlplus cybo][4941]{1916903} #1 time(NULL)
  ............................. = 1570504211
  1570504211.142077 [sqlplus cybo][4941]{1916903} #1 time(NULL)
  ............................. = 1570504211
• In 12c client seems to use "/dev/urandom" and login within 1 second.
  
  
  1570504247.123661 [sqlplus cybo][4981]{1916950} #1 open("/dev/urandom",
  O_RDONLY, 0) ....... = 11 <<<<<<<<<<<
  1570504247.123709 [sqlplus cybo][4981]{1916950} #1 fcntl(11, F_GETFD, 0)
  ................... = 0
  1570504247.123740 [sqlplus cybo][4981]{1916950} #1 fcntl(11, F_SETFD, 1)
  ................... = 0
  1570504247.123788 [sqlplus cybo][4981]{1916950} #1 read(11, "1d+
  a89a8deae218", 8) ......... = 8
  1570504247.123834 [sqlplus cybo][4981]{1916950} #1 close(11)
  ............................... = 0
  1570504247.123872 [sqlplus cybo][4981]{1916950} #1 times(0x7fffd5e0)
  ....................... = 1013181093
  1570504247.123918 [sqlplus cybo][4981]{1916950} #1 pstat(PSTAT_PROCESSOR,
  0x7fffd360, 704, 1, 0) = 1
  1570504247.123991 [sqlplus cybo][4981]{1916950} #1 shmget(0, 0x1000, 0600)
  ................. = 842891336
  1570504247.124062 [sqlplus cybo][4981]{1916950} #1 shmat(842891336, NULL, 0)
  ............... = 0xc07dd000
  1570504247.124105 [sqlplus cybo][4981]{1916950} #1 shmctl(842891336, 0xc,
  0x7fffd578) ...... = 0
  1570504247.124146 [sqlplus cybo][4981]{1916950} #1 shmdt(0xc07dd000)
  ....................... = 0
  1570504247.124183 [sqlplus cybo][4981]{1916950} #1 shmctl(842891336,
  IPC_RMID, NULL) ....... = 0
  1570504247.124218 [sqlplus cybo][4981]{1916950} #1 open("entropy", O_RDONLY,
  0) ............ ERR#2 ENOENT
  1570504247.124257 [sqlplus cybo][4981]{1916950} #1 gettimeofday(0x7fffd618,
  0x7fffd620) .... = 0
• It does not get improved even after set hard link the "/dev/random" to "/dev/urandom"

Changes

Cause

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