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

Last updated on MAY 03, 2017

Applies to:

SQL*Plus - Version 12.1.0.2 and later
Information 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>

 

Changes

 Upgrade to 12c.

Cause

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 hundreds of Community platforms