DBA Command line options
By Acshorten-Oracle on Jun 18, 2010
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
need to be created. e.g. spluser, splread
Default roles are SPL_READ, SPL_USER. e.g. spl_read,spl_user
The command line options allow the DBA to automate the exeucution either via a script or some utility can than execute utilities. This option can apply to the majority of DBA utilities supplied with the product. Take a look at others.