“Could not connect” during update of row count for Products

www.obieefans.com  
 


Q: I’m trying to update the row count for Products in the OBIEE installation tutorial.  I get a “Could not connect message”, even though I can connect using SQL*Plus and the ODBC data source?

When you enter the Connection Pool window you’ll find that the values imported from the “sh” repository don’t match the values in the tutorial.  You’ll get values of

  Call Interface: “OCI 8i/9i”

  Data Source Name: “ORCL”

instead of

  Call Interface: “OCI 10g”

  Data Source Name: “orclSH”

The value for the call interface won’t cause the connection to fail, but it’s worth selecting a value appropriate to your database from the list of values.  If you have an entry with a Net Service Name of “orcl” in your “tnsnames.ora” file then you don’t have to change the value of the Data Source Name.  If you do use “orclSH” then make sure there is a corresponding entry with this Net Service Name in the “tnsnames.ora” file.

Now to your question.  Given that you can connect from SQL*Plus and an ODBC client the problem is likely to be the password.  The default password for schema “sh” is “sh”, and this is the password that is imported from the repository.  When your DBA installed the database it’s quite likely he changed the passwords when he unlocked the schemas.  If schema “sh” has a different password you’ll be able to connect from SQL*Plus using the changed password.  You’ll also be able to connect from an ODBC client since the ODBC data source definition doesn’t store the password – unlike the Administration Tool – but asks you for it each time you test a connection.  If you’re assuming that the Administration Tool has picked up the changed password from somewhere else then that could be the problem.  Just change the password in the Connection Pool to the one that worked from SQL*Plus and you should be able to connect and update the row count.