Examples - Apply Maintenance to Multiple DB Aliases

To apply maintenance to multiple DB aliases, the first step is to create a text file with the appropriate parameters for the tasks.

For this example, the text file is called C:\Maint_dba.txt:

/PSTDirName=ORA_LOCAL   /PSTDirUserID=roberts 
   /PSTDirPassword=softech   /DBAAction=useexisting   
   /DBAName=DB_LOCAL   /UserID=roberts
   /PASSWORD=fido   /Task=MAINTCAT     
/DBAAction=useexisting  /DBAName=ASYB_LOCAL
   /Task=MAINTCAT    
/DBAAction=useexisting  /DBAName=AROBDB3
   /Task=MAINTCAT  
/DBAAction=useexisting  /DBAName=AROBDB4
   /Task=MAINTCAT      
/DBAAction=useexisting  /DBAName=AORA_LOCAL
   /Task=MAINTCAT     
/DBAAction=useexisting  /DBAName=AMSSQL_LOCAL
   /Task=MAINTCAT    
/DBAAction=useexisting  /DBAName=AIFX_LOCAL
   /Task=MAINTCAT    
/DBAAction=useexisting  /DBAName=AIFX_LOCALNA
   /Task=MAINTCAT   
/DBAAction=useexisting  /DBAName=APSTDSNY
   /Task=MAINTCAT     

To perform the tasks from the command line, specify:

PR0CNFG /FILE=C:\Maint_dba.txt


Feedback