Category Archives: Uncategorized

CLONE ORACLE DATABASE WITH COLD BACKUP:

1. Identify and copy the database files With the source database started, identify all of the database’s files. The following query will display all datafiles, tempfiles and redo logs: set lines 100 pages 999 col name format a50 select name, … Continue reading

Posted in Uncategorized | Tagged , , , | Leave a comment

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 Uncategorized | Tagged | Leave a comment

How to switch the database to a new UNDO tablespace and drop the old one

STEP -1 ======= $ sqlplus / as sysdba SQL> show parameter undo NAME                                 TYPE        VALUE ———————————— ———– —————————— undo_management                      string      AUTO undo_retention                       integer     900 undo_tablespace                      string      UNDOTBS1 SQL> The current undo tablespace as suggested by the initialization parameter undo_tablespace is … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

Oracle best practice: Primary and Standby archive crosscheck

Primary: STEP -1 ======== LOGIN TO THE PRIMARY SERVER $ su – orapr1 Password: STEP -2 ======= GET THE SEQUENCE MAX FROM V$LOG_HISTORY SQL> select max(sequence#) from v$log_history; MAX(SEQUENCE#) ————– 76968 SQL> alter system switch logfile; System altered. SQL> select … Continue reading

Posted in Uncategorized | Tagged , , , | Leave a comment

Oracle exp and imp: oracle9i to 11g

Setp — 1 ========== Set the same character on source server: ======================================== In source database export NLS_LANG=AMERICAN_AMERICA.US7ASCII Do actual export(exp parfile=exp.par) Setp — 2 ========== Exporting the data from source database: ======================================== exp system/system123 file=NAS30.dmp log=NAS30.log owner=NAS30 buffer=100000000 grants=y rows=y … Continue reading

Posted in Uncategorized | Tagged , , , | 11 Comments

Oracle Security Alert for CVE-2012-1675 “TNS Listener Poison Attack”

Oracle Critical Patch Updates (CPU) The Oracle database server has a separate network connection process that usually operates on TCP port 1521. The database registers as a listener with this process and the process forwards the client requests on to … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

Optimizing the Oracle 11g Result Cache

The Oracle 11g Result Set Cache stores entire result sets in shared memory. If a SQL query is  executed and its result set is in the cache then almost the entire overhead of the SQL execution is avoided:  this includes … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment