Step 8: Enabling GUI Access for DBCA – X11 Forwarding

Sometimes, clicking is better than typing—especially when you're setting up a database and prefer a mouse over a terminal. If that sounds like you, let’s get DBCA (Database Configuration Assistant) running with a full graphical interface using Xming.

• Download and Install/Configure Xming.

Xming can be obtained from here, configure Xming and start it on Windows Host and make sure that Windows Host can reach out.

• Configure putty to Forward X11 session

Open new putty session and configure your host and then go to SSH in Connection Session and expand it to find X11 forwarding

Enable X11 forwarding option which will set X display location to localhost:0

Example Putty:

Login as root user and install the needed packages. This will pull also multiple required dependencies on Linux,

dnf config-manager --enable ol8_codeready_builder

dnf install xorg-x11-apps xorg-x11-xauth

dnf install xorg-x11-apps xorg-x11-xauth

Login as opc user:

type: xauth list

Allow login for the oracle user in SSH config

Switch to the oracle user:

Add entire output using “xauth add” command:

Allow login for the oracle user in SSH config

export DISPLAY=localhost:10

---