Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Rman Notes -1 Oracle
  • How to find where datafile is created dbf_info.sql Oracle
  • How to Modify the statistics collection by MMON for AWR repository Oracle
  • How to know Number of CPUs on Sun Box Linux/Unix
  • Monitor Long Running Job Oracle
  • Disbaling DBA_SCHEDULER_JOBS Oracle
  • rm_backup_arch_file.ksh Linux/Unix
  • sid_wise_sql.sql Oracle
  • create a folder in multiple places Linux/Unix
  • find_string_in_database.sql Oracle
  • Good Doc 28-JUN-2006 Oracle
  • CPU speed on Linux Linux/Unix
  • ORA-00064: object is too large to allocate on this O/S during startup Oracle
  • TRUNCATE table and disabling referential constraints. Oracle
  • Add new columns in dataframe Python/PySpark

Category: Linux/Unix

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
  • New Latest Param.sql for finding all hidden parameters also Oracle
  • Useful Solaris Commands on 28-SEP-2005 Linux/Unix
  • Jai Shree Ram Oracle
  • DBMS_Shared_pool pinning triggers Oracle
  • move_arch_files.ksh Linux/Unix
  • sql_doing_fts.sql Oracle
  • on IBM-AIX for display Linux/Unix
  • Reclaim temp tablespace for oracle 8, 8i Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme