Skip to Content
Former Member
Dec 13, 2007 at 03:04 PM

CMS tries to start before Oracle service - therefore cannot contact its CMS database


Post Author: patrickcoote

CA Forum: Deployment

HelloI have a windows XP sp 2 machineOracle 9i installedCrystal Server XI Rel 2 (evaluation copy)My problem is that the Central Management Server (CMS) is starting up before the OracleService that the CMS database is installed on. Therefore CMS cannot start automatically and any of the jobservers etc cannot register with CMS.In event viewer i get this:"The root server reported an error Initialization Failure. (Reason: Unable to connect to the database using the provided connection string. Reason: ORA-01033: ORACLE initialization or shutdown in progress)."When the PC boots up fully I can go into Central Configuration Manager and start CMS manually and access all of its features with no problems.I looked at this site program here lists processes in their startup order and I can see from there that CMS and the other Crystal services are started before the Oracle services, for example

BOBJCentralMS starts before OracleServiceBW (alphabetical order)In CCM, on the Dependancy tab for CMS (and all other CR servers) I have added :OracleServiceBWOracleMTSRecoveryServiceOracleOraHome92TNSListenerOracleOraHome92Agent(I thought that maybe this would tell CMS to wait for these to start before starting itself )But still get the same error(s)I can provide any more info if needed.Best regardsCootser