Tuesday 17 February 2009

Installing Oracle 10g on SUSE10

Had problem installing Oracle10g on a Linux server using SUSE10 O/S. The installation file only seems to think Oracle is certified to be installed on SUSE9. To get round the problem run the install file with the following option:

./runInstaller -ignoreSysPrereqs

What Metadata is the MicroStrategy Project Source Connected to?

There is nothing from the GUI inetrface that tells you what metadata DSN your Microstrategy Project Source is connected to. This is one way of finding out however:

In order to determine which DSN is being used by Intelligence Server for metadata connectivity, navigate to the following registry key shown below:

HKEY_LOCAL_MACHINE>SOFTWARE>MicroStrategy>Data Sources>Castor Server>Location

and see the value.
This has to be done on the machine where the Intelligence Server is.