[Solved]Installation of oracle-xe (Oracle express edition 11g R2)

davidg · 2014-05-29 19:09:28

Hi,

I tried to read wiki https://wiki.archlinux.org/index.php/oracle but it says This article or section is out of date.
Reason: Installation: Packages and AUR reference too old, Dutch version is up-to-date (Discuss)

So I do not have complete information.

I did following steps.

1) I downloaded PKGBUILD for oracle-xe from AUR, downloaded rpm from Oracle site. I installed it on x64 bit.

Following is output after installation

Proceed with installation? [Y/n] y
(1/1) checking keys in keyring [############################################################] 100%
(1/1) checking package integrity [############################################################] 100%
(1/1) loading package files [############################################################] 100%
(1/1) checking for file conflicts [############################################################] 100%
(1/1) checking available disk space [############################################################] 100%
(1/1) installing oracle-xe [############################################################] 100%

creating group "dba" ...done

creating user "oracle" ...done

change directory rights ...done

set sticky bit to oracle executable ...done

creating /etc/sysconfig ...done

creating /var/log/oracle ...done

add your user to the "dba" group in order to use the oracle tools

2) Then I ran

sudo /etc/rc.d/oracle-xe configure

and configured the ports and password for sys.

3) Now when I try to run sqlplus I get error. I know I have to confiure more things but since the wiki page is saying it's outdated, where can I get more information about configuring oralce xe 11g R2

 sudo sqlplus /nolog

I get following output.
Error 6 initializing SQL*Plus
SP2-0667: Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

Last edited by davidg (2014-05-29 21:22:32)

libernux · 2014-05-29 19:24:55

Well,

Do exactly what the last line says.
If you had googled a little bit or studied the oracle-documentation you would have found it yourself.

davidg · 2014-05-29 19:31:42

If it was only ORACLE_HOME , I could do myself. But if you read wiki (which says it's outdated now ) has many things to configure. Now since the document itself says it is outdated, I just read it but did not follow it completely. If I read Oralce Doc, well they do not certify Arch Linux for their database. This is the reason I posted question. First read wiki and Oracle doc and google and then tell me how to do all configuration. Sorry I don't think its sraight forward for Oracle database on Arch linux.

libernux · 2014-05-29 19:44:10

It is essential to set the ORACLE_HOME variable, because if it is not set or set to a wrong location oracle can't find essential things.
This is exactly why these message's appeared.
So see where oracle is installed and set this variable accordingly.

The fact that Arch is not certified by oracle will not say that it will not run.
Use google translate to translate the dutch page into english. It will do a good job in translating.

Last edited by libernux (2014-05-29 20:18:19)

davidg · 2014-05-29 20:20:42

I already said

davidg wrote:

If it was only ORACLE_HOME , I could do myself

libernux wrote:

The fact that Arch is not certified by oracle will not say that it will not run.

I know it, this is why I installed it. Anyway probably you have not installed before. There are other things which need to be configured correctly so that it can run smoothly. ORACLE_HOME is just one of the thing. You need to create Oralce user, give some rights to it, set some kernel parameters, create some soft links etc.

libernux · 2014-05-29 20:37:59

That's why I said in my previous post to use Google translate.
For your interest I have been an oracle database administrator for many years and have done a lot of installations.
You have to do the installation by yourself, I'm not going to do it for you.
The oracle installation documentation is easy to follow.
If you follow the dutch translation you should well be on your way.

davidg · 2014-05-29 20:51:19

I never expected to do installation for me. If someone ask help forum it does not mean he is expected to do spoon feeding. I have another installation on CentOS which I use. I wanted it on Arch Linux. Though I am neither Oracle DBA nor I am Linux Administrator, still I have confidence that I can do it on my own. I asked question in forum because I thought if someone has done it or know some blog post which I can follow quickly, it will save my time. Anyway thank you for no help at all.

libernux · 2014-05-29 21:35:52

Obviously you do not have the intention to do any work of your own.
You did not even start looking at the translation of the dutch Wiki page.
There are many howto's for installing oracle in Centos and the dutch version in the AUR looks almost the same as those for Centos.
Good luck installing!

davidg · 2014-05-29 21:56:48

davidg wrote:

3) Now when I try to run sqlplus I get error. I know I have to confiure more things but since the wiki page is saying it's outdated, where can I get more information about configuring oralce xe 11g R2

This was my question. Where in this question you think that I am expecting anyone to do installtion for me?

If I would have been in your place, and if I would have seen that the question is asked in newbie Croner then I would have answered in following way.

Follow dutch version of wiki.

Simple.

But probably you did not want to answer straight forward.

libernux · 2014-05-29 22:41:24

Well I gave you a straight answer in post #2 and #4.

Fackor · 2018-03-11 14:11:20

Did you finally get it to work?

Arch Linux

#1 2014-05-29 19:09:28

[Solved]Installation of oracle-xe (Oracle express edition 11g R2)

#2 2014-05-29 19:24:55

Re: [Solved]Installation of oracle-xe (Oracle express edition 11g R2)

#3 2014-05-29 19:31:42

Re: [Solved]Installation of oracle-xe (Oracle express edition 11g R2)

#4 2014-05-29 19:44:10

Re: [Solved]Installation of oracle-xe (Oracle express edition 11g R2)

#5 2014-05-29 20:20:42

Re: [Solved]Installation of oracle-xe (Oracle express edition 11g R2)

#6 2014-05-29 20:37:59

Re: [Solved]Installation of oracle-xe (Oracle express edition 11g R2)

#7 2014-05-29 20:51:19

Re: [Solved]Installation of oracle-xe (Oracle express edition 11g R2)

#8 2014-05-29 21:35:52

Re: [Solved]Installation of oracle-xe (Oracle express edition 11g R2)

#9 2014-05-29 21:56:48

Re: [Solved]Installation of oracle-xe (Oracle express edition 11g R2)

#10 2014-05-29 22:41:24

Re: [Solved]Installation of oracle-xe (Oracle express edition 11g R2)

#11 2018-03-11 14:11:20

Re: [Solved]Installation of oracle-xe (Oracle express edition 11g R2)

Board footer