Emergency UNIX and Linux Support

echo echo \$DB_USER_NAME | ksh

/p2k/L10.21A/devlp/root/global/data/usage/DAILY>echo $DB_USER_NAME
secadmin
/p2k/L10.21A/devlp/root/global/data/usage/DAILY> echo $DB_PASSWORD
vivadmin
/p2k/L10.21A/devlp/root/global/data/usage/DAILY> echo $TWO_TASK
ltd121a

nawk '{{print $1,$2,$3}}'  ./$DirectoryName/AuditGroupTableTableData_$TimeStamp.txt | while read a b c
do
  echo $a
  echo $b 
  echo $c
  ret=`sqlplus -s  $db_user/$db_pwd@$db_sid  $a $b $c <<EOF > ./${DirectoryName}/Query.sql
SET HEADING OFF
SET SERVEROUTPUT ON
SET FEEDBACK OFF
DECLARE
CNT  NUMBER(5);
DROPCNT NUMBER(5);
ERRORCNT NUMBER(5);
BEGIN
  SELECT COUNT(*) INTO CNT FROM USAGE_INTRNL_ERROR WHERE AUDIT_GROUP_ID='&1';
  IF ( CNT != &3) THEN
    Dbms_Output.put_line('SELECT INTRL_DROP_QTY,INTRL_ERROR_QTY INTO DROPCNT,ERRORCNT FROM USAGE_AUDIT_GROUP WHERE AUDIT_GROUP_NBR=''&1'';';
    SELECT INTRL_ERROR_QTY INTO DROPCNT FROM USAGE_AUDIT_GROUP WHERE AUDIT_GROUP_NBR = '&1';
    SET DROPCNT=DROPCNT-CNT;
    Dbms_Output.put_line('UPDATE USAGE_AUDIT_GROUP SET INTRL_DROP_QTY='||DROPCNT||' ,INTRL_ERROR_QTY='||CNT||'  WHERE  AUDIT_GROUP_NBR=''&1'';'
  END IF;
END;
/
EXIT;
EOF`
  touch ./$DirectoryName/SELECTQuery_$TimeStamp.sql
  touch ./$DirectoryName/UPDATEQuery_$TimeStamp.sql
  for stmt in `cat ./${DirectoryName}/Query.sql`
  do
    is_select=`echo ${stmt} | grep "^SELECT" | wc -l`
    if [ ${is_select} -ne 0 ]
    then
      echo ${stmt} >> ./$DirectoryName/SELECTQuery_$TimeStamp.sql
    else
      echo ${stmt} >> ./$DirectoryName/UPDATEQuery_$TimeStamp.sql
    fi
  done
done

1LK81JVDE2HRNDG
3
0
1LMXTJJD0W28TX2
3
0
1LS1XJGDEVWAC5T
7
1

-rw-rw-r--   1 atlvivd  dvlpmnt     2214 Mar 26 15:46 Query.sql
-rw-rw-r--   1 atlvivd  dvlpmnt        0 Mar 26 15:46 SELECTQuery_20120326154525.sql
-rw-rw-r--   1 atlvivd  dvlpmnt     6078 Mar 26 15:46 UPDATEQuery_20120326154525.sql

 /p2k/L10.21A/devlp/root/global/data/usage/DAILY> echo echo  \ $DB_USER_NAME |ksh
secadmin
 /p2k/L10.21A/devlp/root/global/data/usage/DAILY> echo echo \  $DB_PASSWORD | ksh
vivadmin
 /p2k/L10.21A/devlp/root/global/data/usage/DAILY> echo echo \ $TWO_TASK|ksh
ltd121a

ModifyUsgAuditGroupTable.ksh 120318
********Started processing at 20120327024927**********
 log file path is : ./AuditGroupLogs_20120327024927/AuditUpdate_20120327024927.LOG
1LK81JVDE2HRNDG
3
0

SQL*Plus: Release 10.2.0.4.0 - Production

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Usage 1: sqlplus -H | -V

    -H             Displays the SQL*Plus version and the
                   usage help.
    -V             Displays the SQL*Plus version.

Usage 2: sqlplus [ [<option>] [<logon>] [<start>] ]

  <option> is: [-C <version>] [-L] [-M "<options>"] [-R <level>] [-S]

    -C <version>   Sets the compatibility of affected commands to the
                   version specified by <version>.  The version has
                   the form "x.y[.z]".  For example, -C 10.2.0
    -L             Attempts to log on just once, instead of
                   reprompting on error.
    -M "<options>" Sets automatic HTML markup of output.  The options
                   have the form:
                   HTML [ON|OFF] [HEAD text] [BODY text] [TABLE text]
                   [ENTMAP {ON|OFF}] [SPOOL {ON|OFF}] [PRE[FORMAT] {ON|OFF}]
    -R <level>     Sets restricted mode to disable SQL*Plus commands
                   that interact with the file system.  The level can
                   be 1, 2 or 3.  The most restrictive is -R 3 which
                   disables all user commands interacting with the
                   file system.
    -S             Sets silent mode which suppresses the display of
                   the SQL*Plus banner, prompts, and echoing of
                   commands.

  <logon> is: (<username>[/<password>][@<connect_identifier>] | /)
              [AS SYSDBA | AS SYSOPER] | /NOLOG

    Specifies the database account username, password and connect
    identifier for the database connection.  Without a connect
    identifier, SQL*Plus connects to the default database.

    The AS SYSDBA and AS SYSOPER options are database administration
    privileges.

    The /NOLOG option starts SQL*Plus without connecting to a
    database.

  <start> is: @<URL>|<filename>[.<ext>] [<parameter> ...]

    Runs the specified SQL*Plus script from a web server (URL) or the
    local file system (filename.ext) with specified parameters that
    will be assigned to substitution variables in the script.

When SQL*Plus starts, and after CONNECT commands, the site profile
(e.g. $ORACLE_HOME/sqlplus/admin/glogin.sql) and the user profile
(e.g. login.sql in the working directory) are run.  The files may
contain SQL*Plus commands.

Refer to the SQL*Plus User's Guide and Reference for more information.

nawk '{{print $1,$2,$3}}'  ./$DirectoryName/AuditGroupTableTableData_$TimeStamp.txt | while read a b c
do
echo $a
echo $b 
echo $c
sqlplus  $db_user/$db_pwd@$db_sid  $a $b $c <<EOF

SET HEADING OFF
SET SERVEROUTPUT ON
SET FEEDBACK OFF
DECLARE
CNT  NUMBER(5);
DROPCNT NUMBER(5);
ERRORCNT NUMBER(5);
BEGIN
SELECT COUNT(*) INTO CNT FROM USAGE_INTRNL_ERROR WHERE AUDIT_GROUP_ID='&1';

IF ( CNT != &3) THEN
  SELECT INTRL_DROP_QTY,INTRL_ERROR_QTY INTO DROPCNT,ERRORCNT 
     FROM USAGE_AUDIT_GROUP WHERE AUDIT_GROUP_NBR='&1'; 

     DROPCNT :=DROPCNT-CNT;

     UPDATE USAGE_AUDIT_GROUP 
      SET INTRL_DROP_QTY='DROPCNT' ,INTRL_ERROR_QTY='CNT'  
      WHERE  AUDIT_GROUP_NBR='&1' ;
COMMIT;

END IF;
END;
EXIT;
EOF
done