SAM_DB_ADMIN Make from d0ora3 for production

Currently, we will complile the forms on d0ora3, while pointing to the d0ora1 database. This is incase there is a compile error, you do not have to retar/kit/untar the entire product.

The product version below should be replaced by the product name and version number you are cutting, e.g. sam_db_admin v2_7.

• logon to d0ora3
  • cd /fnal/ups/prd/sam_db_admin/version
  • setup oracle_2000
  • MAKE SURE YOUR ID IS IN THE PRODUCTS GROUP
  • MAKE SURE SAM_DB_ADMIN_DIR is set to /fnal/ups/prd/sam_db_admin/version
  • MAKE SURE TWO_TASK IS SET TO d0ofprd1.
  • MAKE SURE ORACLE_SID IS SET TO d0ofprd1.
  • pwd to make sure you are in the correct directory.
  • command line should be:
    • make all ORAUSER= samprd/password@d0ofprd1 | tee logFile
  • check for invalid objects, sqlplus samprd/pwd select object_name from user_objects where status <> 'VALID';
  • fix invalid objects if any