APEX Quickly installing APEX 22 and ORDS 22 Here are my quick notes on installing Oracle APEX Release 22.1 and Oracle REST Data Services 22.2. Extract Software1. Set path. Use this path when installing APEX, ORDS, and Tomcat. Customize as necessary. export JAVA_HOME=/u01/oracle/jdk-18.0.1 export
APEX Resetting the ORDS_PUBLIC_USER password for APEX 22 and ORDS 22 I recently installed Oracle APEX Release 22.1 and Oracle REST Data Services 22.2 (installation instructions here). All was working fine, but two days later when we navigated to the web console at http://hostname:8080/ords we received the following exception: Specifically,
Expedia Why Expedia's slow killing of their desktop web experience is not a good thing TRIGGER WARNING: This post may include frustration towards recent changes made by Expedia. Expedia has recently (in 2022) redesigned their user interface to provide a completely consistent experience between desktop
AWS When specialty beats functionality While back I wrote a short piece about Pandoc. My excitement about it stands true, yet it's a last-century utility you don't want or can't use in cloud-native applications. Well, I found a new one - WKHTMLTOx
OEM Monitor JMS queues through OEM 13c If you have the WebLogic Management Pack for Oracle Enterprise Manager (OEM), you can monitor a slew of metrics. Often, I am asked if OEM can monitor if there are pending messages in a WebLogic JMS queue or topic. The answer is "sort of.
WebLogic WLST script to monitor WebLogic status, heap, JDBC, and JMS Do you want a custom script to send out an email that reports on your Oracle WebLogic Server status, heap, data source, and JMS information? If you want the an equivalent of the output below, all you need is a single crontab entry, a
Bash Promptless SFTP in bash script Want to run SFTP command in a bash script without being prompted? Here are quick examples of 2 approaches; one with password based authentication and one with private key authentication. Password Authenticationcd /source_directory_on_local echo "cd /target_directory_on_remote" > /tmp/commands.
SQL*Plus Getting ORA-12504 when connecting with sqlplus I happened to install the Oracle Instant Client (instructions here) to quickly connect to a database using sqlplus. ProblemAfter installation, I simply tried to connect to my database as follows: ./sqlplus scott@dbhost:1521/dsoa.revelationtech.comAnd got the ORA-12504 error shown here: SQL*
Conda Conda: Environment configuration With a high probability, you own a powerful computing device that could be used as a standalone system for developing, debugging, and testing applications. And it would be a good idea - to use virtual environments to limit cross-project dependencies and keep your OS package list under control.
JSON JQ is a new GREP If you are a cloud system administrator, security analyst, or data scientist, you already use jq (JSON Query), and if you don't, you should.
WSO2 API Manager Install WSO2 API Manager 4.0.0 for Linux This post describes how to install, configure, and start WSO2 API Manager 4.0.0 on Linux. Download WSO2 API ManagerNavigate to https://wso2.com/api-manager/Click on TRY IT NOWEnter your email addressClick on the checkbox to accept the licenseDownload the Zip Archive
WSO2 API Manager Install WSO2 API Manager 4.0.0 for Windows This post describes how to install, configure, and start WSO2 API Manager 4.0.0 on Microsoft Windows. Download WSO2 API ManagerNavigate to https://wso2.com/api-manager/Click on TRY IT NOWEnter your email addressClick on the checkbox to accept the licenseDownload the Zip
development Game of Words I felt for Wordle the day I read about it, and now my morning starts with a fresh cup of coffee and a fresh puzzle. But sometimes, I struggle to
PL/SQL Quickest way to get PL/SQL source code from the Oracle Database I run into network or security challenges where I can't use tools to connect to my Oracle Database, so I end up having to rely on SQL*Plus to get the source of my PL/SQL code, be it a PACKAGE, PROCEDURE, FUNCTION, or
SQL*Plus Quickest way to set up the Oracle Instant Client for sqlplus access to the Oracle Database Need quick and immediate access to SQL*Plus (i.e., sqlplus) from your Linux server? 1. Navigate to: https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html 2. Download these files: instantclient-basic-linux.x64-21.5.0.0.0dbru.zipinstantclient-sqlplus-linux.x64-21.5.0.0.0dbru.zip
No Technology Today For the second day in a row, I can't get my thoughts together to write another technological post. The horror in Ukraine and the grim prospect of Russian citizens condemned
OCI OCI: Firewall on Ubuntu 20.04 If you have created a load balancer and can't reach your backend servers, check a target firewall configuration, especially if you run Ubuntu.
Documentation Pandoc: My Missing Tool With the "everything as a code" approach, it's natural to treat documentation as a code and use the same source code management and delivery techniques. I know how to create and deliver documents. And now I found my missing link, static content generator - pandoc.
Oracle HTTP Server Standalone Oracle HTTP Server: Deployment Options In one of my previous posts, I mentioned multiple Oracle HTTP server deployment options. Let me do a small "show & tell" to explain how I pick the configuration.
Oracle HTTP Server Mysterious TLS in Oracle HTTP A little "forget-me-not" from a recent Oracle HTTP server troubleshooting, but it could happen to Apache HTTPD as well. To set up a stage: a work installation of the Oracle HTTP Server, stop presenting certificates on the secured port.
Database Flashback: The Lesson I Learned This piece is not about features or products. It's about lessons that we learn or not. The one I learned some twenty-three years ago was: "Don't ask for troubles and do one thing at a time."
Containers Docker: Logn Errors Recently, I spent some time trying to find why I can not push my just-from-the-own image into the GitLab project registry. The message "illegal base64 data at input" is a bit confusing, but the solution is simple.
Bash Bash scripts to diagnose network issues These are 2 simple scripts I wrote that run various types of tests to help diagnose network issues between a source and target. They can be safely run as a non-root user as long as the commands exist. Script 1 - Various network testsThis
Ansible Ansible: Dynamic Inventory I know that Ansible could use as inventory virtually anything, including scripts. However, all inventories on my day job are static, and we keep them in a source repository, and until now, I haven't had a chance to create or use one.
A Simple Token Generator My friend's given me a perfect tip: "Whenever I need a random sequence of characters, I use OpenSSL rand functions." And to be a bit fancy, I pick the value
