Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • find_open_cur.sql Find open cursorts per session Oracle
  • moving lob object to other tablespace lob_mvmt.sql Oracle
  • Check_recovery.sh program to run sqlplus and return its values remotely. Linux/Unix
  • purge_trc.sh Linux/Unix
  • Database logon trigger issue Oracle
  • How to know Number of CPUs on Sun Box Linux/Unix
  • Query to Generate aggregate on every 30 mins. Oracle
  • How To Transfer Passwords Between Databases (ref note: 199582.1) Oracle
  • Good link for LIO in Oracle ( Logical IOs) Oracle
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
  • plan10g.sql good1 Oracle
  • How to find pinned objects from shared pool. (pinned via dbms_shared_pool.keep) Oracle
  • Rename Tablespace Oracle
  • kill all processes from specific user in solaris. Linux/Unix
  • Find_table_size.sql Oracle

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)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (393)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (0)
  • 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

  • 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
  • V$INSTANCE of Oracle in MYSQL24-Jul-2025
  • Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • ORA-4031 issue and solution on 09-MAY-2008 Oracle
  • Does DBMS_JOB recompute the NEXT_DATE interval after or before Oracle
  • Which environment is used by currently running process ( Very good) Linux/Unix
  • Recovering lost SYS password Oracle
  • AWR settings- MMON is not taking snapshot. Oracle
  • Sending SQLPLUS output in HTML format Oracle
  • Good notes for shared pool Oracle
  • SQL_PROFILE – I explaination Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme