Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • how to find VIP from ifconfig Linux/Unix
  • cache buffer chain latch Oracle
  • Wait time tuning research Oracle
  • Restoring a user’s original password 1051962.101 Oracle
  • FRA Information. Oracle
  • TOP-N Sql to find Nth max or Top N rows Oracle
  • Alter procedure auditing Oracle
  • Free conference number from http://www.freeconference.com Oracle
  • Load testing on Oracle 19C RAC with HammerDB Oracle
  • Optimizer_Index init.ora parameter explaination. Oracle
  • Global Unique Identifier Generation in Oracle 9.2 SYS_GUID() Oracle
  • Very Good Oralce Internal Tuning Book Oracle
  • Giving Grant on v$DATABASE Oracle
  • find_pk.sql /* Find Primary Key */ Oracle
  • Virtual Indexes in Oracle 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 (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (150)
  • SQL scripts (350)
  • SQL Server (6)
  • Uncategorized (5)
  • Videos (0)

Recent Posts

  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • SAT Mathematics 10 questions and answer at the end.30-Apr-2026
  • top 10 AI news today30-Apr-2026
  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sql23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026
  • find_arc.sql09-Apr-2026
  • pvm_pre_change.sql08-Apr-2026
  • find_encr_wallet.sql08-Apr-2026
  • find_pdbs.sql08-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Processes parameter and its dependencies on OS kernel parameters Linux/Unix
  • DBMS_Shared_pool pinning triggers Oracle
  • Good RAC & Standby Notes Oracle
  • Oracle Data Direct to TAPE Oracle
  • OEM-troubleshooting on 20-MAY-08 Oracle
  • move_arch_files.ksh Linux/Unix
  • My Test Case On 21-OCT-2005 Oracle
  • SQL Server: How to see historical transactions SQL Server

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme