![]() Oracle Database Express Edition (Oracle Database XE) shuts down automatically when you shut down the computer that hosts it. The query results should look similar to the following: (Optional) Enter the following SQL query to verify that the database started up properly: (System global area sizes will vary depending on the amount of physical memory in your Oracle Database XE host computer.) If the command is successful, it displays output similar to the following. The slash (/) indicates that the database should authenticate you with operating system authentication.Īt the SQL Command Line prompt, enter the following command: See "Setting Environment Variables on the Linux Platform" for details.Īt the operating system prompt, enter the following command to start the SQL Command Line and connect to the database: Linux platform only: Ensure that environment variables are set properly. If not already opened, open a terminal session or command window. To start up the database using the SQL Command Line: When you start up the database with the SQL Command Line, you must run the SQL Command Line on the same computer where you installed Oracle Database XE (the "Oracle Database XE host computer"). Starting Up the Databas e Using the SQL Command Line On Linux with KDE: Click the icon for the K Menu, point to Oracle Database 11g Express Edition, and then select Start Database. On Linux with Gnome: In the Applications menu, point to Oracle Database 11g Express Edition, and then select Start Database. On Windows: Click Start, point to Programs (or All Programs), point to Oracle Database 11g Express Edition, and then select Start Database. See "Operating System Authentication" for more information. On Linux: Log in to the Oracle Database XE host computer as the user that installed Oracle Database XE or as a user who is a member of the dba user group. On Windows: Log in to the Oracle Database XE host computer as the user that installed Oracle Database XE or as a Windows administrator-that is, as a user who is a member of the Administrator group. To start up the database using the desktop: ![]() See "Starting Up the Database Using the SQL Command Line" for instructions. If your Linux computer is not running a windowing manager, or is running a windowing manager other than KDE or Gnome, you must start the database with the SQL Command Line. This section explains how to start up the database from the desktop in Windows and in the following two Linux windowing managers: KDE and Gnome. When Oracle opens a mounted database, the database is available for normal operations.Starting Up the Data base from the Desktop Finally, open the online redo log files.Otherwise, it will select the first available undo tablespace. The instance uses default undo tablespace if an undo tablespace is specified in the UNDO_TABLESPACE initialization parameter. First, open the online data files in tablespaces other than the undo tablespaces.In the OPEN stage, Oracle performs the following actions: When a database is mounted, the database is only available to database administrators, not all users. Third, find the name of data files and the online redo log files.First, get the name of the database control files specified in the CONTROL_FILE initialization parameter.The instance carries the following steps to mount a database: In other words, the instance mounts the database. In the MOUNT stage, Oracle associates a database with an instance. Finally, open the alert log and trace files and record all explicit parameters to the alert log in the valid parameter syntax.Īt the NOMOUNT stage, Oracle does not associate the database with the instance.After that, start the Oracle background processes such as SMON, PMON, and LGWR.Then, allocate the system global area (SGA) based on the initialization parameter settings.Next, read the parameter file to get the values of the initialization parameters.You can override the default behavior by using the SPFILE or PFILE parameters in the STARTUP command. First, search for a server parameter file in the default location.In the NOMOUNT stage, Oracle carries the following steps: The STARTUP command allows you to control the stage of the database instance. When the Oracle Database starts an instance, it goes through the following stages: NOMOUNT, MOUNT, and OPEN. Code language: SQL (Structured Query Language) ( sql )
0 Comments
Leave a Reply. |