Just a stupid error. Posting it so that someone else googling for the same thing can get a clue.
An ASM instance running with default parameters (no pfile, no spfile). Updated spfile for the instance with asmcmd spset command and bounced crs. After reboot also, it still wasn’t using spfile. Got puzzled and checked GPnP settings again. All looked good. Then in alert log came across this
ERROR: SPFile in diskgroup <> does not match (more...)
(Disclamer: any opinions expressed here are fully my own and not representative of my employer)
photo by alvaroprieto (cc 2.0)
Super excited to be working at Amazon on my passion which is performance data visualization and database monitoring. Suffice it to say this is the most excited I’ve been about work in my career and I’ve had ample opportunity to work on database performance in the past such as at (more...)
Just a short post to announce that I’ll be presenting an User Group Forum session. Thanks ODTUG!
SQLcl: A Modern Command Line Interface to the Oracle Database [UGF5641]
“In this session learn about the new Java-based command line interface that takes advantage of Oracle SQL Developer’s scripting engine. It delivers a modern command line interface that is backward compatible with SQL*Plus but also introduces new commands and features that have been missing for a long (more...)
In Oracle 11G, DG Broker needed to be told whether the standby database was physical or logical. The command to add database in 11G was something like this:
ADD DATABASE <DB Unique Name> AS CONNECT IDENTIFIER is <TNS Descriptor>
MAINTAINED AS [PHYSICAL|LOGICAL];
Oracle 12c is definitely smarter and can figure it out on its own. The “ADD DATABASE” syntax is simpler:
DGMGRL for 64-bit Windows: Version 188.8.131.52.0 – 64bit Production
Synthetic full backup is a method for combining incremental backup into a full backup. It is not a new thing, many backup utilities can do that with file system backups. It is also well described:
However, there is only one backup suite that can do that with Oracle RDBMS: Commvault 11.
How is it done? Well, Commvault is a very well documented tool, the documentation is here:
Having take a new job at Amazon just two weeks ago and moving to Seattle (!) I didn’t have the time nor was it practical to set up Oaktable World this year. Luckily Kelly Pot’vin has taken over the mantel !
Get the info straight from the horses mouth at her blog.
The following content has been graciously supplied from Kellyn’s blog:
Oak Table World is FREE to the PUBLIC! We don’t require an (more...)
Tuesday, September 20, 2016
5:00 PM to 7:00 PM
138 Minna Street, San Francisco, CA (map)
Oracle OpenWorld is a time for us to join together and learn all about what Oracle has to offer. But let’s get real, it’s always nice to get free beer. To help show us a good time here in San Francisco, our good friends in the Oracle ADF and Database developer group are planning a Oracle Developers (more...)
It’s frustrating to have to spend time jumping off into web security and wordpress configurations when there are so many other things that are important to be doing. Today the DoS continued and the Jetpack solution didn’t seem to work. The other two solutions from Digital Ocean didn’t seem reasonable. One was to re-install wordpress with there install version. Nice that they offer a better security protected version but I didn’t feel like re-installing my (more...)
This site had been running for a years with no big issues.
I had performance and system saturation issues about 3 years ago and then move the site to DigitalOcean.com.
They are inexpensive and the performance is awesome.
Then last Monday and every day since the site had been going down.
Simplest “solution” for me was just to get on and bounce the machine.
That cleared it up.
After this went on for a (more...)
Session ID: UGF3110
Advanced Active Session History Analytics
09/18/16, 03:30:00 PM – 04:15:00 PM
set last_posting_date = date'2016-08-18';
It’s been a while since I’ve published here. You see, I’ve been kind of busy.
Back in January 2015 I was lucky enough to join Oracle as part of their Developer Advocate team. My focus is SQL.
You see I love working with SQL. And I love helping others. So joining the Developer Advocates was a great chance to combine these passions :)
Which leads some to ask:
Why is your site (more...)
I’ve been really busy last few months – except spending a lot of time on M25 I’ve been doing a lot of Exadata installations and consolidations. I haven’t posted for some time now but the good news is that I got many drafts and presentations ideas.
This is a quick post about an issue I had recently. I had to integrate AD authentication over Kerberos on the compute nodes (blog post to follow) but had (more...)
On the 28th of July, I presented this topic at Kscope16. It was a great conference and if you ever have the chance to visit, definitely do so.
This is a blog not related to Oracle products in any way.
This post is specific to apple Airport Extreme and Express wifi routers. However, in general: if you have multiple (unix/linux) servers, it makes sense to centralise the (sys)logging of these servers, in order to get a better overview on what is happening on these servers. I would want to go as far as saying that if you don’t you are simply (more...)
We are excited to announce AuraPlayer has been shortlisted for UKOUG’s 2016/2017
Digital Transformation Partner of the Year! This award provides recognition to Oracle Partners for their contributions to Oracle users by promoting digital transformation.
It has been such an incredible year watching our customer’s applications change from gray screens nailed onto a desktop to cutting-edge mobile applications. Digital transformations have been occurring in all industries including field service, public-sector and retail. We are so (more...)
My kitchen has a very nice range hood over the cooktop. It has a powerful fan and beautiful brushed steel finish. And it has a user experience like most IT systems: Lousy.
Let’s think about what a range hood does. It has two main functions:
- Start the fan to extract grease and fumes
- Turn on the light over the cooktop
Because of the shape of a range hood, the buttons to operate it are typically (more...)
In this video blog, Fishbowl Solutions’ Technical Project Manager, Justin Ames, and Marketing Team Lead, Jason Lamon, discuss Fishbowl’s Agile (like) approach to managing Oracle WebCenter portal projects. Justin shares an overview of what Agile and Scrum mean, how it is applied to portal development, and the customer benefits of applying Agile to an overall portal project.
“This is my first large project being managed with an Agile-like approach, and it has made (more...)
When a query contains a regular or inline view, there are 3 basic strategies for the optimizer to choose from:
1) merge the view (no “VIEW” operation in the plan)
2) instantiate the view as the whole and join it to the rest of the query (the plan shows a VIEW “operation”)
3) push join predicates inside the view (the plan shows “VIEW PUSHED PREDICATE”).
The last strategy in that list is similar to a (more...)
In my previous post I showed an example of how a query’s performance can be improved using the waste minimization technique. My focus was primarily on identifying and enforcing the correct plan, but I received some questions regarding the root cause of the problem: why the optimizer came up with a wrong join order? It’s a very interesting question, and it deserves a separate post so that it could be explored in detail.
Let’s take (more...)