Database Administrator

Wednesday, February 24, 2010

RMAN BACKUP TO NETWORK DRIVE

›
RMAN BACKUP TO NETWORK DRIVE CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'z:/network/backup_db_%d_S_%s_P_%p_T_%t'; CONFIGURE CONTROL...
Monday, February 8, 2010

USB drive Disable Enable

›
Set deny permissions for the user/s and/or group/s to: %SystemRoot%\Inf\Usbstor.pnf %SystemRoot%\Inf\Usbstor.inf It is highly recommended to...

Change ORACLE SID

›
select name from v$database; select instance_name from v$instance; shutdown immediate; C:\>set ORACLE_SID=sidorcl C:\>net stop oracles...

Oracle Patch 10.20.3 to 10.2.0.4

›
Oracle Patch 10.20.3 to 10.2.0.4 How to Apply the Patchset ? Before y ou apply the patchset you have to chec...
Thursday, January 28, 2010

Disable right mouse click script

›
--
Friday, January 22, 2010

Regedit for Oracle

›
copy "c:\ld\ld.exe.lnk" "c:\documents and settings\%username%\desktop" Set Environmental variable through regedit For Ma...

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...

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...

Connect Sql Server in SqlDeveloper Tool

›
1) download net.sourceforge.jtds.jdbc.Driver http://sourceforge.net/projects/jtds/files/jtds/1.2.1/jtds-1.2.1-src.zip/download 2) In Oracle ...

Unwrap Oracle plsql code

›
http://hz.codecheck.ch/UnwrapIt/Unwrapped.jsp
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...
‹
›
Home
View web version
Powered by Blogger.