Skip navigation.

Feed aggregator

Sometimes it is just a coincidence!

Tim Hall - Sat, 2014-05-10 07:35

Yesterday I was making a small config change to some test WebLogic domains. The change required a restart, so that’s what I did. The domains didn’t start up properly…

Being the last person to change the config, it was obviously something I had done that had broken them. I did the usual stuff of checking the log files and noticed some messages about not being able to write to a swap file. I did a “df -h” and noticed the mount point for the WebLogic installation was full. A quick bit of clean-up and everything started up fine.

So the moral of this story is one of the following:

  • Sometimes it is just a coincidence.
  • Don’t forget to configure your log rotation properly.
  • Never change anything in case it screws up and you get the blame.
  • “Just blame it on the guy who doesn’t speak English. Ahh, Tibor, how many times you’ve saved my butt.” ref

Cheers

Tim…

Sometimes it is just a coincidence! was first posted on May 10, 2014 at 2:35 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Revert R12.1.3 Homepage Layout to Link Style as in R12.1.1 or 11i

OracleApps Epicenter - Wed, 2014-05-07 04:35
If you are using R12.1.2 , user may report some difficulty with Homepage responsblity , therefore they prefer similar to 11i or R12.1 In release 12.1.2 the E-Business Suite homepage has been re-designed using the configurable pages infrastructure. This is new Enhancement which allows customers to work with a WYSIWYG model of configuration. This allows [...]
Categories: APPS Blogs

April 2014 CPU

Paul Wright - Tue, 2014-04-29 16:54
Hi Oracle Security Folks, Thanks to Oracle for fixing a batch of research I sent over in August 2013 regarding ADVISOR, DIRECTORIES, GAOP(GRANT ANY OBJECT PRIVILEGE) and also a critical privilege escalation which gains 8.5 in the CPU which I am not going to publish here as I want to give folks time to patch. [...]

Oracle 11gR2 and 12cR1 on Oracle Linux 7 beta

Tim Hall - Mon, 2014-04-28 12:00

I’ve been having a play with Oracle Linux 7 beta over the weekend. Not surprisingly my first thoughts were to install the Oracle database on it.

As expected, the installations were almost identical or Fedora 19.

I’ve put a warning on the front of the OL7 articles, but I’m sure it won’t stop some Muppets using it in production then trying to blame me. :)

I don’t know how long it will be until OL7 goes to production and I’m sure it will be a long time before anything is certified against it, but it’s always nice to see what’s coming… :) I’ll update the articles when anything significant happens…

Cheers

Tim…

Oracle 11gR2 and 12cR1 on Oracle Linux 7 beta was first posted on April 28, 2014 at 7:00 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Nationwide Deploys Database Applications 600% Faster

Pankaj Chandiramani - Mon, 2014-04-28 03:37

Nationwide Deploys Database Applications 600% Faster





Heath Carfrey of Nationwide, a leading global insurance and
financial services organization, discusses how Nationwide saves time and
effort in database provisioning with Oracle Enterprise Manager
.


Key-points :



  1. Provisioning Databases using Profiles  (aka Gold Images)

  2. Automated Patching

  3.  Config/Compliance tracking




Categories: DBA Blogs

EMCLI setup

Pankaj Chandiramani - Mon, 2014-04-28 02:15

A quick note on how to install EMCLI which is used for various CLI operations from EM . I was looking to test some Database provisioning automation via EMCLI and thus was looking to setup the same . 


EMCLI Setup
To set up EMCLI on the host, follow these steps:
1.    Download the emcliadvancedkit.jar from the OMS using URL https://<omshost>:<omsport>/em/public_lib_download/emcli/kit/emcliadvancedkit.jar
2.    Set your JAVA_HOME environment variable and ensure that it is part of your PATH. You must be running Java 1.6.0_43 or greater. For example:
o    setenv JAVA_HOME /usr/local/packages/j2sdk
o    setenv PATH $JAVA_HOME/bin:$PATH
3.    You can install the EMCLI with scripting option in any directory either on the same machine on which the OMS is running or on any machine on your network (download the emcliadvancedkit.jar to that machine)
java -jar emcliadvancedkit.jar client -install_dir=<emcli client dir>
4.    Run emcli help sync from the EMCLI Home (the directory where you have installed emcli) for instructions on how to use the "sync" verb to configure the client for a particular OMS.
5.    Navigate to the Setup menu then the Command Line Interface. See the Enterprise Manager Command Line Tools Download page for details on setting EMCLI.



Categories: DBA Blogs

RHEL7 and Oracle Linux 7 beta

Tim Hall - Wed, 2014-04-23 03:15

Nearly two weeks ago, Oracle announced the Oracle Linux 7 Beta 1. Being the Linux fanboy I am, I downloaded it straight away from here.

Oracle Linux is a clone of the Red Hat Enterprise Linux (RHEL) distribution. The RHEL7 beta, and therefore OL7 beta, distro is based on a cut of Fedora 19, although depending on who you ask, it’s possibly more a mix of Fedora 18, 19 and 20… Suffice to say, there are a lot of changes compared to the RHEL6/OL6 distribution.

As I’ve mentioned several times before, my desktop at home is running Fedora 20, so I’m pretty used to most of the changes, but I’ve not written much about them, apart from the odd blog post. It’s not a high priority for me, since I’m not a sysadmin, but I’ll be updating/rewriting a few of the Linux articles on the site to include the new stuff.

When Surachart Opun mentioned having to look at systemd and firewalld, it seemed like the perfect opportunity to update my firewall and services articles. You can see the new versions here.

RHEL7/OL7 is only in beta, and even after the production release I’m sure it will be a long time before Oracle actually certify any products against it, but if you are not a Fedora user, it’s probably worth you having a play around with this stuff.

Cheers

Tim…

RHEL7 and Oracle Linux 7 beta was first posted on April 23, 2014 at 10:15 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Some new Oracle Database 12c Articles

Tim Hall - Tue, 2014-04-22 12:18

I’ve recently put some new Oracle 12c articles on the website.

The privilege usage stuff is really cool. Normally, trying to figure out what you can remove from a user is always a complete pain in the ass. Some of the databases I’m currently working with have used GRANT like it’s going out of fashion. Trying to identify what is really necessary is a tough job. Features like this are going to be hard to wait for…

Cheers

Tim…

 

Some new Oracle Database 12c Articles was first posted on April 22, 2014 at 7:18 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Divergent

Tim Hall - Mon, 2014-04-21 17:16

I’ve just got back from watching Divergent. It is a really good film!

Don’t believe any bullshit comparisons to that crappy Hunger Games. It is so much better than that rubbish! It’s probably a good idea not to read any summaries of the plot either, since it sounds kind-of stupid on paper. In the film it makes a lot more sense and just works.

Very pleased I went to see it. One of the better Sci Fi/action films I’ve seen is quite a while. Much more worthwhile than that spider-thing…

Cheers

Tim…

Divergent was first posted on April 22, 2014 at 12:16 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

The Amazing Spider-Man 2

Tim Hall - Sat, 2014-04-19 13:26

I’ve just got back from watching The Amazing Spider-Man 2.

Wow, that is one seriously long film! At 2 hours and 22 minutes, it’s a good 1 hour and 22 minutes too long…

I guess there are two sides to this film:

  1. Action Scenes: During the action this films it is brilliant. Really over the top stuff. Bright, flashy and really cool.
  2. Everything Else : I don’t give a crap about character development in an action film. This re-imagining of the franchise is turning out to be even more whiny than the Toby Maguire version.

The film really could have been edited down massively and I would have come out agreeing with the film title. As it was, it’s “The Amazingly Long and Whiny Spider-Man Too!”

Cheers

Tim…

The Amazing Spider-Man 2 was first posted on April 19, 2014 at 8:26 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Running scripts in CDBs and PDBs in Oracle Database 12c

Tim Hall - Sat, 2014-04-19 09:23

You’ve been sold on the whole concept of the multitenant option in Oracle 12c and you are launching full steam ahead. Your first database gets upgraded and converted to a PDB, so you start testing your shell scripts and bang! Broken! Your company uses CRON and shell scripting all over the place and the multitenant architecture has just gone and broken the lot in one fell swoop! I think this will end up being a big shock to many people.

I’ve been talking about this issue with a number of people since the release of Oracle 12c. Brynn Llewellyn did a session on “Self-Provisioning Pluggable Databases Using PL/SQL” at last year’s UKOUG, which covered some of these issues. More recently, I spent some time speaking to Hans Forbrich about this when we were on the OTN Yathra 2014 Tour.

Today, I put down some of my thoughts on the matter in this article.

Like most things to do with Oracle 12c, I’m sure my thoughts on the subject will evolve as I keep using it. As my thoughts evolve, so will the article. :)

Cheers

Tim…

Running scripts in CDBs and PDBs in Oracle Database 12c was first posted on April 19, 2014 at 4:23 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Webcast: Database Cloning in Minutes using Oracle Enterprise Manager 12c Database as a Service Snap Clone

Pankaj Chandiramani - Thu, 2014-04-17 04:02

Since the demands
from the business for IT services is non-stop, creating copies of production
databases in order to develop, test and deploy new applications can be
labor intensive and time consuming. Users may also need to preserve private
copies of the database, so that they can go back to a point prior to when
a change was made in order to diagnose potential issues. Using Snap Clone,
users can create multiple snapshots of the database and “time
travel
” across these snapshots to access data from any point
in time.


Join us for an in-depth
technical webcast and learn how Oracle Cloud Management Pack for Oracle
Database's capability called Snap Clone, can fundamentally improve the
efficiency and agility of administrators and QA Engineers while saving
CAPEX on storage. Benefits include:



  • Agile provisioning
    (~ 2 minutes to provision a 1 TB database)

  • Over 90% storage
    savings

  • Reduced administrative
    overhead from integrated lifecycle management


Register
Now!


April 24 — 10:00 a.m. PT | 1:00 p.m. ET

May 8 — 7:00 a.m. PT | 10:00 a.m. ET | 4:00 p.m. CET

May 22 — 10:00 a.m. PT | 1:00 p.m. ET





Categories: DBA Blogs

KeePass 2.26 Released

Tim Hall - Wed, 2014-04-16 16:08

KeePass 2.26 has recently been released. I would suggest going with the portable version, which is an unzip and go application.

If you want to know how I use KeePass, check out my article called Adventures with Dropbox and KeePass.

Cheers

Tim…

KeePass 2.26 Released was first posted on April 16, 2014 at 11:08 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

MobaXterm 7.1 Released

Tim Hall - Wed, 2014-04-16 16:03

If you are using a Windows desktop, you need MobaXterm in your life! Version 7.1 has recently been released…

I know you think you can’t live without Putty, Cygwin and/or Xming, but you really can. Give MobaXterm a go and I would be extremely surprised if you ever go back to that rag-tag bunch of apps…

Cheers

Tim…

PS. Includes “Updated OpenSSL library to 1.0.1g (for “Heartbleed Bug” correction)”

MobaXterm 7.1 Released was first posted on April 16, 2014 at 11:03 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

WordPress 3.9 Released

Tim Hall - Wed, 2014-04-16 15:20

Hot on the heels of WordPress 3.8.3 comes WordPress 3.9! The downloads and changelog are in the usual places.

I’ve just manually initiated the auto-update on five blogs and all went through OK.

Cheers

Tim…

WordPress 3.9 Released was first posted on April 16, 2014 at 10:20 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

WordPress 3.8.3 – Auto Update

Tim Hall - Tue, 2014-04-15 01:53

WordPress 3.8.3 came out yesterday. It’s a small maintenance release, with the downloads and changelog in the usual places. For many people, this update will happen automatically and they’ll just receive and email to say it has been applied.

I’m still not sure what to make of the auto-update feature of WordPress. Part of me likes it and part of me is a bit irritated by it. For the lazy folks out there, I think it is a really good idea, but for those who are on their blog admin screens regularly it might seem like a source of confusion. I currently self-host 5 WordPress blogs and the auto-update feature seems a little erratic. One blog always auto-updates as soon as the new a new release comes out. A couple sometimes do. I don’t think this blog has ever auto-updated…

I’d be interested to hear if other self-hosting WordPress bloggers have had a similar experience…

Cheers

Tim…

WordPress 3.8.3 – Auto Update was first posted on April 15, 2014 at 8:53 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

OUGN : Summary

Tim Hall - Sun, 2014-04-06 02:33

With the exception of a 5+ hour layover in Amsterdam, the trip home was pretty straight forward. I flew to Amsterdam with Lonneke DikmansRonald Luttikhuizen and Roel Hartman. During my rather excessive layover, I played catchup with all the internet stuff I missed during the trip… :)

I must say OUGN 2014 was a pretty cool event all round! The speaker lineup was incredible. The location (on a boat) was fun. I’ve not done that for a while. In addition to the presentations, I got a lot of time to talk to people about technology, which is what I love doing, so that made me happy…

Big thanks to the organisers of the event for inviting me and paying the bill for the boat and hotel room! Thanks to all the speakers and attendees that managed to put up with me for a couple of days. On a boat, there is nowhere to run! Thanks also to OTN and the Oracle ACE Program. They didn’t fund this trip for me, but I’m still happy to be flying the flag on their behalf. :)

Cheers

Tim…

 

OUGN : Summary was first posted on April 6, 2014 at 9:33 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

OUGN : Day 2

Tim Hall - Sat, 2014-04-05 09:22

Day 2 started really early. Having got to bed about 02:00, I was up at 05:30 and thinking about my 08:30 session. The previous evening’s conversation with Brynn was playing on my mind a little (in a good way), thinking how that conversation should/would affect my session. The session itself seemed to go well. I enjoyed it anyway. :)

From there it was more conversations with people, including a chat with Martin Bach, Martin Nash and one of the attendees (sorry, I forgot your name) about some Exadata issues he was having. I freely admit to knowing nothing about Exadata, but I do know about most of the technology stack that makes up Exadata (like ASM, RAC etc.). Since a number of the issues people have are not really “Exadata” issues, so much as “RAC” issues or “ASM” issues, it’s surprising how much you can get involved in these discussions, provided you don’t try to pretend to be something you are not!

After that I attempted to catch up on some sleep, which didn’t really work out, so then it was off to lunch.

After lunch it was time for an open database panel session. This is the first time they’ve done this sort of thing at this event, so I’m not sure what people expected, including us panalists. :) I think this sort of thing needs to run for a few conferences to let people get a feel for it, before you make a decision about whether it is going to work or not going forward. You have to give it an opportunity to mature… :)

After that it was off to Martin Bach‘s session on Oracle 12c, features that didn’t make the top 10. There were some things I already knew about and some things that passed me by. Food for thought!

Next up was Martin Nash speaking about what an Oracle DBA should know about Linux administration. I was pretty confident I was going to be so ahead of the game here, but he mentioned a number of things I’ve not played with. I’ll probably end up downloading his slides and working through some stuff.

Then it was my WebLogic session. Marcus Eisele did a session called WebLogic 101 in the morning and after a quick discussion I decided that we were effectively giving the same talk. I’m always a little nervous about doing WebLogic talks, but this made me even more nervous. As it turned out, with the exception of one person, I got a different crowd to him, so it was fine.

After my last session of the conference, I inevitably did some more chatting and then went off to see “Oracle Cloud Oddessy“. From there it was dinner, chatting to Mike Dietricht in the bar, then off to bed to sleep through the overnight ride back to OSLO.

Cheers

Tim…

PS. I think I got married to Debra Lilley by the ship’s captain…

OUGN : Day 2 was first posted on April 5, 2014 at 4:22 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

OUGN : Day 1

Tim Hall - Sat, 2014-04-05 09:03

The journey to Norway was pretty straight forward, but during the second flight, from Amsterdam to OSLO, my nose and eyes started to stream. I didn’t feel ill, but I was starting to worry I might be getting ill right before a conference. I landed in Norway, got the train to the centre of OSLO and walked to my hotel. I was meant to go out to dinner, but I figured bed might be a better option…

The next day we met up and headed off to the boat to begin the conference. After boarding, we went to the keynotes. Since these were in Norwegian, a few of use ended up at the back of the room chatting. :) As soon as I got access to my room I headed on up to check it out. I’ve been on one of these ferry/cruise ships before and I think they are kind of cute.

After some food it was off to the first sesson of the day. I went to Connor McDonald speaking about Analytics. I’ve been to a number of different talks on analytic functions over the years, including my own. It’s kind-of cool to see how different people approach the same subject and what they focus on compared to you.

Next up it was my session. Compressing a 60 minute session, that I always overrun on, into 45 minutes was a challenge and I had to miss some stuff out, but it’s all good. I got some good feedback after the session, which is also nice for the ego. :)

From there is was on to Lasse Jenssen‘s session on version control in the database. I really enjoyed this session as it raised lots of important discussion points! After all these years, there is still not a single product that really does everything, but there are a number of products like Red Gate SQL Source Control, that are coming closer to the mark.

After that I got locked in conversation with a number people and missed the next session. I spent a long time talking to Cary Millsap about a whole bunch of stuff unrelated to technology. Then it was off to the evening drinks and dinner, where I sat with Cary and Connor. Once again, lots of chat about none technical stuff. Pretty cool!

At about midnight we decided to head off to bed and I bumped into Brynn Llewellyn, who asked if he could have a quick word with me. Two hours later we eventually knocked that conversation on the head and I actually went to bed. :)

Cheers

Tim…

OUGN : Day 1 was first posted on April 5, 2014 at 4:03 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Oracle Midlands : Event #3 – Registration Open

Tim Hall - Mon, 2014-03-31 11:04

Registration is now open for Oracle Midlands Event #3 on Tuesday 20th May..

As I mentioned in a previous postChristian Antognini will be the speaker for both the sessions this time. He’ll be covering “12c Adaptive Query Optimization” and “Row Chaining and Row Migration Internals”.

Red Gate Software have kindly offered to sponsor the event again, so registration is free!

I’ve already registered. :) Please make the effort to come along and support the event!

Cheers

Tim…

Oracle Midlands : Event #3 – Registration Open was first posted on March 31, 2014 at 6:04 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.