![]() Code language: SQL (Structured Query Language) ( sql ) Second, issue the SHUTDOWN IMMEDIATE command to shut down the database: shutdown immediate Code language: SQL (Structured Query Language) ( sql ) ![]() For example, this statement brings the database from the NOMOUNT to the MOUNT stage: ALTER DATABASE MOUNT Ĭode language: SQL (Structured Query Language) ( sql ) Oracle STARTUP command exampleįirst, launch the SQL*Plus program and log in to the Oracle Database as the SYS user. To bring the database to the next stage, you use the ALTER DATABASE statement. If you want to start the database instance in a specific stage, you can use the following syntax: STARTUP stage įor example, to start up a database instance in the NOMOUNT stage, you use the following command: STARTUP NOMOUNT It is equivalent to starting the database instance in the OPEN stage: STARTUP OPEN The basic syntax of the STARTUP command is as follows: STARTUP The following picture illustrates the Oracle database startup process: Oracle STARTUP command When Oracle opens a mounted database, the database is available for normal operations.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |