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.
Al Gulland 