Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • metalink all dynamic view reference notes. Oracle
  • Mutating Table Error while using database trigger Oracle
  • Oracle 10g for solaris 10 Oracle
  • Goog notes on X$ tables Oracle
  • USER_TABLES.Freelists Oracle
  • Directory wise folder wise space usage Linux/Unix
  • Removing Blank lines from file using grep Linux/Unix
  • GSQ.sql Oracle
  • column level grant syntax Oracle
  • Exadata Basics Oracle
  • check_copy_progress.sh Linux/Unix
  • New OFA for 11g Oracle
  • On solaris 10, “S” link is not part of $ORACLE_HOME/bin/oracle as default. ( For 9.2.0.8) Oracle
  • Postgres DB user and OS user. POSTGRESQL
  • reset Sequence Oracle

Category: shell

telnet listening

Posted on 09-Jul-2008 By Admin No Comments on telnet listening

if you are trying following $ telnet remote-server port and you are getting error, this means no one is listening on that port on remote server. Start the listening application ( like listener ) & then do telnet. it will work if firewall is not blocking it.

Linux/Unix, shell

Find total file sizes

Posted on 07-Jul-2008 By Admin No Comments on Find total file sizes

sunflower1/800L>./vrm3 | awk ‘{tot+=$5} END {print “TOTAL ” tot/1024}’ TOTAL 52662552 sunflower1/800L>cat vrm3 ls -rlt /EMCdb21/oradata/800P/800P_misc_index31.dbf ls -rlt /EMCdb21/oradata/800P/800P_emp_data23.dbf ls -rlt /EMCdb21/oradata/800P/800P_emp_index55.dbf ls -rlt /EMCdb21/oradata/800P/ORD_SCRPAD_INDEX_06.dbf ls -rlt /EMCdb21/oradata/800P/800P_emp_index56.dbf ls -rlt /EMCdb21/oradata/800P/800P_misc_data_3_04.dbf ls -rlt /EMCdb21/oradata/800P/800P_SAS_DATA_1.dbf ls -rlt /EMCdb24/oradata/800P/800P_ord_index42.dbf ls -rlt /EMCdb24/oradata/800P/800P_misc_index32.dbf ls -rlt /EMCdb24/oradata/800P/800P_phone_index22.dbf ls -rlt /EMCdb24/oradata/800P/800P_atlas_index57.dbf ls -rlt /EMCdb14/oradata/800P/800P_atlas_data34.dbf ls -rlt /EMCdb14/oradata/800P/800P_emp_index57.dbf ls -rlt /EMCdb14/oradata/800P/800P_ord_data29.dbf…

Read More “Find total file sizes” »

Linux/Unix, shell

how to find VIP from ifconfig

Posted on 27-Jun-2008 By Admin No Comments on how to find VIP from ifconfig

As u see in front of VIP, “:1” will be there. sunlight1/800P>ifconfig -a lo0: flags=2001000849 mtu 8232 index 1 inet 127.0.0.1 netmask ff000000 hme0: flags=1000843 mtu 1500 index 2 inet 192.168.9.36 netmask ffffff00 broadcast 192.168.9.255 hme0:1: flags=1000843 mtu 1500 index 2 inet 192.168.9.10 netmask ffffff00 broadcast 192.168.9.255 hme1: flags=1000843 mtu 1500 index 3 inet 192.168.9.38…

Read More “how to find VIP from ifconfig” »

Linux/Unix, shell

Zip and unzip with tar

Posted on 02-Jun-2008 By Admin No Comments on Zip and unzip with tar

***** ZIP IT ************ eaappprod22->UOCUAT@(/export/home/oracle/paresh)ls -rlt total 0 -rw-r–r– 1 oracle dba 0 Jun 2 11:08 2 -rw-r–r– 1 oracle dba 0 Jun 2 11:08 3 -rw-r–r– 1 oracle dba 0 Jun 2 11:08 4 -rw-r–r– 1 oracle dba 0 Jun 2 11:08 5 -rw-r–r– 1 oracle dba 0 Jun 2 11:09 1 eaappprod22->UOCUAT@(/export/home/oracle/paresh)tar -cvf…

Read More “Zip and unzip with tar” »

Linux/Unix, shell

Guide to Linux System Command Mastery

Posted on 20-May-2008 By Admin No Comments on Guide to Linux System Command Mastery

An introduction to system commands for newcomers to Linux In “Guide to Linux File Command Mastery,” we covered the basic information needed to take advantage of the most essential and commonly used Linux file commands. In this article, I’ll do the same with Linux system commands. As we learned in the previous article, everything is…

Read More “Guide to Linux System Command Mastery” »

Linux/Unix, shell

setting prompt display with .profile

Posted on 16-May-2008 By Admin No Comments on setting prompt display with .profile

PS1=” `hostname`*${ORACLE_SID}-${PWD} ==>”

Linux/Unix, shell

runsql_once.ksh

Posted on 10-May-2008 By Admin No Comments on runsql_once.ksh

#!/bin/ksh # This parameter will be for executing environment file. $1 $ORACLE_HOME/bin/sqlplus -s “/ as sysdba”

Linux/Unix, shell

send attachment from unix-shell script

Posted on 10-May-2008 By Admin No Comments on send attachment from unix-shell script

#!/bin/ksh ORACLE_HOME=/oracle/app/oracle/product/9.2.0.8;export ORACLE_HOME ORACLE_SID=800P; export ORACLE_SID $ORACLE_HOME/bin/sqlplus -s “/ as sysdba”

Linux/Unix, shell

send email from unix mailx with attachment.

Posted on 07-May-2008 By Admin No Comments on send email from unix mailx with attachment.

mailx -s “test message” pmehta@1800flowers.com

Linux/Unix, shell

changing kernel parameter in Oracle Enterpise Linux

Posted on 11-Apr-2008 By Admin No Comments on changing kernel parameter in Oracle Enterpise Linux

change the file /etc/sysctl.conf for the kernel parameters. DBA generally do this for changing semaphore and shared memory parameters. Run the following command to change the current kernel parameters. $ /sbin/sysctl -p

Linux/Unix, shell

Posts pagination

Previous 1 … 5 6 7 … 16 Next

Categories

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

Recent Posts

  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • 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.sh23-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

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Rman Notes -1 Oracle
  • Day to day MYSQL DBA operations (Compared with Oracle DBA) MYSQL
  • .profile Linux/Unix
  • Renaming the column name Oracle
  • 10g RAC: Troubleshooting CRS Root.sh Problems Oracle
  • Absolute file number and relative file number Oracle
  • longtx.sql with the flag whether session is blocking any DML locks or not. Oracle
  • changing kernel parameter in Oracle Enterpise Linux Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme