Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • how to find OS block size Oracle
  • changing kernel parameter in Oracle Enterpise Linux Linux/Unix
  • move_arch_files.ksh Linux/Unix
  • dbms_job.submit example Oracle
  • Good links for x$ tables in oracle. Oracle
  • DBMS_Shared_pool pinning triggers Oracle
  • moving lob object to other tablespace lob_mvmt.sql Oracle
  • ORA-01220 Oracle
  • findx.sql /* Find Indexes on specified USER.TABLE_NAME */ Oracle
  • crontab syntax Linux/Unix
  • ENQ: KO – FAST OBJECT CHECKPOINT tips Oracle
  • Find Stale DR Physical Standby Oracle
  • Changing default shell Linux/Unix
  • Good link for LIO in Oracle ( Logical IOs) Oracle
  • Temporary Tablespsace Temp tablespace behaviour 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)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (393)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (0)
  • 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

  • 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
  • V$INSTANCE of Oracle in MYSQL24-Jul-2025
  • Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Small sample shell program Linux/Unix
  • How does one overcome the Unix 2 Gig file limit? Linux/Unix
  • findobj.sql Oracle
  • Running select from V$ views from remote server Linux/Unix
  • Unix command for system configuration Linux/Unix
  • Oracle Statspack survival Guide Oracle
  • CTAS with LONG Column for 9i and higher Oracle
  • Sample WW22 listener.ora Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme