rmoff

[ENGINE]

#DO NOT CHANGE THIS.
Response File Version=1.0.0.0.0

[GENERIC]

#Set this to true if you wish to specify a directory where latest updates are downloaded. This option would use the software updates from the specified directory
SPECIFY_DOWNLOAD_LOCATION=false

rmoff

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

This is for a Linux installation with FMW_HOME as /u01/app/oracle/product/fmw. For a Windows response file see here : https://gist.github.com/rmoff/5299950/

To make use of them you may need to update paths, weblogic password, and DB details.

For more information about upgrading OBIEE to 11.1.1.7 using an in-place upgrade, see http://www.rittmanmead.com/2013/04/upgrading-obiee-to-11-1-1-7/

rmoff

# 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

#!/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

Error: "ORA-01917: user or role 'REGISTRYACCESS' does not exist"

Cause: Running ODI 12c RCU against an Oracle DB 12c container DB. 

rmoff

# @rmoff/ February 16, 2016
# Ref: https://docs.oracle.com/middleware/11119/core/ASPMN/opmnctl.htm#CHDEFIDH
cd /app/oracle/biee/instances/instance1/bin
./opmnctl metric op=query COMPONENT_TYPE=OracleBIServerComponent > /tmp/nqs.$(hostname)-$(date +%Y%m%dT%H%M%S%N).dms.xml
./opmnctl metric op=query COMPONENT_TYPE=OracleBIPresentationServicesComponent > /tmp/saw.$(hostname)-$(date +%Y%m%dT%H%M%S%N).dms.xml
./opmnctl metric op=query COMPONENT_TYPE=OracleBISchedulerComponent > /tmp/sched.$(hostname)-$(date +%Y%m%dT%H%M%S%N).dms.xml
./opmnctl metric op=query COMPONENT_TYPE=OPMN > /tmp/opmn.$(hostname)-$(date +%Y%m%dT%H%M%S%N).dms.xml

rmoff

grep --color=none refresh RPD.xml |awk '{print $3 "\t" $6}'|sed 's/name=//g'|sed 's/refreshPeriod=//g'|sed 's/"//g'

rmoff

Oracle BigDataLite VM 4.4 changes from 4.3.0.1

Based on http://www.oracle.com/technetwork/database/bigdata-appliance/oracle-bigdatalite-2104726.html vs http://www.oracle.com/technetwork/database/bigdata-appliance/oracle-bigdatalite-4301-2894142.html:

• CDH 5.4.7 -> 5.5.1 (compare http://www.cloudera.com/documentation/enterprise/latest/topics/cdh_rn_new_in_550.html to http://www.cloudera.com/documentation/enterprise/latest/topics/cdh_rn_new_in_540.html)
  • Flume 1.6
  • Spark 1.5
• Oracle Big Data Spatial and Graph 1.1 -> 1.1.2
• Oracle Big Data Connectors 4.3 -> 4.4
• Oracle NoSQL Database Enterprise Edition 12cR1 (3.4.7 -> 3.5.2)

rmoff

Background: http://ritt.md/cp-instrumentation

Apply the XML patch by running:

/app/oracle/biee/user_projects/domains/bi/bitools/bin/biserverxmlcli.sh -U weblogic -P Admin123 -D AnalyticsWeb -I SA511_instrumentation.patch.xml

Expected output: