I had installed Oracle 12 to my Linux box. I tried to login using sqlplus but it prompt out this error at below. How to solve it?
Enter user-name: SYSDBA
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
Additional information: 3701
Additional information: 542678011
Process ID: 0 Session ID: 0 Serial number: 0
EDIT:
How to find out default ORACLE_SID?
Best Answer
There could be various reason for this error.
ORACLE_SID
andORACLE_HOME
.When you have wrong ORACLE SID and HOME.
I could reproduce the error by changing my SID to something else. My SID is
oracdb
.But I changed it to
orcl
.Then I tried to connect to the database using SQL*PLUS.
Then I changed it to original SID.
When your instance is down and connected as a non-sys user
Use the following linux command to check whether some of the important background processes are running or not such PMON or SMON.
My oracle instance is down.
Now, as you have tried, I attempt to connect to the database using non-sys user,
sysdba
is a privilege not a database user.I got the same error as you have got.
Now, connect as
sysdba
/sysoper
and start the database instance.