Tuesday, December 13, 2011

Recover Database with allow corruption

›
Here is an example of block corruption faced during database recovery: recover database; RA-00600: internal error code, arguments: [3020], [...

generate move rebuild script to migrate partitioned tables from one tablespace to other

›
declare cflag number; oldDataTablespaceName varchar2(100); newDataTablespaceName varchar2(100); oldIndexTablespaceName varchar2(100); newInd...

Reason: Archivelog Generation Huge

›
There are many reasons for it and need to check out. >Heavy DML statements. >DML with Lobs and xml datatypes. >Investigate the SQL ...

Resizing Recreating RedoLogs / Increase Redo log / Archivelog generation fast size

›
--------------------------------------------final steps-------------------------- select group#, status from v$log; ALTER SYSTEM CHECKPOINT ...
Monday, December 12, 2011

Archivelog Frequency

›
A script to check the frequency of log switches col MidN format 999 col 1AM format 999 col 2AM format 999 col 3AM format 999 col 4AM format ...

sqlserver to oracle 11g connection

›
-----------odbcad32--------------------- datasource name (DSN) : dg4odbc description: dg4odbc sqlserver : 172.168.0.6 database: msajag usern...
Thursday, December 8, 2011

EXPLAIN PLAN

›
SQL> explain plan for 2 SELECT * FROM TBLBANKDETAIL; Explained. SQL> set linesize 160 SQL> set pages 300 SQL> select * from t...

Ora-29257 UTL_INADDR.get_host_address

›
Ora-29257 When Trying to Use UTL_INADDR to Get IP Address or Host Name of a Server Problem Description When using either the get_host_addres...

Index DeFragmentation / Rebuild / Index Performance Tuning

›
Index Defragmentation Steps Analyzing statistics Validating the index Checking PCT_USED Dropping and rebuilding (or coalescing) the index --...
Wednesday, December 7, 2011

win error error 0x80070522

›
This issue might occur permissions are not set properly for the C Drive. Make sure that you are logged in as Administrator. To take ownershi...
Monday, December 5, 2011

tns 12535 operation timed out

›
ping serverip tnsping serverip telnet serverip 1521 solution allow port 1521 on server
Saturday, December 3, 2011

ORA-24005 must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables

›
I was getting this error when I was trying to drop a schema . Sql> drop user test cascade; ERROR at line 1: ORA-00604: error occurred at...

Buffer Cache Size

›
High CPU_COUNT and increased granule size can cause ORA-0431 error. ------CPU_COUNT specifies the number of CPUs available to Oracle. On sin...
Friday, December 2, 2011

ORA-02049: timeout: distributed transaction waiting for lock

›
ORA-02049: timeout: distributed transaction waiting for lock simoutaneously transactions Make sure that there were no any activities on the ...

Oracle Internal Code Error

›
----------------------------- ERROR: ORA-06553: PLS-801: internal error [56319] ERROR: ORA-06553: PLS-801: internal error [56319] Error acce...
Wednesday, November 30, 2011

10g to 11g migration

›
http://debaatobiee.wordpress.com/2009/10/17/step-by-step-upgrading-oracle-10g-to-oracle-11g/
Monday, November 28, 2011

expdp

›
http://www.dba-oracle.com/t_export_import_different_releases_of_oracle.htm
Friday, October 21, 2011

Data Pump EXPDP

›
expdp userid="'sys/oracle@ari1112srv as sysdba'" FULL=y directory=dpump_dir2 dumpfile=ari1112.DMP LOGFILE=ari1112.LOG expd...

Email Notification for System Event

›
Eventtriggers /Create /ru Administrator /rp afl07839 /TR "Event Triggers for unexptected shutdown" /EID "6008" /TK d:\Em...
Tuesday, September 20, 2011

Remove partition without delete data

›
1) ALTER TABLE FALEDDRCR MERGE PARTITIONS BR1000, BR1050 INTO PARTITION BR1050 tablespace USR; ALTER TABLE FALEDDRCR MERGE PA...