Oracle Common Commands

Today's repository is locked and checked, saying that it was logged wrong more than 10 times the user will be locked, there is the understanding lock and password operation

To activate the sqlplus in a non-link way

Sqlplus/nolog;

Link the repository as a DBA:

Conn/as Sysdba;

The library activates the mode and uses:

2. Startup:open mode, activate the example to load and open the library, normal activate

   1. Non-restricted state

   2. Restricted state: startup restrict, only DBAs can visit the repository

      1. Execute the Digital guide;

      2. Extracting external numbers using Sql*loader;

      3. You need to temporarily deny user visits to the repository;

      4. To migrate or upgrade the operation of the repository;

         
         

4. Startup force: Forcing the database to start (seemingly a certain risk)

   
   

6. Startup Mount:mount mode, activating an instance and downloading the library, but does not open the repository (it is not yet understood)

   1. Rename the repository;

   2. Add, delete, rename a journal file;

   3. Perform the full recovery mode of the repository;

   4. Change the mode of the archives;

      
      

8. Startup Nomount:nomount mode, the instance does not load the repository. The process of creating a variety of internal structures, for example,

   1. Create a library;

   2. rebuilding control files;

Transition:

Open mode: Alter database Open

Mount mode: Alter database mount

Transform Nomount mode: Alter database Nomount

Restricted state changed to unrestricted state: Alter system disable restricted session

The unrestricted state becomes restricted: Alter system enable restricted session

Database read-only state: Alter DB Open Read only

Database read-write status: Alter DB Open Read write

Close the repository:

1.shutdown: Normal Close, wait for link to tie

2.shutdown Immediate: Close now

3.shutdown Transactional: shutting things down

4.shutdown Abort: Strong close (presence adventure)

Unlock:

Alter user username account unlock, where username is the user name being locked.

Change Password:

Alter user username identified by password, where username is the user name and password is the new password.

Test the Repository Link:

Tnsping test to get the database test can be connected

This article is from the "Morrowind" blog, make sure to keep this source http://morrowind.blog.51cto.com/1181631/1713410

Oracle Common Commands