#!/bin/sh # # $HOME/dbabatch - Defines required parameters for DBA-related crontab jobs # # >>>>> THIS FILE MUST BE EDITED FOR YOUR SPECIFIC ENVIRONMENT! # >>>>> IN PARTICULAR, YOU MUST CHANGE THE FOLLOWING DEFINITIONS: # >>>>> ORACLE_BASE, DBA, TOOLS, ORACLE_SID # >>>>> (LPDEST CAN ALSO BE DEFINED, IF SO DESIRED) # # This file must be called from the oracle user's .profile file, as: # . ./dbabatch # # Last Change 08/26/97 by Brian Lomasky # set -u # trap "echo 'logout'" 0 ORACLE_BASE=/oracle; export ORACLE_BASE EDITOR=vi; export EDITOR ORACLE_TERM=vt220; export ORACLE_TERM TERM=vt220; export TERM DBA=/oracle/home/dba; export DBA TOOLS=/oracle/home/tools; export TOOLS PATH=/bin:/usr/bin:/opt/bin:/usr/ccs/bin:/usr/openwin/bin:/etc:$DBA:$TOOLS:. export PATH ORACLE_PATH=$DBA:$TOOLS:.; export ORACLE_PATH # # Skip the prompt for the ORACLE_SID. (Executed only for non-interactive jobs). # if [ "`tty`" != "not a tty" ] then # # Prompt for the desired ORACLE_SID for interactive jobs # ORACLE_SID=PROD; export ORACLE_SID . oraenv fi LD_LIBRARY_PATH=/usr/openwin/lib:/usr/dt/lib:$ORACLE_HOME/lib:/usr/ucblib export LD_LIBRARY_PATH # Ensure one (and only one . is in the PATH) case "$PATH" in *.*) ;; # If already in the path? *:) PATH=${PATH}.: ;; # If path ends in a colon? "") PATH=. ;; # If path is null? *) PATH=$PATH:. ;; # If none of the above? esac umask 177 # # Extract type of computer system we're on # TheSystem=`$TOOLS/getsyi` # # See which options to use with the ps command # case $TheSystem in SUNBSD | ULTRIX ) PS_OPTS="-auwx";; *) PS_OPTS="-ef";; esac export PS_OPTS #LPDEST=lj6l; export LPDEST