My Oracle Support Banner

SQLPLUS -SL Option No Longer Works After Upgrade to 12c (Doc ID 2261172.1)

Last updated on DECEMBER 06, 2019

Applies to:

SQL*Plus - Version and later
Information in this document applies to any platform.


You are unable to connect using SQLPLUS -SL option after Oracle Database upgrade to 12c.

This silent mode was working fine with 11g. That is, using command "sqlplus -SL" does not prompt for login or show messages. Whereas with 12c sqlplus client, it shows SQL*Plus information and displays Help page as if this command is invalid.

For Example:

SQL*Plus: Release Production
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Use SQL*Plus to execute SQL, PL/SQL and SQL*Plus statements.
Usage 1: sqlplus -H | -V
-H Displays the SQL*Plus version and the
usage help.
-V Displays the SQL*Plus version.
Usage 2: sqlplus [ [<option>] [{logon | /nolog}] [<start>] ]
<option> is: [-C <version>] [-L] [-M "<options>"] [-NOLOGINTIME] [-R
Refer to the SQL*Plus User's Guide and Reference for more information.



 Upgrade to 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!

In this Document

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