oltpplus − Call SQL*Plus with some username, password and connect string
oltpplus [-H|--help] [-2] [-p|--pool] [-b|--batch] [-A|--awr] [-S|--system] [-R|--results] [-r|--run] [-a|--aw] [-o|--oe] [-x|--cstorm_xtra]
-H
Show short help.
-A|--awr
Call SQL*Plus as the user doing awr snapshots and reporting.
-S|--system
Call SQL*Plus as the system user used to run v$ queries etc.
-C|--cruser
Call SQL*Plus as the system user used to create schemas.
-x|--cstorm_xtra
Call SQL*Plus as the extra user used for connection storms.
-R|--results
Call SQL*Plus as your repository user.
-r|--run
Call SQL*Plus as your normal runtime user.
-a|--aw
Call SQL*Plus as the user who owns the artificial workload schema.
-o|--oe
Call SQL*Plus as the user who owns the order entry schema.
-2
If you are using -r or -a, use the side 2 version of the schema (as used by oltpforever2).
-p|--pool
If you are using -r, -a or -o, use the pool_connect connect string, otherwise use normal_connect.
-b|--batch
If you are using -r, -a or -o, use the batch_connect connect string, otherwise use normal_connect.
The oltpplus command is used to start an interactive SQL*Plus sessions with one of the normal users you have defined in your oltp key file. The major benefit of using this command is that it prevents showing visible passwords on your terminal.
The oltpplus command takes no arguments and exactly one of the schemas must be selected using the appropriate option.
When called, it will first echo the username and the connect string, and then call sqlplus.
The oltpconnect(2rwl) command can be used if you want to start some other tool without showing the password on the terminal.
You cannot give any arguments to the sqlplus session being started. If you want to e.g. give an @script argument to run an SQL*Plus script, use sqlplus with oltpconnect(2rwl). As an example
sqlplus $(oltpconnect -r) @script
will start sqlplus using the normal runtime user and execute the script in the file script.sql
Copyright
© 2023 Oracle Corporation
Licensed under the Universal Permissive License v 1.0 as
shown at https://oss.oracle.com/licenses/upl
oltp(2rwl), oltpsetup(2rwl), oltpparams(2rwl), oltpconnect(2rwl)