Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • How to collect CPU usage on Linux using Shell script Linux/Unix
  • fkwoind.sql fkwoindex.sql Oracle
  • Optimizer SORT Operations Oracle
  • CPU Core related projections AWS
  • handling filenname with space Linux/Unix
  • Rman Notes -1 Oracle
  • db_status.sql Oracle
  • Rownum with Order by Oracle
  • Standby Database File Management in 10g with STANDBY_FILE_MANAGEMENT Oracle
  • Oracle 11g RAC on OEL 5 and Vmware 2 Oracle
  • Sort with ASCII order and Numeric Order Linux/Unix
  • Adding addidional hard drive and attach it to a linux box. Linux/Unix
  • How to find pinned objects from shared pool. (pinned via dbms_shared_pool.keep) Oracle
  • To check whether standby is recovering properly or not?? Oracle
  • Implementing Listener Security Oracle

Category: shell

How to change hostname in Linux

Posted on 09-Apr-2008 By Admin No Comments on How to change hostname in Linux

=> Edit file /etc/sysconfig/network using your favourite editor. => Look for HOSTNAME=xxxxxx => Change the xxxx to the name you wish to set for your computer. (ex: HOSTNAME=techiecorner.com) => Save the file and restart the server.

Linux/Unix, shell

good linux notes

Posted on 09-Apr-2008 By Admin No Comments on good linux notes

http://tldp.org/HOWTO/Partition/intro.html

Linux/Unix, shell

fdisk -l explaination about Primary-Logical-Extended Partitions

Posted on 06-Apr-2008 By Admin No Comments on fdisk -l explaination about Primary-Logical-Extended Partitions

# fdisk -l Disk /dev/hda: 240 heads, 63 sectors, 1940 cylinders Units = cylinders of 15120 * 512 bytes Device Boot Start End Blocks Id System /dev/hda 1 286 2162128+ c Win95 FAT32 (LBA) /dev/hda2 * 288 1940 12496680 5 Extended /dev/hda5 288 289 15088+ 83 Linux /dev/hda6 290 844 4195768+ 83 Linux /dev/hda7 845…

Read More “fdisk -l explaination about Primary-Logical-Extended Partitions” »

Linux/Unix, shell

find the files that are 1 day old.

Posted on 15-Feb-2008 By Admin No Comments on find the files that are 1 day old.

find . -name “*” -type f -mtime -1 -exec ls -rlt {} ;

Linux/Unix, shell

on IBM-AIX for display

Posted on 08-Jan-2008 By Admin No Comments on on IBM-AIX for display

On IBM-AIX, vi was not working properly. Then set the environment variable as following and it started working. ( Thanks Magesh for same). $ export TERM=vt100 $

Linux/Unix, shell

Unix split command to split files

Posted on 28-Dec-2007 By Admin No Comments on Unix split command to split files

split -20 source_filename.lst test1 Above command will split source_filename.lst with every 20 lines. Will create files with 20 lines and with following names. -rw-r–r– 1 oracle dba 41 Dec 28 11:53 test1ag -rw-r–r– 1 oracle dba 2127 Dec 28 11:53 test1af -rw-r–r– 1 oracle dba 2240 Dec 28 11:53 test1ae -rw-r–r– 1 oracle dba 2243…

Read More “Unix split command to split files” »

Linux/Unix, shell

to see when crontab is changed.

Posted on 19-Dec-2007 By Admin No Comments on to see when crontab is changed.

sunflower1/800P>ls -rlt /var/spool/cron/crontabs total 138 -r——– 1 root root 452 Jan 21 2005 lp -rw——- 1 root sys 308 Nov 9 2006 sys -rw——- 1 root sys 317 Aug 20 18:51 adm -rw——- 1 root staff 5605 Oct 9 10:09 bbxuser -rw——- 1 root staff 5126 Oct 9 10:13 bkgr -rw——- 1 root staff 457…

Read More “to see when crontab is changed.” »

Linux/Unix, shell

adding new line after specific pattern using sed

Posted on 09-Nov-2007 By Admin No Comments on adding new line after specific pattern using sed

$cat t1.sql | sed ‘s/ORDER_DETAILS/ This is added newly/g’

Linux/Unix, shell

Search and replace pattern

Posted on 07-Nov-2007 By Admin No Comments on Search and replace pattern

#!/bin/ksh file_name=$1 old_templet=$2 new_templet=$3 # Loop through every file like this for file in file_name do cat $file | sed “s/old_templet/new_templet/g” > $file.new #do a global searce and replace and put the results mv $file.new $file #rename $file.new to original name of file done If you want to replace single pattern with a new pattern…

Read More “Search and replace pattern” »

Linux/Unix, shell

create a folder in multiple places

Posted on 31-Oct-2007 By Admin No Comments on create a folder in multiple places

for i in `df -k | grep EMCdb | awk ‘{print $6}’` do mkdir -p $i/oradata/800P done

Linux/Unix, shell

Posts pagination

Previous 1 … 6 7 8 … 15 Next

Categories

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

Recent Posts

  • find_arc.sql09-Apr-2026
  • pvm_pre_change.sql08-Apr-2026
  • find_encr_wallet.sql08-Apr-2026
  • find_pdbs.sql08-Apr-2026
  • Creating a Container Database using dbaascli08-Apr-2026
  • track_autoupgrade_copy_progress.sql01-Apr-2026
  • refre.sql for multitenant01-Apr-2026
  • prepfiles.sh for step by step generating pending statistics files10-Mar-2026
  • tracksqltime.sql05-Mar-2026
  • Complete Git Tutorial for Beginners25-Dec-2025

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • How to stop OCSSD Daemon Oracle
  • Search and replace pattern Linux/Unix
  • Query to Generate aggregate on every 30 mins. Oracle
  • get_ratio.sql get the ratio of users from v$session and this uses CASE-WHEN-THEN clause Oracle
  • exp syntax in oracle 10g Oracle
  • Pending Distributed Transations Oracle
  • sess_server.sql Oracle
  • Jai Shree Ram Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme