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]
-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.
-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.
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)