Wednesday, November 11, 2009

Oracle File Formats

›
-------------------Backup Format----- 1 %c The copy number of the backup piece within a set of duplexed backup pieces. If you did not d...
Tuesday, October 6, 2009

how to recover deleted file from network drive

›
Issue: how to recover deleted file from network drive Solution: settings on Server 1. go the properties of Share Network Drive 2. Shadow Cop...

Windows terminate process forcefully

›
Windows terminate process forcefully taskkill /f /im process-name.exe /f - Stands for that process be forcefully terminated. /im - Stands fo...
Friday, September 25, 2009

Oracle: Which user process lock the other process

›
SELECT pr.username "O/S Id", ss.username "Oracle User Id", ss.status "status", ss.sid ...
Saturday, August 8, 2009

Linux YUM: download all rpm and dependancies from Internet Automatically

›
COPY file rpmforge.repo to /etc/yum.repos/ #rpmforge.repo # Name: RPMforge RPM Repository for Red Hat Enterprise 5 - dag # URL: http://rpmfo...
Wednesday, July 22, 2009

Linux DNS resolver

›
Not able to send mail to @jalindia.co.in due to jalindia.co.in DNS issue. they use their own dns to resolve jalindia.co.in. they should use ...
Saturday, July 18, 2009

RMAN Recovery with Previous Incarnation

›
rman>list incarnation of database; sql>shutdown immediate sql>startup mount rman>reset database to incarnation 3; rman>restor...
Friday, July 17, 2009

ASP Pages Cache problem

›
Don't Cache ASP pages ================ LD ASP Error: we hide the client but data is fetched from some branch. but on LD ASp server...
Wednesday, July 8, 2009

Recover Database with missing Archieve Logs

›
Recover Database witn missing Archieve Logs I am trying the restore my old database but due to missing of one archieve log. i m not able to ...
Monday, June 29, 2009

OEM Backup Notification

›
If Backup is failed or stop then i will get notification Steps : - Open a database target (SNS0910) - Click on User-Defined-Metrics - Create...
Saturday, June 27, 2009

OEM Backup Error Solution

›
OEM Backup Error -------------------- Recovery Manager: Release 10.2.0.3.0 - Production on Sat Jun 27 11:24:24 2009 Copyright (c) 1982, 2005...
Tuesday, June 23, 2009

ORACLE EXPORT/IMPORT UTILITY - DATA PUMP

›
==================ROLES====================================== SQLPLUSW sys/linux@sns0910srv as sysdba; create user dpuser identified by dpus...
Friday, June 19, 2009

Configure Oracle E-MAIL notification for DB shutdown or startup events Manually

›
Configure Oracle E-MAIL notification for DB shutdown or startup events Manually conn sys/linux@sns0910srv as sysdba @E:\oracle\product\10.2....
Tuesday, June 9, 2009

Oracle 10g Data Guard

›
Oracle 10g Data Guard Oracle Data Guard ensures high availability, data protection, and disaster recovery f...

Oracle- OEM - Export Database / Table / Schema / Tablespace (Data Pump)

›
1) user: snsexport passowrd:snsexp role:exp_full_database 2) Now Try to export database by login above user Errors: ORA-31626: job does not ...

Oracle - Create Standby / Duplicate / Test / Development / Clone Database

›
Steps to restore RMAN backup to different host, for example, RMAN backup from Production server to Test server. Presumptions * Productio...
Saturday, June 6, 2009

Spool To Excel and Html

›
SPOOL to EXCEL set head off; set feed off; set trimspool on; set linesize 32767; set pagesize 32767; set echo off; set termout off; Spool c:...
Friday, June 5, 2009

OEM OS Host Credentials (User Authenication Error)

›
OEM OS Host Credentials (User Authenication Error) Validation Error - Connection to host as user kgupta2 failed: ERROR: Wrong password for u...
Tuesday, June 2, 2009

Oracle-Rename database User

›
Rename Oracle Database User 1) exp owner=kgupta2 2) create user kshitij identified by rakesh; 3) DROP USER kgupta2 CASCADE; 4) imp FROMUSER=...

Oracle- Rename Database

›
Rename the Oracle Database 1) Full Database Backup 2) conn SYS/ORACLE AS SYSDBA 3) ALTER DATABASE BACKUP CONTROLFILE TO TRACE RESETLOGS; 4) ...