DBA Command line options
Posted
by Anthony Shorten
on Oracle Blogs
See other posts from Oracle Blogs
or by Anthony Shorten
Published on Fri, 18 Jun 2010 13:40:34 +1000
Indexed on
2010/06/18
4:14 UTC
Read the original article
Hit count: 784
There are a number of database utilities supplied with the installation of the Oracle Utilities Application Framework based products. These are typically run in interactive mode where the utility prompts you for the values and then executes the required functionality. Did you know that the utilities also have command line options that allow you to run the utility in silent mode as well?
You can assess the command line options by specifying the -h option on the command line.
Here is an example of the oragensec command line options:
oragensec -d <Owner,OwnerPswd,DbName> -u <Database Users> -r <ReadRole,UserRole> -l <logfile> -h
where:
| -d <Owner,OwnerPswd,DbName> | Database connect information for the target database. e.g. spladm,spladm,DB200ODB. |
| -u <Database Users> | A comma-separated list of database users where synonyms need to be created. e.g. spluser, splread |
| -r <ReadRole,UserRole> | Optional. Names of database roles with read and read-write privileges. Default roles are SPL_READ, SPL_USER. e.g. spl_read,spl_user |
| -l <logfile> | Optional. Name of the log file. |
| -h | Help |
The command line options allow the DBA to automate the exeucution either via a script or some utility can than execute utilities. This optin can apply to the majority of DBA utilities supplied with the product. Take a look at others.
© Oracle Blogs or respective owner
