Wednesday, February 23, 2011

Wait Events

›
http://www.scribd.com/doc/3321687/09-enqueues SQL*Net message from client The server process (foreground process) waits for a message from t...

AWR Sections

›
AWR report is broken into multiple parts. 1)Instance information:- This provides information the instance name , number,snapshot ids,total t...
Tuesday, February 22, 2011

delete listener services in windows

›
how to delete listener services in windows regedt32-->hkey_local_machine-->system-->currentcontrolset-->services-->oracle and...
Sunday, February 20, 2011

RMAN :Restore Different Server, Database folder on different Directory, Backup Piece on different location

›
Scenario Restore on Different Server, Database folders are on different Directory, Backup Piece on different location Previous Server Prod, ...

Restore Error to different server and different directory (RMAN ORA-01180 ORA-01110)

›
--------Error--------RMAN ORA-01180 ORA-01110---------- I have taken database backup (location E drive ) in backuppieces and restore it into...
Wednesday, February 16, 2011

Data Pump

›
USING DATA PUMP TABLE EXPORT IMPORT expdp scott/tiger@db10g tables=EMP,DEPT directory=TEST_DIR dumpfile=EMP_DEPT.dmp logfile=expdpEMP_DEPT.l...

General Errors

›
http://www.articles.freemegazone.com/oracleErrors.php ORA12518: TNS:listener could not hand off client connection ORA04030: out of process m...

Database fresh creation using cold backup(physical folder)

›
Database fresh creation using cold backup(physical folder) with same database files location Install oracle software without database creati...

Trace files generated in Bulk in BDUMP

›
Same following error in all trace file which is generated in every minute.. Error in Alert log ORA-07445 ORA-12012 ORA-00604 ORA-01427 ORA-0...
Friday, December 31, 2010

ORA-04030: out of process memory when trying to allocate

›
Do session, memory monitoring Windows Server 2003 SP2 Oracle 10g /PAE /3GB RAM 8GB instances:6 Memory Usage of Oracle.exe for current FY goe...
Thursday, November 11, 2010

Clear Temporary tablespace

›
1) CREATE TEMPORARY TABLESPACE temp2 TEMPFILE 'E:\SNSD1011\TEMP02.ORA' SIZE 5M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE unlimited E...
Wednesday, October 6, 2010

When to Rebuild an Index?

›
When to Rebuild an Index? It is important to periodically examine your indexes to determine if they have become skewed and might need to be ...
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 ---------...