You may suffer issues when attempting to login to the Oracle VM Console i.e. http://<host>:port/ovm/console. May receive an error such as :- “Unexpected error during login (com.oracle.ovm.mgr.api.exception.FailedOperationException: OVMAPI_6000E Internal Error: Connection refused Connection refused Tue Nov 15 17:20:22 PST 2011), please consult logs for details. This is generally caused by the OVS user account on…
There are times when you need to open the OBIEE Web Catalog tool in offline mode, to amend permissions on user folders, as the “system account” user. This essentially means running the web cat tool on the BI Server itself. Open a putty session to the Linux server hosting the OBIEE BI Services, Check to…
Often you may find that when you come to start and OBIEE environment, it may fail with errors relating to the fact the OBIEE platform and mds accounts are either locked, or the stored passwords within the OBIEE configuration are out of step with whats held in the database. You may see errors in the…
The SQL Workbench provided as a SQL tool for Redshift Database development and analysis. I wondered if it would be possible to configure Oracles SQL Developer to connect to a AWS Redshift instance. It is possible, but only gives basic administration, but is worth keeping an eye on just in case future releases provide more…
UnixODBC When attempting to prove ODBC connectivity on a Unix system, you often need an ODBC Driver manager, http://www.unixodbc.org is a useful resource. Once downloaded to install :- untar /gunzip the downloaded media As root user ./configure make make install This will create the following files which you can then configure /usr/local/etc/odbcinst.ini /usr/local/etc/odbc.ini A recent…
The following steps were performed using a HLC Test environment using OBIEE 11.1.7 ( patch level 131017 ). The aim was to ensure it was possible to configure an OBIEE RPD to have two connection pools, one being an Oracle RDBMS, the other being an Amazon Redshift instance. The final test was to ensure a…