DBA Command line options
- by Anthony Shorten
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.
