AppWorx, Dollar Universe and Sysload Community

  • 1.  Banner 9 and Oracle Wallet

    Posted Mar 09, 2018 12:44 PM

    Banner 9 and Oracle Wallet

    Job submission in Banner 9 uses the Oracle wallet.  Oracle wallet uses a proxy to submit a job.  It will put a bracket around the username and it replaces the password.  User's will not be able to view their output on capture jobs using oracle wallet. This is because it creates a:  {user name} user account that the job run under to accommodate the changes associated with Oracle Wallet.

    An enhancement request has been submitted to remove the {} for users when banner jobs are captured in Applications Manager. 

    Please use the link below to login in and vote this request.

    Banner 9 and Oracle Wallet



  • 2.  Re: Banner 9 and Oracle Wallet

    Posted Oct 26, 2018 08:32 AM

    At UNCG I have developed a way to remove the brackets before job capture and then adding the brackets back before the job runs.  I have modified GJAJOBS to do this.  This modification works when the user has the jobsub proxy or does not.  Also AppMgr is running on Linux at UNCG.

     

    IN GJAJOBS make changes as follows:

     

    if [ "$UC4" != "true" ]
    then
      if [ "$UC4capture" = "true" ]
      then
         # UNCG Oracle Wallet Mod
          USER_CHECK="`echo $3 | grep '\['`"
           if [ ! -z "$USER_CHECK" ]; then
            USER="`echo $3|cut -f2- -d[ |cut -f1 -d] `"    
            echo "captured" >> $SQLOPER_HOME/out/${1}_${5}.CAPTURE
          else
            USER=$3  
          fi  
         #call capture script to see if job should be captured
        # UNCG Oracle Wallet Mod
        #$captureDir/jobcapture.shl $1 $2 $3 $4 $5 $6 $7 $8
        $captureDir/jobcapture.shl $1 $2 $USER $4 $5 $6 $7 $8
        ret=$?

     

          #if ret is 0 job was captured successfully
          #else don't exit and run it
        if [ $ret -eq  0 ]
        then
          exit 0
        fi
      fi
    fi

    .

    .

    .

    #start gjajobs.shl
    #
    # UNCG Oracle Wallet Mod
    if [ -f $SQLOPER_HOME/out/${1}_${5}.CAPTURE ]; then
      USER="["$3"]"
      echo "******Capture File Found*******"
      rm $SQLOPER_HOME/out/${1}_${5}.CAPTURE
    else
      echo "******No File*******"
      USER=$3  
    fi

     

    Then replace $3 with $USER where $3 is found in GJAJOBS.