I just finished BO XI R2 Server installation. I am using Oracle as my database which i setup before BO installation. I also created a System DSN for oracle client before installation.
During the end of installation, i got this screen saying - The install could not logon to the CMS. Please enter a user name and password for the CMS displayed below. However, the user name and password was provided during installation (in CMS Database Information screen).
I am wondering why it is asking me for that? The user name/passwor dthat i provided is working as i tested the DSN connection and also verified by logging into SQL+ with that.
I missed out on 1 major point … I actually uninstalled BO before re-installing. So has it got something to do with Oracle connection? CMS was working earlier and i re-installed because i was facing issues with tomcat.
I recollect that there was an option on ‘CMS Database Information’ screen to RESET EXISTING DATABASE (bottom left corner). Has it got something to do with this?
If it asks you to provide the CMS username and password AFTER the install, then it means that the Oracle user (or servicename) you specified during the install is not correct or at least does not have enough permissions to create/drop/update tables.
I typically use the following roles on Oracle:
Connect (which includes the Create Session permission)
Resource
And the subsequent permissions:
Alter Session
Create Cluster
Create Database Link
Create Procedure
Create Sequence
Create Synonym
Create Table
After you made sure your account has the proper set of permissions, you can reconfigure the connection for the CMS repository in the CCM. This process is described in the admin guide.
(BOB member since 2009-07-01)
(BOB member since 2006-09-18)