A Simple, Straightforward Method to Update Content on WebCenter-Based Portal Pages

In our experience working with numerous WebCenter Portal customers, almost all of whom suffered from failed portal/intranet implementations, this difficulty to update and quickly edit page content always lead to stagnant content throughout the portal. This stagnant content made the portal less sticky and therefore the organization didn’t realize widespread adoption.

The difficulty to add and update content was magnified by the fact that in most cases, portal page updates were performed by system administrators. (more...)

ADF Performance Monitor – Major New Version 7.0

We are very happy to announce that a major new version 7.0 of the ADF Performance Monitor will be available from May 2018. There are many improvements and major new features. This blog describes one of the new features; on usage statistics and performance metrics of end-user click actions.

A click action is the start trigger event of an HTTP request by the browser, by an action that a user takes within the UI. (more...)

Upgrade Grid Infrastructure to 18.2 by applying RU

Database 18c Patch

As of the Release date (17-Apr-2018), the only Oracle Database 18 software that is available is 18.1.0 for on-premise Exadata. Therefore, the following patches for Oracle Database 18 are only for on-premise Exadata systems that are running Oracle Database 18.1.0.

More Info: Database 18 Proactive Patch Information (Doc ID 2369376.1)

OPatch Utility Information

You must use the OPatch utility version 12.2.0.1.13 or later (more...)

Fedora User Manager

As one of my students pointed out, Fedora doesn’t install a GUI user management tool installed by default. That’s true. It’s easy to install. You can install it as the root user, like:

yum install -y system-config-users

It should generate a screen console output like this when successfully installed:

Loaded plugins: langpacks, refresh-packagekit
http://yum.postgresql.org/9.3/fedora/fedora-20-x86_64/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found
Trying other mirror.
Resolving Dependencies
--> Running transaction check
 (more...)

Collaborate 18 Session: Microservices Using Python and Oracle

Uncategorized
| Apr 24, 2018
Many thanks to all those who came to my session at Collaborate 18 today. I sincerely hope you enjoyed the session and learned something new in the process.

Here are the files you can download:

1. The presentation
2. The list_avail template
3. The hotel.py python program (download the file and remove the .txt extension)
4. The hoteld.py python program

In case you wanted to visit the Python learning series I wrote, here (more...)

Last Week in Stream Processing & Analytics – 24.4.2018

This is the 112th edition of my blog series blog series around Stream Processing and Analytics!

As every week I was also updating the following two lists with the presentations/videos of the current week:

As usual, find below the new blog articles, presentations, videos and software releases from last week:

News and Blog Posts

General

Oracle Linux 7 Update 5 is out: time to create a new Vagrant Base Box

It's been busy, so unfortunately it's already been almost two weeks I wrote my introductory story on Vagrant. Today I happen to have an afternoon off, and I noticed that Oracle Linux 7 Update 5 is out. I based my first boxes on 7.4, so nice moment to start with creating a new Base Box.

De essentials on creating a Vagrant base box can be read here. But I'm going to guide you trough (more...)

Upgrade Version to 18.2 from Oracle 18c by applying RU

Database 18c Patch

As of the Release date (17-Apr-2018), the only Oracle Database 18 software that is available is 18.1.0 for on-premise Exadata. Therefore, the following patches for Oracle Database 18 are only for on-premise Exadata systems that are running Oracle Database 18.1.0.

More Info: Database 18 Proactive Patch Information (Doc ID 2369376.1)

OPatch Utility Information

You must use the OPatch utility version 12.2.0.1.13 or later (more...)

Evaluation and Prediction in Oracle RAC 12c

In a DBA’s routine, we perform thousands of command every day. Sometimes it also happens we don’t know the post-impact of the command.

Then, Oracle 12c Comes up with very powerful feature WHAT IF EVALUATION.

It shows us the impact of command without actually performing it. So with help of this our life can become easier, first perform an evaluation of command you want to actually apply to your production.

We can use eval and (more...)

Manually Converting Non-RAC DB to RAC DB

In previous articles, we have seen various methods of converting Non-RAC database to RAC database.

In this article, we will convert non-RAC database to RAC database using RMAN backup-restore utility.

Single Instance DB Name RAC DB name RAC Instance Node RAC Instance Name RAC Node Name
MGR MGR Node 1 db1 RAC1
Node 2 db2 RAC2

Step 1: Check details of Single Instance Database :

SQL> select name,open_mode from v$database;

NAME	  OPEN_MODE
--------- --------------------
MGR	       (more...)

View All Rules with REST API in Oracle Cloud

The following example shows how to view detailed information about a Database Cloud Service instance by submitting a GET request on the REST endpoint using cURL.

To know basic about RESTAPI

In the last post, we created an access rule with RestApi. Now, in this post, we will see how to get the information about that instance.

The following example shows how to view the rules for a Database Cloud Service instance by submitting a (more...)

Enable an Access Rule with REST API in Oracle Cloud

The following example shows how to view detailed information about a Database Cloud Service instance by submitting a GET request on the REST endpoint using cURL.

To know basic about RESTAPI

In the last post, we created an access rule with RestApi. Now, in this post, we will see how to get the information about that instance.

The following example shows how to enable a rule by submitting a PUT request on the REST endpoint (more...)

Create a Access Rule with REST API in Oracle Cloud

The following example shows how to view detailed information about a Database Cloud Service instance by submitting a GET request on the REST endpoint using cURL.

To know basic about RESTAPI

The following example shows how to create a rule by submitting a POST request on the REST endpoint using cURL.

In this example, the identity domain is “idcs-bac676f0a2c643a281868616b45986da”, and the Oracle Cloud username and password are “clouduser” and “Pa$$word“. The (more...)

Restart a Service Instance with REST API in Oracle Cloud

The following example shows how to view detailed information about a Database Cloud Service instance by submitting a GET request on the REST endpoint using cURL.

To know basic about RESTAPI

The following example shows how to restart a Database Cloud Service instance by submitting a POST request on the REST endpoint using cURL.

In this example, the identity domain is “idcs-bac676f0a2c643a281868616b45986da”, and the Oracle Cloud username and password are “clouduser” and “ (more...)

Logger Snippets for VS Code

Snippets are a common feature in text editors, allowing you to essentially paste in a snippet of code from some library somewhere.

Snippets appear for selection as you start typing, and the editor will paste in the entire content of the snippet.

Snippets in VS Code

VS code snippets also have the ability to focus the cursor, ready for typing.

It's very closely related to code completion concepts, applied in VS Code with Intellisense. Vito (more...)

Enterprise Manager Silent Installation

Introduction

This is another post in my series on silent installations using response files. In previous posts, I covered silent installations for the Grid Infrastructure, RDBMS, post installation configuration steps, and creating the listener and database using response files. In this post, I’ll cover installing Enterprise Manager using a response file.

Generating the Response Files

Unlike all the other installations and configurations using response files, for some reason Oracle Corporation in its (more...)

How to check the status of OMS and Agent in OEM 13cR2

We used 2 servers, one for the Database server and another one is for the management server.

10.237.1.207 em13c.localdomain em13c
10.237.2.107 host01.localdomain host01

To check the status of OMS, we can login to em server.

eg10438 : [oracle@em13c ~]$emctl status oms
Oracle Enterprise Manager Cloud Control 13c Release 2
Copyright (c) 1996, 2016 Oracle Corporation. All rights reserved.
WebTier is Up
Oracle Management Server is Up
 (more...)

Collaborate18 Session: Real Life DBA Best Practices

Uncategorized
| Apr 23, 2018
Thank you all those came for my session at IOUG Collaborate 18 today. I hope you learned something new and inspired by something to make your task a bit easier, a bit more efficient and a whole lot enjoyable.

You can download the presentation here.

Remember, a best practice is something that can be explained as:
1) why it is good, or what specific good comes by following it
2) what happens if you don't (more...)

Using Java Management Extensions within Oracle Enterprise Manager Cloud Control 13c

The answer to using Java Management Extensions(JMX) within Oracle Enterprise Manager Cloud Control is using Metric Extensions. Metric extensions provide you with the ability to extend Oracle’s monitoring capabilities. I will show you one example on how to create an extension to monitor a WebLogic Messaging Bridge. You can use other methods to create metric extensions, for example via the EMCLI. This will not be covered in this blog.

First of all, you have to (more...)

On Switching Code Editors

Ever since I joined the industry, my preferred text editor was TextPad.
It's a solid tool, similar to Notepad++. I probably underutilise it, but I started to see some people to interesting things with more modern editors.

Day-to-day, I work with two monitors, so I've been trialling software literally side-by-side for a while.

With some help from my nearby colleague, I tried a little Sublime (freemium), and that peaked my interest when contemplating the jump. (more...)