Oracle XE installation in Windows 7

After installation of OBIEE ,if there is no DB it has no meaning to work only with default Oracle provided samplesales.rpd and the backend XML data.Hence tried to run Oracle 10g DB version in Windows 7 running the 10g installer after changing the mode to Windows XP Service pack 2 compatibility. Alas ! tried couple of times but unfortunately not succeeded . Typical reason behind this might be Windows 7 latest security features and there must be some problem happening with my account “Debashis” though it is having full admin rights. The entire installation works except while cloning the DB it suddenly throws exception that “TNS-Can’t connect-Permission Denied” . Looks strange ! Even for me … I can see the TNS created and DB service created in Windows Services but still hopeless . Tried to google somewhere and suggested tweaks not work for me . (I might be doing something wrong … definitely will reinvent and dig to the issue later some time).

Anyway give up hope to install 10g for the time being (maybe try with 11g some time later) and suddenly come out my mind to install the Oracle smaller DB version which is enough and good compatibility with Windows 7 .

Its pretty cool except some of the typical features are missing in this small release of only 157 MB . Table Partitioning is not working in this version . Also iSqlplus , DB Console etc . is missing .Obviously I can’t expect everything in this non-business personal DB version .

So all setup is now in place to work-out with OBIEE with back-end OracleXE database.

However clean out the previous incomplete and erroneous DB installation by running Oracle 10 g De-install wizard and found still some entry in Windows Services and wipe them out straightway from Registry and Windows Environment  variables. This is very handy tweak specially for the service that creating nuisance and clutters your services list . Type Regedit in run window and goto the below path and remove the entry your wish for . (Do it very cautiously after understand the impact ) . Here my concern is ‘Oracle service for 10g’ and I remove that.

Oracle Services in registry

OBIEE installation in Windows 7

Today I tried to install Windows 7 Ultimate on my MAC Air laptop(having bootcamp enabled) specially to see the look and feel and the features available comparing of its earlier counterparts and it seems cool . Its just a polished version of Windows Vista with couple of changes and enhancement made on Taskbar and easy navigation across explorer . In addition it is having cool “Alt+Tab” and “Windows key+Tab”  options to browse through the already open multiple windows . Moreover with my “NVIDIA GeForce 9400M” Display the default Microsoft provided desktop wallpapers looking awesome and perfectly handy with full satisfaction and faith in “Windows 7 Ultimate” .

I just become fan of this with my evaluation copy Bulid 7100 downloaded from one of the famous torrent site . Still just looking for a final and official version of Windows 7 .

Now the bottom-line of the above background is simple .I am now going to install OBIEE v (I don’t have latest patch still)  on my new installed Windows 7 .(Ah ! may I have had the same installer for MAC Leopard OS-X).

Anyway the installation process seems to be simple but it suddently throw the compatibility issue with this version of OS . However done the installation after changing the setup.exe to run in compatibility mode of Windows XP Service Pack 2 .

Voila ! Its done and absolutely cool and working fine with default samplesales.rpd .But one thing I did notice is the Lock icon set against the two BI folder .I have Admin permission and though it is showing like this . Did not bother about investigating these ,specially when all the OBIEE stuffs are working fine,which seems to be new security features of Windows 7 . Will explore it later .

OBI after Installed