# S292APEX.cfg: Setup specification to get the internal variables used for the # APEX gathering function of the RDA process. # $Id: S292APEX.cfg,v 1.7 2009/01/16 16:22:34 ldens Exp $ # ARCS: $Header: /u02/webapps/workbench/cvs/RDA_4/src/scripting/lib/modules/S292APEX.cfg,v 1.7 2009/01/16 16:22:34 ldens Exp $ # # Copyright (c) 2002-2009, Oracle. All rights reserved. # # Change History # 20090115 LDE Improve documentation. ############################################################################### # Collect APEX setup information ############################################################################### #------------------------------------------------------------------------------ # Module definition #------------------------------------------------------------------------------ col=${APEX_IN_USE} dsc="Collects APEX Information" req=S000INI rpt=APEX_IN_USE ttl="Oracle Product Settings" var=force_apex_tests #------------------------------------------------------------------------------ # Setting definitions #------------------------------------------------------------------------------ [force_apex_tests] typ=B alt=APEX_IN_USE dft=0 dsc="Is the APEX collection required by the profile?" nam=- var=apex_in_use [apex_in_use] typ=B dft=1 dsc="Is APEX information requested?" nam=APEX_IN_USE var=APEX_CHECK_HTTP [APEX_IN_USE] typ=B dft=${RDA_DEFAULT:0} dsc="Is APEX information requested?" inp="Do you want RDA to analyze Oracle APEX (Y/N)?" var=APEX_CHECK_HTTP [APEX_CHECK_HTTP] typ=B alt=check_sid dft=0 dsc="Indicate if marvel.conf is located on the current computer" inp="Is the configuration file (marvel.conf) located on this computer (Y/N)?" var=APEX_ORACLE_HOME [APEX_ORACLE_HOME] typ=D dft=${ORACLE_HOME} dsc="Oracle home containing the configuration files" err="The specified directory does not exist" inp="Enter the absolute path of the Oracle home containing the configuration \ files" val=F var=chk_modplsql [chk_modplsql] typ=D alt=no_modplsql,APEX_ORACLE_HOME dft=${APEX_ORACLE_HOME}/Apache/modplsql nam=- var=chk_marvel [no_modplsql] typ=C dsc="Report bad Oracle home" inp="The specified directory ${APEX_ORACLE_HOME} does not contain the \ required configuration files!\n " vis=0 [chk_marvel] typ=F alt=check_sid dft="${APEX_ORACLE_HOME}/Apache/modplsql/conf/marvel.conf" dsc="marvel.conf location" nam=-TMP_APEX_MARVEL var=APEX_DB_AUTO [APEX_DB_AUTO] typ=B alt=check_sid dft=1 dsc="Do you want RDA to collect the database connection details automatically?" inp="Do you want RDA to collect the database connection details automatically \ (Y/N)?" lvl=1 var=apex_db_set,set #------------------------------------------------------------------------------ # Single database connection #------------------------------------------------------------------------------ [check_sid] typ=I alt=apex_local dft="exists:ORACLE_SID" dsc="Check if ORACLE_SID is defined" nam=- var=APEX_LOCAL [apex_local] typ=B alt=APEX_SID,APEX_LOGIN,APEX_SYSDBA dft=0 dsc="Is the APEX schema stored in the database to be analyzed?" nam=APEX_LOCAL [APEX_LOCAL] typ=B alt=APEX_SID,APEX_LOGIN,APEX_SYSDBA dft=1 dsc="Is the APEX schema stored in the database to be analyzed?" inp="Is the APEX schema stored in the '${ORACLE_SID}' database (Y/N)?" [APEX_SID] typ=T dsc="Database containing the APEX schema" inp="Enter the Oracle SID of the database containing the APEX schema" [APEX_LOGIN] typ=T dft='${SQL_LOGIN:system}' dsc="User to connect to SQL*Plus" inp="Enter an Oracle User ID (user ID, only) to view DBA_ and V$ tables. If \ RDA will be run under the user ID of Oracle software owner, enter a \ forward slash ('/') here, and \ enter Y at the SYSDBA prompt. This prevents that you are prompted for \ the database password at runtime." [APEX_SYSDBA] typ=B dft=0 dsc="Indicate that APEX_LOGIN will connect as SYSDBA" inp="Is '${APEX_LOGIN}' a SYSDBA user (connects as SYSDBA) (Y/N)?" #------------------------------------------------------------------------------ # Multiple database connections #------------------------------------------------------------------------------ [apex_db_set] typ=T dft="<