Examples - Create Multiple DB Aliases with One Optim Directory

To create multiple DB aliases with one Optim™ Directory, 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:\Cre_dba.txt.

/PSTDirName=ORA_LOCAL    /PSTDirUserID=roberts   
   /PSTDirPassword=softech      /DBAAction=createnew   
   /DBAName=AUDB_LOCAL  /DBMSType=ORACLE
   /DBMSVERSION=6.1
   /ConnectStr=sample  /UserID=roberts   /Password=robbie   
   /SPAction=createnew  /Description="Local ORA V 6.1 Sample"
   /Task=DB  

/DBAAction=createnew   /DBAName=ASYB_LOCAL  
   /DBMSType=SYBASE   /DBMSVERSION=11.9.2   
   /ConnectStr=roberts    /UserID=roberts   /Password=robbie  
   /DBQualifier=roberts   /SPAction=createnew    /SPShare=True   
   /Description="Local Sybase V 11.9.2 roberts"  /Task=DB 

/DBAAction=createnew  /DBAName=AROBDB3 
   /DBMSType=SYBASE   /DBMSVersion=11.9.2
   /ConnectStr=roberts 
   /UserID=roberts  /Password=robbie  /DBQualifier=robdb3 
   /SPAction=Useexisting   /SPShare=True   /Description="Local 
   Sybase V 11.9.2 robdb3"  /Task=DB   

/DBAAction=createnew  /DBAName=AROBDB4   
   /DBMSType=SYBASE   /DBMSVersion=11.9.2
   /ConnectStr=roberts 
   /UserID=roberts  /Password=robbie  /DBQualifier=robdb4  
   /SPAction=UseExisting  /SPShare=True   /Description="Local 
   Sybase V 11.9.2 robdb4"  /Task=DB  
To perform the tasks from the command line, specify
PR0CNFG /FILE=C:\Cre_dba.txt


Feedback