I am trying to setup a connection to an Oracle 11g instance from universe designer 18.104.22.1682. 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?