Sunset photo

Photo from sunset at Jane's parents' house.

Comments

Post a Comment

Popular posts from this blog

Using RMAN DUPLICATE when the target system is behind a firewall

My production servers are on the other end of a network link where they can not make connections to any of the servers in my dev/test environment, but connections from dev/test to production are fine.  This is problematic: OEM 12c (housed in dev/test environment) can't monitor production (needs 2-way agent<->OMS comms) RMAN DUPLICATE doesn't work (requires connection from source to destination) No way to push files from production to dev/test And many others... The point of this post is to talk about RMAN DUPLICATE in this situation. As there's no outbound connectivity from prod->dev/test, I initially assumed this wouldn't be possible, however I've tried using SSH tunnels. and while it didn't work due to my previous blog post (RMAN-05531 during duplicate from active standby), the concept is fine. Log in to the shell of the destination database, and follow the usual setup (DocID 452868.1 ) to create a duplicate from active database: C...
Read more

Useful stuff to note - (Mainly) Bash scripting

I have a wealth of stuff stuck in Bash scripts that I've generated over the years.  Some of the most useful tips, and some of the most rarely used things that I want to note down for myself are probably: stat - such a simple but terribly useful command.  With the -f switch it gives you filesystem info about where the file you pass it is located.  Without it you get easy access to any information about the file you could ever need. Parameter substitution - insanely useful for stripping off paths or extensions from filenames, for setting default variables if they're not explicitly set by something else, string handling, providing sensible error messages, so much good stuff.  Have a look at these links for more information: http://www.tldp.org/LDP/abs/html/parameter-substitution.html http://www.cyberciti.biz/tips/bash-shell-parameter-substitution-2.html shellcheck.net .  Paste your shell script (or sections of it) into this tool, and it will tell you a...
Read more

Data Guard with Transparent Application Failover (TAF)

One of the problems with Data Guard is that even after switching/failing over to the standby database, all clients need to be reconfigured to communicate with the new primary. The simplest way to achieve this (if using a centralised tnsnames.ora ), is to modify the file and  add the line " (FAILOVER=YES) ",  and either multiple ( DESCRIPTION=...) or (ADDRESS=...)  lines, one for each of the standby systems, in the order that the client should attempt connections . This tells the client to try each address in turn until one succeeds. Doing so provides basic failover functionality within Oracle Net, and will probably function correctly most of the time.  Though be aware - because both primary and standby can share the same instance name (e.g. the same SID, therefore the same connection string), there is potential for this simple scheme to go wrong. An example in an active data guard environment (where the standby is open read only): a temporary network issue cau...
Read more