Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • SQL Server Vs Oracle Architecture difference SQL Server
  • send email from unix mailx with attachment. Linux/Unix
  • useful dg links Oracle
  • Giving Grant on v$DATABASE Oracle
  • Transfer SQL Profiles from One database to other database. Oracle
  • telnet listening Linux/Unix
  • DBA_HIST_SQLSTAT contents Oracle
  • Specify the Rollback segment to use in Transaction Oracle
  • How to sort list of files on basis of their sizes. Linux/Unix
  • before_trunc.sql Before Truncate table needs to execute following: Oracle
  • move_arch_files.ksh Linux/Unix
  • dbms_job.submit example Oracle
  • create a folder in multiple places Linux/Unix
  • S3 Basic info AWS
  • How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven) Oracle

Category: Linux/Unix

rm_backup_arch_file.ksh

Posted on 02-Aug-2005 By Admin No Comments on rm_backup_arch_file.ksh

a=`ps -ef|grep $SCRIPT_NAME|grep -v grep|wc -l` if [ $a -gt 2 ] then echo “Exiting because of more than 1 Moving archive log script is running ” >>$LOGFILE exit fi cd $DESTFOLDER b=0 buffersize=85 currentdskspce=`df -k $DESTFOLDER|tail -1 |awk {‘print $5’}| sed ‘s/%//g’` echo “This $DESTFOLDER files removal script was executed on `date`” >>$LOGFILE while…

Read More “rm_backup_arch_file.ksh” »

Linux/Unix, shell

purge_trc.sh

Posted on 02-Aug-2005 By Admin No Comments on purge_trc.sh

#!/bin/sh . /oracle/oraprocs/oracle_env_10g_UAS ORACLE_HOME=/oracle/app/oracle/product/10.1;export ORACLE_HOME ORACLE_SID=UAS;export ORACLE_SID find $UDUMP/*.trc -mtime +15 -exec rm {} ; find $BDUMP/*.trc -mtime +15 -exec rm {} ; find $CDUMP/*.trc -mtime +15 -exec rm {} ;

Linux/Unix, shell

cif crons

Posted on 01-Aug-2005 By Admin No Comments on cif crons

01 * * * * /export/home/oracle/scripts/move_arch_files_uoc.ksh > /export/home/oracle/scripts/log/move_arch_files_uoc.log 2> /export/home/oracle/scrip ts/log/move_arch_files_uoc.err 10 * * * * /export/home/oracle/scripts/move_arch_files_cif.ksh > /export/home/oracle/scripts/log/move_arch_files_cif.log 2> /export/home/oracle/scrip ts/log/move_arch_files_cif.err 05,20,35,50 * * * * /export/home/oracle/scripts/switchlogfile_UOC.sh > /export/home/oracle/scripts/log/switchlogfile_UOC.log 2> /export/home/oracle/s cripts/log/switchlogfile_UOC.err 10,25,40,55 * * * * /export/home/oracle/scripts/switchlogfile_CIF.sh > /export/home/oracle/scripts/log/switchlogfile_CIF.log 2> /export/home/oracle/s cripts/log/switchlogfile_CIF.err 0 6 * * * /export/home/oracle/scripts/purge_trc_UOC.sh >> /export/home/oracle/scripts/log/purge_trc_UOC.log 2>> /export/home/oracle/scripts/log/purge_trc_UOC.err 0…

Read More “cif crons” »

Linux/Unix, shell

Paste command syntax

Posted on 29-Jul-2005 By Admin No Comments on Paste command syntax

paste file1 file2 > out1 Above command will paste file1 with line by line setting from file2 amd stores output on out1 file.

Linux/Unix, shell

switchlogfile.sh

Posted on 29-Jul-2005 By Admin No Comments on switchlogfile.sh

#!/bin/sh . /export/home/oracle/oraprocs/oracle_env_10g_CIF ORACLE_HOME=/oracle/app/oracle/product/10.1;export ORACLE_HOME ORACLE_SID=CIF;export ORACLE_SID $ORACLE_HOME/bin/sqlplus

Linux/Unix, shell

For Search and replace unix command.

Posted on 29-Jul-2005 By Admin No Comments on For Search and replace unix command.

To remove any text becore patterrn “pvm” in all lines of file, you need to apply following vi editor command. %s/^.*pvm/pvm/g 🙂 “.” represend any single chanracter occurance.

Linux/Unix, shell

Search and Replace vi editor command.

Posted on 29-Jul-2005 By Admin No Comments on Search and Replace vi editor command.

Changing Case To change all the lower case characters to UPPER case characters, starting from the current line, and going for 5 lines, type :s/^.*$/U&/5 To change from UPPER to lower, type :s/^.*$/L&/5 Deleting characters To delete the first 5 characters off of every line in the current file, type :%s/^…..//g

Linux/Unix, shell

Jai Shree Ram

Posted on 29-Jul-2005 By Admin No Comments on Jai Shree Ram

God Bless All………..

Linux/Unix, shell

Jai Shree Ram

Posted on 29-Jul-2005 By Admin No Comments on Jai Shree Ram

God Bless All………..

Linux/Unix, shell

Posts pagination

Previous 1 … 14 15

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (397)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (150)
  • SQL scripts (345)
  • SQL Server (6)
  • Uncategorized (3)
  • Videos (0)

Recent Posts

  • Hello08-Apr-2026
  • Hello07-Apr-2026
  • Test107-Apr-2026
  • track_autoupgrade_copy_progress.sql01-Apr-2026
  • refre.sql for multitenant01-Apr-2026
  • prepfiles.sh for step by step generating pending statistics files10-Mar-2026
  • tracksqltime.sql05-Mar-2026
  • Complete Git Tutorial for Beginners25-Dec-2025
  • Postgres DB user and OS user.25-Dec-2025
  • Trace a SQL session from another session using ORADEBUG30-Sep-2025

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Distributed Transaction Troubleshooting. Oracle
  • Does DBMS_JOB recompute the NEXT_DATE interval after or before Oracle
  • Oracle Data Direct to TAPE Oracle
  • Nice Article about semaphores and init.ora Processes parameter relations Linux/Unix
  • Reading config file from other folder inside class Python/PySpark
  • Absolute file number and relative file number Oracle
  • Flowers Resize datafiles Oracle
  • Rollback force for distributed transactions Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme