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.
A colleague (more...)
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 (more...)
I noticed the error message when running lsinventory against a 22.214.171.124 Oracle_Home. As the command worked I didn’t think anymore of it until on the same server against an 126.96.36.199 home I got the same error message.
tr: extra operand `y'
Try `tr --help' for more information.
/app/oracle/product/188.8.131.52/dbhome_1/OPatch/opatch: line 384: [: =: unary operator expected
There is a Mos note which provides a solution (more...)
I recently found out that it is possible to change a database link password without dropping and recreating a database link in its entirety.
To be honest I thought this might have existed forever and I had just never come across it but it actually come out in 11GR2
The ALTER DATABASE LINK statement can be used and you do not need to specify the target service either – all you need is to run (more...)
I recently saw the following command in a script that was to be run and thought an error had been made and the power level should have been 5 not 500.
ALTER DISKGROUP DATA REBALANCE POWER 500;
Upon doing some research it was not a mistype but a new method of disk balancing which came in from 184.108.40.206
Previously setting the power limit from 0 to 11 basically caused an additional number (more...)
Stopping one ASM listener in Flex ASM environment takes down ASM instance
This is a heads-up about behaviour we are seeing during OAT testing on a 12c environment. We are running OAT tests on a new 220.127.116.11 Grid Infrastructure environment using Flex ASM (OEL 5.8) and when taking down one of the two ASMNETLSNR listeners on one of the nodes, the ASM instance running on that node is taken down. We (more...)
To be honest it was asked 2 years ago in a blog about ASM and rebalancing and someone asked the following question
Can I upgrade ASM from 10205 to 11203 while ASM rebalancing is in progress?
and the answer, unsurprisingly, was
Why would anyone even think of asking that question never mind contemplating the idea of running an upgrade under such circumstances.
Needless to say my next blog post is about ASM related activities (more...)
Nobody can say that I am not current and topical with my posts. This post refers to functionality that was introduced in 9i, however I have just come across it and thought it useful enough to blog about it.
The command ALTER USER USERB GRANT CONNECT THROUGH USERA allows a proxy connection to be made using the username and password of USERA but to connect in as USERB. The purpose is so that management of (more...)
This was sent to me for posting by my friend and ex-colleague Vitaly Kaminsky ….
I have recently worked with the customer where standard RMAN backups of production 2-node cluster (18.104.22.168) were getting too big and taking longer than 24 hours to run.
The problem with this particular cluster was the fact that ALLOCATION of RMAN connections to the instances of the cluster was controlled by SCAN and driven by the load-balancing (more...)
I will start this post off stating that I know there are better and more efficient methods of doing this but this is the best method I could come up with.
I had a csv file with a number of columns, one of which was data in a timestamp with timezone format.
A few rows looked like this – note I have stripped the other columns out for ease of display.
7941 11/9/2014 (more...)