Use BusinessObjects credential mapping against Oracle 11g instance

60 Views

Hi,

I am trying to setup a connection to an Oracle 11g instance from universe designer 12.1.0.882. My username and password to universe and DB instance is the same.

Connection type = Secured

Oracle 11g Client

Authentication Mode = Use BusinessObjects credential mapping

When I test connection, I get an error "The Server is not responding (SBO001)". Details tab say

"DBD: ORA-01017: Invalid username/password; logon denied".

The database instance is OID authenticated.

Has anyone come across this problem?

One guess- I had a similar problem with Oracle 10g forms server as well. turned out that forms 10g apps server was converting password to all upper case before trying to connect to the instance. Oracle 11g instance password are case sensitive and hence login was failing. With Oracle apps server, we were able to solve the problem by putting in a parameter to ignore password case. Is there something similar with BO server?

regards,

Sridhar