Parm Patram

http://www.oracle.com/technology/documentation/discoverer.html

http://ilearning.oracle.com/ilearn/en/learner/jsp/player.jsp?rco_id=107194876&classroom_id=108352291

http://www.vanemery.com/Linux/Serial/serial-console.html

http://oracle.anilpassi.com/workflow-notifications-override-email-address-for-all-notifications-2.html

cat /d01/oracle/VIS1/db/tech_st/10.2.0/VIS1_oraapps.env
#!/bin/sh
# $Header: ad8idbux.env 120.6.12000000.2 2007/07/02 13:18:28 dhakumar ship $
# =============================================================================
# NAME
# VIS1.env
#
# DESCRIPTION
# Setup environment for Oracle
#
# NOTES
#
# HISTORY
# Created by AutoConfig
# =============================================================================
#
# ###############################################################
#
# This file is automatically generated by AutoConfig. It will be read and
# overwritten. If you were instructed to edit this file, or if you are not
# able to use the settings created by AutoConfig, refer to Metalink Note
# 387859.1 for assistance.
#
# ###############################################################

#

######################################
# Unset all the variables NOT required
######################################

unset TWO_TASK

unset ORA_NLS33

unset USERPATH

#####################################
# Source the custom file if it exists
#####################################

customfile=/d01/oracle/VIS1/db/tech_st/10.2.0/customVIS1_oraapps.env
if [ -f $customfile ]; then
. /d01/oracle/VIS1/db/tech_st/10.2.0/customVIS1_oraapps.env
fi

############################
# Set the variables required
############################

ORACLE_HOME=”/d01/oracle/VIS1/db/tech_st/10.2.0″
export ORACLE_HOME

ORACLE_SID=”VIS1″
export ORACLE_SID

ORA_NLS10=”/d01/oracle/VIS1/db/tech_st/10.2.0/nls/data/9idata”
export ORA_NLS10

PATH=”/d01/oracle/VIS1/db/tech_st/10.2.0/bin:/usr/bin:/usr/sbin:/d01/oracle/VIS1/db/tech_st/10.2.0/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:$PATH”
export PATH

LINK_CNTRL=”"
export LINK_CNTRL

TNS_ADMIN=”/d01/oracle/VIS1/db/tech_st/10.2.0/network/admin/VIS1_oraapps”
export TNS_ADMIN

if test “LINUX_X86-64″ = “IBM AIX”; then
export AIXTHREAD_SCOPE=S
fi

####################################################################
# The CONTEXT_FILE variable stores the location of the context file.
####################################################################

CONTEXT_FILE=”/d01/oracle/VIS1/db/tech_st/10.2.0/appsutil/VIS1_oraapps.xml”
export CONTEXT_FILE

####################################################################
# The CONTEXT_NAME variable stores the value for the current context
####################################################################

CONTEXT_NAME=”VIS1_oraapps”
export CONTEXT_NAME

##################
# Set Library Path
##################

LD_LIBRARY_PATH=”/d01/oracle/VIS1/db/tech_st/10.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/d01/oracle/VIS1/db/tech_st/10.2.0/lib:/usr/dt/lib:/d01/oracle/VIS1/db/tech_st/10.2.0/ctx/lib”
export LD_LIBRARY_PATH

SHLIB_PATH=”/d01/oracle/VIS1/db/tech_st/10.2.0/lib:/usr/lib:/d01/oracle/VIS1/db/tech_st/10.2.0/ctx/lib”
export SHLIB_PATH

LIBPATH=”/d01/oracle/VIS1/db/tech_st/10.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/d01/oracle/VIS1/db/tech_st/10.2.0/lib:/usr/dt/lib:/d01/oracle/VIS1/db/tech_st/10.2.0/ctx/lib”
export LIBPATH

#######################################
# Add perl to the PATH and set PERL5LIB
#######################################

PERLBIN=`dirname /d01/oracle/VIS1/db/tech_st/10.2.0/perl/bin/perl`

PATH=${PERLBIN}:${PATH}
export PATH

PERL5LIB=/d01/oracle/VIS1/db/tech_st/10.2.0/perl/lib/5.8.3:/d01/oracle/VIS1/db/tech_st/10.2.0/perl/lib/site_perl/5.8.3:/d01/oracle/VIS1/db/tech_st/10.2.0/appsutil/perl
export PERL5LIB

ADPERLPRG=/d01/oracle/VIS1/db/tech_st/10.2.0/perl/bin/perl
export ADPERLPRG

#################################################
# National Language Support environment variables
#################################################

NLS_LANG=”American_America.UTF8″
export NLS_LANG

NLS_DATE_FORMAT=”DD-MON-RR”
export NLS_DATE_FORMAT

NLS_NUMERIC_CHARACTERS=”.,”
export NLS_NUMERIC_CHARACTERS

NLS_SORT=”binary”
export NLS_SORT

#############################
# Set java program used by AD
#############################

ADJVAPRG=”/d01/oracle/VIS1/db/tech_st/10.2.0/appsutil/jre/bin/java”
export ADJVAPRG

ADJREOPTS=”-Xms128M -Xmx512M”
export ADJREOPTS

#############################
# Timezone Specification file
#############################

ORA_TZFILE=”$ORACLE_HOME/oracore/zoneinfo/timezlrg.dat”
export ORA_TZFILE

[root@oraapps ~]#

REPORTS_PRE=”&5555″
export REPORTS_PRE

REPORTS_POST=”&5556″
export REPORTS_POST

REPORTS_NO_DUMMY_PRINTER=”TRUE”
export REPORTS_NO_DUMMY_PRINTER

RW=”/d01/oracle/VIS1/apps/tech_st/10.1.2/reports”
export RW

REPORTS_TAGLIB_URI=”/WEB-INF/lib/reports_tld.jar”
export REPORTS_TAGLIB_URI

REPORTS_CLASSPATH=”/d01/oracle/VIS1/apps/tech_st/10.1.2/reports/jlib/rwbuilder.jar:/d01/oracle/VIS1/apps/tech_st/10.1.2/reports/jlib/rwrun.jar:/d01/oracle/VIS1/apps/tech_st/10.1.2/jlib/zrclient.jar:/d01/oracle/VIS1/apps/tech_st/10.1.2/j2ee/home/oc4j.jar:/d01/oracle/VIS1/apps/tech_st/10.1.2/j2ee/home/lib/ojsp.jar”
export REPORTS_CLASSPATH

REPORTS_USEREXITS=”/d01/oracle/VIS1/apps/apps_st/appl/fnd/12.0.0/bin/fndrwxit.so”
export REPORTS_USEREXITS

if [ "`uname -rs`" = "SunOS 5.9" ]
then
REPORTS_SOLARIS_9=”YES”;
export REPORTS_SOLARIS_9
fi

TK_ICON=”/d01/oracle/VIS1/apps/tech_st/10.1.2/reports/plugins/resource”
export TK_ICON

TK_PRINTER=”noprint”
export TK_PRINTER

TK_PRINT_STATUS=”echo %n is valid”
export TK_PRINT_STATUS

# Set XENVIRONMENT variable in a UTF8 env

if test “UTF8″ = “UTF8″; then
XENVIRONMENT=”/d01/oracle/VIS1/apps/tech_st/10.1.2/guicommon/tk/admin/Tk2Motif_UTF8.rgb”
export XENVIRONMENT
fi

####################################
# Oracle Forms environment variables
####################################

FORMS_DISABLE_UNPAD_LOV=”TRUE”
export FORMS_DISABLE_UNPAD_LOV

FORMS_MESSAGE_ENCRYPTION=”TRUE”
export FORMS_MESSAGE_ENCRYPTION

FORMS_SESSION=”TRUE”
export FORMS_SESSION

FORMS_OAM_FRD=”OFF”
export FORMS_OAM_FRD

FORMS_APPSLIBS=”APPCORE FNDSQF APPDAYPK APPFLDR GLCORE HR_GEN HR_SPEC ARXCOVER”
export FORMS_APPSLIBS

FORMS_FORCE_MENU_MNEMONICS=”0″
export FORMS_FORCE_MENU_MNEMONICS

FORMS_TRACE_DIR=/d01/oracle/VIS1/inst/apps/VIS1_oraapps/logs/ora/10.1.2/forms
export FORMS_TRACE_DIR

FORMS_PATH=”/d01/oracle/VIS1/apps/apps_st/appl/au/12.0.0/resource:/d01/oracle/VIS1/apps/apps_st/appl/au/12.0.0/resource/stub”
export FORMS_PATH

FORMS_FLAG_DIFFERENT_SUBORD=”1″;
export FORMS_FLAG_DIFFERENT_SUBORD

FORMS_WEB_CONFIG_FILE=”/d01/oracle/VIS1/inst/apps/VIS1_oraapps/ora/10.1.2/forms/server/appsweb.cfg”
export FORMS_WEB_CONFIG_FILE

FORMS_BLOCKING_LONGLIST=”FALSE”
export FORMS_BLOCKING_LONGLIST

FORMS_LOV_INITIAL=”5000″
export FORMS_LOV_INITIAL

FORMS_TIMEOUT=”5″
export FORMS_TIMEOUT

FORMS_RESTRICT_ENTER_QUERY=”TRUE”
export FORMS_RESTRICT_ENTER_QUERY

FORMS_CATCHTERM=”1″
export FORMS_CATCHTERM

FORMS_RTI_DIR=”/d01/oracle/VIS1/inst/apps/VIS1_oraapps/logs/ora/10.1.2/forms”
export FORMS_RTI_DIR

FORMS_REJECT_GO_DISABLED_ITEM=”0″
export FORMS_REJECT_GO_DISABLED_ITEM

FORMS_OVERRIDE_ENV=”NLS_LANG,NLS_NUMERIC_CHARACTERS,NLS_SORT,NLS_DATE_LANGUAGE,NLS_DATE_FORMAT,FORMS_USER_DATE_FORMAT,FORMS_USER_DATETIME_FORMAT,FORMS_OUTPUT_DATE_FORMAT,FORMS_OUTPUT_DATETIME_FORMAT,FORMS_ERROR_DATE_FORMAT,FORMS_ERROR_DATETIME_FORMAT,FORMS_TZFILE,FORMS_DATETIME_SERVER_TZ,FORMS_DATETIME_LOCAL_TZ,FORMS_USER_CALENDAR”
export FORMS_OVERRIDE_ENV

FORMS_MODULE_PATH=”/d01/oracle/VIS1/apps/apps_st/appl/fnd/12.0.0/forms”
export FORMS_MODULE_PATH

#################################################
# Define the Full path of the Reviver Process PID
#################################################

FNDREVIVERPID=”/d01/oracle/VIS1/inst/apps/VIS1_oraapps/pids/appl/reviver.sh_VIS1_oraapps.pid”
export FNDREVIVERPID

#############################
# Define the variable AFCPDNR
#############################

TEMP_APPS_VERSION=”12.0.4″
APPS_VERSION=`echo $TEMP_APPS_VERSION | grep 11.5 | awk -F. ‘{ print $1 }’`
if [ "x${APPS_VERSION}" = "x11" ]; then
AFCPDNR=”enabled”
export AFCPDNR
fi

###########################
# For integration with ILOG
###########################

APPL_CPLEX_LICDIR=”/d01/oracle/VIS1/apps/apps_st/appl/admin/cplex”
export APPL_CPLEX_LICDIR

###################################
# Add perl location to the PATH and
# set PERL5LIB for Perl
###################################

PERLBIN=`dirname /d01/oracle/VIS1/apps/tech_st/10.1.3/perl/bin/perl`

PATH=${PERLBIN}:${PATH}
export PATH

PERL5LIB=/d01/oracle/VIS1/apps/tech_st/10.1.3/perl/lib/5.8.3:/d01/oracle/VIS1/apps/tech_st/10.1.3/perl/lib/site_perl/5.8.3:/d01/oracle/VIS1/apps/apps_st/appl/au/12.0.0/perl:/d01/oracle/VIS1/apps/tech_st/10.1.3/Apache/Apache/mod_perl/lib/site_perl/5.8.3/i686-linux-thread-multi
export PERL5LIB

ADPERLPRG=/d01/oracle/VIS1/apps/tech_st/10.1.3/perl/bin/perl
export ADPERLPRG

####################################################
# Get customer-defined environment variable settings
####################################################

. /d01/oracle/VIS1/apps/apps_st/appl/admin/adovars.env

###########################
# iAS ORACLE_HOME directory
###########################

IAS_ORACLE_HOME=”/d01/oracle/VIS1/apps/tech_st/10.1.3″
export IAS_ORACLE_HOME

######################################
# Define the DBC file storage location
######################################

FND_SECURE=”/d01/oracle/VIS1/inst/apps/VIS1_oraapps/appl/fnd/12.0.0/secure”
export FND_SECURE

########################################################################
# Setting APPLORB & APPLORC env variables to override the value of these
# variables set from /d01/oracle/VIS1/apps/apps_st/appl/fnd/12.0.0/fndenv.env
########################################################################

APPLORB=”/d01/oracle/VIS1/inst/apps/VIS1_oraapps/ora/10.1.2/bin/appsrwrun.sh”
export APPLORB

APPLORC=”/d01/oracle/VIS1/inst/apps/VIS1_oraapps/ora/10.1.2/bin/appsrwrun.sh”
export APPLORC

####################################################
# Env variables for shared file system configuration
####################################################

# INST_TOP is the top level location for all the instance specific conf,
# logs, pids, certs etc.

INST_TOP=”/d01/oracle/VIS1/inst/apps/VIS1_oraapps”
export INST_TOP

# APPL_CONFIG_HOME is the top level location for all the instance specific
# APPL_TOP related config files.

APPL_CONFIG_HOME=”/d01/oracle/VIS1/apps/apps_st/appl”
export APPL_CONFIG_HOME

# ORA_CONFIG_HOME is the top level location for all the instance specific
# Oracle home related config files.

ORA_CONFIG_HOME=”/d01/oracle/VIS1/inst/apps/VIS1_oraapps/ora”
export ORA_CONFIG_HOME

# LOG_HOME is the top level location for all the instance specific logs.

LOG_HOME=”/d01/oracle/VIS1/inst/apps/VIS1_oraapps/logs”
export LOG_HOME

# ADMIN_SCRIPTS_HOME is the location for all the administation scripts for
# application tier.

ADMIN_SCRIPTS_HOME=”/d01/oracle/VIS1/inst/apps/VIS1_oraapps/admin/scripts”
export ADMIN_SCRIPTS_HOME

# Set java program used by FND

AFJVAPRG=”/d01/oracle/VIS1/inst/apps/VIS1_oraapps/admin/scripts/java.sh”
export AFJVAPRG

##############################################
# Release information to patch the environment
##############################################

APPS_VERSION=”12.0.4″
export APPS_VERSION

http://download.oracle.com/docs/cd/B14099_19/core.1012/b13995/cloning.htm#CEGFDGCF

Get release number:

select RELEASE_NAME from fnd_product_groups;

See if a patch has already been applied:

select bug_number from AD_BUGS where bug_number =’&patch_no’;

FNDCPASS apps/apps 0 Y system/manager USER  lscott welcome

set env variables:
. /d01/oracle/VIS/apps/apps_st/appl/APPSVIS_oraapps.env

start listener:
/d01/oracle/VIS/db/tech_st/10.2.0/appsutil/scripts/VIS_oraapps/addlnctl.sh start listener

start database:
/d01/oracle/VIS/db/tech_st/10.2.0/appsutil/scripts/VIS_oraapps/addbctl.sh start

start apache:
/d01/oracle/VIS/inst/apps/VIS_oraapps/admin/scripts/adapcctl.sh start

start middle tier:
/d01/oracle/VIS/inst/apps/VIS_oraapps/admin/scripts/adstrtal.sh apps/apps

http://download.oracle.com/docs/cd/B40089_10/current/html/docset.html

Good help from http://www.pythian.com/blogs/1265/installing-oracle-r12-ebs-in-my-living-room for getting older libraries.