Vim Sessions

Sessions are a built-in feature of vim to allow you to quickly restore buffers and window layouts to a viminfo-file. These files can be reused and can usually be transferred to other machines. This is particularly nice if you have many config files across the system where the location is hard to remember, or if you like your window layout a certain way every time. In my example below I will show how I like to setup some Session files for OBIEE.

(Redshift) [ISQL]ERROR: Could not SQLConnect

Amazon has really made it quite simple to pull down the ODBC/JDBC drivers needed to connect to Redshift. Today, however, I attempted to test connectivity with isql and got the error “Could not SQLConnect” The Error [oracle@obiee-server ~]$ isql "Redshift ODBC" [ISQL]ERROR: Could not SQLConnect Digging In Locate the primary driver config [oracle@obiee-server ~]$ odbcinst -j unixODBC 2.3.1 DRIVERS............: /etc/odbcinst.ini SYSTEM DATA SOURCES: /etc/odbc.ini FILE DATA SOURCES..: /etc/ODBCDataSources USER DATA SOURCES.

ORA-38881: Cannot drop tablespace

Drop attempt Input ./rcu -silent -dropRepository -schemaPrefix DEV -connectString test-db1:1521:RCUDEV -dbUser sys -dbRole sysdba -component STB -component IAU_APPEND -component OPSS -component BIPLATFORM -component IAU -component MDS -component IAU_VIEWER -component WLS Output Processing command line .... Repository Creation Utility - Checking Prerequisites Checking Global Prerequisites Repository Creation Utility - Checking Prerequisites Checking Component Prerequisites Repository Creation Utility - Drop Repository Drop in progress. Percent Complete: 2 Percent Complete: 12 ORA-38881: Cannot drop tablespace DEV_IAU on primary database due to guaranteed restore points.

Store Weblogic User Config (keyfiles)

Keyfiles Weblogic has a nice feature where you can dump out login keys. These keys can be used within WLST script to login without a password. This can be handy for automated tasks. Generate the files This is basically a one liner WLST script that will generate the keyfiles for the weblogic user. Adjust the script to fit your needs. This was done for 11g, but the same can be done for 12c – Just change the port from 7001 to 9500.

Starting and Stopping OBIEE

OBIEE 11g init.d Script Right away I suggest you take a look at RittmanMead’s init.d script located here on github. This script is really well written and handles the startup and shutdown of Node Manager, Admin Server, bi_server, and OPMN. Enable it with chkconfig and and it will nicely handle server reboots. I also like to call this script via Ansible playbooks after deploying RPDs or doing a security migration to make changes take affect.

Load RPD using WLST

Intro I was talking to PedroF over at #obihackers today, and I realized it might be helpful if I start to post some of the scripts that I use regularly. So today I bring you RPD file deployment! The Code 11g rpd_path = "/tmp/RPDfile2Upload.rpd" rpd_password = "Admin123" connect('weblogic', 'Password123', 't3://localhost:7001') # Be sure we are in the root cd('..\..') print 'Connecting to Domain ...' try: domainCustom() except: print 'Already in domainCustom' print 'Go to biee admin domain' cd('oracle.

RCU connection issues (11g/12c)

Background I have run into a few install issues with OBIEE the last couple years, and some of them have been odd enough I feel necessary to document – Both for my sanity and yours. Today I will cover connectivity issues with the RCU database. OBIEE 11g ( URG Packets This one was a real head-scratcher. I would start a fresh install of OBIEE 11g, but in certain network environments coreapplication_obisch1 would fail to start.

Set OBIEE Email Server settings via WLST (11g/12c)

Alternative Title: Relearning WLST I am currently in the process of redoing all of my OBIEE install/configure scripts as I am moving from 11g to 12c. Turns out, a lot of my old WLST scripts will need to be heavily modified. Some simple things like going from oracle.biee.admin to – And some major changes with things like locking/saving. After messing around with different bits, and reading different Oracle docs, I finally got a hint when I noticed editCustom() on this Oracle doc.