How To, SAP Business Objects Enterprise

SAP BI 4 Checking Database Connectivity

A common issue found when starting SAP Business Objects BI4 is that the system cannot logon to the CMS database repository. Troubleshooting this can be tricky but the following command can be used on a Linux deployment to check connectivity to an Oracle database and capture error messages in a log file,

/opt/sapboe/sap_bobj/ccm.sh -isdbempty -dbdriver "oracledatabasesubsystem" 
-connect "DSN=<tnsname>;UID=<username>;PWD=<password>" -logfile logfile.out

where <tnsname>, <username> and <password> are the appropriate Oracle logon credentials for the database.

What this command actually does is to check that the target database is or is not an empty database schema. However if there is a database connection error then this will be captured in the logfile.out and from there we can troubleshoot connection issues.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s