introduction
Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ]
where <option> ::= -H | -V | [ [-L] [-M <o>] [-R <n>] [-S] ]
<logon> ::= <username>[/<password>][@<connect_string>] | / | /NOLOG
<start> ::= @<URI>|<filename>[.<ext>] [<parameter> ...]
"-H" displays the SQL*Plus version banner and usage syntax
"-V" displays the SQL*Plus version banner
"-L" attempts log on just once
"-M <o>" uses HTML markup options <o>
"-R <n>" uses restricted mode <n>
"-S" uses silent mode
examples
[oracle@www oracle]$ sqlplus
SQL*Plus: Release 9.2.0.1.0 - Production on Wed Feb 19 22:32:19 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: scott
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
the above error will occur whenever the wrong database is specified or the wrong password/user combination is given. Not a very helpful error description, it tends to lead one to assume there's a database problem.
return to top