How does an Oracle database start? - Database Tutorial 38
Video 38 How does an Oracle database start? - Database Tutorial 38
How does an Oracle database start? - Database Tutorial 38
The startup of sequence of an Oracle Database.
1) Startup process looks for a parameter file in the default location.
2) If a parameter file is found, it then parses it and gets the information about the control files.
3) With that information, it reads the control files.
4) Upto this point, we can say that the Oracle Instance has been started in nomount mode.
5) The same can be achieved by issuing the following command in sqlplus.
a) startup nomount;
6) Then, from the control files, the Instance gets to know about the details of the database and its related files.
7) It then 'mounts' the database.
8) At this point, the database has been started. But it can be only accessed by the DBAs.
9) This is called 'mount' mode.
10) The same can be achieved by issuing the following command in sqlplus.
a) startup mount;
11) Then, once the database has mounted, it gets opened for other users.
12) This is called 'OPEN' mode.
13) This is the final mode of a startup process after which the database is available for use.
14) The same can be achieved by issuing the following command in sqlplus.
a) startup
15) That concludes the startup.
Sur cette page du site, vous pouvez voir la vidéo en ligne How does an Oracle database start? - Database Tutorial 38 durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Sam Dhanasekaran 11 février 2013, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 18,371 fois et il a aimé 93 téléspectateurs. Bon visionnage!
