3 Replies Latest reply: Aug 5, 2008 11:33 AM by Sbarber.Uk-Oracle RSS

    11g loopback adapter static ip, dbconsole fails after install wired LAN NIC

    Lannie Liberty
      11g installation:
      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
      4. Rebooted.
      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
      192.168.30.64 box01.data.local
      127.0.0.1 localhost
      7. Rebooted.
      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:
           https://box01.data.local:1158/em
      12. Added environment variables:
           a. ORA_BASE=C:\ORA
           b. ORA_HOME=C:\ORA\DB11G106_HOME
           c. ORA_SID=MYDB
           d. ORA_HOST=box1.data.local
      13. Rebooted.
      14. Oracle database, listener, and database control all functioning
      on box01.data.local
      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
      18. Rebooted.
      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:
      c:\ora\db11g106_home\box01.data.local_MYDB
      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.