Two posts from me on the same day. The other one about Datapatch is about a brand new utility in 12c and is probably new to most people. This post caused mixed reactions when I mentioned it at work last week. Some people laughed at my naivety in not knowing about it, others took the same view as me and were interested to hear about it as it may prove useful one day.
There have been a few changes in the way patches are managed and monitored in 12c and whilst looking at this I found a potential problem that might occur when you clone or copy databases around, or even build them from a template file.
Firstly when you apply a PSU and run an opatch lsinventory command you now see a description of the patch rather than just a patch number – here showing that PSU 1 has been applied. This came in at 220.127.116.11 and in my opinion is really helpful.
Oracle 11gR2 RAC Grid install includes a useful script that can be used to make your life easier no more copying and waiting for errors the above scripts will make your easier simply../sshUserSetup.sh useful script to establish and exchange ssh keys between all the nodes of the cluster called sshUserSetup.shAnd Can Be Used like the below :-./sshUserSetup.sh -user oracle -hosts "node1 node2" -noPromptPassphrase
The annual Oracle User Group in Ireland Conference will be on Thursday 19th March. This year the conference will be held in the Croke Park conference centre. This conference centre is only a short taxi ride from Dublin Airport and Dublin City Centre. If you are planning a hotel stay for the conference I would recommend staying in a hotel in the city centre and get a taxi to/from the conference venue.
Steven Feuerstein runs a great site at PL/SQL Challenge that is just another way for developers to stay up to date with their knowledge of PL/SQL, SQL and database design with a bit of fun.
PL/SQL championships are held quarterly, but the less frequent SQL and Database Design quizzes are currently held annually. Thanks to persistence and maybe a bit of experience, I was eligible to compete in both.
Have you seen your VNC Viewer showing a black screen intermittently ? We have a fix for it. This issue has been occurring in our lab servers for a few students intermittently since the past few months on Oracle Linux server 6.5 release.
The VNC Viewer desktop background turns into a full black screen intermittently. It does not happen all the time and one of our
Wow I had a great time presenting at RMOUG 2015. The room was absolutely packed and I felt presentation went pretty well ( so let's see what the evaluation numbers show ).
Here is a link (Final version presentation and supporting files ) to zip file containing the final version of the presentation as well the script and sql file shown at the end of the presentation. Please let me know if anyone has any problems using this and sorry I thought I would get this updated and available Thursday.
Thanks so much to RMOUG!