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...)
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...)
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...)
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...)
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 […]
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.
All tools that we use to obtain diagnostic information about database processes are intrusive to some (more...)
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...)
Fishbowl 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...)
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:
Name of the cluster: cluster01
Number of nodes : 3 (host01, host02, host03)
RAC Database version: 18.104.22.168
Name of RAC database : orcl
Number of instances : 3
- Created a directory object pointing to shared storage which is accessible by all (more...)
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...)
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...)
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...)
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...)
2 3 4
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...)
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.
For one of my clients, I experienced several issues with applying PSU 22.214.171.124.5 with opatch 126.96.36.199.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 188.8.131.52 or 11) which has these issues fixed.
Bug 22091017 : OPATCHAUTO -ANALYZE COMMAND SHUTS DOWN THE RDBMS HOME IN 12C
“opatchauto apply -analyze” is (more...)
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...)
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) */
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
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...)