Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • create a folder in multiple places Linux/Unix
  • ext#.sql Oracle
  • find checksum of a file. Linux/Unix
  • Read CSV File using Python Python/PySpark
  • purge_trc.sh Linux/Unix
  • find_string_in_database.sql Oracle
  • True Session Wait Activity in Oracle 10g Verygood Oracle
  • Restoring a user’s original password 1051962.101 Oracle
  • Another export with Query Oracle
  • GSQ.sql Oracle
  • Implementing Listener Security Oracle
  • CTAS with LONG Column for 7.x and 8 and 8i Oracle
  • Locally Managed Tablespace and Dictionary managed tablespace (LMT-DMT) Oracle
  • To Find Orphan OS processes. Linux/Unix
  • pvm_rbs1.sql (to collect rbs info from db) Oracle

Category: shell

Generate SSH without password authentication.

Posted on 14-Jun-2006 By Admin No Comments on Generate SSH without password authentication.

*******************************************************************************************Step by Step Implementation of key based authentications from Source A to Destination B. ******************************************************************************************* (1) At source A (1-A) Generate a Key ssh-keygen -t dsa Sampe Output posdbprod21->CIF@(/export/home/oracle/paresh)ssh-keygen -t dsa Generating public/private dsa key pair. Enter file in which to save the key (/export/home/oracle/.ssh/id_dsa): Enter passphrase (empty for no passphrase): Enter same passphrase again:…

Read More “Generate SSH without password authentication.” »

Linux/Unix, shell

How to find Unix server conguraiton including Server Model number and underlying disk sub-system ( On Solaris)

Posted on 12-Jun-2006 By Admin No Comments on How to find Unix server conguraiton including Server Model number and underlying disk sub-system ( On Solaris)

$ /usr/platform/sun4u/sbin/prtdiag System Configuration: Sun Microsystems sun4u 8-slot Sun Enterprise E4500/E5500 System clock frequency: 100 MHz Memory size: 10240Mb ========================= CPUs ========================= Run Ecache CPU CPU Brd CPU Module MHz MB Impl. Mask — — ——- —– —— —— —- 0 0 0 400 8.0 US-II 1.0 0 1 1 400 8.0 US-II 1.0 2…

Read More “How to find Unix server conguraiton including Server Model number and underlying disk sub-system ( On Solaris)” »

Linux/Unix, shell

catting.sh

Posted on 07-Jun-200602-Jun-2023 By Admin No Comments on catting.sh

This is the script used for merging multiple text files in single large text(ASCII) file. for i in `ls *sql *sh` { echo “****************************************************” >> myfile echo File Name : $i >> myfile echo “****************************************************” >> myfile cat $i >> myfile echo ” ” >> myfile }

Linux/Unix, shell

copying/removing directory with all its subdirectory

Posted on 24-May-2006 By Admin No Comments on copying/removing directory with all its subdirectory

copying/removing directory with all its subdirectory use -r flag for recursive copy (cp) or remove (rm). use -f flag for forcefully. I used “rm -fr dir_name” and “cp -r src_dir dest_dir”.

Linux/Unix, shell

catall.sh

Posted on 06-Apr-2006 By Admin No Comments on catall.sh

#!/bin/ksh for fname in `ls` do print “”; print “/* File Name : $fname */”; print “”; cat $fname done

Linux/Unix, shell

Single character replacement in Unix

Posted on 08-Mar-2006 By Admin No Comments on Single character replacement in Unix

uocdbprod21->WEBARCH@(/db2/oradata)ls -rlt /db?/oradata/WEBP18F /db6/oradata/WEBP18F: total 0 /db5/oradata/WEBP18F: total 0 /db3/oradata/WEBP18F: total 0 /db4/oradata/WEBP18F: total 0 /db2/oradata/WEBP18F: total 0 uocdbprod21->WEBARCH@(/db2/oradata)

Linux/Unix, shell

age_alert.ksh aging out alert.log

Posted on 28-Feb-2006 By Admin No Comments on age_alert.ksh aging out alert.log

!/bin/ksh . /export/home/oracle/envs/oracle_env_PNETP save_date=`date +%Y%m%d%H%M` # Set ORATAB variable if [ -f /etc/oratab ] ; then ORATAB=/etc/oratab else if [ -f /var/opt/oracle/oratab ] ; then ORATAB=/var/opt/oracle/oratab else echo “” echo “`date` Cannot find oratab!” echo “” exit 2 fi fi export ORATAB # search the alert log for errors for all databases # for ORACLE_SID…

Read More “age_alert.ksh aging out alert.log” »

Linux/Unix, shell

avail.sh ( find filesystem spae usage)

Posted on 23-Feb-2006 By Admin No Comments on avail.sh ( find filesystem spae usage)

df -k | grep -i “/EMCdb”|awk ‘{tot += $2; used += $3; avail += $4;} END {print “Total”,tot/1024/1024,”Used “,used/1024/1024,”Avail “avail/102 4/1024, “Avail % ” avail*100/tot, “Used % ” used*100/tot}’ df -k | grep -i “/testdb”|awk ‘{tot += $2; used += $3; avail += $4;} END {print “Total”,tot/1024/1024,”Used “,used/1024/1024,”Avail “avail/10 24/1024, “Avail % ” avail*100/tot, “Used…

Read More “avail.sh ( find filesystem spae usage)” »

Linux/Unix, shell

Directory wise folder wise space usage

Posted on 07-Feb-2006 By Admin No Comments on Directory wise folder wise space usage

find . -type d -exec du -sk {} ;

Linux/Unix, shell

Korn Shell Arithmatic

Posted on 23-Jan-2006 By Admin No Comments on Korn Shell Arithmatic

Method 1 ======== One more way of adding two numbers. Which one to use depends on which shell it is. d=400 e=52 f=`expr $d + $e` print $f Method 2 ======== #!/usr/bin/ksh let a=$1 let b=$2 let c=a+b print $c

Linux/Unix, shell

Posts pagination

Previous 1 … 10 11 12 … 15 Next

Categories

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

Recent Posts

  • 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
  • SQL Server Vs Oracle Architecture difference25-Jul-2025
  • SQL Server: How to see historical transactions25-Jul-2025
  • SQL Server: How to see current transactions or requests25-Jul-2025
  • T-SQL Vs PL/SQL Syntax25-Jul-2025
  • Check SQL Server edition25-Jul-2025
  • Checking SQL Server Version25-Jul-2025
  • Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • All Hints for Oracle Databases Oracle
  • Virtual Indexes in Oracle Oracle
  • get_aix_vmstat.ksh Oracle
  • Order by with ROWNUM Oracle
  • cur_sql.sql Oracle
  • segment_wise_space.sql segspace.sql Segment wise space usage (allocated and used) Oracle
  • Locktree.sql Oracle
  • Search and replace pattern Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme