4.2 Access the Oracle Data Transforms Compute Instance through VNC

To access the Oracle Data Transforms instance through VNC, you need to install a VNC viewer on your local computer. You also need to provide the VNC password that you had provided during the stack creation.

To access Oracle Data Transforms utilities and logs through VNC, do the following:

1. Log in to the provisioned Oracle Data Transforms instance on Oracle Cloud Marketplace using SSH as opc user:

   ssh –i <private_key> opc@<IP Address>

2. Execute the following firewall commands to open the VNC ports:

   sudo firewall-cmd --permanent --new-service=odissh
   sudo firewall-cmd --permanent --service=odissh --set-description="ODI SSHserver"
   sudo firewall-cmd --permanent --service=odissh --add-port=5901-5905/tcp
   sudo firewall-cmd --permanent --add-service=odissh
   sudo firewall-cmd –reload

3. To create a VNC session, log in to the instance as Oracle user:

   ssh –i <private_key> oracle@<IP Address>

4. Start the VNC server by typing vncserver.
5. Enter the VNC password that you had provided during the stack creation.
6. Install a VNC viewer on your local computer.
7. Use SSH to connect to the compute instance running Oracle Data Transforms, as described in Connect to Oracle Data Transforms Instance.
8. On your local computer, connect to your instance and create a ssh tunnel for port 5901 (for display number 1):

   $ ssh -L 5901:localhost:5901 –i id_rsa oracle@<IP Address>

9. On your local computer, for the VNC to work, add an Ingress rule as follows:

   No 0.0.0.0/15 TCP All 5901 TCP traffic for ports: 5901

10. On your local computer, start a VNC viewer and establish a VNC connection to localhost:1.
11. Enter the VNC password that you had provided during the stack creation.
12. For connecting multiple users, after the vncpasswd utility exits, start the VNC server by typing vncserver. This will start a VNC server with display number 1 for the oracle user, and the VNC server starts automatically if your instance is rebooted. For example vncserver@:2 or vncserver@:3.

    Note:

    Do not reboot the instance by choosing Force reboot the instance by immediately powering off. The VNC session will not start automatically.

To start developing your data loads, data flows or workflows,

1. In a web browser that has network connectivity to your compute instance, enter the url - http://<ip address>:9999/oracle-data-transforms.
2. Sign in to Data Transforms using the user and password supplied during instance deployment. Default user is SUPERVISOR.
3. Click Connections from the left pane of the Home page.
4. Click Test connection, to check if the created Autonomous Database connection is working.