BOBJ can not connect to the Oracle DB.

[Former Member]

Currently I am having issues connecting our BOBJ server to our DB. This worked in the past but I am now receiving the following error:

err: ERROR Failed to get cluster name. (STU00165)

err: Error description: BusinessObjects Enterprise CMS: Unable to connect to the CMS system database ""prept04"". Reason: ORA-01017: invalid username/password; logon denied

I checked the tnsnames.ora and "prept04" is there. I also checked the user and password (user: bobj) to ensure they are correct. I took this one step further and connected from the BOBJ server to our DB using sqlplus with success.

Here is the other error that we are seeing:

2015/09/22 15:49:31.628|>>|A| |6684766|   1| |||||||||||||||assert failure: (OracleDatabase.cpp:117). (0 : Programmer error: OCI_INVALID_HANDLE).

[5] + Stopped (SIGTSTP)        tail -100f boe_cmsd_6684766_2015_09_22_15_49_31_626_trace.log 

Any idea what else could be missing/misconfigured? Thanks.

[onkarvelhals · Accepted solution]

Hi Jacob,

It is quite a generic error. Invalid handle pops up when BI doesn't know how to handle the data that your DB just provided.

The other error; invalid username/ password makes me wonder if the password for this user is expired.

However, using sqlplus you should be promted if that was the case.

Is there any other user which has DBA access to this database?

Furthermore, repoint your SIA (node) to exsiting database using cmsdbsetup.

Regards,

Onkar

[Former Member · Accepted solution]

Thanks Onkar! I re-pointed our BOBJ server to the DB using cmsdbsetup (Option 6: Update) and it works!