New kid on the block – let’s install “Database Release Update 12.2.0.1.170718”

At the DOAG database conference in May, Andrew Mendelsohn announced that Oracle will change the release schedule to annual releases and that patch naming will be changed to “Release Updates” (RU). The latter started – as announced – in July 2017 and now the first “Database Release Update” is available.
Let’s start patching.

Continue reading

Posted in Common, Oracle 12c | Tagged , , | Leave a comment

Oracle Restart not deprecated anymore

Oracle Restart ist the Clusterware for single instance systems. You can use it to run a single instance system with (almost) the same commands as a cluster. For example, Oracle Restart takes over Starting and stopping of listeners and database instances. On “normal” Unix/Linux scripts you have to provide scripts for that.

With the release of Oracle Database 12c Release 1, Oracle announced the deprecation of Oracle Restart. This is documented in Oracle 12c Release 1 – Upgrade Guide. This announcement caused uncertainty among the users, because Oracle did not announce any information about a successor.

Now (July, 10th, 2017) has withdrawn the deprecation. MOS-Note 1584742.1 reads: “Effective July 10th 2017, Oracle has withdrawn the deprecation of Oracle Restart.” 

 

Posted in RAC | Tagged | Leave a comment

SQLDeveloper on Mac hung at Startup – JDK upgrade solved the issue

All of a sudden, SQL Developer on my Mac stopped working. When starting SQL Developer, it hung at the splash screen.

No progress. Never …

My first idea was to reinstall SQLDeveloper, which is not a great thing as the settings are kept, but then I checked the version of my JDK and found, that it was still on JDK 8u111.

So I downloaded the current JDK, 8u131, from the JDK Download Page, installed it, and …

.. SQL Developer comes up without any issues 🙂

 

 

Posted in Common | Tagged , | Comments Off on SQLDeveloper on Mac hung at Startup – JDK upgrade solved the issue

Patching OEM 13c Cloud Control Release 2

Some days ago, Oracle released a new bundle for Oracle Enterprise Manager 13.2 (Patch# 25990918). This was the reason for me to update my local test and play OEM system on my local Linux system. Continue reading

Posted in Common | Tagged , , , , , | Comments Off on Patching OEM 13c Cloud Control Release 2

DBCA 12.2 runs datapatch automatically

It was one of the issues with Oracle 12c Release 1 that datapatch was not executed by dbca automatically. So, if you had installed patches to your Oracle home before running dbca, dbca did not take this into consideration and ran datapatch to apply the SQL changes to the databases. In August 2015 Mike Dietrich wrote a blog post on this issue.

Continue reading

Posted in Common, Oracle 12c | Tagged , , | Comments Off on DBCA 12.2 runs datapatch automatically