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 MobaXterm.
No extra fuss with Xming or PuTTY—MobaXterm does it all, like a well-trained cat fetching socks (okay, maybe not that magical, but close).
Install X11 on Linux
1) Enable the CodeReady-builder repository
Install the needed packages. This will pull also multiple required dependencies:
Install GUI packages on your Linux server
Login as opc user:
type: xauth list
Switch to the oracle user:
Add entire output using “xauth add” command:
Install and Launch MobaXterm
- Download from:
🔗 https://mobaxterm.mobatek.net/download-home-edition.html - Run MobaXterm (no installation needed for the portable edition)
- In the toolbar, click “Session” → “SSH”
Configure SSH with X11 Forwarding
In the session settings:
- Remote host: your server’s IP or hostname
- Check “Specify username” and enter your Linux username (e.g.,
oracle
oryouruser
) - Under X11 Forwarding, make sure “X11-Forwarding” is checked
Then click OK and connect. MobaXterm automatically handles the X server part—no need for a separate tool like Xming!
Steps to Enable Direct SSH Login for the oracle
User
- Set a password for the
oracle
user.
sudo -s
passwd oracle
Allow login for the oracle
user in SSH config
Open the SSH config file:
/etc/ssh/sshd_config
AllowUsers oracle opc, Check or add the following line (if it's missing):
Check or add the following line (if it's missing):
Check or add the following line (if it's missing):
AllowUsers oracle opc
If AllowUsers
is already set but does not include oracle
, add it.
Also make sure these options are set (or uncommented):
PermitRootLogin no
PasswordAuthentication yes