Tuesday, April 12, 2011

All About Unix Shell Scripts

Execute sql fom unix.ksh to find unusable object

Copy or create a sql script and place it on Unix server.
 “unusable_objects.sql”

spool unusable.txt
set pagesize 2000
set linesize 200
set recsep off
set heading off
select 'UNUSABLE OBJECT' from dual;
select owner,index_name,status from all_indexes where status='UNUSABLE';
select 'VALID OBJECT' from dual;
select count(*) from all_indexes where status='VALID';
set heading on
spool off
exit;

Copy or create a Shell Script and place it on Unix server.
“findunusableobject.sh“

#/bin/ksh
rm -rf unusable.txt
sqlplus -s sbx01esb/sbx01esb@pocesb @unusable_objects.sql
mailx -s "test" -r "sumitest" my_mal@gmail.com< unusable.txt
#rm -rf unusable.txt
exit

To convert .cert to .truststore

-Executed the below command

set KEY_CMD="C:\j2sdk1.4.2_13\jre\bin\keytool"
%KEY_CMD% -import -v -trustcacerts -alias tst01-soaf.f5 -file dev02-soaf.am.health.ge.com.cer -keystore client.truststore -keypass XXXXXX -storepass XXXXXX

# JKS and Cer - certificate installation

1) keytool -v -genkey -keyalg RSA -keysize 1024 -keystore /home/soauser/Certificate/newjks.jks -storepass serverpass -alias server1 -keypass server

2) keytool -import -noprompt -trustcacerts -keystore /home/soauser/Certificate/newjks.jks -storepass serverpass -alias {7295d7bc-272b-4d81-9d84-f9655d4f94af} -file /home/soauser/Certificate/Newcer.cer

3) keytool -list -keystore /home/soauser/Certificate/newjks.jks -storepass serverpass

No comments:

Post a Comment