I’ve been running R2 without any issues for the last 6-7 years.
This morning I received an alert that the database server (in DEV) was restarted. When I tried to start the CMS in CCM, I got this error:
The root server reported an error Initialization Failure. (Reason: Unable to connect to the database using the provided connection string. Reason: ORA-01017: invalid username/password; logon denied)
I did a tnsping to the database instance and its good.
i then connected to the database with the CMS admin account using
c:\ > sqlplus username/password@database and that worked out fine too.
The DBAs have verified that the account is ok.
I tried to copy data from another source and use the same database, but it gave me the ORA error again. Strange that I can connect using SQLPLUS, but not through CCM.
I’m at a loss with this one. Any other things I can try? thanks
I went in to the CMS configuration tab and did a ‘Select a data source’ option and re-entered the database name, username, and password. CMS appears to have started.
Hi,
I’m facing exact same issue. You mentioned “went in to the CMS configuration tab” can you please explain that? meaning, how did you get to the CMS tab?. I verified the username / password and they are good. Thanks for your response.
Mohan
@Mohan:
You need to use CCM (Central Configuration Manager) a client tool that is required on your machine. If you already have it, open it from Start Menu --> Programs --> Business Objects (depends on your version) --> CCM.
Go to the configuration tab by clicking on the properties of SIA(Server Intelligent Agent). There you can specify the user/passwd for the repository.
(BOB member since 2004-06-06)