oltpconnect − Provide credentials to some other utility
oltpconnect [-H|--help]
$(oltpconnect [-2] [-p|--pool] [-b|--batch] [-A|--awr] [-S|--system] [-R|--results] [-r|--run] [-a|--aw] [-o|--oe])
-H
Show short help.
-A|--awr
Return credentials for the user doing awr snapshots and reporting.
-S|--system
Return credentials for the system user used to run v$ queries etc.
-C|--cruser
Return credentials for the system user used to create schemas.
-R|--results
Return credentials for your repository user.
-r|--run
Return credentials for your normal runtime user. This is the default when no other options are provided.
-a|--aw
Return credentials for the user who owns the artificial workload schema.
-o|--oe
Return credentials for 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 oltpconnect command is used to provide credentials in the form username/{password}@service such that they can be provided to some other tool. Note that if stdout is a terminal, the password will be blank and that the preferred usage is via your shells command substitution. The primary usage of the oltpconnect command is to allow you to show how various tools can be used without revealing passwords on the screen.
The oltpconnect command takes no ordinary arguments and returns the credentials for the rwlrun1 user unless one of the other schemas is selected using the appropriate option(s).
Call ashplot connecting to your system user without the need to show or type password:
ashplot -l $(oltpconnect -S) --autoupdate=5
The following is equivalent to typing oltpplus -r:
sqlplus $(oltpconnect)
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), oltpplus(2rwl)