KIIT Student here, hates Windows to the point where I refuse to even run it via dualboot or VM now. Below is a somewhat guide to install OracleDB xe 11 on (Arch) Linux.
Sadly, Oracle no longer officially hosts v11 of this product, so I had to look for alternatives. Our college themselves keep a Windows version copy of original OracleDB, but it's not usable on linux, even if I try it on Wine.
The hardest part was to find the original .zip file, and I finally found it at here
Archlinux hosts an AUR package oracle-xe-11g, which you can install via AUR Helpers like yay or paru.
For both of the above helpers, try installing the package first, and after the installation once fails, visit the following folders as per your AUR helper:
Yay: ~/.cache/yay/oracle-xe-11g
Paru: ~/.cache/paru/clone/oracle-xe-11g
Copy your oracle-xe-11.2.0-1.0.x86_64.rpm.zip to this specified directory above.
Then rerun your install command, it should work now.
After installation is complete, here are some tweaks you need to do:
sudo mkdir /var/lock/subsys
sudo usermod -aG dba $USER
sudo pacman -S xorg-xsetroot
Now we need to configure the SQL server as said by oracle officially:
sudo /etc/rc.d/oracle-xe configure
Since our teacher has said that we need to connect as system/kiit, it means they said the password should be kiit,
so when the configure script asks for any root/system/sys password, put in kiit. NOTE: Passwords (sensitive text in general) don't show in terminal!
NOTE: If you don't know, C:\dbms wont work here! Paths are different here, so you need to write /home/<WRITE YOUR USERNAME HERE> here, and DONT FORGET to put your username as said in that text.
You obviously also need to create the folder in your home directory (not desktop folder).
Every other command works as-is, so the spool log files are gonna be same as other Windows users :)
The desktop app called Run SQL Command doesn't work out of the box, in order to fix it - run this script in terminal, which fixes the issue:
sudo sed -i.bak 's|Exec=/usr/lib/oracle/product/11.2.0/xe/config/scripts/runsqlplus.sh|Exec=/usr/lib/oracle/product/11.2.0/xe/config/scripts/sqlplus.sh|; s|Terminal=false|Terminal=true|' /usr/share/applications/oraclexe-runsql.desktop
Troubleshooting:
If you get this error:
SQL> connect system/kiit;
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
This means the server is offline, so just run the desktop app called Start Database. This also means that you can close the DB server at any time by just running Stop Database!
Here's a list of apps you get from OracleDB (definitely not Instagram, Genshin Impact & Gradia lol)
We have 1:1 support for GUI Apps on par with Windows haha!
Happy Journey for your DBMS Lab Classes (I use Arch Linux BTW)!