Report

Jimbart's Oracle DBA Blog




Site Details
Current Rank: 62 (Technology & Computers)
URL: http://dba.watimbox.com/
Site Description: Oracle Database Adiminstration tips and tricks
Date Joined: Jun 14, 2012

Tags: Oracle, database, database administration, Oracle Rac, Oracle Database


Latest Blog Posts

ORA-29701 When Starting Up Standalone ASM
on Apr 11, 2013 in Database Errors ORA-29701 ORA-29701 ASM ORA-29701 single instance ASM ORA-29701 standalone ASM ORA-29701: unable to connect to Cluster Manager ORA-29701: unable to connect to Cluster Synchronization Service   First of all, Oracle clusterware services are needed by any ASM instance whether it is a single node (standalone) or clustered setup (RAC). This means, ASM will not start...



Troubleshooting backups in Ts
on Mar 24, 2013 in Backup and Recovery backup troubleshooting Company Specific Troubleshooting Oracle Backup troubleshooting RMAN Ts   Specific to Te**s Only. 1. Hanged RMAN sessions — For Checking Hung rman sessions — Exact query used by orabackup.ksh : subscript dbbackup.ksh — If value is not null,...



How to Add Datafiles to Databases with Configured with Physical Standby
on Feb 23, 2013 in Backup and Recovery Database Errors Datafile Dataguard Dataguard manual standby_file_management manual ORA-02096 Oracle Dataguard Physical Standby standby_file_management   It’s always prudent to check for your database’ current configuration before adding new datafiles. A mistake can cause serious problems if your database has a physical standby configured. The...



Query to Check Inactive Sessions
on Feb 14, 2013 in Scripts   What to do when processes reach the maximum? You can cleanup sessions that have been inactive for a long time or increase the processes parameter. select 'alter system disconnect...



Script to Check Maximum Processes
on Feb 5, 2013 in Scripts maximum number of processes ORA-00020 ORA-00020 maximum number of processes   Instead of querying the v$parameter or executing the show parameter command then querying the v$process dynamic view. This query will return the maximum and current utilization of processes on...



Relocating Oracle RAC services
on Nov 2, 2012 in Uncategorized   During maintenance activities where only one (1) or not all of the database nodes/instances are shutdown, services are automatically relocated by Oracle to the other remaining online database nodes/instances....



Changing Archivelog Destination of the Primary Database
on Aug 28, 2012 in Backup and Recovery Scripts archive log archive log broker archive log dataguard broker archive log destination archive log destination broker archive log destination dataguard broker archivelog archivelog broker archivelog dataguard broker archivelog destination archivelog destination broker archivelog destination dataguard broker log_archive_dest log_archive_dest broker log_archive_dest dataguard broker log_archive_dest_1 log_archive_dest_1 broker log_archive_dest_1 dataguard broker log_archive_dest_n log_archive_dest_n broker log_archive_dest_n dataguard broker   Usually it is generally easy to change the archivelog destination of the primary database especially when the current archivelog destination system is almost full. However, when Oracle Dataguard is...



Check Standby Database Archive Log Gap
on Aug 28, 2012 in Scripts Uncategorized archive log archive log gap archive log monitor archivelog archivelog gap archivelog monitor   How to monitor archive log shipping in Oracle databases using Oracle Dataguard technology for standby databases. Monitor Archivelog Gap: SELECT ' DGSYNCH' as column_title, max(p.sequence#) primary_current_log, max(s.sequence#) secondary_curren...



Query to Detect Sessions Using up a Lot of Database Resources
on Aug 1, 2012 in Performance Tuning Scripts A common issue among databases are sessions/users that overuse database resources which causes database performance degredation. This can be averted through the use of Oracle’s Resource Manager but it is...



How to Generate Database Systemstate Dumps and Hanganalyze
on Jun 12, 2012 in Database Errors Performance Tuning Generate Database Systemstate Dump and Hanganalyze Generate Database Systemstate Dumps and Hanganalyze Generate Oracle RAC Database Systemstate Dump and Hanganalyze Generate Oracle RAC Database Systemstate Dumps and Hanganalyze Hanganalyze How to Generate Database Systemstate Dump and Hanganalyze How to Generate Database Systemstate Dumps and Hanganalyze How to Generate Oracle RAC Database Systemstate Dump and Hanganalyze How to Generate Oracle RAC Database Systemstate Dumps and Hanganalyze Oracle Generate Database Systemstate Dump and Hanganalyze Oracle Generate Database Systemstate Dumps and Hanganalyze Oracle Generate Oracle RAC Database Systemstate Dump and Hanganalyze Oracle Generate Oracle RAC Database Systemstate Dumps and Hanganalyze Oracle Hanganalyze Oracle RAC Hanganalyze Oracle RAC Systemstate Oracle RAC Systemstate Dump Oracle RAC Systemstate Dumps Oracle Systemstate Oracle Systemstate Dump Oracle Systemstate Dumps RAC Hanganalyze RAC Systemstate RAC Systemstate Dump RAC Systemstate Dumps Systemstate Systemstate Dump Systemstate Dumps   Generating Systemstate Dumps and Hanganalyze for your database is cruicial when diagnosing database performance or hanging issues. Hanganalyze and Systemstate dumps provide information on the processes in the database...



Statistics
Unique Visitors Today: 1
Page Views Today: 1
Unique Visitors this Week: 8
Page Views this Week: 8
Unique Visitors this Month: 183
Page Views this Month: 197
Total Unique Visitors: 11,622
Total Page Views: 15,024
Total Hits Out: 50

Site Traffic