|
|
Need to pass Oracle SQL output to Linux and back... Help!
10-28-2014
# Section 1: Obtain list of user names from EBS
echo "
set echo off;
set heading off;
set feedback off;
set pagesize 3000;
set linesize 200;
set termout off
set trimout on;
set trimspool on;
spool $CLONING_LOG/ldap.txt
select user_name from fnd_user where user_id<>3304
and (END_DATE > SYSDATE or END_DATE is null)
and user_name <> 'ASADMIN'
order by user_name;
spool off
exit" > $CLONING_LOG/ldap.sql
sqlplus apps/$APPS_PASSWORD @$CLONING_LOG/ldap.sql
grep -v "^$" $CLONING_LOG/ldap.txt > $CLONING_LOG/ldap2.txt
mv $CLONING_LOG/ldap2.txt $CLONING_LOG/ldap.txt
# Section 2 obtain the orclguid from OID for these users
while read -r U
do
ldapsearch -h $OIDHOST -p $OIDPORT -w $OIDPWD "(sn=$U)" orclguid sn | awk 'NR==2,NR==3' | sed 's/^.*\=//' | xargs
done < $CLONING_LOG/ldap.txt | while IFS="=" read NAME
do
# Section 3 updating the GUID in EBS from OID
echo "Now Updating" $NAME
sqlplus -s apps/$APPS_PASSWORD @$CLONING_SCRIPTS/ebsclone_target_guid.sql $NAME
done
10-28-2014
# Section 1: Obtain list of user names from EBS
cat > $CLONING_LOG/ldap.sql <<EOF
set echo off;
set heading off;
set feedback off;
set pagesize 3000;
set linesize 200;
set termout off
set trimout on;
set trimspool on;
spool $CLONING_LOG/ldap.txt
select user_name from fnd_user where user_id<>3304
and (END_DATE > SYSDATE or END_DATE is null)
and user_name <> 'ASADMIN'
order by user_name;
spool off
exit
EOF
sqlplus apps/$APPS_PASSWORD @$CLONING_LOG/ldap.sql
# Section 2 obtain the orclguid from OID for these users
while read -r U
do
[ -z "$U" ] && continue # Skip blank lines
ldapsearch -h $OIDHOST -p $OIDPORT -w $OIDPWD "(sn=$U)" orclguid sn | awk -F"=" 'NR==2,NR==3 { print $2 }'
done < $CLONING_LOG/ldap.txt | xargs | while read NAME
do
# Section 3 updating the GUID in EBS from OID
echo "Now Updating" $NAME
sqlplus -s apps/$APPS_PASSWORD @$CLONING_SCRIPTS/ebsclone_target_guid.sql $NAME
done|
|
|
|