19 februari 2012

VirtualBox - Oracle VM - networking

I had some trouble finding a working solution for running Oracle ( ovm3 ) in Virtualbox 4.1.8 on Windows 7 Professional 64-bit.

After a while, I found this configuration works (at least the connection between Host and Guest) :

  1. After installing Virtualbox, an extra networking device appears : VirtualBox Host-only Network (1)
    (see Control Panel > Network and Inteternet > Network Connections > Change adapter settings)
    Host-only means you can only establish a connection between guest and host,  your guest will not be able to connect to e.g. the internet
  2. This adapter  (1)  has IP address
    (see Control Panel > Network and Inteternet > Network Connections > Change adapter settings > Select VirtualBox Host-Only network > Details
  3. Now change the settings of the virtual machine ovm3 in Oracle VM VirtualBox Manager:
    1. Select ovw3
    2. Click on Settings (and wait until the config is fully read)
    3. Click on Network and choose Adapter 1
      1. [x] Enable Network Adapter
      2. Attached to: Host-only Adapter
      3. Name: VirtualBox Host-Only Ethernet Adapter
      4. In the Advanced section I left the settings to their defaults:
        1. Adapter Type: Inter PRO/1000 MT Desktop (82540EM)
        2. Promiscuous Mode: Deny
        3. Mac address .....
        4. [x] Cable connected
  4. Start the virtual machine ovm3
  5. Configure the network settings as follows:
    1. System > Administration > Network
    2. Enter password for root
    3. Tab Devices : select eth0 and click on Edit
      1. Statically set IP address:
        1. Address:   (or another in range 192.168.56.x)
        2. Subnet mask:
        3. Default gateway:
    4. Tab Hosts: I entered the same IP (..56) for the current hostname (don't know if this is really necessary)
  6. Save this configuration: File > Save
  7. Go back to tab Devices , click on Deactivate and Activate to finalize the network setup 
  8. Now you should be able to ping and
    Applications > Accessoires > Terminal
    ping     ...  OK
    ping    ...  OK
    pinging other IP addresses won't work because we are using the host-only  configuration in VirtualBox.
  9. Test login OVM console:
    From e.g. Internet Explorer in Windows:
    Login as admin/Welcome1
  10. Test sql*plus
    In ovm3: start sql*plus and login as ovs/Welcome1@XE
    Also working :
    -  connect system/Welcome1@XE
    - connect sys/Welcome1@XE as sysdba
  11. Start Oracle Application Express
    Login als admin/Welcome1 ... je moet onmiddellijk je paswoord wijzigen (Welkom9!)

  12. Login as sys/Welcome1
    Create a new database user:
    Database username: mvr
    Application username: mvr
    Password: Welcome1
    Create Workspace mvr
    Manage workspaces > mvr > Manage developers and users > create/edit user mvr en ken paswoord toe
    Use http://localhost:8080/apex to login workspace mvr username admin password Welkom9! .. lukt niet (ook niet als user mvr)

    Oeps ... I can't yet connect  to from Windows
    (Might not be needed anymore, because the cause was the firewall, see further)
    EXEC DBMS_XDB.SETHTTPPORT(8080);exec dbms_xdb.setListenerLocalAccess (l_access =>FALSE)
    Solution: Disable the firewall in ovm3 (or add port 8080 to the exception list)
    System  > Administration > Security Level and Firewall > Firewall: Disabled
    Now I can use I.E. in Windows to use
  13. Accessing APEX from SQL*Developer
    1. Tried but failed:
      Port 1521
      SID: XE
      Got error:
      Status: Failure - Test failed: IO Error: The Network Adapter could not establish the connection
    2. Solution:
      In ovm3:
      1. /etc/hosts:
        Verify/add   wwwdevpc37d.as.local    wwwdevpc37d
      2. In listener.ora and tnsnames.ora:
        replace localhost with   wwwdevpc37d.as.local 
      3. tnsping wwwdevpc37d.as.local
    3. In windows:
      1. c:\windows\system32\drivers\etc\hosts
        Verify/add wwwdevpc37d.as.local
      2. In sql*developer add a Connection:
        Connection name: test1
        Password: Welcome1
        [x] Save password
        Connection type: Basis  Role: sysdba
        Hostname: wwwdevpc37d.as.local
        Port: 1521
        SID: XE

  14. Info Listener.ora :
    su - root
    su - oracle

    /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh  (don't forget the point + space at the start of this line)

    locate listener.ora

    /u01/app/oracle/product/11.2.0/xe/network/admin/listener.oralsnrctl status
  15. Finally got bridged network working. This way the guest machine also can reach the internet.
    (this works for me:)

    Make sure host and guest OS share the same network segment e.g. 192.168.1.*
    Use the correct interface in Settings > Network:
    In my case:
    Adapter 1 [x] Enable Network Adapter
    Attached to: Bridged Adapter
    Name: Intel(R) Centrino(R) Advanced-N 6230 (=my wireless network adapter of the host)
    Advanced (leave the defaults): Adapter Type: Intel PRO/1000 MT Desktop 58254OEM)
    Promiscuous Mode: Deny
    [x] Cable connected

    In the guest VM :
    Not a bad idea to record your ip address and hostname in /etc/hosts
    Assign IP address, gateway and DNS:
    System > Administration > Network
    Doubleclick the eth0 interface and fill out a static IP address, mask and gateway (same as your host)
    On the DNS tab, fill out the Hostname, DNS (same as your host or e.g.

    File > Save
  16. Nice link:
  17. Enterprise managerstart Oracle simply type “emctl start dbconsole” into the console .. does not work
    Probably because some environment variables need to be set correctly in emctl
    su - root
    su - oracle
    . ./setenv.sh
    locate emctl
    ... to be continued

Geen opmerkingen: