Wednesday, August 29, 2012

OBIEE 11g (11.1.1.5.0) Installation on windows 7 64 bit, installation gets stuck at configuration stage

Issue:


OBIEE 11g (11.1.1.5.0) Installation  on windows 7 64 bit, installation gets stuck at configuration stage and log files show below lines

CSF Entries will not be parsed since the AdminServer is unreachable…..

Cause: This issue is because of the wrong entry in hosts file .



Solution:

Install the Loopback Adapter and update the hosts file file (C:\Windows\System32\drivers\etc) with the IP and your Computer Name

Eg: 127.0.0.1          ATMOHAMM.in.oracle.com     ATMOHAMM

Pre-installation checks for all platforms should include nslookups to confirm network and DNS settings. For example, the following command should return without error and the IP address and host should match those listed in the etc/hosts file:




nslookup host (where host is the "short name" or "alias" for the host machine)

nslookup host.oracle.com (lookup on the actual host name and domain)

nslookup 123.456.789.0 (where IP address specified is that of the actual OBIEE machine)




Steps to install and configure Loopback Adapter in Windows 7:

1.Click the Start menu.

2.Search for “cmd".

3.Right-click on “cmd” and select “Run as Administrator”

4.Enter “hdwwiz.exe”

1.In the "Welcome to the Add Hardware Wizard", click Next.

2.Select "Install the hardware that I manually select from a list (Advanced)" and click Next.

3.Scroll down and select "Network adapters" and click Next.

4.Select under Manufacturer "Microsoft" and then under Network Adapter "Microsoft Loopback Adapter" and click Next.

Tuesday, August 28, 2012

File Not Found error during db11g install

Issue seems to be caused by unzipping oracle database software into Disk1, 2,etc. folders. You do the same the 11g zip files. When it comes to install, you might get the above message. So, please make sure you unzip all the zip files into the same directory.




Example:



cd D:

mkdir db11g

mv win64_11gR2_database_1of2 d:\db11g

mv win64_11gR2_database_2of2 d:\db11g



unzip win64_11gR2_database_1of2

unzip win64_11gR2_database_2of2

cd d:\db11g

cd database

./runInstall



ORACLE HOME not found in the register ..Oracle DB 11g install

The issue seems to be caused by,




An old ORACLE_HOME had not been deinstalled/removed correctly and the following registry information still existed:



[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OracleMTSRecoveryService]



[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OracleMTSRecoveryService\Protid_0]

"Name"="HTTP"

"Host"="hostname"

"Port"="49155"



[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OracleMTSRecoveryService\Setup]

"NumberOfInstalls"=dword:00000001



[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OracleMTSRecoveryService\Setup\All Versions]



[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OracleMTSRecoveryService\Setup\All Versions\1]

"Version"="11.2.0.1.0"

"Home"="SOFTWARE\\ORACLE

KEY_OraDb11g_home2"



[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OracleMTSRecoveryService\Setup\Current Version]

"Version"="11.2.0.1.0"

"Home"="SOFTWARE\\ORACLE

KEY_OraDb11g_home2"





Please do the following,



1. Verify that:

the above registry keys exist in the Windows registry, and

they point to an old %ORACLE_HOME% which no longer exists on the server

If the registry keys do not exist or if they point to a valid %ORACLE_HOME% on the server, there is another cause for the error which needs to be investigated further. Do not perform step 2.



2. After verifying both of the above points, remove the above registry keys and perform the 11.2 installation again. The error should no longer occur.



Hope this fixes the issue

Manual and Clean Uninstall Oracle for Windows

Manual and Clean Uninstall Oracle for Windows
Warning: Editing registry may cause problems to your PC.
 If you facing problems trying to uninstall Oracle from your Windows workstation, or unable to uninstall Oracle installations cleanly and properly, the following steps may be used to uninstall all Oracle products currently install on the workstation:
 1. Uninstall all Oracle components using the Oracle Universal Installer (OUI).
2. Delete the HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE key which contains registry entries for all Oracle products by using regedit.
3. Delete any references to Oracle services/components in the following registry location: HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/. Looks for key entries that starts with “Ora” which are obviously related to Oracle.
4. Reboot the workstation.
5. Delete the ORACLE_BASE directory. (i.e C:\Oracle)
6. Delete the C:\Program Files\Oracle directory.
7. Empty the temp directory.
8. Empty the recycle bin. With this, the computer is more or less clear of any Oracle components, which allows you to reinstall Oracle if needed.