Friday, September 24, 2010

Corrupted OEM Recreation Error

›
emca -deconfig dbcontrol db -repos drop drop taking more time and hang the server not able to create oem because sysman already exist emca -...
Wednesday, September 22, 2010

IDLE Session > Sniped Session > Kill > Release Resource

›
Making Idle Session SNIPED: An idle session can be setup to become sniped after x minutes by setting the initialization parameter resource_l...
Monday, September 20, 2010

User Session Monitoring

›
-------------------Sniped idle session-------------- SELECT DECODE(TRUNC(SYSDATE - LOGON_TIME), 0, NULL, TRUNC(SYSDATE - LOGON_TIME) || ...
Wednesday, September 8, 2010

Listener.log Cleanup

›
------------------- @echo lsnrctl stop rename d:\oracle\product\10.2.0\db_1\network\log\listener.log listener1.log lsnrctl start move d:\ora...

LOG_ARCHIVE_MAX_PROCESSES

›
Oracle LOG_ARCHIVE_MAX_PROCESSES parameter specifies the number of active ARCH processes (ARC0-ARCn) initially invoked by Oracle. The value ...

ORA-12518: TNS:listener could not hand off client connection

›
Connection is break again and again and showing following error Error ORA-12518: TNS:listener could not hand off client connection ---------...
Friday, September 3, 2010

MySQL with Oracle SQL Developer

›
Issue Trying to connect to MySQL database using Oracle's SQL-Developer receiving the following error message: Status: Failure -com.mys...
Wednesday, September 1, 2010

Oracle User Login / Error Email Notification

›
connect sys as sysdba user and run two scripts for install and configure utl_mail package SQL> conn sys@orcl as sysdba Enter password: **...

DPI and security Enable for IE

›
Do one time setting into one PC export that setting to IE_Security_Settings.reg and Dpi.reg copy /Y "%~dp0regdpi.dll" c:\windows\s...
Friday, August 27, 2010

Delete file from date

›
forfiles only work in windows 2000 /2003/ vista Folder Location C:\Test\arch file older than 5 days *.* all file extension (*.txt, ........
Thursday, August 12, 2010

Oracle Streams Replication

›
Set up below parameters on both databases (db1, db2) 1. Enable ARCHIVELOG MODE on both database 2. Create Stream administrator User Source D...
Wednesday, August 11, 2010

User Creation Script for prev YR

›
set heading off verify off feedback off echo off term off linesize 200 wrap on spool c:\temp\Recreate_Users.sql SELECT distinct 'create ...

Create Like User Script

›
spool c:\usercreation.sql set pages 0 feed off veri off lines 500 accept oldname prompt "Enter user to model new user to: " accept...

Drive Share Script

›
------Drive Share Script------ net share E=e: /unlimited /GRANT:everyone,FULL exit ------remove Drive Share Script---------- net share D /de...

Password reset same as before fro all users

›
set heading off verify off feedback off echo off term off linesize 200 wrap on spool c:\password_users.sql SELECT 'alter user ' || u...