A nice list this holiday season…Top 10 Takeaways on Oracle WebCenter 12c, The Cloud, and User Experience from OpenWorld 2015

Source: https://www.pinterest.com/pin/154389093449771355/

Everyone likes lists. They are easy to follow, easy to cross off, and easy to add to. And since it is the holiday season, and you are (hopefully) putting the finishing touches on your gift giving or meal preparation lists, I thought what better way to summarize what we learned from Oracle OpenWorld 2015 in a Top 10 list. However, one caveat to that is these are not listed in any particular order, and they (more...)

TurboTax Bug

It was quite annoying to find that TurboTax couldn’t send me a text message to confirm my order of a second state. However, I made the mistake of clicking the “Confirm my account a different way (takes longer)” radio button to get to their web page.

After I got two-step verification enabled on their web site, now it’s impossible to order the second state software. It appears that once you click that button, the software (more...)

Github Repository

I am experimenting with Github. I have created a repository for my Oracle database related scripts. Here is my Github URL: https://github.com/bobbydurrett/dba.git

You can clone this repository locally if you have git installed using this command:

git clone https://github.com/bobbydurrett/dba.git

I’ve had challenges before when I write a blog post about a script and then revise the script later.  It seems weird to update the post with links to the new version.  So, I’m thinking of (more...)

Action Links in OBIEE 12c – Part 2

Introduction and Scenario

Part 1 of this series on Action Links had us creating a simple navigate action and left us in suspense with the promise of a new means by which to filter one report from another. Now time to deliver! The scenario: say we’ve got a company dashboard that is pretty locked down in terms of adding any new user-facing content, and as a developer you occupy more of an analyst role where (more...)

Enterprise Manager 13c Upgrade

My goodness me it’s been a long time since I updated here. As it’s nearly the season for New Years resolutions I thought I’d make one early and start updating again. This post is inspired by the release on Friday of Oracle Enterprise Manager 13c. Already there’s a nicely screenshotted How to Upgrade article by @gokhanatil . Step […]

Non-intrusive tracing

Earlier this year I’ve already touched upon the subject of so called “Observer effect” – impact that the act of observation makes upon the observed process – applied to the database world.  In this blog I’d like to expand on this subject a little bit, and discuss one way to minimize this effect using OS observability tools.

Traditional tools

All tools that we use to obtain diagnostic information about database processes are intrusive to some (more...)

Recruiting for DBAs

My team has vacancies for several permanent DBAs. We are a supermarket chain based in Bradford, West Yorkshire.

The estate is split between HPUX and Linux (mostly OEL but moving to RH). The oracle versions in production are primarily 11Gr1,11GR2 and 12c with a little 10g, all managed through OEM

The key requirements are knowledge of DataGuard, RMAN and RAC.

It is an interesting site and we do a lot of work looking at new (more...)

How Fishbowl’s Enterprise Support Program Keeps Your WebCenter System Running Smoothly

JohnFishbowl introduced our Enterprise Support program during the summer of 2014, and since then we have helped numerous customers keep their WebCenter environments running smoothly. Enterprise Support Engineer John Lundgren often talks with WebCenter users who are interested in Fishbowl’s support program. He recently created a list of FAQ’s for those who are considering Fishbowl’s product support or in supplementing their Oracle maintenance agreement with Fishbowl’s enterprise support.

 

Q: What kinds of support does (more...)

ORA-39070: Unable to open the log file

RSS content

I received this error message when I was trying to perform a data pump export of SH schema in parallel in a RAC database. I proceeded as follows:

Current scenario:
Name of the cluster: cluster01
Number of nodes : 3 (host01, host02, host03)
RAC Database version: 11.2.0.3
Name of RAC database : orcl
Number of instances : 3

  • Created a directory object  pointing to shared storage which is accessible by all (more...)

Testing software: 5 tips from Devoxx- speakers

In software development testing is vital. At Devoxx Belgium 2015 several experts formulated useful tips for the creation and use of such tests:

#1 Use graphs to monitor behavior

Lorin Hochstein, Senior Software Engineer at Netflix showed a graph with the typical use of the services of Netflix: most users watch videos and series in the evening, while there is less activity during the day and at night. If the graph does not follow this (more...)

WordPress and Docker

One of the attractive things about Docker to me, is that I can spin up containers with software that doesn’t affect the rest of my system. I can spin down the container, remove the container, make multiple containers. It’s all nice neat and clean unlike traditional application installation on an OS where files are spewed all through the file system and it’s a  mess to try and clean it it up and/or remove it if (more...)

Docker and Delphix architectures

In my last post I showed using Docker and Delphix to support WordPress.

I use wordpress for this blog. Works fine on it’s own. It is just me making a few posts here and there. Occasionally there are problems like an upgrade that goes bad or a hack that get’s some redirection code into the site. In those cases I have to go to a backup of my MySQL database that is used by wordpress (more...)

Relocation

I feel like I owe a big apology to my readers — not also I haven’t blogged anything for about half a year, but also I started a series and I haven’t finished it. But I have a good excuse. In September, I’ve moved to the UK. It’s a great place to be if you’re into databases — UKOUG is one of the strongest Oracle groups in the world, if not the strongest one. And (more...)

ORA-24247: network access denied by access control list (ACL)

SQL> begin
send_mail(‘test’,’azarmohds@gmail.com’);
end;
2 3 4
5 /
begin
*
ERROR at line 1:
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at “SYS.UTL_TCP”, line 19
ORA-06512: at “SYS.UTL_TCP”, line 280
ORA-06512: at “SYS.UTL_SMTP”, line 163
ORA-06512: at “SYS.UTL_SMTP”, line 199
ORA-06512: at “SCOTT.SEND_MAIL”, line 8
ORA-06512: at line 2

This error message means that no access control list has been assigned to the host you (more...)

Oracle Forms is heading to the clouds and to UK!

As I have been preaching from my soapbox for years now, Oracle Forms will remain a constant, supported development tool to build on premise, enterprise level, data entry desktop applications. However this time, Oracle has joined me by declaring their commitment to Oracle Forms, as Oracle Forms 12c was released on the heels of OOW. Oracle Forms 12c can be downloaded here. Our customers and team have been anticipating Oracle Forms 12c, and it is great to finally have it available.

It’s (more...)

Docker Data Containers

10921784526_e02cfdd9ab_z

photo by  www.GlynLowe.com

One challenge with Docker is having persistent storage for a container especially when that container gets restarted on another VM host and we want it to point to the same data. If we add in Delphix with Docker we can easily move persistent data and a docker container to a new host.

For the docker container we will use wordpress that leverages a MySQL database for it’s persistent datastore.
In this example I (more...)

OPatch bugs when applying Grid Infrastructure 12.1.0.2.5

For one of my clients, I experienced several issues with applying PSU 12.1.0.2.5 with opatch 12.1.0.1.9.

There were some code changes in opatchauto, which are not yet production-ready. I am looking forward to seeing a new opatch release (maybe 12.1.1.10 or 11) which has these issues fixed.

  • Bug 22091017 : OPATCHAUTO -ANALYZE COMMAND SHUTS DOWN THE RDBMS HOME IN 12C
    “opatchauto apply -analyze” is (more...)

Actively Manage Your OMR with EMDIAG

Oracle provides the OMR analysis tools EMDIAG and repvfy so we can perform detailed management repository analysis and maintenance just like the pros.

Werner de Gruyter (Yoda), the father and caretaker for EMDIAG, has provided a custom Information Publisher report that you can use to manage your system on a regular basis.

Create EMDIAG Report

EM CLI allows you to create an IP report by importing an XML definition of the report.  Create and save the XML (more...)

Update hinted for wrong index

I worked with our support team to improve the performance of a PeopleSoft Financials update statement yesterday. The update statement had an index hint already in it but the index was not the best one of the available indexes.

Here is the original update statement:

UPDATE /*+ INDEX(B PSCPYMNT_VCHR_XREF) */
 PS_PYMNT_VCHR_XREF B
 SET BANK_SETID = :1,
 BANK_CD = :2,
 BANK_ACCT_KEY = :3,
 PYMNT_METHOD = :4,
 BANK_ACCT_SEQ_NBR = :5,
 EFT_LAYOUT_CD = :6,
 STL_THROUGH = :7
 WHERE  (more...)

Oracle OpenWorld 2015: The Developer’s Overview

Last week was Oracle OpenWorld in San Francisco, California, and a huge week for me and our whole team at AuraPlayer.  Our week began on Sunday when I presented my “Mobile / Cloud Buzz Words for Dummies” to over 120 people eager learn how to start their mobile journey. But in fact they weren’t! I was shocked to find out, by a show of hands, that only 3 people in a room of over (more...)