Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\UnifiedRepos\patch_paris_repos.sh
#!/bin/sh # # $Header: patch_paris_repos.sh 14-mar-2006.10:35:02 jfklein Exp $ # # patch_paris_repos.sh # # Copyright (c) 2006, Oracle. All rights reserved. # # NAME # patch_paris_repos.sh - upgrade OWB repository to current version # # DESCRIPTION # This script can be used to patch a repository for the latest build. It # assumes that the base repository version is 10.1.2.5.44 or later. # # NOTES # USAGE: # Change default directory to <OWB-HOME>/owb/UnifiedRepos # ./patch_paris_repos.sh # <host> <port> <svcName> <dbaUsr> <dbaPwd> <owbUsr> <owbPwd> # Where:: # <host>/<port>/<svcName> - Connection information for Oracle # instance containing the OWB repository to # be upgraded. # <dbaUsr>/<dbaPwd> - Name/Password for user with dba priviledges. # This user will be logged on AS SYSDBA to execute # the patch_paris_repos_sys.sql script. # <owbUsr>/<owbPwd> - Name/Password for OWB repository owner. This # user will be logged on to execute the # patch_paris_repos.sql script and also to execute # the owb_uprop_nls table load in this script. # CUSTOMIZATION: # The nls translation set for each language is fairly large and this # script defaults to installing all of them. (This is to match the # behavior of the standard repository installation.) The execution time # of this script can be improved by removing any non-required language # sets in the OWB_UPROP_NLS_FILES variable declaration. Tests on linux # with a local database show savings of approximately 2.5min/language. # (Initial run with just base (en) = 3:11, 2nd run adding de = 5:53, # 3rd run with all languages = 23min) # # # # MODIFIED (MM/DD/YY) # jfklein 03/14/06 - # bjeffrie 02/24/06 - Creation # echo ======================================= echo ===== patch_paris_repos Executing ===== echo ======================================= echo HOST=$1 PORT=$2 SVCNAME=$3 DBAUSR=$4 DBAPWD=$5 OWBUSR=$6 OWBPWD=$7 CURDIR=`pwd` EXEDIR=../bin/unix cd $EXEDIR eval `cat ../unix/setowbenv.sh` # Note: All external files referenced from EXEDIR PATCH_FILES_DIR=../../UnifiedRepos # Note: sql files must have final 'exit;' DBA_PATCH_FILE=$PATCH_FILES_DIR/patch_paris_repos_sys.sql OWB_PATCH_FILE=$PATCH_FILES_DIR/patch_paris_repos.sql NLS_FILES_DIR=../../browserasst/views # REQUIRED! OWB_UPROP_NLS_FILES=$NLS_FILES_DIR/owb_uprop_nls.xml # Optional, may comment out those not needed. OWB_UPROP_NLS_FILES=$OWB_UPROP_NLS_FILES $NLS_FILES_DIR/owb_uprop_nls_de.xml OWB_UPROP_NLS_FILES=$OWB_UPROP_NLS_FILES $NLS_FILES_DIR/owb_uprop_nls_es.xml OWB_UPROP_NLS_FILES=$OWB_UPROP_NLS_FILES $NLS_FILES_DIR/owb_uprop_nls_fr.xml OWB_UPROP_NLS_FILES=$OWB_UPROP_NLS_FILES $NLS_FILES_DIR/owb_uprop_nls_it.xml OWB_UPROP_NLS_FILES=$OWB_UPROP_NLS_FILES $NLS_FILES_DIR/owb_uprop_nls_ja.xml OWB_UPROP_NLS_FILES=$OWB_UPROP_NLS_FILES $NLS_FILES_DIR/owb_uprop_nls_ko.xml OWB_UPROP_NLS_FILES=$OWB_UPROP_NLS_FILES $NLS_FILES_DIR/owb_uprop_nls_pt_BR.xml OWB_UPROP_NLS_FILES=$OWB_UPROP_NLS_FILES $NLS_FILES_DIR/owb_uprop_nls_zh_CN.xml ${ORACLE_HOME}/bin/sqlplus ${DBAUSR}/${DBAPWD} AS SYSDBA@${HOST}:${PORT}/${SVCNAME} @${DBA_PATCH_FILE} ${ORACLE_HOME}/bin/sqlplus ${OWBUSR}/${OWBPWD}@${HOST}:${PORT}/${SVCNAME} @${OWB_PATCH_FILE} echo echo ======================================== echo ===== load owb_uprop_nls Executing ===== echo ======================================== ./jvm.sh -classpath ../../../lib/transx.zip:../../../lib/xschema.jar:../../../lib/xsu12.jar:../../../rdbms/jlib/xdb.jar:../../lib/int/rtpplatform.jar:../../lib/int/rtpcommon.jar:../../../jdbc/lib/ojdbc14.jar:../../../lib/xmlparserv2.jar:../../../sqlj/lib/runtime12.jar:../../../jdk/jre/lib/rt.jar oracle.xml.transx.loader "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=${HOST})(PORT=${PORT}))(CONNECT_DATA=(SERVICE_NAME=${SVCNAME})))" ${OWBUSR} ${OWBPWD} ${OWB_UPROP_NLS_FILES} echo ======================================== echo ===== load owb_uprop_nls Finished ===== echo ======================================== echo cd $CURDIR echo ======================================= echo ===== patch_paris_repos Finished ===== echo =======================================
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de