SAM_DB Make from d0ora3 for production

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

mail to users and helpdesk informing of downtime for version cut

logon to d0ora1 as sam

d0ora1 as sam: ups stop sam_bootstrap

logon to d0ora1 as oracle

setup oracle

setenv ORACLE_SID d0ofprd1

cd /usr/ora1/admin

svrmgrl

select * from v$database (to check sid!!!!)

shutdown the database

startup restrict; exit

ensure there is enough space on the disk where exports live (df -k /d0ora1/dbs_backup)

export the database as system by running /usr/ora1/admin/cron_exp

rename the export file with meaningful identifier i.e. BEFORE_CUT so it's not overwritten by anyone else's export.

svrmgrl

shutdown

startup; exit

logon to d0ora3

cd /fnal/ups/prd/sam_db/product version
MAKE SURE YOUR ID IS IN THE PRODUCTS GROUP
setup oracle
MAKE SURE SAM_DB_DIR is set to /fnal/ups/prd/sam_db/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 convert version=version user=samprd/password@d0ofprd1 | tee logFile
- after successful cut, do an "AFTER_CUT" export from oracle account on D0ora1(same procedure as above)
- From the D0ora1 sam user account, ups start sam_bootstrap
- mail to users and helpdesk informing that new version is active