Delphix is now available for 30 day trial direct download ! ( if you would like a longer version please contact me at firstname.lastname@example.org year trials and even indefinite trials potential possible for partners, bloggers, Oracle Aces etc)
Just got to the
Delphix home page delphix.com and click the “Free Trial”
I’m sitting here watching the import of a moderately sized database via transportable tablespaces. You know…the thing you use when a full export / import would be too slow, and this is meant to be … well…fast.
And fast it is.. until it reaches the following step:
Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS
Now understandably, there’s plenty of stats to import, so its fair that it should take a little while. But a quick look (more...)
I will be talking at my daughter’s high school for career day on Monday, explaining my job as an Oracle Database Administrator. Wish me luck!
The funny thing is that no one understands what Oracle DBAs do, unless they are one or work closely with one. I have a feeling that my talk is going to fall flat, but if it helps one of the students in any way it will be worth (more...)
Data virtualization solutions also known as Copy Data Management (CDM), Copy Data Virtualization (CDV) and Data Virtualization Appliances (DVA) are rising rapidly as over 100 of the Fortune 500 have adopted data virtualization solutions between 2010 and end of 2014. Adoption is hardly surprising given that data virtualization reduces the time to provision copies of large data sets from days down to minutes and eliminates most of the space required (more...)
We had an interesting issue on 184.108.40.206, where users were reporting very slow performance on queries to external tables. When I tried to replicate the problem, everything seemed just fine, so I initially reported back the familiar "Well, it works on my PC" :-) [Just kidding]
Anyway, connecting by proxy to one of their accounts, did reveal the error, which suggested something to do with privileges. A sql trace revealed that (more...)
Flashback feature of Oracle database has been of interest to me since its inception in 9i. Thank you OTech Magazine for publishing my article on Flashback in the winter edition. Read the article here. There are several excellent articles in this edition of the Magazine. More than 100 pages of tech content. Don’t miss!! Merry Christmas! […]
Innovation in Managing the Chaos of Everyday Project Management discusses our strategy for leveraging the content management and collaboration features of Oracle WebCenter to enable project-centric organizations to build and deploy a project management portal. This solution was designed especially for groups like E & C firms and (more...)
NoSQL and Big Data are “disruptive innovations” in the sense used by Harvard professor Clayton M. Christensen. In The Innovator’s Dilemma: When New Technologies Cause Great Firms to Fail, Christensen defines disruptive innovations and explains how they eventually lead to the failure of the established players who ignored them:
“Generally, disruptive innovations were technologically (more...)
This article is about the importance of appropriately simplistic architectures. I frequently get involved with the creation of full-stack architectures—in particular the architecture of the database platform. There are some golden rules when designing such systems, but one of the most important ones is to keep the design as simple as possible. This isn’t a performance enhancement; this is an availability enhancement. Complexity, after all, is the enemy of availability.
Tim Gorman is a technical consultant for Delphix (http://www.Delphix.com), who enable database and storage virtualization to increase the agility of IT development and testing operations. He has co-authored six books, tech-reviewed eight more, and written articles for RMOUG SQL_Update and IOUG SELECT magazines. He has been an Oracle ACE since 2007, an Oracle ACE Director since 2012, a member of the Oak Table Network since 2002, and has presented at Oracle (more...)
Sorry it’s taken a couple of days to finish off this series of blog posts on UKOUG Tech 14. I had expected to get some time on the trip back to write this, but as you’ll see if you keep reading, that really didn’t happen. So let’s go back to Day 3 of the conference.
I started the day by attending Patrick Hurley’s “Adventures in Database Administration” session. This was quite different to the normal (more...)
Anyone that has ever coded PLSQL will be familiar with the error ORA-4068, where you had some state persisted in a session due to a package variable, and then when you change the package, the state is cleared along with an ORA-4068. Here’s a quick example:
SQL> create or replace
2 package PKG is
3 procedure P;
SQL> create or replace
2 package body (more...)
Too many programmers think that their job is to write code. It isn’t.
The job of the programmer is to help the business solve a problem using appropriate technology for the task at hand. The programmer knows (or should know) the available tools and will hopefully select the right one for the task.
Unfortunately, too many programmers suffer from framework-phobia and don’t trust any code they have not written themselves. That takes more time, causes more (more...)
Day 2 of the UKOUG Tech 14 conference for me started with the second session (I spent the first session typing up the blog post on Day 1 as there wasn’t a presentation I was interested in). Tammy Bednar was presenting on “Creating a Test / Dev Database in Minutes Using the Oracle Database Appliance”. Tammy is another old timer at Oracle. Like myself and Maria Colgan, she has been an Oracle employee for 20 (more...)
You can follow datainstaller and hrglobal apply process from here
sqlplus -s APPS/***** @/u01/EBSUAT/apps/apps_st/appl/per/12.0.0/patch/115/sql/hrrbdeib.sql 2 4
ERROR at line 1:
ORA-04091: table HR.FF_USER_ENTITIES is mutating, trigger/function may not see
ORA-06512: at “APPS.FFDICT”, line 1224
ORA-06512: at “APPS.FFDICT”, line 1901
ORA-06512: at “APPS.FF_USER_ENTITIES_BRI”, line 7
ORA-04088: error during execution of trigger ‘APPS.FF_USER_ENTITIES_BRI’
ORA-06512: at “APPS.HRDYNDBI”, line 5446
ORA-06512: at (more...)