Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Adding Datafile on Primary Server and Impact on Standby Server Oracle
  • How to remove blank lines using vi editor command Linux/Unix
  • sid_wise_cursor.sql find open cursor basis on username or SID Oracle
  • Oracle 11g RAC on OEL 5 and Vmware 2 Oracle
  • Rownum with Order by Oracle
  • catting.sh Linux/Unix
  • Removing Ctrl-M from end of line using vi Linux/Unix
  • Reading config file from other folder inside class Python/PySpark
  • How to hide author name in WordPress BLOG PHP/MYSQL/Wordpress
  • oracle 11g RAC on vmware Oracle
  • Which environment is used by currently running process ( Very good) Linux/Unix
  • Privileges Required to Create Procedures and Functions that uses objects from other schema. Oracle
  • segment_wise_space.sql segspace.sql Segment wise space usage (allocated and used) Oracle
  • fkwoindex.sql /* Find FK without Index */ Oracle
  • Jai Shree Ram PHP/MYSQL/Wordpress

Year: 2008

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

RAC 11g with vmware

Posted on 01-Jun-2008 By Admin No Comments on RAC 11g with vmware

http://www.oracle-base.com/articles/11g/OracleDB11gR1RACInstallationOnOEL5UsingVMware.php

Oracle, RAC

oracle 11g RAC on vmware

Posted on 25-May-2008 By Admin No Comments on oracle 11g RAC on vmware

http://startoracle.com/2007/09/30/so-you-want-to-play-with-oracle-11gs-rac-heres-how/

Oracle, RAC

OEM-troubleshooting on 20-MAY-08

Posted on 20-May-2008 By Admin No Comments on OEM-troubleshooting on 20-MAY-08

FROM TUNINGDB21 (Target) =============== tuningdb21*-/db1/home/oracle/paresh ==>ping 10.180.1.144 10.180.1.144 is alive tuningdb21*-/db1/home/oracle/paresh ==>ping oem2k.1800flowers.int ping: unknown host oem2k.1800flowers.int tuningdb21*-/db1/home/oracle/paresh ==>nslookup 10.180.1.144 *** Can’t find server name for address 127.0.0.1: Unspecified error *** Default servers are not available tuningdb21*-/db1/home/oracle/paresh ==>nslookup oem2k.1800flowers.int *** Can’t find server name for address 127.0.0.1: Unspecified error *** Default servers are not available…

Read More “OEM-troubleshooting on 20-MAY-08” »

Oracle, SQL scripts

normal maintenance for exp-imp and renaming table

Posted on 20-May-2008 By Admin No Comments on normal maintenance for exp-imp and renaming table

exp userid=vivek file=ats_florist_zips_20MAY08.dmp log=ats_florist_zips_20MAY08.log grants=N indexes=N tables=ats.ats_florist_zips triggers=N statistics=None feedback=5000 imp userid=vivek file=ats_florist_zips_20MAY08.dmp log=imp_ats_florist_zips_20MAY08.log buffer=20971520 grants=N indexes=N fromuser=ats touser=5049 commit=Y constraints=N feedback=5000 statistics=None alter table “5049”.ATS_FLORIST_ZIPS rename to ats_florist_zips_05_20_2008;

Oracle, SQL scripts

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

OEM-Commnds

Posted on 15-May-2008 By Admin No Comments on OEM-Commnds

D:oracle_homesagent10gBIN> emctl status agent D:oracle_homesagent10gBIN> emctl start agent D:oracle_homesagent10gBIN> emctl stop agent yantradevdb-YANTRAD> emctl getemhome yantradevdb-YANTRAD> emctl upload

Oracle, SQL scripts

V$ROLLSTAT status is Full

Posted on 13-May-2008 By Admin No Comments on V$ROLLSTAT status is Full

Problem Description: ==================== You receive the following error: ORA-01562: “failed to extend rollback segment number %s” Cause: Failure occurred when trying to extend rollback segment Action: This is normally followed by another error message that caused the failure. You may take the rollback segment offline to perform maintainence. Use the alter rollback segment offline command…

Read More “V$ROLLSTAT status is Full” »

Oracle, SQL scripts

Rman Notes -1

Posted on 12-May-2008 By Admin No Comments on Rman Notes -1

A flash recovery area is a disk location in which the database can store and manage files related to backup and recovery. Some features of Oracle database backup and recovery, such as Oracle Flashback Database and guaranteed restore points, require the use of an FRA. However, having an FRA for use by these features does…

Read More “Rman Notes -1” »

Oracle, rman-dataguard

Posts pagination

Previous 1 … 3 4 5 … 8 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
  • Oracle Standby Database Library Index from Metalink Oracle
  • how to find VIP from ifconfig Linux/Unix
  • Jai Shree Ram Linux/Unix
  • Add new columns in dataframe Python/PySpark
  • How to find Unix server conguraiton including Server Model number and underlying disk sub-system ( On Solaris) Linux/Unix
  • avail.sh ( find filesystem spae usage) Linux/Unix
  • V$ROLLSTAT status is Full Oracle
  • Proc Compilation Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme