Arch Linux

alonhar

Member

Registered: 2013-10-31

Posts: 16

oracle-xe does not work on new arch installation

I install arch on new laptop. Now I try to install oracle-xe, This is the steps I did:

1.Download from aur the PKBUILD and also the zip.
2.add my user to dba group
3.run /etc/rc.d/oracle-xe configure

My problem is that when I try to connect to the system user I get errors

        ORA-01092: ORACLE instance terminated. Disconnection forced
        Process ID: 0
        Session ID: 0 Serial number: 0

I think that the configuration process was fast so it maybe the problem (I think that the XE.sh file failed). I also tried to install on my another arch laptop and computer and exactly the same process works on both computer.

What is the problem with my new computer? maybe I have to install another dependency?

Thanks

Ceaser Niko

Member

From: Bangalore, India

Registered: 2017-01-27

Posts: 13

Re: oracle-xe does not work on new arch installation

I install arch on new laptop. Now I try to install oracle-xe, This is the steps I did:

1.Download from aur the PKBUILD and also the zip.
2.add my user to dba group
3.run /etc/rc.d/oracle-xe configure

My problem is that when I try to connect to the system user I get errors

        ORA-01092: ORACLE instance terminated. Disconnection forced
        Process ID: 0
        Session ID: 0 Serial number: 0

I think that the configuration process was fast so it maybe the problem (I think that the XE.sh file failed). I also tried to install on my another arch laptop and computer and exactly the same process works on both computer.

What is the problem with my new computer? maybe I have to install another dependency?

Thanks

I faced the same issue some days back on my new installation.

Here's what i did.

i)    Reset the password of oracle user, so that I can login as oracle user
ii)    go to ORACLE_HOME/bin/
iii)    ./createdb.sh - (Have patience, this takes lot of time, i have no idea why)
iv)    After this is done, i would suggest to restart. (I have had issues for not restarting)
v)    Now start listener (lsnrctl) as oracle user, and start the database. (Permission issues with lsnrctl, even though i am part of dba, no idea why )

Last edited by Ceaser Niko (2017-01-31 20:08:07)