Monthly Archives: April 2013

Oracle Database: ORA-00604 and ORA-20000

*************************************************************************************** * ORA-00604: error occurred at recursive SQL level 1 * ORA-20000: Trigger xdb_installation_trigger does not support object creation of type SNAPSHOT * *************************************************************************************** Solution: A trigger named xdb_installation_trigger that prevent you from creating your sequence. Disable it before the … Continue reading

Posted in Oracle | Tagged , | 2 Comments

Oracle Database – Enableing Trace for a concurrent request

Step 1 : ======= Get Concurrent Request ID of long running concurrent request from Application(fronted). Navigation : Application >> System administrator>> concurrent>request> Step 2 : ======== Find session associated with concurrent request .i.e SID By using the above Query we … Continue reading

Posted in Oracle | Tagged | Leave a comment

Oracle – Temporarily disabling the log shipping to standby database

Temporarily disabling the log shipping to standby database $ sqlplus SQL*Plus: Release 10.2.0.3.0 – Production on Wed Jul 25 21:07:57 2012 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. Enter user-name: /as sysdba Connected to: Oracle Database 10g Enterprise Edition … Continue reading

Posted in Oracle | Tagged , | Leave a comment

Oracle Activating the Standby Database – Switchover Method

Activating the Standby Database – Switchover Method The main advantage of a graceful switchover is that it avoids the resetlogs operation. By avoiding the resetlogs operation, the source database can resume its role as the standby database almost immediately with … Continue reading

Posted in Oracle | Tagged , , | Leave a comment

Oracle Database Health Check Script

SPOOL OFF CLEAR SCREEN SPOOL /tmp/quickaudit.lst –SELECT SYSDATE FROM DUAL; –SHOW USER PROMPT PROMPT ———————————————————————–| PROMPT SET TERMOUT ON SET VERIFY OFF SET FEEDBACK ON PROMPT PROMPT Checking database name and archive mode, dbid PROMPT column NAME format A9 column … Continue reading

Posted in Oracle | Tagged | Leave a comment

Create a Full Database Backup (SQL Server) Using SQL Server Management Studio

Create a Full Database Backup (SQL Server) Using SQL Server Management Studio: ———————————————————————————————————- Recommendations As a database increases in size full database backups take more time to finish and require more storage space. Therefore, for a large database, you might … Continue reading

Posted in MsSQL Server | Tagged , | Leave a comment

MOVING MASTER, MSSQL SYSTEMRESOURSE DB PRIMARY AND LOG FILES FROM ONE DRIVE TO ANOTHER DRIVE IN THE SAME MACHINE IN MSSQL Server 2005

MOVING MASTER, MSSQL SYSTEMRESOURSE DB PRIMARY AND LOG FILES FROM ONE DRIVE TO ANOTHER DRIVE IN THE SAME MACHINE IN MSSQL Server 2005 1.Goto Start > All programs > Microsoft sq l server 2005 > Configuration Tools > sq l … Continue reading

Posted in MsSQL Server | Tagged , | Leave a comment