9/16/2023 0 Comments Oracle startup time![]() ![]() Finally, start the database using the pfile you just edited: SQL startup pfile'C:\ora\pfile\init. Now edit the pfile in notepad to make the changes need to allow Oracle to start. SQL> create pfile'C:\ora\pfile\init.ora' File Created. During the nomount stage, Oracle first opens and reads the initialization parameter file (init.ora) to see how the database is configured. L_start_time := to_date(' 20:00:00','DD/MM/YYYY HH24:MI:SS') Tip - Making a PFILE when Oracle will not start. THE STARTUP (NOMOUNT) STAGE: When you issue the startup command, the first thing the database will do is enter the nomount stage. The following example script gives the below output SET SERVEROUTPUT ON ĭbms_output.put_line('start time='||l_start_time) ĭbms_output.put_line('end time ='||l_end_time) ĭbms_output.put_line('a) difference days ='||to_char(l_diff)) ĭbms_output.put_line('a) difference hours ='||to_char(l_diff*24)) ĭbms_output.put_line('a) difference minutes='||to_char(l_diff*24*60)) ĭbms_output.put_line('a) difference seconds='||to_char(l_diff*24*60*60)) For startup time in alertlog - grep 'Starting ORACLE instance (normal)' alert.log For shutdown - grep 'Completed: ALTER DATABASE CLOSE NORMAL' alert.log Unless of course it crashes, then there won't be a shutdown in the alertlog. Oracle Database - Enterprise Edition - Version 12.1.0. The command should take about 45 minutes and your database should be up and. You can calculate the difference as a number and then calculate it from the fractions of the day. docker run -d -p 5500:5500 -p 1521:1521 -e ORACLEPWDGGPASS oracle/database:19.3.0-ee.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |