Tuesday, April 20, 2010

Reuse statements, cursor_sharing=force

›
Reuse statements select * from emp where ename = :EMPNAME select * from v$parameter where name like '%cursor_sharing%'; cursor_shari...

Oracle Flushing-Pinning PL/SQL packages, FLUSH SHARED POOL

›
Oracle Flushing-Pinning PL/SQL packages, FLUSH SHARED POOL http://www.remote-dba.cc/oracle_tips_flushing_secrets.htm 1. Pinning all com...
Tuesday, April 13, 2010

RMAN Block Corruption Detection & Recovery

›
Block Media Recovery with RMAN sql>select file# block# from v$database_block_corruption; --corrupted block Rman>> block recover da...

RMAN recover & open database if archive log missing

›
RMAN recover and open the database if the archive log required for recovery is missing 1) Set _ALLOW_RESETLOGS_CORRUPTION=TRUE in init.ora f...

RMAN recovery from loss of all online redo log files

›
RMAN recovery from loss of all online redo log files SQL> select thread#,sequence#,status from v$Log; set oracle_sid=sns6 rman Target SYS...
Monday, April 12, 2010

Uninstall Oracle from Server Completely

›
Uninstall Oracle # Stop any Oracle services that have been left running. Start->Settings->Control Panel->Services Look for any serv...

Create a Oracle Database Server Using RMAN backup from another Server

›
Create a Oracle Database Server Using RMAN backup from another Server 1) install Oracle server 10.2.0.3 without create startup database ----...

RECOVER THE DATABASE IN DIFFERENT SERVER ON DIFFERENT DIRECTORY FROM ACTUAL BACKUP LOCATION DIRECTORY

›
SCENIRIO IS I HAVE TAKEN RMAN BACKUP ON A SERVER IN D:\ARCHIVE0910\SNS1011\ LOCATION AND COPY THE BACKUP SET TO B SERVER IN DIFF. DIRECTORY ...
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 ...