Mar 27, 2009

ODI Server install - missing odiparams.sh file

I’m installing ODI agent on our database server using OUI. I selected the “Server” option at install time to get the Agent only, but looking in oracledi/bin odiparams.sh is missing: $ls -l *.sh -rwxrwxrwx 1 odiadm dba 685 Nov 21 15:58 agent.sh -rwxrwxrwx 1 odiadm dba 908 Nov 21 15:58 agentscheduler.sh -rwxrwxrwx 1 odiadm dba 707 Nov 21 15:58 agentstop.sh -rwxrwxrwx 1 odiadm dba 941 Nov 21 15:58 agentweb.sh -rwxrwxrwx 1 odiadm dba 724 Nov 21 15:58 jython.

Continue Reading

Mar 27, 2009

Remove windows line feed characters in vi

If you work with a file in Windows and Unix at some point you might end up with windows line feed characters in your Unix file. It’ll look like this: one line of text ^M next line ^M and next line with more ^M To remove the ^M character, load the file into vi on unix and enter as a line command the following: :1,$s/^M// but instead of typing ^M do Ctrl-V Ctrl-M to get the charaters

Continue Reading

Mar 25, 2009

ORA-12537 / ORA-12518 [Informatica DAC error CMN_1022]

We’re getting problems with an instance of Informatica / out-of-the-box OBIA on a new set of servers. When we run the execution plan we get this error soon after starting: MAPPING> DBG_21075 Connecting to database [TNSENTRY], user [MYUSER] MAPPING> CMN_1761 Timestamp Event: [Tue Mar 24 18:56:33 2009] MAPPING> CMN_1022 Database driver error… CMN_1022 [ Database driver error… Function Name : Logon ORA-12537: TNS:connection closed Database driver error… Function Name : Connect

Continue Reading

Mar 24, 2009

Clustering Publisher - Scheduler and Report Repository

The Oracle BI Publisher Enterprise Cluster Deployment doc which I just found through Metalink highlighted a couple of points: - Report repository should be shared - The scheduler should be configured for a cluster Report Repository Through Admin>System Maintenance>Report Repository I changed the path from the default, /xmlp/XMLP to a NFS mount data/shared/xmlp and restarted the xmlpserver application in OAS. On coming back up Publisher complained because all its config files (in xmlp/Admin), had disappeared.

Continue Reading

Mar 24, 2009

Metalink Metalink Metalink

I’m learning about a lot of the Oracle BI stack through reading manuals and trial-and-error. One thing I’ve realised is that Metalink holds a whole heap of useful information. For example, simply searching on “publisher cluster” throws up these two very pertinent docs: OBIEE Clustered Installation with BI Publisher (Doc ID 744515.1) BI Publisher does not accept cluster jdbc connection strings (Doc ID 559795.1) The first one is a publically available PDF, the second one is the answer to the problem I spent more time than I needed to scratching my head over yesterday.

Continue Reading

Mar 24, 2009

Which jdbc driver to use

In setting the scheduler in Publisher I discovered a useful difference in jdbc drivers. Our repository is on Oracle 11g. According to the manual oracle.jdbc.driver.OracleDriver should be used, but previous installations have used oracle.bi.jdbc.AnaJdbcDriver so I tried this too. In experimenting with both I found you get more useful feedback from the second one. Here’s the same problem reported by both drivers: · Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.

Continue Reading

Mar 23, 2009

Finding config files in unix

Following my previous work on configuring Publisher, I wanted to note down where the changes were written to. The -mname syntax of the unix find command comes in handy here: find /app/oracle/product/obiee -mtime -1 Shows me all files under the specified path which were modified in the last 1 day and helpfully throws up: /app/oracle/product/obiee/xmlp/XMLP/Admin/DataSource/datasources.xml

Continue Reading

Mar 23, 2009

OBIEE Publisher - configuring connection to clustered BI Server

I’m setting up a clustered OBIEE 10.1.3.4 production environment. There are four servers; two BI Server + Cluster Controller + Scheduler and two OAS + Presentation Services + Publisher. Clustering of BI is configured, now I’m setting up the other bits. Today is Publisher. On publisher instance A connections to the BI Servers directly work fine: jdbc:oraclebi://serverA.fqdn.company.net:9703/ jdbc:oraclebi://serverB.fqdn.company.net:9703/ both work individually as Connection Strings (with database driver class of oracle.bi.jdbc.AnaJdbcDriver) - verified with “Test Connection” button.

Continue Reading

Jan 1, 0001

As I explore the current world of data & analytics engineering, one of the things I’m trying to grok is the idea of a Metric Layer (described by Drew Banin in this keynote: https://www.youtube.com/watch?v=MdSMSbQxnO0 and Benn Stancil here https://benn.substack.com/p/metrics-layer). It strikes me as conceptually similar to what #OBIEE did in its logical layer with measures. Admittedly it was almost always exposed through the tool’s front end itself, but there was an ODBC and JDBC (https://rmoff.

Continue Reading

About Me

whoami Robin is a Principal DevEx Engineer at Decodable. He has been speaking at conferences since 2009 including QCon, Devoxx, Strata, Kafka Summit, and Øredev. You can find his talks online, subscribe to his YouTube channel, and read his blog. Outside of work, Robin enjoys running, drinking good beer, and eating fried breakfasts—although generally not at the same time. 👉🏻 Bio & speaker photos Speaking experience Speaker since 2009 at conferences including QCon, Devoxx, O’Reilly Strata, NDC, USENIX LISA, Kafka Summit, Øredev, O’Reilly SACon, Oracle OpenWorld, JavaZone, Big Data LDN, UKOUG, Oracle CODE, PGConf, etc plus numerous meetups.

Continue Reading

Jan 1, 0001

Talks

You can find all my recent talks on Notist at https://talks.rmoff.net/. Older ones are on Speaker Deck. I have a variety of talks, around several different aspects of Apache Kafka and related technologies. Kafka 101 / introductory talk : “Kafka as a Platform: the Ecosystem from the Ground Up” Introduction to ksqlDB and stream processing principles and semantics - with lots of live demos. “An introduction to ksqlDB” Live demo showing use of Kafka Connect and ksqlDB: “Apache Kafka in Action : Let’s Build a Streaming Data Pipeline!

Continue Reading