9/19/2023 0 Comments Oracle startup time![]() I solve it by starting in nomount SQL> startup nomount Okay, so I tried a few things and found a solution to the problem described above (thanks to JSapkota ). Is there some other way to change the size of the db_recovery_file_dest? I should be able to change the size like this: SQL> alter system set db_recovery_file_dest_size=20G scope=both īut since I get the error described above (end-of-file.) I am not able to change or evne see the values of any parameter. I found out that (possibly) the real problem is this (seen in the alert log): ORA-19815: WARNING: db_recovery_file_dest_size of 4781506560 bytes is 100.00% used, and has 0 remaining bytes available. Could this be the problem? And how can I check this, and if possible, change the timezone when I can't connect to the database? It hits me that is after we changed our clock that I try to restart the database. And this weekend that has passed, we changed our clock so the time was put one hour ahead. So our time will change all of a sudden compared to other countries. I live in Denmark, when it is fall, we change our time, so that it is one hour behind, and when it is spring, we put so it is one hour ahead. ![]() I'm have no idea what to do, since the solutions described are already as should be (those I found). I just turned on my computer, and trying to connect to the database, it gives me the error mentioned above. But none of these apply to me, as I have not changed anything. Or if NLS_DATE_FORMAT is entered incorrectly etc. ![]() I tried searching info on the SP2-0642, and see that things that could cause this kind of error, is if environmental variables end in a /įor example: old LD_LIBRARY_PATH=/Applications/instantclient10_1/ ORA-03113: end-of-file on communication channel Total System Global Area 2483027968 bytes Running: startup open I get this SQL> startup open I get the error: SP2-0642: SQL*Plus internal error state 2133, context 3114:0:0 I installed Oracle 12c on Ubuntu 3-4 months ago, and it worked perfectly until now.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |