ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist ORACLE 10g XE

linux ubuntu oracle10g oracle-xe
Jatin Adarsh picture Jatin Adarsh · Feb 16, 2017 · Viewed 8.7k times · Source

enter image description here

Dont know what went wrong. It worked perfectly first time untill i restarted my Machine.

Answer

mathguy picture mathguy · Feb 16, 2017

In addition to Alex's explanation, in particular the bit about the database not restarting automatically when you restarted your machine:

Navigate to /etc/oratab and edit it as root.

Find the line

orcl:/u01/app/oracle/product/12.1.0/db_1:N

Change the N at the very end to Y.

This will make the database start up whenever you restart your machine, so you won't have this trouble again.

Related questions

error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' -- Missing /var/run/mysqld/mysqld.sock

My problem started off with me not being able to log in as root any more on my mysql install. I was attempting to run mysql without passwords turned on... but whenever I ran the command # mysqld_safe --skip-grant-tables & …

Read More
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I am an electrical engineer who mainly plays around with power systems instead of programming. Recently, I have been following a manual to install a software suite on Ubuntu. I have no knowledge of mySQL at all, actually. I have …

Read More
Lost httpd.conf file located apache

How can I find where my httpd.conf file is located? I am running an Ubuntu Linux server from the Amazon Web Services EC2 (Elastic Compute Cloud) and I can't find my Apache config.

Read More