SQL*Plus Using the SQL*Plus Instant Client Now that you have the Oracle SQL*Plus Instant Client installed, here's the quickest way to start using it. (Installation instructions on this blog post.) # Set the environment variables to your local installation export SQLPLUS_HOME=/u01/sqlplus/instantclient_21_5 export TNS_ADMIN=
BPEL Cheat sheet for XSL transformation I'm really publishing this blog post for myself as a future reference. :) This .xsl file (aka XSL transformation file) contains perhaps 90% of everything I generally use in my Oracle SOA development projects. Here is the file in its entirety (I'll break it down
Oracle Fusion Middleware Not getting the "Sign In" button on the Oracle Fusion Middleware EM Console? Try this Quite a few times I've opened up the Oracle Enterprise Manager Fusion Middleware Control 12c console and the prompt for the user name and password is right there, but not the Sign In button (see screenshot). Where's the "Sign In" button?!The solution to
BPEL EMAIL activity in Oracle BPEL does not support single quotes During compilation of an Oracle SOA BPEL project, I ran into an error related to the EMAIL activity. Problem: I received an error invalid syntax when building the project, but the error message did not tell me what the issue exactly was: Error(782)
JDeveloper Testing an XSL transformation mapping in Oracle JDeveloper 12c So you developed a somewhat complicated XSL transformation in your Oracle SOA/BPEL project. But how do you go about testing this? Traditionally, we deploy the project to the SOA server, conduct a test of the end-to-end process, see what failed, and go back
WebLogic Getting JPS-01050 when starting WebLogic (cannot open wallet) When starting up WebLogic after a network outage, we received the following exception: oracle.security.jps.JpsException: JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException at oracle.security.jps.internal.config.OpssCommonStartup.preStart(OpssCommonStartup.java:423) at oracle.security.jps.
Performance Creating a test file to test I/O performance For the purpose of testing the performance of a cloud storage volume, I recently came across the xfs_mkfile command. This command creates a file called 30GigFile.out that is 30 GB in size: xfs_mkfile 30720m 30GigFile.out What I do is simply
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 Software 1. Set path. Use this path when installing APEX, ORDS, and Tomcat. Customize as necessary. export JAVA_HOME=/u01/oracle/jdk-18.0.1
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 Authentication cd /source_directory_on_local echo "cd /target_directory_on_remote" > /tmp/
SQL*Plus Getting ORA-12504 when connecting with sqlplus I happened to install the Oracle Instant Client (instructions here [https://chronicler.tech/quickest-way-to-set-up-the-oracle-instant-client-for-sqlplus-access-to-the-oracle-database/] ) to quickly connect to a database using sqlplus. Problem After installation, I simply tried to connect to my database as follows: ./sqlplus scott@dbhost:1521/dsoa.revelationtech.com And got
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 Manager 1. Navigate to https://wso2.com/api-manager/ 2. Click on TRY IT NOW 3. Enter your email address 4. Click on the checkbox
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 Manager 1. Navigate to https://wso2.com/api-manager/ 2. Click on TRY IT NOW 3. Enter your email address 4. Click on the
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.zip * instantclient-sqlplus-linux.x64-21.5.0.0.0dbru.
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 tests
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 Machine If
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
