working on applications and technology

It is very popular to install Oracle database Express edition on one's laptop , XE is a small and light footprint of Oracle database which is very good to serve as a repository database for many products.

I have been using XE on my laptop for a long time and when I install Hyperion Essbase 11 today, I use XE as the hyperion repository natrually and I realize that the default parameters of XE is really small and we have to change it to bigger value for the installation to be sucessful.

Installation of Essbase

Now the installation of Essbase 11 has become tedious, We have to download and install a bunch of products before we could set up the testing essbase envorirment. you could refer to this article.

It seems that Oracle does not treat Essbase as a separate product and we have to install the EPM foundation service before you could play with Essbase.

Although the whole installation process of the products is very smooth and takes me only about 20 minutes but the configuration process prove to become complex.

From my previous experience with 9.3.1 version, the configuration process of essbase is really easy and only required a few dummy clicks of the 'next' button.

Before starting the 'EPM system configurator', we have to configure an Oracle databaes to serve as the repository to store some configuration data for the Oracle(Hyperion) EPM, I use the XE database on my laptop to do it.

When I start the 'EPM System Configurator' , the whole process is similiar with version 9.3.1, But errors appear at the final screen indicating some components does not register with the shared service.

I check one of the log files under the HYPERION_HOME/logs and found errors like the following:

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)

It seems that there 's database related problems now and When I try to connect to the database using sqlplus

sqlplus user/password@XE

I receive the following error message:

ORA-12520: TNS:listener could not find available handler for requested type of server

With my abundant database experience I could tell that the value of the 'processes' parameter is too small.

I found out that the default value of 'processes' for my XE database is only 40 and I modified the parameter and restart the XE database and the configuration finally succeed!