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
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*
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
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
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
Bash Bash script to test port availability I created a quick script to test if a port is consistently available between a source server to a target server for the purpose of gathering statistics to see if there are any network hiccups not. This is a very simple and straightforward script.
SSH Connecting with a private key using SSH and SFTP SSH uses public/private key pairs. id_rsa is your RSA private key (do not share this!). id_rsa.pub is your RSA public key; this you give out to the administrator of the target system so that they can add it to verify
WebLogic Getting "The payload data size exceeds the configured payload threshold size" in WebLogic An Oracle SOA Suite 12c composite was consuming files via inbound polling on the FTP Adapter. The file size was larger than 10MB and we got a Payload Size Exceeds Threshold. The payload data size: "" exceeds the configured payload threshold size: "": Option #1: Update
WebLogic Setting up single and multiple WebLogic NodeManagers in the same machine If you have multiple Oracle WebLogic Server 12c domains on a single machine, can each domain have its dedicated Node Manager? Can a single Node Manager manage all the domains in this machine? Yes and yes. Multiple Node Managers on a Single MachineIf you
WebLogic Regenerating the 'DemoIdentity' certificate in WebLogic 12c I recently encountered an Oracle WebLogic 12c environment that was installed 5 years ago, and whoever set it up at the time settled on using the included demo certificate created with the installation. Unfortunately, this demo cert expires after 5 years and now they
WebLogic WebLogic managed server RUNNING but with 'Failed' health On Oracle SOA Suite 12c (and technically Oracle WebLogic Server 12c), I noticed that a couple of managed servers were in a RUNNING state but the health was reporting Failed. What could cause this particular scenario? In this domain, the TLOGs were persisted in
BPEL Getting "Element 'binding.rest' not expected" in BPEL I created a BPEL process and attempted to add the property oracle.webservices.http.headers to my reference as shown below. However, during compilation, I received the following error: Error(39,100): schema - (Error) Element 'binding.rest' not expected. SolutionMove the <binding.
SQL*Plus Getting `ORA-00933: SQL command not properly ended` due to blank line What's strange is that a SQL script someone wrote (which apparently was running fine for months) seemed to return an ORA-00933: SQL command not properly ended error when executed through the Linux command line, as shown below: oracle@dbhost:/home/oracle> /u01/sqlplus/instantclient_
BPEL Don't let the '&' confuse you when viewing Oracle SOA instances on a web browser Man... dealing with & (ampersands) in SOA, web services, XML, and REST sucks. Dealing with special characters in general sucks-having to figure out if the product or tool is escaping/encoding them for you or not. Recently, I had to update my BPEL process
JDeveloper Working around messy REST references using WSDL interfaces in JDeveloper I recently ran into multiple issues with Oracle JDeveloper 12.2.1.4 when trying to call external REST web services from a BPEL project. It was quite painful and
JDeveloper Getting java.lang.NoClassDefFoundError in JDeveloper Native Format Builder for JSON Apparently I've run into an issue with Oracle JDeveloper 12.2.1.4.0 when using the Native Format Builder against a JSON file. Other online posts point to Oracle
Documentation My template for technical installation documents As a technical administrator, I often recommend creating high quality document deliverables. In a typical installation document, I am adamant about including certain sections which I normally don't seen many
Linux Checking Linux host performance (for the newbie) Every time I interview someone (for a non-Unix admin position) and ask them how they would check for performance on Linux, I'd like to say that the only answer I
