Oracle DataBase connection module
Vladimir Bormotov <bormotov@gmail.com>
new
cx_Oracle
all
module provide connections for multiple Oracle DB instances.
OS Environment
ORACLE_HOME: path to oracle product
PATH: path to Oracle Client libs need to be in PATH
pillar
oracle:
dbs:
<db>:
uri: connection credentials in format:
user/password@host[:port]/sid[ servicename as {sysdba|sysoper}]
optional keyword servicename will determine whether it is a sid or service_name
<db>:
uri: .....
Oracle Client Version
CLI Example:
salt '*' oracle.client_version
Run SQL query and return result
CLI Example:
salt '*' oracle.run_query my_db "select * from my_table"
Show databases configuration from pillar. Filter by *args
CLI Example:
salt '*' oracle.show_dbs
salt '*' oracle.show_dbs my_db
Show Environment used by Oracle Client
CLI Example:
salt '*' oracle.show_env
Note
at first _connect() NLS_LANG
will forced to '.AL32UTF8'
Show Pillar segment oracle.* and subitem with notation "item:subitem"
CLI Example:
salt '*' oracle.show_pillar
salt '*' oracle.show_pillar dbs:my_db
Server Version (select banner from v$version)
CLI Example:
salt '*' oracle.version
salt '*' oracle.version my_db
Generated on December 02, 2024 at 20:43:35 UTC.
You are viewing docs for the previous stable release, 3006.9. Switch to docs for the latest stable release, 3007.1, or to a recent doc build from the master branch.
© 2024 VMware, Inc. | Privacy Policy