Martins Blog

Powered by
WordPress

  • UKOUG RAC&HA SIG September 2010

    Just a quick one to announce that I’ll present at said event. Here’s the short synopsis of my talk: Upgrading to Oracle Real Application Cluster 11.2 With the end of premier support in sight mid 2011 many business start looking at possible upgrade paths. With the majority of RAC systems deployed on Oracle 10g, there…

  • Content theft on my blog

    I have received an email today from Don Burleson who informed me that a number of my articles have mysteriously appeared on another weblog hosted by wordpress on the name of http://gjilevski.wordpress.com/.  For instance: My post: https://martincarstenbach.wordpress.com/2010/01/21/upgrade-clusterware-10-2-to-11-2/ has reappeared as http://gjilevski.wordpress.com/2009/11/24/upgrade-oracle-crs-10-2-to-oracle-grid-11-2/. Even the host names are identical! The next one is a bit better as…

  • It has gone really quiet!

    Yes, it has, and I’m really sorry but at the moment all the blog writing has to take a lower priority. I am working very hard to finish my chapters of the upcoming  Pro Oracle Database 11g RAC on Linux, which turned out to be a lot more work than I expected. The last chapter…

  • Where are the logs for the SCAN listeners?

    Quick post and note to self. Where are the SCAN listener log files? A little bit of troubleshooting was required, but I guess I could have read the manuals too. In the end it turned out to be quite simple! First of all, I needed to find out where on my four node cluster I…

  • crsctl status resource – state details are really useful

    A very short post about a cool new feature I noticed today. RAC 11.2 has moved a lot of commands previously having their own syntax into crsctl. One of the cool new things is the fact that crsctl status resource -t (“tabular”) reports state details. Here I could see that my lab environment had a…

  • Display scheduler class for a process in linux

    The ps command in the ways I use it most (ps -ef and ps auxwww) doesn’t display the scheduling class for a process. Oracle have cunningly released a patchset to update Grid Infrastructure that changes the scheduling class from the VKTM and LMSn ASM processes to “Timeshare” instead of Realtime. So far so good, but…

  • orapki 11.2 bug when password complexity is too low

    I am currently experimenting with SSL encryption for ONS, an 11.2 new feature. My system is OEL 5.5 64bit with PSU 11.2.0.1.1 installed on the stack. Apart from the poor documentation, the orapki tool that can be used to create self-signed certificates for testing has a bug in 11.2. There is also a documentation bug…

  • Incrementally gathering statistics in 10g

    One of the cool new features of the Oracle 11g database is that you can copy statistics and incrementally gather global stats for rlt (really large tables). I wanted to do some testing around these features in 10.2.0.4 but ran into a number of problems. So this is the story…. I have decided to split…

  • RAC SIG June 2010

    Good morning all! Just wanted to put up a quick note about the upcoming UKOUG RAC SIG in June. This is going to be a really good event showing some of the most prominent members of the Oracle community: Harald Van Breederode Joel Goodman Julian Dyke From an infrastructure point of view Simon Haslam is…

  • The difference between a direct grant and a role in PL/SQL

    This is a quick post about beginning Oracle PL/SQL development. Long story short, there is a difference between invoker rights and definer rights in the way they respect role grants: Fun story: I helped troubleshoot a case of what appeared to be stubborn PL/SQL. The developer asked why the procedure wouldn’t compile. Oracle threw an…