Error Encountered in Cognos 8.3 with Oracle XE

Below is the error message that I encountered when trying to run a report in Cognos.

CNC-MON-0024 Monitor Service paging error: Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found The Connection descriptor used by the client was: localhost:1521:XE

I am not too sure what is the actual cause of this error but below is the way that I solved it.

Launch SQL Plus and issue the the command as below:

SQL> connect / as sysdba;
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 285212672 bytes
Fixed Size 1287016 bytes
Variable Size 96472216 bytes
Database Buffers 184549376 bytes
Redo Buffers 2904064 bytes
Database mounted.

SQL> alter system set job_queue_process=20;
System altered.

SQL> alter system set PROCESSES=100 scope=SPFILE;
System altered.

SQL> alter system set open_cursors=300 scope=both;
System altered.

SQL> alter database open;
Database altered.

SQL> alter system disable restricted session;
System altered.

Hope this may helps. :)

Install and Configure Cognos 8 Business Intelligence - Part 1

This post shows the step-by-step from installation and configuration of Cognos 8.

Assumption : MS SQL Server 2005 and IIS already installed in your machine.

Install Cognos 8 BI on Windows 2000

Run the issetup.exe in the win32 folder from your download directory. The following screen will be shown.


Ensure that English is selected as the language and click Next.


Accept the license agreement by choosing the I accept radio button. Click Next.


Accept the default as the installation location. Click Next.


A dialog box will be pop-up to ask for confirmation whether you want to create the directory. Click Yes and next screen will be shown.


Ensure that all the components are selected as depicted in above screen and click Next.


Click Next again at this step.


You are now at Installation Summary screen which summarize list of components to be installed in your machine and in the particular drive. Click Next.


The installation process is now starting. Once completed, click Next and you can see the following screen.


Click on finish to close the screen. You just finish with the installation process of Cognos 8 BI.

You shouldn't have any problem with all the steps indicated here as the entire installation process is pretty straight forward. I will be posted the Part 2 end of this week. :)

IBM acquired Cognos at $5 billion USD

SAP bought BusinessObjects last month and now IBM acquired Cognos, last of large independent business intelligence providers. In just a month, two leading business intelligence players have been acquired.

http://www.cognos.com/news/releases/2007/1112.html