"SQLPLUS -S " is not working in one environment where same code is working in another

UNIX for Beginners Q & A
1

"SQLPLUS -S " is not working in one environment where same code is working in another

getting below error 
===================================
SQL*Plus: Release 11.2.0.3.0 Production

Copyright (c) 1982, 2011, 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>"] [-R <level>] [-S]

    -C <version>   Sets the compatibility of affected commands to the
                   version specified by <version>.  The version has
                   the form "x.y[.z]".  For example, -C 10.2.0
    -L             Attempts to log on just once, instead of
                   reprompting on error.
    -M "<options>" Sets automatic HTML markup of output.  The options
                   have the form:
                   HTML [ON|OFF] [HEAD text] [BODY text] [TABLE text]
                   [ENTMAP {ON|OFF}] [SPOOL {ON|OFF}] [PRE[FORMAT] {ON|OFF}]
    -R <level>     Sets restricted mode to disable SQL*Plus commands
                   that interact with the file system.  The level can
                   be 1, 2 or 3.  The most restrictive is -R 3 which
                   disables all user commands interacting with the
                   file system.
    -S             Sets silent mode which suppresses the display of
                   the SQL*Plus banner, prompts, and echoing of
                   commands.
2

Sadly this doesn't really get us anywhere because there is no specific question with examples. Please can you tell us:-

  • What OS you are using in each case? The output from uname -a would be very useful here.
  • What version of Oracle client you have installed for each case?
  • What default environment variables you have set in each case?
  • Can you show us the connect session, query & output/errors you get?

Hopefully someone here can help you.

Please wrap all code, files, input & output/errors in CODE tags, or ICODE tags for inline text.
It makes it easier to read and preserves spacing for indenting or fixed width data.

Kind regards,
Robin

1 Like