Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Passing from Unix to PLSQL using bind variables Linux/Unix
  • ORACLE_SID in sqlplus Oracle
  • How to change hostname in Linux Linux/Unix
  • Jai Shree Ram Oracle
  • How to sort list of files on basis of their sizes. Linux/Unix
  • Remove DOS CR/LFs (^M) Linux/Unix
  • When to rebuld B-tree index Oracle
  • Add new columns in dataframe Python/PySpark
  • dbms_job.submit example Oracle
  • DETERMINING WHICH INSTANCE OWNS WHICH SHARED MEMORY & SEMAPHORE SEGMENTS Oracle
  • newupload.html PHP/MYSQL/Wordpress
  • v$backup.status information Oracle
  • Find all users who have DML privileges Oracle
  • pvm_pre_change.sql Oracle
  • find_pdbs.sql Uncategorized

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 (402)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (150)
  • SQL scripts (350)
  • SQL Server (6)
  • Uncategorized (5)
  • Videos (0)

Recent Posts

  • 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.sql23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026
  • 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

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • create user with unlimited quota Oracle
  • pvm_metric.sql for gathering report from vmstat tables Oracle
  • send attachment from unix-shell script Linux/Unix
  • Oracle 11g RAC on OEL 5 and Vmware 2 Oracle
  • import-export with multiple files Oracle
  • good note for shared pool tunnig Oracle
  • Good link for LIO in Oracle ( Logical IOs) Oracle
  • .profile Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme