# S200DB.cfg: Setup specification to get the internal variables used for the # RDBMS gathering function of the RDA process. # $Id: S200DB.cfg,v 1.39 2009/05/05 08:31:18 mschenke Exp $ # ARCS: $Header: /u02/webapps/workbench/cvs/RDA_4/src/scripting/lib/modules/S200DB.cfg,v 1.39 2009/05/05 08:31:18 mschenke Exp $ # # Copyright (c) 2002-2009, Oracle. All rights reserved. # # Change History # 20090505 MSC Extend the trigger mechanism. ############################################################################### # Collect the common RDBMS setup information ############################################################################### #------------------------------------------------------------------------------ # Module definition #------------------------------------------------------------------------------ col=0 dsc="Controls RDBMS Data Collection" env=ORACLE_SID,TWO_TASK req=S000INI rpt=ORACLE_HOME,DATABASE_INSTALLED,DATABASE_LOCAL,ORACLE_SID,\ PFILE_LOCAL,PFILE_LOCATION ttl="Oracle Product Settings" trg=S201DBA,S203DBM,S204LOG,S205BR,S206RSRC,S207D2PC,S208OMM,S209XDB,S210OLAP,\ S211EXA var=force_db_tests #------------------------------------------------------------------------------ # Setting definitions #------------------------------------------------------------------------------ [force_db_tests] typ=B alt=check_rdbms,DATABASE_INSTALLED nam=- var=database_installed [database_installed] typ=B dft=1 dsc="Gather database information?" nam=DATABASE_INSTALLED var=DATABASE_LOCAL,PFILE_LOCAL,SQL_LOGIN,SQL_SYSDBA [check_rdbms] typ=P dft="check:TMP_RDBMS:oracle.rdbms" dsc="rdbms installed?" nam=-TMP_INSTALLED [DATABASE_INSTALLED] typ=B dft=${TMP_INSTALLED:${RDA_DEFAULT:1}} dsc="Gather database information?" inp="Is there a database for RDA to analyze (Y/N)?" var=DATABASE_LOCAL,PFILE_LOCAL,SQL_LOGIN,SQL_SYSDBA [DATABASE_LOCAL] typ=B alt=remote_sid dft=${ORACLE_SID} dsc="Is the database associated to the current Oracle home?" inp="Is the database associated to the current Oracle home (Y/N)?" var=local_sid [local_sid] typ=T dft=${ORACLE_SID} dsc="Oracle SID" inp="Enter the Oracle SID to be analyzed" nam=ORACLE_SID [remote_sid] typ=T dft=${TWO_TASK:${ORACLE_SID}} dsc="Oracle SID" inp="Enter the Oracle SID to be analyzed" nam=ORACLE_SID [PFILE_LOCAL] typ=B dft=${DATABASE_LOCAL} dsc="Is the PFILE local?" inp="Is the INIT.ORA for the database to be analyzed located on this machine? \ (Y/N)" var=pfile_dir_u,pfile_dir_w,PFILE_LOCATION [pfile_dir_u] typ=D dft=${ORACLE_HOME}/dbs dsc="PFILE directory" fam=Unix nam=-PFILE_DIR var=find_spfile [pfile_dir_w] typ=D dft=${ORACLE_HOME}/database dsc="PFILE directory" fam=Win32 nam=-PFILE_DIR var=find_spfile [find_spfile] typ=F alt=find_pfile dft="<