Oracle 11 XE on Ubuntu giving ORA-27101: shared memory realm does not exist

Question

I am trying to setup oracle 11g xe on my ubuntu system. I started with instructions given on http://meandmyubuntulinux.blogspot.com/2012/05/installing-oracle-11g-r2-express.html and its other link as well. Everything works fine and database gets installed. XE schema gets created. problem: I am not able to log into database.

when I try

sqlplus / as SYSDBA

I get

ERROR:
ORA-01031: insufficient privileges

Enter user-name: root
Enter password: 
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 have checked ORACLE_SID is XE I have manually put root user to DBA group

everything is fine in Listener.ora. I also created initXE.ora as suggested in some blog and assigned it to DBA group and put it in classpath.

I think I tried almost everything. and nothing more comes to my mind.

question : how else can I log in?

[This page](https://community.oracle.com/thread/2378116) may be helpful. — Joachim Isaksson, Dec 29 '13 at 16:47
Have you tried running sqlplus as the oracle user (*not* as the root user) ? — Frank Schmitt, Dec 29 '13 at 16:54
possible duplicate of [ORA-27101: shared memory realm does not exist](http://stackoverflow.com/questions/3302941/ora-27101-shared-memory-realm-does-not-exist) — Yaroslav Shabalin, Dec 29 '13 at 17:35
The OP needs to get past the ORA-01031 before they can start the instance and get rid of the ORA-27101 though? — Alex Poole, Dec 29 '13 at 17:47
I also faced the same problem for oracle 10g XE. suod /etc/init.d/oracle-xe restart works for me. — Razib, Aug 17 '14 at 09:02

score 1 · Answer 1 · answered Dec 29 '13 at 17:24

Seems like your oracle database isn't running. Shared memory is what your client uses to talk to the server when you use the BEQ adapter - i.e. you're not running over the network. Check ps -fuoracle (assuming you named your db user oracle) if the server is up.

score 1 · Answer 2 · answered Oct 27 '14 at 12:29

1

Use this command to log in with SQL plus

sqlplus {username}/{password}@//{ip}:{port}/{SID}

sample:

sqlplus test_username/test_password@//192.168.0.12:1521/val

answered Oct 27 '14 at 12:29

X-HuMan

1,488
1
17
37

Okay. That works for me. However, a clear text password on the command line? There must be a better solution, right? – Martijn Burger Jul 03 '15 at 15:25

Senior .Net Dev3loper · Answer 3 · 2016-11-24T11:00:33.790

1

You must create a new user and then you will be able to connect

  $> su - oracle
  $> . goo
  $> sqlplus / as sysdba
  SQL> create user <myuser1> identified by <mypassword>;
  SQL> grant connect, resource to <myuser1>;
  SQL> connect <myuser1>/<mypassword>

Edited
To Start the instance

  $>sys as sysdba
  SQL>Enter password:<*****>
  SQL>startup open

edited Nov 24 '16 at 11:00

answered Nov 23 '16 at 16:12

Senior .Net Dev3loper

111
1
1
9

`That error generally means there's no Oracle instance (the processes) to connect to. Someone needs to log in and start the instance.` it's not about missing users – are Nov 23 '16 at 16:45
You are right that's why I will change the posted answer! – Senior .Net Dev3loper Nov 24 '16 at 08:39

score 0 · Answer 4 · answered Nov 25 '19 at 06:31

0

Connect to Oracle as sys user and Run these commands.

sqlplus sys/sys as sysdba
shutdown
startup
exit

answered Nov 25 '19 at 06:31

Abhishek KM

11
1

Oracle 11 XE on Ubuntu giving ORA-27101: shared memory realm does not exist

4 Answers4