Ansible Simple SQL Shell Script Setup

Ansible example of running a sql script from a shell script on target servers. 1) First setup a central Ansible control host server (if you don’t have one already). Pick a server which has a reasonably recent version of Linux OS. No need to be a dedicated server, and no need to be a physical […]

Read More Ansible Simple SQL Shell Script Setup
June 2, 2023

Python create Confluence Page

Python script to create a Confluence page, plus child pages, based on input .txt files in Confluence markup language. In my case called from Jenkins with a Jenkins parameter (p_test_description) used to name the Confluence page. Based on https://stackoverflow.com/questions/33168060/how-can-i-create-a-new-page-to-confluence-with-python

Read More Python create Confluence Page
May 29, 2023

Call Sqlplus from Jenkins

For Jenkins running on Microsoft Windows, to run a sqlplus .sql file, can specify any of these in the Build Command: 1) PowerShell 2) Execute Windows Batch Command 3) Execute shell Or to run some sqlplus statements directly without using a separate .sql file: 4) PowerShell 5) Execute shell

Read More Call Sqlplus from Jenkins
May 29, 2023

Logon Trigger set Module

Ideally developers will set module and action to allow for easy debugging and performance monitoring in v$session, v$active_session_history, dba_hist_sqlstat, OEM screens, etc. If not, a logon trigger can be used to set these. Below does this for any tomcat sessions which still have module set to the default generic value. Pattern matching is used for […]

Read More Logon Trigger set Module
May 29, 2023

Logger alternative to dbms_output Oracle Log4j

Simple logger.write alternative to dbms_output.put_line. Call with: logger.write ( ‘hello world!’ ) ;or even just: logger.write ; It does the dbms_output.put_line but also writes asynchronously to a log_table, and gives info on calling line number and procedure name.

Read More Logger alternative to dbms_output Oracle Log4j
May 29, 2023