...:::SUDHIR:::...: July 2012

---------------------------------------------------------
Run App Engine in Unix

export PS_DBNAME=QNYPSGL5
export PS_HOME=/app/psfinancials/848
export PS_SERVDIR=/app/psfinancials/848/appserv
export TUXCONFIG=${PS_HOME}/appserv/prcs/${PS_DBNAME}/PSTUXCFG
export PS_SERVER_CFG=${PS_HOME}/appserv/prcs/${PS_DBNAME}/psprcs.cfg ( make sure this file exists)
export PS_SETUP=${PS_HOME}/setup/cs

psae -CT ORACLE -CD ${PS_DBNAME} -CO SITEAMID -CP PASSWORD12 -R TEST -AI VERSION
---------------------------------------------------------

PeopleSoft password expired in a database environment
---------------------------------------------------------

1. Login to the database environment using sqlplus.
sqlplus <user_id>/<password>@<database_environment>

2. Run the sql command to return the date at which password was changed last.
SQL> select oprid, acctlock, LASTPSWDCHANGE from psoprdefn where oprid='SITEAMID';

OPRID ACCTLOCK LASTPSWDC
------------------------------ ---------- ---------
SITEAMID 0 28-APR-10

3. If the date is too old, then the password has expired.

4. Update the LASTPSWDCHANGE field to the latest date.

SQL> update psoprdefn set LASTPSWDCHANGE='15-FEB-11' where oprid='SITEAMID';

5 row updated.

6. Verify that the date has been updated and then commit the change.

SQL> select oprid, acctlock, LASTPSWDCHANGE from psoprdefn where oprid='SITEAMID';

OPRID ACCTLOCK LASTPSWDC
------------------------------ ---------- ---------
SITEAMID 0 15-FEB-11

SQL> commit;

Commit complete
---------------------------------------------------------
User Creation:

CREATE USER <USER_NAME> IDENTIFIED BY <PASSWORD>
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK
PASSWORD EXPIRE
---------------------------------------------------------

Select statements:

SQL> select OPRID,ACCTLOCK,OPERPSWD from psoprdefn where OPRID='PSAPPS';
SQL> select oprid,operpswd,acctlock from psoprdefn where oprid='VP1';
SQL> select username,account_status from dba_users where username='PSOFT';
grant delete,update,insert,select on PS_FB_BALEXTRP_US_BKP to PSUSER;

SQL>select ACCTLOCK from psoprdefn where OPRID='BATCH';
select OPERPSWD from psoprdefn where OPRID='BATCH';
alter user BATCH identified by caic0s;
update psoprdefn set operpswd = 'caic0s' where oprid = 'BATCH';
update PSOPRDEFN set OPERPSWD = 'caic0s', ENCRYPTED = 0 where OPRID = 'BATCH';
encrypt_password BATCH;

update DISTNODENAME = 'QNYPGL10' from PS_CDM_DIST_NODE;
select DISTNODENAME from PS_CDM_DIST_NODE;
update PS_CDM_DIST_NODE set DISTNODENAME = 'QNYPGL10';

export ORACLE_HOME=/app/oracle.11.1.0.7
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

# Export Security Tables: PSACCESSPRFL, PSOPRDEFN, PSOPRALIAS, PSROLEUSER

create or replace public synonym PS_CSG_GAD_TMP_PRE1 for sysadm.PS_CSG_GAD_TMP_PRE1

create user G538196 identified by G538196;
GRANT OLAP_SECURE_DRO TO G538196;
GRANT SYSADM_DRO TO G538196;
GRANT DAC_DRO TO G538196;
GRANT SNQSCHED_DRO TO G538196;

SQL> select * from dba_role_privs where grantee like 'M911194';
ALTER INDEX PS_FB_JR2011_ZHBAL NOPARALLEL LOGGING

( TUXDIR=/ apps/bea/tuxedo/9.1/; export TUXDIR )tuxedo dir

http://beej.us/guide/bgipc/output/html/multipage/semaphores.html - (Semaphores, file locking & locking mechanisms)

---------------------------------------------------------
Recompilation required for PI COBOLs
---------------------------------------------------------
bash-3.00# export COBDIR=/app/microfocus/cobol
bash-3.00# export PATH=$PATH:/app/microfocus/cobol/bin
bash-3.00# export LD_LIBRARY_PATH=/app/microfocus/cobol/lib
bash-3.00# cd /app/microfocus/mflmf/; ./mflmman
---------------------------------------------------------

#get_email_address_fnc EM_PERF_RPT RECPT
RECPT="sudhir.ravindra@credit-suisse.com"
ATTACH1=/tmp/$$.ATTACH_MAT_VIEW.$$.csv
ATTACH2=/tmp/Monthly_Batch_Perf_Report.`date +%Y%m%d`.csv
ORA_SERV="$2"

MON_SQL=${SQL_TMP_DIR}/${ORA_SERV}_trigger_check_sql_$$.sql

STAMP="Calling perf_mon_fnc";log_stamp_fnc

perf_mon_fnc

DB Check SPOOL file: /app/psoft/setup/data/TNYPUA40/DB_CHECK.log

STAMP="End";log_stamp_fnc

netstat -an > test.txt --> finding port number

export DISPLAY=0.0
and used -i console
DISPLAY=<webserverip>:0.0
. setup.sh -i console

---------------------------------------------------------

find /tmp -user Sudhir (sort as per owner of the file)
find . -type f -name " "
find /app/ -name " " -print
find . -name set* | grep 6001 | - print
find . -size +150000 > log.txt
find . -mtime +10 -exec rm -rf {} \; (days)
find /opt/app/logs -name '*.log' -mtime +90 -exec rm {} \; (same directory has multiple type of files, and want to delete ONLY those with .log)
find /tmp -name '*.log' -mtime +30 -exec rm {} \;
find /tmp -name '*.log.1' -mtime +30 -exec rm {} \;
find . -name "*" -size +999999 -exec ls -ltr {} \;
find . -name "*" -exec grep -l "1995383" {} \; (to find an id in a file with in a folder)

------------------------------------------------------------------------------------------------------------
Find ten day old files

#/bin/ksh
echo "This script will put the names of ten day old files in /tmp in /tmp/checkold.txt file"
find /tmp -size 0 -atime +10 -exec ls -l {} \; > /tmp/checkold.txt
find /tmp -size 0 -atime +10 -exec rm -f {} \;

Find large files on System

---------
#!/bin/sh
# Script to find the big files on a disk. 
# Defaults and temporary info.
# This script send the output to a default printer
DiskName=${1:?Disk name not supplied.}
TMPFILE=/tmp/$LOGNAME.$$.txt
SysName=`uname -n`
 
echo \
        "Checking for large files on $SysName $DiskName.  " \
        "Output will be sent to default printer."
 
echo "\nNewer big files on $SysName $DiskName" >> $TMPFILE
find $DiskName -type f -mtime -3 -size +5000 -exec ls -ld {} \; \
        2>/dev/null | sort -n -k 5.1,5 >> $TMPFILE
 
echo "\nOlder big files on $SysName $DiskName" >> $TMPFILE
find $DiskName -type f -mtime +3 -size +5000 -exec ls -ld {} \; \
        2>/dev/null | sort -n -k 5.1,5 >> $TMPFILE
 
#change the following line if you want to put output to a file
#or anything.

lp -onb -olandscape $TMPFILE
rm $TMPFILE
 # End of script

Count files in directory (not hidden one's)

#!/bin/ksh
echo * | wc -w

Total Disk space in system in MB.

#!/bin/ksh
#This script will return the total disk space in system.
df -t | awk 'BEGIN {tot=0} $2 == "total" {tot=tot+$1} END {print (tot*512)/10000
00}'

Total used space in system in MB.

#!/bin/ksh
#This script tells total used space in a system
df | awk 'BEGIN {tot=0} {tot=tot+$4} END {print (tot*512)/1000000}'

Search for pattern in a file and return total count.

#!/bin/ksh
#This script  searchs the file passed as first argument to this command line and 
#prints total number found
grep $1 filename | awk 'BEGIN {tot=0} {tot=tot+$1} END {print (tot)}'

This command will find the core files with group name mycomp and delete them while also writing the name of deleted file in mycompcore.

#!/bin/ksh
find / -name core -group mycomp -print -exec rm -f {} \; >> mycompcore

...:::SUDHIR:::...

My help...

Find Commands

About Me