Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, nidhi.

Asked: September 06, 2016 - 2:44 pm UTC

Last updated: November 19, 2021 - 12:45 am UTC

Version: oracle 11g

Viewed 100K+ times! This question is

You Asked

connect system password : password.
i got following errors
ORA-01034: ORACLE NOT AVAILABLE
ORA-27101: shared memory realm does not exist



and Connor said...

Your Oracle instance is not running! You need to start it up!

bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 6 08:37:00 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options
bash-3.00$ sqlplus chris/chris

SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 6 08:37:23 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

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


Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 6 08:38:32 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup 
ORACLE instance started.

Total System Global Area  655609856 bytes
Fixed Size                  2255992 bytes
Variable Size             629146504 bytes
Database Buffers           16777216 bytes
Redo Buffers                7430144 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options
bash-3.00$ sqlplus chris/chris

SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 6 08:39:11 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options

SQL>

Rating

  (19 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

nidhi sharma, September 06, 2016 - 4:07 pm UTC

Hi Tom ,
thanks for answering..
after sqlplus / as sysdba , i got following error
ORA-28056: Writing audit records to Window event log failed.
OSD-00512:Message 512 not found; product=RDBMS; facility=sosd
O/S-ERROR:<OS-1717> The interface is unknown.


NIDHI
Chris Saxon
September 06, 2016 - 4:19 pm UTC

It's Chris here, but thanks anyway ;)

There's a problem writing to the Window event log. This could be because it's full. Try clearing it down.

nidhi sharma, September 07, 2016 - 1:31 pm UTC

thanks Chris... but how to clear log file

Chris Saxon
September 07, 2016 - 3:47 pm UTC

A quick search turned up this:

https://msdn.microsoft.com/en-gb/library/d3wah3h5(v=vs.80 ).aspx

Which says:


1 Open Server Explorer, and then expand the node for the server on which the event log you want to clear resides.
2 You will see a list of the three main event logs — Application, Security, and System.
3 Right-click the log node you want to clear, and then click Clear Event Log.
4 Click Yes when prompted to confirm the deletion.

very useful

A reader, March 12, 2017 - 1:17 pm UTC

perfectly worked
Connor McDonald
March 13, 2017 - 2:53 am UTC

glad we could help

thanks for answer TOM

Rytham, June 09, 2017 - 11:38 am UTC

Hey when i run sqlplus command i get this

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

and when i run startup command i get this

SQL>startup
ORA-00845: MEMORY_TARGET not supported on this system

Please help me out

Connor McDonald
June 11, 2017 - 6:58 am UTC

You have the memory_target parameter set. You need to remove this, and use (for example) sga_target and pga_aggregate_target instead.

You might need to do:

create pfile = 'init.ora' from spfile
edit the init.ora
startup pfile=init.ora
create spfile from system;

Useful.

Shaikh Shahabaj, November 30, 2017 - 6:26 am UTC

Hey,
Your explanation helped me a lot.
but I want to know why this error is generated?
Could you please explain in brief?

Warm Regards,
Shaikh Shahabaj.
Chris Saxon
November 30, 2017 - 2:05 pm UTC

Because you need to know the database is unavailable? What precisely are you wanting to know?

Good Wokred

Sunil, December 12, 2017 - 10:46 am UTC

Yes, it work pefectly.

You Rocked Man

A reader, April 14, 2018 - 12:51 pm UTC

Excellent!!!!!!!!!!!!!!!!!!!!!
Connor McDonald
April 16, 2018 - 2:11 am UTC

glad we could help

It still works for this problem

A reader, August 20, 2018 - 11:41 pm UTC


Case matters!

Bill Cole, August 22, 2018 - 2:39 pm UTC

Good catch and advice. There are some variations you might consider.
1. If the database was created using DBCA and you specified the name in lower case, you need to set ORACLE_SID to lower case. Why? All those directories were created using that-lower case name. DBNAME != dbname
2. Is your ORACLE_HOME set properly? I've seen cases where there are multiple installs & databases on a server and a tiny mistake means you can't see the lkSID file doesn't exist in the ORACLE_HOME.
/Bill
Connor McDonald
August 25, 2018 - 6:00 am UTC

nice input

help me to solve this error

vishal, October 06, 2018 - 6:22 pm UTC

SQL> connect /as sysdba
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'E:\APP\VISHAL_2\ORAHOME_1\DATABASE\INITORCL.ORA'
Connor McDonald
October 07, 2018 - 2:06 am UTC

Well... seems fairly straightforward no?

Make sure E:\APP\VISHAL_2\ORAHOME_1\DATABASE\INITORCL.ORA exists and looks like a normal init.ora file, ie

db_block_size=8192
open_cursors=300
db_name="db18"
control_files=("c:\oracle\oradata\DB18\control01.ctl", "c:\oracle\oradata\DB18\control02.ctl")

etc etc

A reader, February 11, 2019 - 4:16 pm UTC

Worked!!!!

Thank you.

Mikel, May 07, 2019 - 10:33 am UTC

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue May 7 12:16:45 2019

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to an idle instance.

SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
SQL> exit
Disconnected

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue May 7 12:20:03 2019

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
SVR4 Error: 2: No such file or directory
SQL> exit
Disconnected
Chris Saxon
May 10, 2019 - 8:12 am UTC

And your question is?

If you're wondering about the ORA-16032 error, you're getting this because the parameter LOG_ARCHIVE_DEST_1 points to a file location that doesn't exist. Or the Oracle user doesn't have write permissions on it.

PLEASE HELP ME I AM STRUCK IN IT. USING ORACLE 11.2.0.1.0

KUBER SHARMA, August 22, 2019 - 1:57 pm UTC

Enter user-name: sqlplus / as sysdba
Enter password:
Connected to an idle instance.

SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SQL>
Chris Saxon
August 22, 2019 - 2:21 pm UTC

And what happens when you do:

SQL> startup


I need your help. A bit urgent actually.

Chaitanya, November 20, 2019 - 7:04 pm UTC

conn sys/password as sysdba
connected

conn system/password
connected

conn system/password@DBNAME
-

======================

Above Third step is running forever and I am unable to connect to SID using third step. This is on CMD.

Could you help me in this regard. It is hurting me a lot.

Connor McDonald
November 25, 2019 - 12:28 pm UTC

Do

tnsping dbname

to see what machine/port/db that tns entry is trying to reach. Make sure it is the one you are expecting. What tends to cause that long delay is either a wrong or missing tnsnames.ora entry, and hence you get a long delay trying to resolve a host name.

A reader, November 25, 2019 - 2:59 pm UTC

SQLPLUS
/ as sysdba
startup

use the above command to start the database.

A reader, November 27, 2019 - 5:38 pm UTC

There is a shell script called dbstart provided by oracle which comes with oracle rdbms. You can use this script as well to start the database
Chris Saxon
November 28, 2019 - 11:27 am UTC

Good suggestion.

A reader, January 16, 2021 - 8:38 am UTC

SQL> startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size 2260048 bytes
Variable Size 805307312 bytes
Database Buffers 255852544 bytes
Redo Buffers 5517312 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [],
[], [], [], [], [], [], [], []
Connor McDonald
January 19, 2021 - 4:26 am UTC

Normally means the database is inconsistent, so try this:

SQL> startup mount
SQL> recover database;
SQL> alter database open;

If that doesn't work, its time to talk to Support

Even if it works, once it is complete, check your alert.log for evidence of corruptions - because corrupt data is corrupt data, and might come back to bite you later

Even after performing startup I'm unable to fix the error

vinun, November 18, 2021 - 11:29 am UTC

ORA-12754: Feature 'Memoptimized Rowstore' is disabled due to missing capability 'Runtime Environment'.
Connor McDonald
November 19, 2021 - 12:45 am UTC

This means you're trying to run this feature on a non-exadata system.

More to Explore

VLDB

If you are new to partitioning, check out Connor McDonald's introduction series here.

VLDB

Documentation set on VLDB and Partitioning.