How to start Oracle databases in Linux

Oracle Database startup is one of the most basic operations. The following describes the Oracle database startup methods in detail. If you are interested in this, take a look.

I. Oracle Database startup

Syntax: startup [force] [pfile = file name] [exclusive | shared] [mount database name | normal database name] [nomount]

1. normal startup:

SQL> conn sys/sys as sysdba;

SQL> startup

You can also specify the database name at startup.

SQL> startup ora9

2. Installation and non-installation start

The installation and startup options are mount, indicating that the routine only loads the database, but does not open the database. The option not to install and start is nomount, indicating that only the database is created and not loaded into the database, of course, it cannot be opened.

SQL> startup mount-install and start

SQL> startup nomount-start without Installation

3. Exclusive and shared startup

Exclusive indicates that only one routine is allowed to use the database. The shared startup parameter is shared, indicating that multiple routines can be used in parallel to load the database into multiple sites.

4. constraint start

The restricted start option is restrict. When a database is started, the database can only be used by database administrators with special permissions. Generally, users cannot join the database.

SQL> startup restrict

Generally, when a user has the create session permission, the user can join the database. However, for a database started in restrict mode, only the user has the restricted session system permission can join the database.

To change this mode during database running, use the alter system command.

SQL> alter system disable restricted session;

You can also shut down the database before starting the database again in non-restrict mode.

5. Force start

If you encounter some trouble when you start the database normally, or the database cannot be shut down normally when you shut down the database last time, you can use force start. The option is force.

Connecting sys users

SQL> startup force

6. Start the file with initialization parameters

The initialization parameter file is read by the system when the database is started. Some global parameters are set, which does not affect the running mode of the database.

SQL> startup pfile = d: \ oracle \ admin \ site \ pfile \ init. ora

Tip: You can use alter database to perform some startup mode conversion, but the conversion type is very limited. For example, to open a database in mount mode, you can use the following command:

SQL> alter database open;

You can also change from the mount status to the mount status, as shown below:

SQL> alter database mount;

Implementation of Oracle redo log

Oracle Log File Management

Oracle Password File Management

Read and Write files in Oracle stored procedures

Oracle creates and deletes user instances