Technote (troubleshooting)
Problem
Administrator launches Cognos Configuration. Administrator opens the 'Data Access - Content Manager' section. Administrator right-clicks on the Content Store, and chooses 'test'. Administrator receives error message:
[Content Manager database connection]
1. [ ERROR ] The database connection failed.
2. [ ERROR ] Content Manager failed to start because it could not load driver "oracle.jdbc.driver.OracleDriver".
Cause
Cognos Configuration cannot read the required Oracle driver file. It requires ojdbc14.jar.
Resolving the problem
Do not use the Cognos Configuration tool for testing the JDBC connection to the Cognos Content Store.
Instead use the following method:
1) Open command prompt.
2) Navgiate to the directory where you extracted the CognosConfig.zip|.tar package
3) Ensure that the JDBC driver file has been copied to the <CognosConfig>/BI-Customization/JDBC folder; if not, copy it there now.
4) Run the following commands:
Windows:
set cp=.;"%CD%\lib\*";"%CD%\BI-Customization\JDBC\*"
java -classpath %cp% com.ibm.connections.metrics.cognos.install.CognosDBJDBCConnectionVerifer cognos.db.type cognos.db.host cognos.db.name cognos.db.user cognos.db.password
Linux, AIX:
export cp=".:`pwd`/lib/*:`pwd`/BI-Customization/JDBC/*"
java -classpath $cp com.ibm.connections.metrics.cognos.install.CognosDBJDBCConnectionVerifer cognos.db.type cognos.db.host cognos.db.name cognos.db.user cognos.db.password
where
cognos.db.type, cognos.db.host , cognos.db.name, cognos.db.user, cognos.db.password are the values specified in the cognos-setup.properties file
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.