I'm having services startup issues after having installed EPM v11 with Essbase, Provider Services, SharedServices Web app + OpenLDAP, EAS and Oracle Express (XE) as repository.

After reboot, at start I have to restart Oracle XE and Shared Services services or I cannot log to EAS.

The errors I could spot are the following :

FILE HyS9SS-sysout.log
26 Jun 2009 16:36:00 - org.apache.slide.store.impl.rdbms.JDBCStore - EMERGENCY - Could not create connection. Reason: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-12519 The listener could not find any available service handlers that are appropriate for the client connection. One possible cause for this error is that the server was not configured for the specified server type (shared/dedicated).

Rgds,

SRx

I'd be curious if Oracle Express isn't starting fast enough and Shared Services is timing out because of that.

Are you able to look at event logs and disk logs to see if Oracle Express is fully online by the time Shared Services is looking for it?

Do the Shared Services log indicate they cannot access the database also?

Regards,

John

We went to support with this issue. They said that the services had to start in a certain order. So we had to change them to manual startup and then set up a startup script using net start to start the services. We also found we had to put waits in between a couple of the services.

Thanks for your reply, indeed I as fearing this reply... I thought that the services sync and wait was solved since the first releases of 9.

I'll try to do the thing manually!

We've recently deployed 11.1.1.1 as well and also found in addition to the service startup order, the antivirus (I believe we are using Officescan) played a large part in the startup time as it took much longer for each service to startup as it would have to pass through the files before proceeding so a service would literally take up to 5mins to startup each one. So the server admin set the antivirus to avoid any directories and files pertaining to 11x or used by it.

Perhaps try disabling your antivirus first, then startup your services in the specific order and see if it starts up and syncs quicker.

One of the fixes in 11.1.1.2 was supposed to be startup order so if you are on a laptop install of 11.1.1.1 suggest you upgrade it and this alone may do the trick.

The upgrade is pretty simple (aside from downloading the 4 gig and unpacking to 8 gig of executables).

Regards,

John

Strange... because I'm indeed dealing with 11.1.1.2 !!!
The issue is not isolated as I could reproduce it many time on different winxp environments...