Arch Linux

sveatlo

Member

Registered: 2015-08-04

Posts: 2

Oracle Express edition Installation

Hi,
I'm trying to install Oracle Database Express edition. I have installed oracle-xe from AUR, but I couldn't run `dbca` command (command not found). I even tried to install oracle following the article on Arch wiki, but no luck. Is there any detailed tutorial on setting up oracle on Arch?

satanselbow

Member

Registered: 2011-06-15

Posts: 538

Re: Oracle Express edition Installation

The wiki is as good as it gets - though, from my own experience, is not as easily reproduced as such a comprehensive article may suggest.

I needed Oracle for college coursework (a couple of years ago) and ended up installing one of the Oracle Linux virtual machines with Oracle XE pre-installed due to the convoluted, hacky and usually broken installation process on Arch. Oracle (as a company) seems to have little interest in running their database software on anything other than their own distro or Windows so either a dualboot or virtual machine may be a more productive and successful option.

twelveeighty

Member

Registered: 2011-09-04

Posts: 1,456

Re: Oracle Express edition Installation

Not being able to find dbca most likely means you did not set up your $ORACLE_BASE and/or $ORACLE_HOME and you didn't add $ORACLE_HOME/bin to your path.

I'm not that familiar with oracle-xe, more with the full versions of Oracle, but in general, I recommend running dbca from your "oracle" user, which should be a member of the oinstall group. Oracle DB isn't exactly the most intuitive database package out there, so be sure to prepare yourself by reading up on the subject. There's a lot of information out there, including from Oracle corp itself.