Shutti ng Down the Database 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 Stop Database. On Linux with Gnome: In the Applications menu, point to Oracle Database 11g Express Edition, and then select Stop Database. On Windows: Click Start, point to Programs (or All Programs), point to Oracle Database 11g Express Edition, and then select Stop Database. To shut down the database using the desktop: If your Linux computer is not running a windowing manager, or is running a windowing manager other than KDE or Gnome, you must shut down the database with the SQL Command Line.
ORACLE DATABASE STARTUP TIME HOW TO
This section explains how to shut down the database from the desktop in Windows and in the following two Linux windowing managers: KDE and Gnome. Shut ting Down the Database from the Desktop Shutting Down the Database Using the SQL Command Line Shutting Down the Database from the Desktop Each of these methods is described in the following sections: You can shut down the database with the desktop or with the SQL Command Line (SQL*Plus). No new connections are permitted, and no new transactions are allowed to be started.Īny uncommitted transactions are rolled back.Īll users and applications are immediately disconnected. If users or applications are still logged in when you begin a shutdown operation, the shutdown proceeds under the following conditions:
See "Monitoring Sessions" for information on how to view current database sessions. However, you can also shut Oracle Database XE down manually whenever you want, such as to reduce the overall system processing overhead when you do not need to use the database.īefore shutting down Oracle Database XE, it is best to ensure that all users and applications have completed their work and logged out. 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. Starting Up the Data base from the Desktop
0 kommentar(er)
