12gR1: Remote SQL*Plus May Core Dump or Yield ORA-24550 if Server Configured with SEC_USER_AUDIT_ACTION_BANNER (Doc ID 2499926.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Attempting to connect via SQL*Plus from a remote client.   Client release is 12.1.0.1 and database is 12.2.x.
A core dump, seg fault or the following error is returned to prompt.

ORA-24550: signal received: [si_signo=11]

Collected OS trace of the SQL*Plus failure like:

truss -f -o outfile.txt sqlplus username/password@"//host:1521/my_service"

Truss of the failure to execute SQL*Plus shows:

16974234: 124912175: kwrite(1, " *\t\t\t\t\t\t\t\t      ".., 14) = 14
16974234: 124912175: kwrite(1, " *   T h i s   s y s t e".., 68) = 68
16974234: 124912175: kwrite(1, " *   t h i s   s y s t e".., 69) = 69
16974234: 124912175: kwrite(1, " *\t\t\t\t\t\t\t\t      ".., 14) = 14
16974234: 124912175: kwrite(1, " *   A n y o n e   u s i".., 69) = 69
16974234: 124912175: kwrite(1, " *   a n d   i s   a d v".., 63) = 63
16974234: 124912175: kwrite(1, " *   e v i d e n c e   o".., 69) = 69   <====note that this plain text is from Security banner and can vary.
16974234: 124912175: kwrite(1, " *   e v i d e n c e   f".., 67) = 67
16974234: 124912175: kwrite(1, " *\t\t\t\t\t\t\t\t      ".., 14) = 14
16974234: 124912175: kwrite(1, " * * * * * * * * * * * *".., 69) = 69
16974234: 124912175: kwrite(1, "\n", 1) = 1
16974234: 124912175: kwrite(1, "\n", 1) = 1
16974234: 124912175: kfcntl(1, F_GETFL, 0x0000000000000008) = 67110914
16974234:     Received signal #11, SIGSEGV [default]
16974234: *** process killed ***

Changes

This may be a new installation or a new implementation of using the security banner at the Database server.

Example sqlnet.ora file entries at db server:

SEC_USER_AUDIT_ACTION_BANNER=/mybanner/mybannertext.txt
SEC_USER_UNAUTHORIZED_ACCESS_BANNER=/mybanner/mybannertext.txt

Cause

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