What’s going on here? The username/password is definitely valid, proved by the sqlplus connection. Configuring DAC in OBIA 7.9.5.1: [sourcecode] What can I do for you? 1 - Enter repository connection information 2 - Test repository connection 3 - Enter email account information 4 - Send test email 5 - Save changes 6 - Exit Please make your selection: 1 These are your connection type choices: 1 - MSSQL 2 - DB2 3 - Oracle (OCI8) 4 - Oracle (Thin) 5 - Keep current ( Oracle (Thin) )

Continue Reading

Here’s a set of scripts that I use on our servers as a quick way to check if the various BI components are up and running. Because we split the stack across servers, there are different scripts called in combination. On our dev boxes we have everything and so the script calls all three sub-scripts, whereas on Production each server will run one of: BI Server Presentation Server & OAS Informatica & DAC The scripts source another script called process_check.

Continue Reading

We’re upgrading from OBIA 7.9.5 (Financials - GL) to OBIA 7.9.6. Our reasons are for support (7.9.5 does not support Oracle 11g) and minor functionality additions. Our architecture is: HP-UX 64 bit Itanium (11.31), Oracle 11g (11.1.0.7), separate ETL server, 4x OBIEE servers (2x BI, 2xPS). We have no customisations in the ETL except something for budgets, which is superseded in 7.9.6. This post is a semi-formed articulation of my frustrations encountered during an initial run through of the upgrade in a sandbox.

Continue Reading

Mark Rittman has an excellent article about querying the DAC repository database tables, including a downloadable RPD file. Being new to working with RPDs I thought it would be good practise to explore this as well as hopefully get some useful information about our current ETL deployment. I downloaded the RPD to c:\OracleBI\server\Repository and opened it up in the Admin tool (Administrator/Administrator). First off I changed the connection pool to point to my DAC repository database, having setup a TNS entry for it first.

Continue Reading

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