Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • DBMS_UTILITY PACKAGE Oracle
  • SQL_PROFILE – I explaination Oracle
  • longtx.sql Oracle
  • How to sort list of files on basis of their sizes. Linux/Unix
  • Kernel Parameters for Solaris Linux/Unix
  • move_arch_files.ksh Linux/Unix
  • 276434.1 Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node Oracle
  • Wait time tuning research Oracle
  • Remove DOS CR/LFs (^M) Linux/Unix
  • Very clear article about oracle dataguard Oracle
  • Import and export statements Oracle
  • runsql_once.ksh Linux/Unix
  • sess1.sql Oracle
  • track_autoupgrade_copy_progress.sql Oracle
  • How to check current redo log progress redo_progress.sql Oracle

Category: Linux/Unix

rm_backup_arch_file.ksh

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

DESTFOLDER=/uocdb7/archlog/UAS LOGFILE=/oracle/scripts/log/rm_backup_arch_uas.log NOTIFY_LIST=’dbaoracle@1800flowers.com’ NODENAME=`hostname` ORACLE_SID=UAS SCRIPT_NAME=rm_backup_arch_file.ksh

Linux/Unix, shell

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

  • AMC10 (0)
  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (150)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (151)
  • SQL scripts (349)
  • SQL Server (6)
  • Uncategorized (9)
  • Videos (0)

Recent Posts

  • Tutornet.US — Source of excellent learning14-Oct-2026
  • OCI Infrastructure Patching14-Oct-2026
  • Free API credits for AI models14-Oct-2026
  • AMC1020-Sep-2026
  • 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.sh23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • export import with parameter file. Oracle
  • Day to day MYSQL DBA operations (Compared with Oracle DBA) MYSQL
  • sqlnet.ora paramters Oracle
  • DBMS_STATS Metalinks Notes Oracle
  • Add new columns in dataframe Python/PySpark
  • Generate SSH without password authentication. Linux/Unix
  • Database link password in user_db_links Oracle
  • chk_space_SID.ksh Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme