Ahmed Aboulnaga - Chronicles of Technology

ER_MUST_CHANGE_PASSWORD_LOGIN on Ghost blog platform

Seems that our Ghost blog platform received the following error when I tried to publish a post: Internal server error, cannot list posts. ER_MUST_CHANGE_PASSWORD_LOGIN: Your password

Don't kid yourself - you're not a Cloud Architect

With the boom in cloud adoption, many IT professionals are looking to formalize their new skillsets by acquiring various cloud certifications. Last week, I took advantage of Oracle's free training

Certification

What you need to pass the OCI Architect Associate certification exam

In March 2020, Oracle announced free access to online learning content and certifications to a broad array of Oracle Cloud certifications for about 2 months (details here). Literally tens of

Compute Cloud

Setting up our compute cloud virtual machines for POCs

We've been doing some quick performance testing of Oracle software on various compute cloud providers that include AWS, Oracle Cloud, IBM Cloud, Google Cloud, and Microsoft Azure. Once the virtual machine is created, most setup/configuration is generally standard. This post is mostly self-documentation

JDBC

Using "utils.dbping" to test JDBC database connectivity

Recently I ran into a problem with an Oracle WebLogic Server data source. We were getting an IO Error: Connection reset in the console and logs when we try to

OCI

Can't find the "oci" executable in Oracle Cloud?

A few months ago, I attended an Oracle Cloud Infrastructure workshop in Oracle Reston. In one of the hands-on labs, it appears that the oci executable was not found in

OEM

Yet another custom OEM uptime report

Here is my custom availability report in Oracle Enterprise Manager (OEM) 13c (using Information Publisher). It consists of multiple elements across multiple rows. Though this report is specific to WebLogic Managed Servers, it could apply to any target type. Each element is a distinct

OEM

Create a custom OEM uptime report for business hours only

There was a need to create a custom Information Publisher Report in Oracle Enterprise Manager 13c to provide uptime metrics. These uptime metrics were to be calculated weekly, from Monday to Friday, only for the hours of 8am to 5pm, and for specific targets.

OEM

Create a custom metric extension in OEM 13c

Oracle Enterprise Manager (OEM) 13c is a solid and comprehensive monitoring tool, providing a long list of monitoring metrics across a large number of target types. But there are bound

Script

Ugly (but quick) script to get Oracle Fusion Middleware software versions

I created a quick script that I ran across all our environments to consolidate a list of all software versions. This includes versions of: operating system, WebLogic, Java, RDA, OPatch, and OPatch patches. It's a crude script, but quite quick and efficient. It may

OEM

Querying incidents in OEM 13c

Unfortunately, the Incident Manager page in Oracle Enterprise Manager 13c is slow, cumbersome, and lacks customization. Running an SQL query against the OMS repository is extremely quick and efficient and you can get exactly what you need. Here is a simple query to pull

OHS

Web server returning 'Cross-Origin Request Blocked' to browser

With a typical web service call made, the browser debugger is showing a Cross-Origin Request Blocked error because it Did not find method in CORS header, specifically Access-Control-Allow-Methods. The resolution to this is quite simple with Oracle HTTP Server (OHS) 12c. Browser Error: "Did

Bash

How to show a timestamp in Bash history

By default, when you run the history command, it lists the history of all commands previously executed, but it does not include a timestamp. Adding a timestamp to the bash history can easily be accomplished with the HISTTIMEFORMAT Bash variable as shown. export HISTTIMEFORMAT=

UMS

Sending test UMS notification fails due to missing JMS queue

I recently ran into a problem sending test email notifications from the Human Workflow Engine in Oracle SOA Suite 12.2. In the EM Console, if you navigate to SOA > soa-infra (soa_server1) > Service Engines > Human Workflow > Notification Management, you

Oracle HTTP Server

Getting HTTP-403 connecting to OHS using CORS

We had a vanilla installation of Oracle HTTP Server (OHS) 12.1.3 and configured it to support CORS. On a new installation of OHS 12.2.1, the same

OBIEE

Repeated DFW-99998 errors in OBIEE 12c? Some of them you can ignore

On OBIEE 12.2.1.1.0, you may get repeated DFW-99998 errors, such as: <Feb 20, 2020, 3:22:08,281 PM EST> <Emergency> <oracle.dfw.incident> <BEA-000000> <incident 9116 created with problem key

Oracle SOA Suite

URLs for Oracle SOA, BPM, OSB, BAM, WSM, ESS, MFT, and API consoles

Just a quick reference to most console URLs typically available on the following products: Oracle WebLogic ServerOracle SOA SuiteOracle Business Process Manager (BPM) SuiteOracle Service Bus (OSB)Oracle Business Activity

WebLogic

Quickest way to decrypt passwords in Oracle WebLogic Server 12c

There are lots of scripts online that show you how to decrypt WebLogic passwords. Some work on different versions of the product but not others. Here's the simplest, most straightforward approach to decrypting passwords in Oracle WebLogic Server 12c. This has been tested on

ESS

Unable to create an error notification rule in Oracle SOA Suite 12.2.1? Patch 26088894 is not the fix

On Oracle SOA Suite 12.2.1.0.0, when we tried to create an error notification rule to alert on failed ESS scheduled jobs, we experienced an issue where the dropdown was not showing any schedules. Unfortunately, the solution to apply patch 26088894

WebLogic

Filtering WebLogic log messages

There is a ton of documentation online on how to create WebLogic log filters. In this blog post, I describe how to easily filter out a repeating error that appears to be harmless. What harm is there keeping these entries in the log file?

WebLogic

blowfish-cbc is not supported in FtpAdapter? Not true

We added a new JNDI to the FtpAdapter in Oracle SOA Suite 12.2.1.0.0, and upon execution of the SOA composite, received the error "blowfish-cbc is not supported". Blowfish is a cipher, and this generally should be configured within the adapter

Advanced find/replace commands in Linux

Below are some random find/replace examples that I've used in the past with a brief explanation of each. Example 1 - Recursively find a string Recursively search through all

Coherence

Get Oracle Coherence version

Many Oracle Fusion Middleware products are bundled with Oracle Coherence, either optionally or required by the product you are installing. Often it is necessary to identify the Coherence version. These are the commands to extract the Coherence version from coherence.jar: cp $DOMAIN_HOME/

WebLogic

Deployment exception because operation cannot be performed until the WebLogic server is restarted

Problem: I tried to create a datasource on Oracle WebLogic 12.1.3, but encountered the following error on the WebLogic Admin Console: The full error stack in AdminServer.log: ####<Sep 26, 2019 10:25:07 AM MDT> <Error> <

OSB

Getting "Hostname verification failed" in OSB 12c

Problem: When calling a service on Oracle Service Bus (OSB) 12c, I received an SSLKeyException related to hostname verification even though we do not have SSL configured. The entire error stack in osb_server1.out is: [2019-09-24T21:58:33.853-06:00] [osb_server1] [ERROR]