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 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
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 12.1.0.2.0 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
<level>]
[-S]
..........
..........
Refer to the SQL*Plus User's Guide and Reference for more information.
[hostname]/refresh/home>
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
<level>]
[-S]
..........
..........
Refer to the SQL*Plus User's Guide and Reference for more information.
[hostname]/refresh/home>
Changes
Upgrade to 12c.
Cause
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
Symptoms |
Changes |
Cause |
Solution |