DBA Command line options

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:

cellpadding="0" cellspacing="2">






















-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 option can apply to the majority of DBA utilities supplied with the product. Take a look at others.

Comments:

Appreciation for the great blog post. I am glad I have taken the time to learn this.

Posted by craftsman tool boxes for sale on November 20, 2010 at 05:28 PM EST #

Finally a blog that didnt contradict it self, amazing writing. :)

Posted by Berniece Lutzi on February 04, 2011 at 04:32 AM EST #

You guys really know how to write a blog! This was extremely helpful. Thank you vey much.

Posted by Deane Netley on February 04, 2011 at 10:31 AM EST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Anthony Shorten
Hi, I am Anthony Shorten, I am the Principal Product Manager for the Oracle Utilities Application Framework. I have been working for over 20+ years in the IT Business and am the author of many a technical whitepaper, manual and training material. I am one of the product managers working on strategy and designs for the next generation of the technology used for the Utilities and Tax markets. This blog is provided to announce new features, document tips and techniques and also outline features of the Oracle Utilities Application Framework based products. These products include Oracle Utilities Customer Care and Billing, Oracle Utilities Meter Data Management, Oracle Utilities Mobile Workforce Management and Oracle Enterprise Taxation and Policy Management. I am the product manager for the Management Pack for these products.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
9
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today