Oracle 10.2.0.3 Gap Resolution of Physical Standby Appears to Hang
Last week we’ve encountered the archived-log-gap-missing issue on Oracle 10.2.0.3 physical standby. Looking from V$MANAGED_STANDBY, it showed waiting for gap of the archived log sequence #53713. SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY; PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS ——— ———— ———- ———- ———- ———- ARCH CONNECTED 0 0 0 0 ARCH …
Oracle 10.2.0.3 Gap Resolution of Physical Standby Appears to Hang Read More »
Install 11g Release 2 Grid Infrastructure for Standalone Server on Windows 7 for Sandbox
Oracle 11g Release 2 for Windows was just released this month. With the availability of the grid infrastructure in this version, I plan to install it on my Windows 7 desktop to see what it can do even if it is just on stand alone environment. In order for database to use Automatic Storage Management …
Install 11g Release 2 Grid Infrastructure for Standalone Server on Windows 7 for Sandbox Read More »
Alter Tablespace Read Only Hangs
I found this tip from Oracle document while looking for a solution for session hung at the SQL prompt after issuing “alter tablespace read only”. Usually “alter tablespace read only” executes very quickly. However, the likelihood cause of waiting for tablespace to become read-only is due to existing in-flight transactions started before “alter tablespace read …
Book Review: Oracle SQL Developer 2.1 by Sue Harper
I must admit that I rarely use the Oracle SQL Developer because I’m using SQL*Plus, Toad from Quest and PL/SQL Developer from Allround Automations as primary tools for database administration and PL/SQL programming. They’re already providing all functionalities I need. I have nothing against Oracle SQL Developer. Actually it is quite opposite. I really want …
Book Review: Oracle SQL Developer 2.1 by Sue Harper Read More »
Use PHP5 to Solve the WordPress Automatic Upgrade Failure for 1and1
I’ve been having issue with WordPress automatic upgrade for quite awhile. It never make any progress after download completes. This upgrade issue applies to both WordPress itself and its plug-ins. But at that time I’ve never bothered trying to find a solution for it. My WordPress version 2.6 was so far behind. 🙁 After searching …
Use PHP5 to Solve the WordPress Automatic Upgrade Failure for 1and1 Read More »