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