Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • DBMS_JOB all example Oracle
  • Rename Tablespace Oracle
  • runon_allpdbs_show_conname.sh Oracle
  • How to collect CPU usage on Linux using Shell script Linux/Unix
  • CPU Core related projections AWS
  • How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven) Oracle
  • Oracle 10g Wait Model Oracle
  • Check Oracle installed products using one command Oracle
  • Goog notes on X$ tables Oracle
  • Good Doc 28-JUN-2006 Oracle
  • handling filenname with space Linux/Unix
  • Kernel Parameters for Solaris Linux/Unix
  • V$CONTROLFILE_RECORD_SECTION reference notes. Oracle
  • Metalink Note: Note:250655.1 : ADDM Basics USING THE AUTOMATIC DATABASE DIAGNOSTIC MONITOR Oracle
  • Display the top 5 salaries for each department using single SQL 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
  • TOP-N Sql to find Nth max or Top N rows Oracle
  • To Find Orphan OS processes. Linux/Unix
  • Jai Shree Ram Oracle
  • Processes Parameter decision Oracle
  • How To Transfer Passwords Between Databases (ref note: 199582.1) Oracle
  • cur_sql.sql Oracle
  • Find all users who have DML privileges Oracle
  • 751131.1 New Article Error 2819 While Requesting a Systemstate Dump Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme