oracle database to start and stop
Oracle user to log on
Login, enter the following command:
oracle-> sqlplus / nolog
SQL * Plus: Release 9.2.0.1.0 - Production on Monday April 26 09:42:00 2004
Copyright (c) 1982, 2002>>, Oracle Corporation. All rights reserved.
SQL>; connect / as sysdba
Is connected.
SQL>;
After entering the following actions can be a!
Let me talk about shutting down the database
shutdown has four parameters, four parameters, the following meanings:
Normal users need to wait for all of the disconnected
Immediate waiting for the user to complete the current statement
Transactional waiting for the user to complete the current transaction
Abort without any waiting, direct closure of the database
normal need to disconnect all connected users off the database after the implementation of the task, sometimes looks as if the command is not running the same! In the implementation of this command does not allow new connections
immediate implementation of the end user statement is being executed after the user connections disconnect, and does not allow new users to connect.
transactional in supporting the implementation of the End of the current after disconnect things, and does not allow new users to connect to the database.
abort the implementation of forced disconnect and directly close the database.
The first three methods do not return to lost user data. Fourth, that has been not the case, is not recommended!
DATABASE
The database to start using the startup command, it has three kinds of situations
The first: with no parameters, start the database instance and open the database, so that users using the database, in most cases, the use in this way!
The second: with nomount argument, only to start the database instance, but does not open the database you want to create a new database to use, or when you need to use this!
The third: with mount parameters, making use of the database when the name change. This time the database is open and ready to use!
Related Posts of oracle database to start and stop
-
Merge the use of (1)
Merge to select from a table update or insert some data to another table. And finally is used to update or insert depends on the conditions of the statement. rn Here's our easy to cite an example: rn rn SQL> create table merge_test1 (a number, ...
-
SGA extended the principle of 32bit oracle
SGA extended the principle of 32bit oracle From: http://www.itpub.net/247048.html Because the median 32bitrnoracle restrictions can only visit the oracle process 4g (2 of 32 power) following virtual memory address, the time at a lot of people this is ...
-
High Availability Oracle Flashback
Brief introduction Flashback Database is a point in time (PIT) restore the database approach. This incomplete recovery strategy can be used to restore the logic because of human error cause damage to the database. At the introduction of 10g, it is de ...
-
An example of the use of TKPROF
First, view and edit parameters SQL> show parameter max_dump_file_size NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- max_dump_file_size string UNLIMITED SQL> show parameter user_dump_dest NAME TYPE
-
Diagnosis and principles of order
SQL> select disk.value "Disk", mem.value "Mem", 2 (disk.value / mem.value) * 100 "Ratio" 3 from v $ sysstat mem, v $ sysstat disk 4 where mem.name = 'sorts (memory)' 5 and disk.name = 'sorts (disk)'; D ...
-
ORACLE 10G dataguard configuration Step by Step
oracle dataguard
Leave a Reply