Hi, I installed Oracle XE on CentOS 7 earlier and everything was working...
I could login with the following locally, create tables, do queries etc:
sqlplus system
However, I now get an error when I try to login using "sqlplus system" locally:
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
I guess the service is running according to systemctl?
[root@localhost admin]# systemctl status oracle-xe
● oracle-xe.service - SYSV: This is a program that is responsible for taking care of
Loaded: loaded (/etc/rc.d/init.d/oracle-xe; bad; vendor preset: disabled)
Active: active (exited) since Wed 2017-05-24 18:01:29 BST; 56min ago
Docs: man:systemd-sysv-generator(8)
Process: 1282 ExecStart=/etc/rc.d/init.d/oracle-xe start (code=exited, status=0/SUCCESS)
May 24 18:01:29 localhost.localdomain systemd[1]: Starting SYSV: This is a program that is responsible for taking care of...
May 24 18:01:29 localhost.localdomain systemd[1]: Started SYSV: This is a program that is responsible for taking care of.
However, I do not see the Oracle service actually running... this yields no results:
[root@localhost admin]# ps -ef | grep smon
root 5655 4149 0 19:00 pts/0 00:00:00 grep --color=auto smon
ORACLE_HOME and ORACLE_SID are as follows:
[root@localhost admin]# echo $ORACLE_SID
XE
[root@localhost admin]# echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/xe
Any tips for what I should look at next?
Thanks!