DUPERREY.COM

Outils pour utilisateurs

Outils du site

Piste :
bloc_note

Différences

Ci-dessous, les différences entre deux révisions de la page.

Lien vers cette vue comparative

Les deux révisions précédentesRévision précédente
Prochaine révision		Révision précédente
bloc_note [2025/01/15 07:29] – adminbloc_note [2025/03/24 15:27] (Version actuelle) – admin
Ligne 2: Ligne 2:
  
 <code> <code>
-#!/bin/bash +        <g id="SANDOUVILLE" transform="matrix(2.91786,0,0,2.64787,-910.867,-504.816)"> 
-export LOG="/traces/pre_lanceur.log" + <ellipse cx="475.825" cy="305.328" rx="0.902" ry="0.994" style="fill:rgb(216,29,29);"/> 
- + <g transform="matrix(0.0639002,0,0,0.0708526,474.795,304.48)"> 
-function mk_extract_sql(){ + <g> 
-##### Backup t_versions_ihm + <path id="Rectangle-24" serif:id="Rectangle-2" d="M24,11L26,11L26,13.686L13.686,26L2,13.686L13.686,2L26,2L26,8L24,8L23,5L14.929,5L6.188,13.741L13.742,21.701L23,12.444L24,11Z" style="fill:rgb(26,26,26);"/> 
-ORACLE_SID="$1" + <path id="D4" serif:id="D" d="M13.342,17.085C12.996,17.085 12.623,17.074 12.225,17.052C11.827,17.031 11.461,17 11.128,16.96L11.128,9.795C11.504,9.708 11.925,9.64 12.39,9.59C12.855,9.54 13.307,9.515 13.748,9.515C15.191,9.515 16.272,9.823 16.993,10.44C17.713,11.057 18.073,12.01 18.073,13.3C18.073,14.187 17.9,14.908 17.555,15.465C17.21,16.022 16.691,16.431 15.998,16.693C15.304,16.954 14.419,17.085 13.342,17.085ZM13.938,15.34C14.378,15.34 14.737,15.273 15.015,15.14C15.293,15.007 15.502,14.791 15.64,14.493C15.778,14.194 15.848,13.793 15.848,13.29C15.848,12.793 15.775,12.396 15.63,12.098C15.485,11.799 15.272,11.583 14.99,11.45C14.708,11.317 14.353,11.25 13.923,11.25C13.832,11.25 13.728,11.256 13.608,11.268C13.487,11.279 13.386,11.293 13.303,11.31L13.303,15.325C13.456,15.335 13.667,15.34 13.938,15.34Z" style="fill:rgb(50,50,50);"/> 
-FILEOUT="$2" + </g> 
-#select PRODUIT,APPLICATION,NVL(VERSION_SERVEUR,'0.0.0.0'),NVL(VERSION_IHM_BACKUP,'0.0.0.0'),NVL(VERSION_IHM_COURANTE,'0.0.0.0'), NVL(VERSION_IHM_BETA,'0.0.0.0'),DATE_MAJ from LANCEUR.T_VERSIONS_IHM; + </g> 
-echo "SET LINESIZE 1000 + </g>
-SET TRIMSPOOL ON +
-SET TRIMOUT ON +
-SET TERMOUT OFF +
-SET PAGESIZE 0 +
-SET WRAP OFF +
-SET ECHO OFF +
-COL PRODUIT FORMAT A15 +
-COL APPLICATION FORMAT A15 +
-spool $FILEOUT +
-alter SESSION set NLS_DATE_FORMAT = 'dd-MON-yyyy'; +
-select PRODUIT,APPLICATION,VERSION_SERVEUR,NVL(VERSION_IHM_BACKUP,'null'),VERSION_IHM_COURANTE, NVL(VERSION_IHM_BETA,'null') ,DATE_MAJ from LANCEUR.T_VERSIONS_IHM; +
-exit; +
-">/tmp/tmp_sql.sql +
-echo "---     selection des version en BD (/tmp/tmp_sql.sql)" >> "$LOG" +
-cat /tmp/tmp_sql.sql >> "$LOG" +
-su oracle -c ". /composants/oracle/adm/oracle_util.sh $ORACLE_SID > /dev/null 2>&1; +
-timeout 5 sqlplus -s / as sysdba @/tmp/tmp_sql.sql" +
-sed -i "s/\s\s\+/|/g"  "$FILEOUT" +
-rm -rf /tmp/tmp_sql.sql +
-} +
- +
-function get_version_serveur_active(){ +
-ORACLE_SID="$1" +
-echo "SET LINESIZE 1000 +
-SET TRIMSPOOL ON +
-SET TRIMOUT ON +
-SET TERMOUT OFF +
-SET PAGESIZE 0 +
-SET WRAP OFF +
-SET ECHO OFF +
-COL VERSION_SERVEUR  +
-spool /tmp/VERSION_SERVEUR_INSTALLEE.txt +
-select VERSION_SERVEUR from $USERBD.T_VERSIONS_IHM_COMPATIBLES ; +
-exit; +
-">/tmp/tmp_sql.sql +
-echo "---     selection des version en BD (/tmp/tmp_sql.sql)" >> "$LOG" +
-cat /tmp/tmp_sql.sql >> "$LOG" +
-su oracle -c ". /composants/oracle/adm/oracle_util.sh $ORACLE_SID > /dev/null 2>&1; +
-timeout 5 sqlplus -s / as sysdba @/tmp/tmp_sql.sql" +
-sed -i "s/\s\s\+/|/g"  "/tmp/VERSION_SERVEUR_INSTALLEE.txt" +
-cat /tmp/VERSION_SERVEUR_INSTALLEE.txt +
-rm -rf /tmp/VERSION_SERVEUR_INSTALLEE.txt +
-rm -rf /tmp/tmp_sql.sql +
-} +
- +
-function get_t_version_ihm(){ +
-ORACLE_SID=$1 +
-APPLICATION=$2 +
-OUTFILE="/tmp/tmp_t_ihm_version.tmp" +
-mk_extract_sql "$ORACLE_SID" "$OUTFILE" +
-while read ligne +
-  do +
-  PRODUIT=$(echo $ligne | awk -F"|" '{print $1}') +
-  APPLICATION=$(echo $ligne | awk -F"|" '{print $2}') +
-  VERSION_SERVEUR=$(echo $ligne | awk -F"|" '{print $3}') +
-  VERSION_IHM_BACKUP=$(echo $ligne | awk -F"|" '{print $4}') +
-  VERSION_IHM_COURANTE=$(echo $ligne | awk -F"|" '{print $5}') +
-  VERSION_IHM_BETA=$(echo $ligne | awk -F"|" '{print $6}') +
-  DATE_MAJ=$(echo $ligne | awk -F"|" '{print $7}') +
-  if [ "$ORACLE_SID" ] && [ "$PRODUIT" ] && [ "$APPLICATION" ] && [ "$VERSION_SERVEUR" ] && [ "$VERSION_IHM_BACKUP" ] && [ "$VERSION_IHM_COURANTE" ] && [ "$VERSION_IHM_BETA" ] +
-  then +
-  POST="${POST}&t_version_ihm[]="$ORACLE_SID":"$PRODUIT":"$APPLICATION":"$VERSION_SERVEUR":"$VERSION_IHM_BACKUP":"$VERSION_IHM_COURANTE":"$VERSION_IHM_BETA":"$DATE_MAJ +
-  echo "$VERSION_IHM_BACKUP" >> /tmp/ALL_VERSION_IHM.txt +
-  echo "$VERSION_IHM_COURANTE" >> /tmp/ALL_VERSION_IHM.txt +
-  echo "$VERSION_IHM_BETA" >> /tmp/ALL_VERSION_IHM.txt +
-  fi +
-done < /tmp/tmp_t_ihm_version.tmp +
-echo " --- Fichier "$OUTFILE" ---" >> "$LOG" +
-cat "$OUTFILE" >> "$LOG" +
-echo "---   --- FIN ---" >> "$LOG" +
-echo " ">> "$LOG" +
-rm -rf "$OUTFILE" +
-} +
- +
-valide_t_version_ihm(){ +
-ORACLE_SID=$1 +
-echo -e "$GREY - Validation du schema lanceur ($ORACLE_SID) $NORM" +
-#### Requette valide repertoire +
-echo "SET WRAP OFF ; +
-set underline off ; +
-set heading off ; +
-spool /tmp/out1.sql ; +
-select count(DIRECTORY_NAME)from all_directories where DIRECTORY_NAME='LANCEUR_DEPOT_VERSIONS';  +
-spool off;  +
-spool /tmp/out2.sql ; +
-select count(*) FROM all_tables where OWNER='LANCEUR';  +
-spool off;  +
-spool /tmp/out3.sql ; +
-ALTER VIEW LANCEUR.V_VERSIONS_IHM_COMPATIBLES COMPILE;  +
-spool off;  +
-exit;  +
-" > /tmp/sql1.sql +
- +
-su oracle -c ". /composants/oracle/adm/oracle_util.sh $ORACLE_SID > /dev/null 2>&1; +
-timeout 5 sqlplus -s / as sysdba @/tmp/sql1.sql +
-" +
-#ETAT_DIRECTORY=$(sed -e "s/\s\s\+//g" /tmp/out1.sql |grep -v "^\$") +
-ETAT_DIRECTORY=`grep -v "^\$" /tmp/out1.sql | sed -e "s/\s\s\+//g"` +
-ETAT_TABLE=`sed -e "s/\s\s\+//g" /tmp/out2.sql |grep -v "^\$"` +
-ETAT_VIEW=`grep "altered." /tmp/out3.sql | wc -l ` +
- +
-rm -rf /tmp/out1.sql /tmp/out2.sql /tmp/out3.sql +
- +
-if [[ $ETAT_DIRECTORY -eq 1 ]] && [ "$ETAT_TABLE" -eq 2 ] && [ "$ETAT_VIEW" -eq 1 ] +
-then +
-VALIDATION=0 +
-echo "Validation ok pour le schema lanceur" >> "$LOG" +
-else +
-VALIDATION=1 +
-echo "Validation KO pour le schema lanceur" >> "$LOG" +
-echo "ETAT_DIRECTORY:$ETAT_DIRECTORY (1), ETAT_TABLE:$ETAT_TABLE (2), ETAT_VIEW:$ETAT_VIEW (1)" >> "$LOG" +
-fi +
- +
-}+
  
 </code> </code>
bloc_note.1736922564.txt.gz · Dernière modification : 2025/01/15 07:29 de admin