Alison Holloway's Blog

So now you have a guest virtual machine running on Oracle VM Server. You want to connect to it of course. As I've not yet introduced Oracle VM Manager to this scenario, I'll not talk about connecting to it from there just yet, though this is probably the easiest way. So my next blog will be devoted to Oracle VM Manager.

There are many ways to connect to the guest virtual machine. Here I'll show you how to do it using VNC. Before you connect to it,  you'll need to find the VNC port used by the domain. On the Oracle VM Server, run:

# xm list -l |more

In the output, look for the device vfb and the location entry in that section. It will be something similar to:

location 0.0.0.0.:5900

The last part of that string is the VNC port you can use to connect to the guest. From another host, use VNC to connect to the guest:

# vnc -Shared 192.168.2.21:5900

The -Shared flag allows others to connect to the port as well as yourself. The IP address is the IP address of the Oracle VM Server. If all goes well, you'll see a command shell login. Log in using the default template login root/ovsroot.

If you used an Oracle Database template when you created the guest, here's how to log in to the database with SQL*Plus (the Oracle Database command-line tool):

Once you're logged in to the guest as root, su as the oracle user (oracle/oracle):

su oracle

Start SQL*Plus:

$ORACLE_HOME/bin/sqlplus /nolog

The $ORACLE_HOME environment variable is already set in the template to /u01/app/oracle/product/db10g, which is the location of the Oracle Database installation (the Oracle Home).

At the SQL*Plus prompt, log in as the SYSDBA user using operating system authentication:

SQL> connect / as sysdba

You are logged into SQL*Plus and connected to the Oracle Database with full database administration privileges.

Huzzah!