Skip to content

Instantly share code, notes, and snippets.

View rmoff's full-sized avatar

Robin Moffatt rmoff

View GitHub Profile
@rmoff
rmoff / gist:5716573
Created June 5, 2013 19:33
Show what port WLS AdminServer is running on
echo 'AdminServer is running on port ' $(ps -fC "java"|grep AdminServer|awk '{print $2}'|xargs -I'{}' lsof -nPp {}|grep LISTEN|head -n 1|awk -F ":" '{print $2}'|cut -d " " -f 1)
@rmoff
rmoff / 0_readme.md
Last active December 18, 2015 10:59
OBIEE 11.1.1.7 in-place upgrade - response files for Linux
@rmoff
rmoff / static-ports.ini
Created October 30, 2013 13:28
OBIEE 11.1.1.7.0 static-ports.ini
# Note that if ports are not defined in this file they will be autoallocated starting at port 9500
# It is recommended that ports 9500-9520 are left unassigned for this auto-allocation
[WEBLOGIC]
#The Domain port no. This is the listen port of Weblogic Adminserver for the domain.
#Domain Port No = 7001
#The "content" port for the BIEE apps. This is the Weblogic Managed Server port on which BIEE applications are deployed.
#Oracle WLS BIEE Managed Server Port No = 9704
@rmoff
rmoff / zendesk__to_confluence.py
Last active December 30, 2015 03:49
Zendesk to confluence migration script. Hacked together and not pretty, but it does the job!
#!/usr/bin/python
#
# Migrate Zendesk topics/forums to Confluence pages/child pages
#
# Hacky as hell, I'm not proud!
#
# @rmoff 2013-12-03
#
# Known bugs:
# 1. Embedded images with non-safe characters in the filename (eg +) get encoded by Confluence at upload but the
@rmoff
rmoff / gist:8474271
Created January 17, 2014 14:31
"ORA-01917: user or role 'REGISTRYACCESS' does not exist"
Error: "ORA-01917: user or role 'REGISTRYACCESS' does not exist"
Cause: Running ODI 12c RCU against an Oracle DB 12c container DB.
@rmoff
rmoff / obiee_soap.py
Last active February 11, 2020 19:11
Calling OBIEE SOAP Web Service from Python using SUDS
# RNM 20140124
#
# https://twitter.com/rmoff/
# --------------------
# Required
from suds.client import Client
client = Client('http://obiee-server:9704/analytics-ws/saw.dll/wsdl/v7')
#------------
# Logon
sessionid = client.service['SAWSessionService'].logon('weblogic','Password01')
@rmoff
rmoff / fs_example.py
Last active August 29, 2015 13:57
FluidSurvey API example
#!/usr/bin/python
#
# Example of calling the FluidSurveys API from python
#
# March 10, 2014
#
# @rmoff
# --------------------------
#
# To explore the API, use this syntax with curl:
@rmoff
rmoff / gist:9687727
Last active July 21, 2020 20:33
XRDP - connect using any color (colour) depth

XRDP - connect using any color (colour) depth

XRDP version

xrdp 0.5.0

Problem

When connecting from mstsc or other RPD clients, unless specifying 24-bit colour depth (Millions), sesman fails. The Connection log just shows "error - problem connecting".

// @rmoff
// May 21, 2014
//
// Visual Regression Testing for OBIEE using PhantomCSS/CasperJS
//
// No kind of error or exception handling, no checks for successful login, etc
// Use at your own risk!
//-----------------------------------------------------------------------------
var phantomcss = require('./phantomcss.js');
@rmoff
rmoff / gotcha.md
Last active August 29, 2015 14:02
OBIEE runcat.cmd - $USER_INSTALL_DIR$

On an Admin tools only (no OBIEE server), version 11.1.1.7.1, runcat.cmd has two invalid lines:

set ORACLE_HOME=$USER_INSTALL_DIR$\oraclebi\orahome
set JAVA_HOME=$JAVA_HOME$

This means that the script fails to run (because $USER_INSTALL_DIR$ is invalid).

I suspect this is because $USER_INSTALL_DIR$ and $JAVA_HOME$ are tokens that the installer should be replacing when it builds runcat.cmd, but due to a bug doesn't

To get runcat.cmd to work, strip out the $var$ and replace it with the correct path, eg: