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
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
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
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
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.
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!!!!!!!!!!!!!!!!!!!!!
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
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'
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
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>
August 22, 2019 - 2:21 pm UTC
And what happens when you do:
SQL> startup
Helpful
Cng, September 26, 2019 - 3:10 pm UTC
How to auto start my oracle when system starts?
September 26, 2019 - 3:57 pm UTC
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.
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
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], [], [], [],
[], [], [], [], [], [], [], []
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'.
November 19, 2021 - 12:45 am UTC
This means you're trying to run this feature on a non-exadata system.
Hamza Mahmood, March 01, 2022 - 6:50 am UTC
Tom
I was trying to connect with database by entering my username and password but my logon denied. then I mess-up with some option in the service after that it give me this. I had read your answered, but I don't know where to write what? kindly tell me in detail. I have to submit my assignment on Wednesday.
Enter user-name: cleveland
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0
March 01, 2022 - 1:49 pm UTC
You need to connect as SYS to start an Oracle Database instance. Your username/password won't work.
If this is for a class assignment reach out to your supervisor for help.
help pls
A reader, March 28, 2022 - 11:19 am UTC
hey,
I am getting the same error
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
on trying the given solution when i write startup the foloowing error displays:
SQL> startup
ORA-01031: insufficient privileges
also getting started with oracle application that opens in browser donot open now (it did opened for the first time where i created workspace )
March 28, 2022 - 12:39 pm UTC
ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
Ramakrishna, August 10, 2022 - 8:17 am UTC
Thank you so much. Helped me a lot.
August 10, 2022 - 11:57 am UTC
You're welcome
Please help me Error ORA-01034 / Error ORA-27101 / Error ORA-01078 / Error LRM-00109
David, May 02, 2023 - 4:16 pm UTC
Hi Tom Please help me I have this problem :
{
SQL*Plus: Release 21.0.0.0.0 - Production on Tue May 2 17:53:26 2023
Version 21.3.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Enter user-name: system
Enter password:
ERROR:
ORA-01034: Message 1034 not found; No message file for product=RDBMS,
facility=ORA
ORA-27101: Message 27101 not found; No message file for product=RDBMS,
facility=ORA
separator not found in message(3144)separator not found in message(3142)
}
and when i Type "startup" I got this :
{
ORA-01078: Message 1078 not found; No message file for product=RDBMS, facility=ORA
LRM-00109: could not open parameter file 'C:\APP\ACER\PRODUCT\21C\DATABASE\INITORCL.ORA'
SQL> startup
ORA-01078: Message 1078 not found; No message file for product=RDBMS, facility=ORA
LRM-00109: could not open parameter file 'C:\APP\ACER\PRODUCT\21C\DATABASE\INITORCL.ORA'
}
and when I Type sqlplus / as sysdba I got :
{
Microsoft Windows [Version 10.0.19044.2846]
(c) Microsoft Corporation. All rights reserved.
C:\Users\ACER>sqlplus / as sysdba
SQL*Plus: Release 21.0.0.0.0 - Production on Tue May 2 18:14:05 2023
Version 21.3.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to an idle instance.
SQL> shutdown immediate
ERROR:
ORA-01034: Message 1034 not found; No message file for product=RDBMS,
facility=ORA
ORA-27101: Message 27101 not found; No message file for product=RDBMS,
facility=ORA
separator not found in message(3144)separator not found in message(3142)
SQL>
}
May 09, 2023 - 4:26 pm UTC
As the error says:
could not open parameter file 'C:\APP\ACER\PRODUCT\21C\DATABASE\INITORCL.ORA'
Check there is a file called INITORCL.ORA in C:\APP\ACER\PRODUCT\21C\DATABASE and your user has permissions to access it.
The "Message 1034 not found; No message file for product=RDBMS,facility=ORA" is also worrying, it means these files are missing too:
$ORACLE_HOME/rdbms/mesg/oraus.msg
$ORACLE_HOME/rdbms/mesg/oraus.msb
It looks like someone has deleted some database files or otherwise corrupted your installation.
Please help me Error ORA-01034 / Error ORA-27101 / Error ORA-01078 / Error LRM-00109
David, May 11, 2023 - 11:14 pm UTC
Yeah I check them and I diden't find them
Where I can find them ?
May 12, 2023 - 3:21 pm UTC
Ideally you have a backup you can recover these files from. If not reinstall the software.
sql developer Connection Id issue
Manasa, May 16, 2023 - 12:19 pm UTC
hello Tom , glad to catch u , Have aproblem .Installed oracle19c but while connecting sql dev ..three four oracle services from services.msc not running as it it showing a pop_up that "windows could not start service on local computer" checked more videos but unable to crack..please help me out Tom
May 17, 2023 - 12:57 pm UTC
That's a pretty generic error - please check the event logs to find what the actual error is.
ajay, June 02, 2023 - 10:07 am UTC
SQL> startup
ORA-00442: Oracle Database Express Edition (XE) single instance violation error
ORA-00600: internal error code, arguments: [OSDEP_INTERNAL], [], [], [], [], [], [], [], [], [], [], []
ORA-27302: failure occurred at: sxesingleins
ORA-27303: additional information: environment variable ORACLE_SID should be XE only
please suggest
June 05, 2023 - 1:37 pm UTC
I don't know exactly, but the final line looks like a clue:
ORA-27303: additional information: environment variable ORACLE_SID should be XE only
Check what the value of this variable is
ajay b, June 02, 2023 - 10:23 am UTC
getting error: 21c
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'C:\APP\ABHIJ\PRODUCT\21C\DATABASE\INITORCL.ORA'
SQL>
June 05, 2023 - 1:38 pm UTC
There's a problem accessing the file C:\APP\ABHIJ\PRODUCT\21C\DATABASE\INITORCL.ORA. Does it exist? Does your user have permission to read it?
Great Work
John, June 06, 2023 - 12:02 am UTC
Chris, Connor,
You both have patience of a Saint. Bravo!
Most issues such as these can be solved by a quick web search.
Or better yet, the questioner need only scroll up a page or two in the thread to discover the hint that'll work.
The rest of us thank you for your tolerance and patience.
June 06, 2023 - 9:52 am UTC
Thanks :)
after entering password error comes. please help me sir
Maheshkumar Ramtele, September 03, 2023 - 6:04 pm UTC
i am starting sqlplus whenever i entered password this error comes
Enter user-name: system
Enter password:
ERROR:
ORA-01034: Message 1034 not found; No message file for product=RDBMS,
facility=ORA
ORA-27101: Message 27101 not found; No message file for product=RDBMS,
facility=ORA
Process ID: 0
Session ID: 0 Serial number: 0
September 04, 2023 - 2:38 am UTC
Windows or Unix?
Worked for me. Thanks
Salil Jain, September 05, 2023 - 3:39 am UTC
I was getting the error
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: 4376
Additional information: 1799314291
Process ID: 0
Session ID: 0 Serial number: 0
But after firing 'startup' Its gone. Thanks
September 06, 2023 - 4:22 am UTC
glad we could help
Mate nees your help
Bill, September 08, 2023 - 5:00 am UTC
SQL> shutdown immediate
ERROR:
: ORACLE not available
:shares memory realm does not exist
Process ID: 0
Session ID: 0 Serial number:0
SQL> start-up
: failure in processing system parameters
: could not open parameter file 'C:\USERS\ORACLE_1\DOCUMENTS\ORACLE 19C\ORACLE19C\DATABASE\INITBILL.ORA'
September 08, 2023 - 7:17 am UTC
So .... did this work before?
Seems very weird to have Oracle installed under "Documents"
Still error
Morshed, April 19, 2024 - 8:06 am UTC
when give startup I get this error
startup
ORA-02778: Name given for the log directory is invalid
April 19, 2024 - 4:34 pm UTC
Check the LOG* parameters for your database. One or more of these refer to a non-existent directory.
Where can I find *LOG parameters of my database
Sarower Morshed, April 20, 2024 - 2:50 pm UTC
Thank you for your fast reply sir.
Can you tell me how can I find that.
I am using oracle apex in this database (oracle 19c) and all on a suddent i got this error after 1 restart.
I have a running application of my company in that apex server and I have the datafile with me. But I dont have any backup of that application. More than 800 employees data is stored in that application and I have a very old backup.
Can I restore this datafile to another oracle database by replacing the datafile?
I badly need the application restored.
I am having this problem for 1 week and my boss is asking me about it and now all I am saying is we are having some maintainance.
Can anyone help me out here. I will be so grateful mates.
April 22, 2024 - 1:12 am UTC
Check the following three parameters
- background_dump_dest
- core_dump_dest
- user_dump_dest
If they are not valid, then the database will most likely complain.
You definitely cannot just copy an old datafile over the top. You need to do a database recovery. We'd need to see some more context on what you state you are currently in and what you are trying to achieve here
A reader, May 17, 2024 - 4:47 am UTC
[oratest@ebs-upg ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Fri May 17 06:46:03 2024
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
NAME OPEN_MODE
--------- --------------------
TESTDB READ WRITE
TESTDB> ^C
why it is not connect to sql database why it is conect SID(TESTDB)
May 20, 2024 - 12:53 am UTC
not really sure what you are asking, but see if TWO_TASK is set