Month: January 2010

Oracle sudden, inordinate irrensponsibility and ORA-07445


if you ever experience sudden, inordinate irrensponsibility of your oracle instance (one or more threads are running at 100% cpu) and find an error message like this in your alert.log:

ORA-07445: Exception aufgetreten: CORE Dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7C921766] [ADDR:0x4C43414F] [UNABLE_TO_READ] []

this windows xp sp2 hotfix may be for you:

KB951312 – When you run an application that uses a timer queue on a Windows XP-based computer, the application may stop responding

regards

Running google maps 3.2.1 on a blackberry curve 8900


this is way off topic (of oracle) somehow but it may probably help some people that complain that the latest versions of google maps (http://www.google.com/gmm) does not run on a pure, that is no bes / bis, blackberry curve 8900 device. the problem shown is the famous:

Network Unavailable: This application requires a data connection, and some blackberry devices require reconfiguration to work properly.

error message on application launch of google maps (and other applications as i read). aside from any wrong application security settings, as one may suspect, the problem solution is explicitely setting the carrier apn login information with the tcp/ip settings dialogue (see settings -> advanced settings -> tcp/ip). here you have, as a free minded translation of my german dialogue layout, originally:


[x] APN-Settings enabled
APN:
[ ] APN-Authentication
enabled
Login name for APN:
Password for APN:

complete this with the freely available carrier apn login information (see in germany, for example, http://www.besmgmt.de/knowledgebase/geraete/apn-ubersicht-deutscher-mobilfunkanbieter) to:


[x] APN-Settings
enabled
APN: internet.eplus.de
[x] APN-Authentication
enabled
Login name for APN: eplus
Password for APN: gprs

please note, that proceeding like this may cause extra cost at your side iff you do not have packet-based flat rate contract with your carrier.

to me, i think that google is urgently up to change its application design to use the network resources as being listed in the network service book (see settings -> advanced settings -> service book). this would also be another way to bind google maps to the much faster wifi network.

so far, this post http://www.google.com/support/mobile/bin/answer.py?hl=en&answer=47617 is actually big nonsense.

last but not least: if you want to switch off gps tracing you mysterious adventures, the appropriate setting can be found in the google maps help dialogue.

regards

rman duplicating an oracle database in a new sid / two host scenario


introduction

there are many ways to clone an oracle database. you may just copy and init a cold backup, do a rman restore / recover or employ datapump. according to the number of possibilities there is another multitude number of things you have to evaluate in advance, prepare, configure, keep in mind, postprocess etc., for every clone procedure. me, i mostly use cloning by cold backup, preferably if cloning to another host is requested and if the database system identifier (sid) remains the same. although this way of cloning nearly needs no additional work, you have to take into account that copying the (cold) files from source to destination may take a considerable amount of time, especially for large databases (i’m going to show in another post how to accelerate that by san-snapshotting, a technique becoming deservedly popular lately).

if you cannot go with source database downtimes at all, the rman duplicate functionality might be the preferred choice. it is sort of rman restore / recover, can therefore live on a hot backup, but saves yourself from playing around with controlfile backups / scripts or the nid tool for example. much more far from it, rman duplicate even uses a live, the source, controlfile for automated database structure setup on the destination. but now let’s see how a rman duplicate may work for a given scenario.

(more…)