#!/bin/sh
#*******************************************************************************
#             ISTP RE-ENGENEERING
#         ORACLE RECONSTRUCTION RULES
#               NASA/GSFC
#*******************************************************************************
#PURPOSE: Pin all reconstruction procedures in SGA
#
#INVOCATION METHOD: PIN_PROCEDURES  installacct/installpasswd username
#
#
#DEVELOPMENT HISTORY:
#
#       Author          Change-ID       Release   Date    Description of Change
#       ------          ---------       ------- --------  ---------------------
#       Y.AZIE          Build 1         B1      7/97      Initial development build
#
#
#
#NOTES: This script is called by the rules build script (buildscript)
#*******************************************************************************
#
if test $# -ne 2 
then
echo '**************************************************************'
echo 'Error: You must enter the Oracle SYS/Password username'
echo '**************************************************************'
exit
fi

sqlplus $1 << ENDORACLE

EXEC DBMS_SHARED_POOL.KEEP ('STANDARD');
EXEC DBMS_SHARED_POOL.KEEP ('DBMS_UTILITY');
EXEC DBMS_SHARED_POOL.KEEP ('DBMS_STANDARD');
EXEC DBMS_SHARED_POOL.KEEP ('DBMS_OUTPUT');
EXEC DBMS_SHARED_POOL.KEEP ('DBMS_SQL');
EXEC DBMS_SHARED_POOL.KEEP ('DBMS_DESCRIBE');
EXEC DBMS_SHARED_POOL.KEEP ('$2.UNLOAD');                      
EXEC DBMS_SHARED_POOL.KEEP ('$2.UPDATE_MNFFPT');              
EXEC DBMS_SHARED_POOL.KEEP ('$2.INITIALIZE');                
EXEC DBMS_SHARED_POOL.KEEP ('$2.GFST_CHECK_NUM_ENTRIES');   
EXEC DBMS_SHARED_POOL.KEEP ('$2.GFST_CHECK_SPANS');        
EXEC DBMS_SHARED_POOL.KEEP ('$2.CP_LPOINTER');            
EXEC DBMS_SHARED_POOL.KEEP ('$2.GFST_EX_INSERT_TIME');   
EXEC DBMS_SHARED_POOL.KEEP ('$2.GFST_PROCESS1');        
EXEC DBMS_SHARED_POOL.KEEP ('$2.RATIO_RULE');          
EXEC DBMS_SHARED_POOL.KEEP ('$2.CREATE_INDEXES');     
EXEC DBMS_SHARED_POOL.KEEP ('$2.GFST_CHECK_VOIDS');  
EXEC DBMS_SHARED_POOL.KEEP ('$2.GFST_PROCESS2');    
EXEC DBMS_SHARED_POOL.KEEP ('$2.BFST_SET_MNFSKIP');
EXEC DBMS_SHARED_POOL.KEEP ('$2.BFST_SET_MNFCERR');            
EXEC DBMS_SHARED_POOL.KEEP ('$2.BFST_SET_MODEERR');           
EXEC DBMS_SHARED_POOL.KEEP ('$2.FILL_FLAG');
EXEC DBMS_SHARED_POOL.KEEP ('$2.BFST_SET_DATEERR');          
EXEC DBMS_SHARED_POOL.KEEP ('$2.BFST_CHECK_UNPACKED_TIMES');     
EXEC DBMS_SHARED_POOL.KEEP ('$2.CS_DT');              
EXEC DBMS_SHARED_POOL.KEEP ('$2.CS_UMFC');             
EXEC DBMS_SHARED_POOL.KEEP ('$2.BFST_CALC_TIME_GRT');   
EXEC DBMS_SHARED_POOL.KEEP ('$2.BFST_REPORT_FILL');
EXEC DBMS_SHARED_POOL.KEEP ('$2.ACTION_CS_00');          
EXEC DBMS_SHARED_POOL.KEEP ('$2.BFST_COMP_UMFCS');        
EXEC DBMS_SHARED_POOL.KEEP ('$2.BFST_GRTVSUMFC');          
EXEC DBMS_SHARED_POOL.KEEP ('$2.BFST_CALC_TIME_UMFC');      
EXEC DBMS_SHARED_POOL.KEEP ('$2.ACTION_CS_01');              
EXEC DBMS_SHARED_POOL.KEEP ('$2.ACTION_CS_02');
EXEC DBMS_SHARED_POOL.KEEP ('$2.ACTION_CS_10'); 
EXEC DBMS_SHARED_POOL.KEEP ('$2.BFST_CALC_UMFC');
EXEC DBMS_SHARED_POOL.KEEP ('$2.BFST_CALC_UMFC2');
EXEC DBMS_SHARED_POOL.KEEP ('$2.ACTION_CS_11_S1'); 
EXEC DBMS_SHARED_POOL.KEEP ('$2.ACTION_CS_11');     
EXEC DBMS_SHARED_POOL.KEEP ('$2.ACTION_CS_12');      
EXEC DBMS_SHARED_POOL.KEEP ('$2.ACTION_CS_20');       
EXEC DBMS_SHARED_POOL.KEEP ('$2.ACTION_CS_21');        
EXEC DBMS_SHARED_POOL.KEEP ('$2.ACTION_CS_22');         
EXEC DBMS_SHARED_POOL.KEEP ('$2.BFST_FILL_TIMES');       
EXEC DBMS_SHARED_POOL.KEEP ('$2.BFST_REFILL_TIMES');      
EXEC DBMS_SHARED_POOL.KEEP ('$2.BFST_CHECK_FILLED_TIMES'); 
EXEC DBMS_SHARED_POOL.KEEP ('$2.CROSS_CHECK_TIMES');        
EXEC DBMS_SHARED_POOL.KEEP ('$2.CREATE_WFST');               
EXEC DBMS_SHARED_POOL.KEEP ('$2.BFST_GET_MFT');               
EXEC DBMS_SHARED_POOL.KEEP ('$2.WFST_VERIFY_TIME');            
EXEC DBMS_SHARED_POOL.KEEP ('$2.BFST_FAIL_DUPLICATES');         
EXEC DBMS_SHARED_POOL.KEEP ('$2.CREATE_QUAL_COMP');    
EXEC DBMS_SHARED_POOL.KEEP ('$2.GFST_CHECK_INSERTS');   
EXEC DBMS_SHARED_POOL.KEEP ('$2.BFST_SUBT_GETROWID');    
EXEC DBMS_SHARED_POOL.KEEP ('$2.BFST_RECORD_QUAL');       
EXEC DBMS_SHARED_POOL.KEEP ('$2.BFST_CHECK_SUBT2');         
EXEC DBMS_SHARED_POOL.KEEP ('$2.INSERT_POINTERS');           
EXEC DBMS_SHARED_POOL.KEEP ('$2.GEN_RECIPE1');                
EXEC DBMS_SHARED_POOL.KEEP ('$2.GEN_RECIPE3');
EXEC DBMS_SHARED_POOL.KEEP ('$2.QL');
EXEC DBMS_SHARED_POOL.KEEP ('$2.DET_QL_WINDOW');
EXEC DBMS_SHARED_POOL.KEEP ('$2.RESET_TIME');
EXEC DBMS_SHARED_POOL.KEEP ('$2.CREATE_SPOINTERT1');            
EXEC DBMS_SHARED_POOL.KEEP ('$2.UPDATE_CDM');   
EXEC DBMS_SHARED_POOL.KEEP ('$2.BFST_ASS_QRANK');
EXEC DBMS_SHARED_POOL.KEEP ('$2.BFST_COMP_QUAL'); 
EXEC DBMS_SHARED_POOL.KEEP ('$2.GEN_RECIPE4');     
EXEC DBMS_SHARED_POOL.KEEP ('$2.GEN_RECIPE2');      
EXEC DBMS_SHARED_POOL.KEEP ('$2.MFT_FILL_STATE');    
EXEC DBMS_SHARED_POOL.KEEP ('$2.CREATE_TEMP_AFST');   
EXEC DBMS_SHARED_POOL.KEEP ('$2.QA_AFST');             
EXEC DBMS_SHARED_POOL.KEEP ('$2.UPDATE_IFST');          
EXEC DBMS_SHARED_POOL.KEEP ('$2.TERMINATE_REC');         
EXEC DBMS_SHARED_POOL.KEEP ('$2.CREATE_GFST_FROM_BFST');  
EXEC DBMS_SHARED_POOL.KEEP ('$2.GEN_RECIPE5');    
EXEC DBMS_SHARED_POOL.KEEP ('$2.RECONSTRUCTION2'); 
EXEC DBMS_SHARED_POOL.KEEP ('$2.RECONSTRUCTION3');  
EXEC DBMS_SHARED_POOL.KEEP ('$2.EX_RECONSTRUCTION1');
EXEC DBMS_SHARED_POOL.KEEP ('$2.RECONSTRUCTION1');
EXEC DBMS_SHARED_POOL.KEEP ('$2.CONFIG');
EXEC DBMS_SHARED_POOL.KEEP ('$2.POST_STATE');
EXEC DBMS_SHARED_POOL.KEEP ('$2.RULES_STATES');
EXEC DBMS_SHARED_POOL.KEEP ('$2.DIRECTION');
EXEC DBMS_SHARED_POOL.KEEP ('$2.OPEN_AND_PARSE');
EXEC DBMS_SHARED_POOL.KEEP ('$2.EXECUTE_AND_CLOSE');
EXEC DBMS_SHARED_POOL.KEEP ('$2.SWITCH');
EXEC DBMS_SHARED_POOL.KEEP ('$2.RULE');
EXEC DBMS_SHARED_POOL.KEEP ('$2.STATES');
EXEC DBMS_SHARED_POOL.KEEP ('$2.LOG_FILE');
ENDORACLE
