Database Administrator

Friday, March 26, 2010

Linux lock unlock user account

›
----------------------------script.sh--------------- #! /bin/sh ### BEGIN Script INFO # # Befor Usering it please check the user name # file...
Wednesday, March 10, 2010

URL Rewriting - Create Search Engine Friendly URLs

›
URL Rewriting - Create Search Engine Friendly URLs Add following line in web.config url="~/Commodity.aspx" mappedUrl="~/ProdA...
Tuesday, March 9, 2010

LD installation

›
@echo off M:\3ldtransfer\oracle_10g_10.2.0.3_client\setup.exe M:\3ldtransfer\VFP5.0\setup.exe mkdir C:\LD mkdir C:\ldoutput copy M:\1SHARED\...
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...
‹
›
Home
View web version
Powered by Blogger.