Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • cif crons Linux/Unix
  • Export Oracle data and Compress at same time Oracle
  • Index Range Scan Oracle
  • How to find where datafile is created dbf_info.sql Oracle
  • Oracle GoldenGate lag monitoring shell script Linux/Unix
  • Check SQL Server edition SQL Server
  • AWR license Oracle
  • Settting up get_vmstat.sh for colletinf CPU Usage. Oracle
  • Oracle Statspack survival Guide Oracle
  • Configure ssh authentications for RAC Oracle
  • on IBM-AIX for display Linux/Unix
  • findinfo.sql (SQL for getting CPU and Active session info) Oracle
  • shr1.sql for MTS or Shared server configuration Oracle
  • create database syntax Oracle
  • MYSQL for Oracle DBA MYSQL

Category: Linux/Unix

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

restarting network in linux

Posted on 09-Apr-2008 By Admin No Comments on restarting network in linux

Restart networking: # /etc/init.d/network restart

Linux/Unix, 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

Posts pagination

Previous 1 … 5 6 7 … 15 Next

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (393)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • 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

  • Complete Git Tutorial for Beginners25-Dec-2025
  • Postgres DB user and OS user.25-Dec-2025
  • 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

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • find_open_cur.sql Find open cursorts per session Oracle
  • currwaitobj.sql SQl_ID and SQL statement you can get from currwaitobj.sql Oracle
  • Giving Grant on v$DATABASE Oracle
  • exp syntax in oracle 10g Oracle
  • CTAS with LONG Column for 9i and higher Oracle
  • crtgr.sql /* For creating trigger from data dictionary */ Oracle
  • Session_info.ksh Linux/Unix
  • Parallel DML Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme