Development Laptop environment for Oracle 11g and Visual Studio 2008.
1. Disabled motherboard network interface card.
2. Booted to new unpartitioned hard drive and installed Windows 2008.
3. In SYSTEM configuration:
a. computer named box01
b. workgroup named data
c. DNS named data.local
5. Installed Microsoft Loopback adapter and configured:
a. IP 192.168.30.64 Mask 255.255.255.0
b. Gateway none
c. DNS 127.0.0.1
6. Made first entry into hosts.ini
8. Ping 192.168.30.64 success.
9. Ping box01.data.local resolved to 192.168.30.64
10. Installed Oracle 11g with servicename and sid MYDB.
11. Oracle gave database control the address:
12. Added environment variables:
14. Oracle database, listener, and database control all functioning
15. Rebooted to BIOS and enabled motherboard network card.
16. Rebooted and installed motherboard network card drivers in Windows 2008.
17. Auto assigned network card IP, Gateway, and DNS from firewall DHCP.
DHCP assigned IP was 192.168.1.100
19. Oracle database instance and listener started.
Oracle functional from SQLPlus.
20. Oracle dbconsole did not start.
emctl dbconsole status
could not find c:\ora\db11g106_home\192.168.1.100_MYDB
It should be looking for:
21. Disable network card and reboot, and 11g goes back to using
the loopback adapter, and database control functioning again.
I followed the above procedure for Oracle 10g,
and for years had no trouble with Oracle 10g running on MS loopback static IP
and the Win2003 OS using the DHCP assigned IP for the motherboard network card,
allowing use of IIS and internet connection. Oracle 10g even tolerated me
assigning a static LAN IP to the motherboard network card.
So in Oracle 11g, how can I force the database on bootup to use the loopback
adapter and not the DHCP LAN card? Even though I installed the lookpback adapter first,
modified system hosts and environment variables appropriately, installed Oracle
with only the loopback adapter present, and then when all was working,
installed the LAN NIC.
Perhaps I need to enable a DNS Server on the Windows 2008?
I thought not since ping of the box01.data.local resolved appropriately
to the loopback adapter virtual LAN address.
Excellent test case, may by you should raise an SR and hope it ends up as a bug.
What happens if you "ping box01.data.local" what IP Address do you get back? You should be looking to get back the loopback address.
What happens if you do a nslookup 192.168.30.64 and 192.168.1.100?
Have you tred setting ORACLE_HOSTNAME? Not sure if this is just for the installer or not.