You can access database servers remotely by using tools such as PuTTY and Virtual Network Computing (VNC) which are freely available for download. In most cases, accessing a database server in a command-line mode via PuTTY is enough. Sometimes we may need to access a database server to run GUI-based software. For example, to run runInstaller to install Oracle software or DBCA to create databases. In these cases, VNC comes handy as it support GUI-based interface.

VNC allows you to run GUI interface on database server. It allows you to execute programs locally on the server, while only the screen output is sent to the VNC client on your desktop. you can use the vncserver command to configure VNC.

In this article we will demonstrate how to install VNC package using 2 different methods, start VNC session and run some Graphical interface tools to ensure VNC is configured correctly on the server.

Step 1: Installing VNC Package

Get the Exadata software version (optional)

[root@dm01db01 ~]# imageinfo

Kernel version: 4.1.12-94.7.8.el6uek.x86_64 #2 SMP Thu Jan 11 20:41:01 PST 2018 x86_64
Image kernel version: 4.1.12-94.7.8.el6uek
Image version: 12.2.1.1.6.180125.1
Image activated: 2018-05-03 01:49:58 -0500
Image status: success
System partition on device: /dev/mapper/VGExaDb-LVDbSys1

Get the Exadata Model (optional)

[root@dm01db01 ~]# dbmcli -e list dbserver attributes makeModel
Oracle Corporation SUN SERVER X4-2

Check if VNC package already exists. In my case VNC is not configured.

[root@dm01db01 ~]# rpm -qa tigervnc*

Get the Operating System version and update

[root@dm01db01 yum.repos.d]# cat /etc/oracle-release
Oracle Linux Server release 6.9

You can install packages in 2 ways:

Using proxy server. This should be configured by your Organization network engineer already.
Using Local Yum repository

Using proxy server

Get the proxy server details from your network engineer

Set the http_proxy environment variable

[root@dm01db01 ~]# export http_proxy=webproxy:80

Navigate to YUM repository directory

[root@dm01db01 ~]# cd /etc/yum.repos.d/

[root@dm01db01 yum.repos.d]# ls -ltr
total 24
-rw-r–r– 1 root root 6843 May 7 2016 public-yum-ol6.repo
-r–r—– 1 root root 896 Jan 26 05:19 Exadata-computenode.repo.sample
-rw-r—– 1 root root 291 May 3 01:59 Exadata-computenode.repo

Open the public-yum-ol6.repo and uncomment enabled=1 for the following 2 stanza

[root@dm01db01 yum.repos.d]# vi public-yum-ol6.repo

[ol6_latest]
name=Oracle Linux $releasever Latest ($basearch)
baseurl=http://yum.oracle.com/repo/OracleLinux/OL6/latest/$basearch/
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
gpgcheck=1
enabled=1

[ol6_u9_base]
name=Oracle Linux $releasever Update 9 installation media copy ($basearch)
baseurl=https://yum.oracle.com/repo/OracleLinux/OL6/9/base/$basearch/
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
gpgcheck=1
enabled=1

[root@dm01db01 yum.repos.d]# ls -ltr
total 36
-r–r—– 1 root root 896 Jan 26 05:19 Exadata-computenode.repo.sample
-rw-r—– 1 root root 291 May 3 01:59 Exadata-computenode.repo
-rw-r–r– 1 root root 10544 May 9 10:09 public-yum-ol6.repo

Perform the Yum clean up

[root@dm01db01 yum.repos.d]# yum clean all
Cleaning repos: ol6_latest ol6_u8_base ol6_u9_base
Cleaning up Everything

List the yum repositories

[root@dm01db01 yum.repos.d]# yum repolist
ol6_latest | 1.4 kB 00:00
ol6_latest/primary | 68 MB 00:01
ol6_latest 40153/40153
ol6_u7_base | 1.4 kB 00:00
ol6_u7_base/primary | 3.2 MB 00:00
ol6_u7_base 8428/8428
repo id repo name status
ol6_latest Oracle Linux 6Server Latest (x86_64) 32,690+7,463
repolist: 39,319

Install the VNC package as shown below

[root@dm01db01 yum.repos.d]# yum install tigervnc*
Setting up Install Process
Resolving Dependencies
–> Running transaction check
—> Package tigervnc.x86_64 0:1.1.0-24.el6 will be installed
—> Package tigervnc-server.x86_64 0:1.1.0-24.el6 will be installed
–> Processing Dependency: libxshmfence.so.1()(64bit) for package: tigervnc-server-1.1.0-24.el6.x86_64
—> Package tigervnc-server-applet.noarch 0:1.1.0-24.el6 will be installed
—> Package tigervnc-server-module.x86_64 0:1.1.0-24.el6 will be installed
–> Processing Dependency: xorg-x11-server-Xorg for package: tigervnc-server-module-1.1.0-24.el6.x86_64
–> Running transaction check
—> Package libxshmfence.x86_64 0:1.2-1.el6 will be installed
…
…
Transaction Summary
=============================================================================================================================================================================================
Install 24 Package(s)

Total download size: 4.3 M
Installed size: 11 M
Is this ok [y/N]: y
…
…
Installed:
tigervnc.x86_64 0:1.1.0-24.el6 tigervnc-server.x86_64 0:1.1.0-24.el6 tigervnc-server-applet.noarch 0:1.1.0-24.el6 tigervnc-server-module.x86_64 0:1.1.0-24.el6

Dependency Installed:
acl.x86_64 0:2.2.49-7.el6_9.1 cryptsetup-luks.x86_64 0:1.2.0-11.el6 cryptsetup-luks-libs.x86_64 0:1.2.0-11.el6 hal.x86_64 0:0.5.14-14.el6
hal-info.noarch 0:20090716-5.el6 hal-libs.x86_64 0:0.5.14-14.el6 hdparm.x86_64 0:9.43-4.el6 libepoxy.x86_64 0:1.2-3.el6
libevdev.x86_64 0:1.4.5-2.el6 libxshmfence.x86_64 0:1.2-1.el6 mesa-libEGL.x86_64 0:11.0.7-4.el6 mesa-libgbm.x86_64 0:11.0.7-4.el6
mtdev.x86_64 0:1.1.5-1.el6 pm-utils.x86_64 0:1.2.5-11.el6 system-setup-keyboard.x86_64 0:0.7-4.el6 xorg-x11-drv-evdev.x86_64 0:2.9.2-1.el6
xorg-x11-drv-vesa.x86_64 0:2.3.4-1.el6 xorg-x11-drv-void.x86_64 0:1.4.1-1.el6 xorg-x11-server-Xorg.x86_64 0:1.17.4-16.0.1.el6_9.1 xorg-x11-server-common.x86_64 0:1.17.4-16.0.1.el6_9.1

Complete!

Verify the VNC package is installed

[root@dm01db01 yum.repos.d]# rpm -qa | grep tigervnc*
tigervnc-server-applet-1.1.0-24.el6.noarch
tigervnc-server-1.1.0-24.el6.x86_64
tigervnc-server-module-1.1.0-24.el6.x86_64
tigervnc-1.1.0-24.el6.x86_64

Using Local Yum repository

This method is useful when you don’t have internet access through proxy.

Refer to the blog article below on how to configure a local yum repository on Exadata
http://netsoftmate.blogspot.com/2018/05/create-local-yum-repository-on-Exadata.html

Step 2: Configure VNC Server

Execute the vncserver command. On the prompt enter any password of your choice

[root@dm01db01 ~]# vncserver

You will require a password to access your desktops.

Password:
Verify:

Warning: dm01db01.netsoftmate.com:1 is taken because of /tmp/.X1-lock
Remove this file if there is no X server dm01db01.netsoftmate.com:1

New ‘dm01db01.netsoftmate.com:2 (root)’ desktop is dm01db01.netsoftmate.com:2

Creating default startup script /root/.vnc/xstartup
Starting applications specified in /root/.vnc/xstartup
Log file is /root/.vnc/dm01db01.netsoftmate.com:2.log

3. Verify VNC server is running and note down the port number. Here the VNC server is running at dm01db01.netsoftmate.com:3 for root user

[root@dm01db01 ~]# ps -ef|grep vnc
root 141816 297951 0 12:14 pts/1 00:00:00 grep vnc
root 356225 1 0 11:02 pts/1 00:00:00 /usr/bin/Xvnc :3 -desktop dm01db01.netsoftmate.com:3 (root) -httpd /usr/share/vnc/classes -auth /root/.Xauthority -geometry 1024×768 -rfbwait 30000 -rfbauth /root/.vnc/passwd -rfbport 5903 -fp catalogue:/etc/X11/fontpath.d -pn
root 356351 1 0 11:02 pts/1 00:00:00 vncconfig -iconic

Step 3: Test VNC Connection and GUI interface

Download and Install VNC Viewer. Here I am using VNC Tiger for Windows

Double Click on VNC Viewer icon to launch VNC Viewer

Enter the host name and port. You can get these by execute the command “ps -ef|grep vnc” on the server

Enter the password provided at the time of configuring vncserver

The VNC session is displayed

Now test the GUI interface by starting some GUI tool. Here I am going to start DBCA to test the GUI interface

Conclusion

In this article we have learned how to install, configure and test VNC server on Exadata compute node. VNC allows you to run GUI interface on database server. It allows you to execute programs locally on the server, while only the screen output is sent to the VNC client on your desktop. you can use the vncserver command to configure VNC.

Oracle DBCS : Configure and Use VNC (GUI) On Oracle Cloud Compute Node

By Netsoftmate on

February 5, 2018

- Uncategorized

When you create a Database Deployment in Oracle Database Cloud Service, the following tasks are completed for you:

Compute Node Allocated
Storage Allocated
Virtual Machine Image Installed
Set Keys and Privileges
Install and Configure Database
Configure Backup
Configure Tools
Configure Access

Network access to the Compute Node associated with Oracle Database Cloud Service is primarily provided by SSH connections on port 22. By default SSH port 22 is opened to allow access to the tools, utilities and other resources on the Compute Node associated with the Oracle Database Cloud Services. You can use SSH client software such as PuTTY on Windows to establish a secure connection and log in as “opc” or “oracle” user. You can also connect to Compute node using GUI interface, for this you can use VNC.

In this article we will demonstrate how to connect to Compute Node using VNC.

Prerequisites

IP address of Compute Node
TigerVNC Viewer client software
TigerVNC Server package installed on Compute Node

Steps to connect to Oracle Database Cloud Compute Node using VNC on Windows Operating System

Open PuTTY session on your desktop and enter Compute Node IP address

On the left pane, expand “SSH” and select “Auth”. On the right pane, click on “Browse” button. Select the Private Key that matches the Public Key for your Deployment. Click “Open”

Enter login as “opc”. This will connect you to the compute node without password

Switch to root by executing “sudo -s” command. Confirm that you are switched to root by executing “id” command

Verify your Operating System version. Here the OS is OEL and version is 6 with update 8

Navigate to the yum repository directory and open the public yum repository file

In the file look for your operating system version, example ol6_latest and make sure “enabled=1” is set

Next look for operating system base update, example ol6_u8_base and make sure “enabled=1” is set

Verify the file is updated successfully

Install the Tigervnc* package using the yum utility

Type y and hit return

We can see that the package installation completed successfully

Verify that the package is installed using rpm -qa command

Verify if vnc server is running or not as root and oracle user. We can see that vnc server is not running

Let’s start the vnc server as oracle users. Enter a password of your choice and verify. From the ‘ps -ef|grep vnc’ command output note down the port numbers :1 and 5901

Open Tiger VNC Viewer on your desktop/laptop and enter the port :1

Connection failed…. This is because the port 5901 is not opened on the Compute Node. We should open the port 5901 and try again

Follow the procedure below to configure custom Security List and Rules to enable access to specific security applications (VNC application and port range 5901 – 5905) on the compute node.

Open a web browser and enter the URL you received in the Welcome email to login to Oracle Cloud Account

Enter your username and password

On the home page, Click “Menu” under “Compute Classic” Cloud Service as shown below

Click “Open Service Console”

Click on “Network”

Expand “Shared Network”

Click “Security Applications” and then “Create Security Application”

Enter a Security Application Name, Port Type, Port Range Start, Port Range End and a Description and click Create. In our scenario we are enabling access to VNC application on the ports between 5901 and 5905

Make sure the Security Application is created by searching it

Click “Security Lists” and then “Create Security List”

Enter Security List Name and leave Inbound Policy and Outbound Policy to DEFAULT value and click Create

Make sure the Security List is created by searching it

Click “Security Rules” and then “Create Security Rule”

Enter the details as show below:

Name: Any desired meaningful name
Status: Enabled to enable the rule
Security Application: we create above
Source: Security IP List -> public-internet
Destination: select security list created above from drop down
Click Create

Make sure the Security Rule is created by searching it

Click “Instances”

Select your Instance and scroll down

Click “Add Security List”

Select “Security List” create above from the drop down list

Make sure the Security List added to your Instance

Open VNC on your desktop/Laptop and enter the IP address of your Database Deployment

Enter VNC password used at the time of starting VNC server software on the compute node

Enter Oracle user password given at the time of configuring VNC Server to connect to the Compute node

We are now connected to the compute node in GUI interface using VNC

Enjoy working with Compute Node in GUI mode…

Conclusion
In this article we have learned how to connect to Oracle Cloud Compute Node using VNC in GUI Mode. To accomplish this we need to install Operating System packages and create custom Security List and Rules to enable access to specific security applications (VNC application and port range 5901 – to 5905) on the compute node. Oracle Compute Cloud Service networking create resources to provide network access to the compute node.

Configure VNC On Oracle Database Appliance

By Netsoftmate on

July 3, 2017

- Uncategorized

Introduction:

To Deploy ODA you need GUI interface, to do this you make use of VNC server to connect with ODA and open GUI interface.

In this article I will demonstrate how to configure VNC on Oracle Database Appliance.

Configure VNC:

You can access database servers remotely by using tools such as PuTTY and Virtual Network Computing (VNC) which are freely available for download.

In most cases, accessing a database server in a command-line mode via PuTTY is enough. Sometimes we may need to access a database server to run GUI-based software. For example, to run runInstaller to install Oracle software or DBCA to create databases. In these cases, VNC a cool tool for running GUI-based sofware.

VNC allows you to run GUI interface on database server. It allows you to execute programs locally on the server, while only the screen output is sent to the VNC client on your desktop.

On ODA you can configure VNC in two ways:

startx command
vncserver command

Using startx command:

– Login to ILOM as super user (root) and execute startx command

– VNC screen is displayed

– Execute “oakcli deploy” to test GUI access

– Left click and exit to return back to ILOM session

Using vncserver command:

– Login to database server as Suport user (root), Check if vnc servers is running, Execute vncserver command to start vnc. Enter the root password first time and enter again to verify. Check if vnc server is started and note down the port number.

– Download VNC-Viewer and Click on VNC-Viewer on desktop

– ON VNC-Viewer page enter the ODA Node IP or hostname along with VNC server port

– Click Continue

– Enter the root password

– VNC screen is displayed

– Execute “oakcli deploy” to test GUI access

– Left click and exit to return back to ILOM session

Conclusion:

In this article we have learned about VNC and how to configure VNC on Oracle Database Appliance. Configure VNC is simple and straight forward. VNC comes handy when you want to run GUI-Based applications. To Deploy ODA you need GUI interface, to do this you make use of VNC server to connect with ODA and open GUI interface.

Good Contents Are Everywhere, But Here, We Deliver The Best of The Best.Please Hold on!

Home

About

Services

Blog

Contact

Configure VNC on Exadata Database Machine

Oracle DBCS : Configure and Use VNC (GUI) On Oracle Cloud Compute Node

Configure VNC On Oracle Database Appliance

ABOUT US

Services

CONTACT US

Follow Us!