手动建库（Manual database building）.doc

手动建库（Manual database building） 1. Preparation: build password file first The password file is to verify the user login before the Oracle file, when we a user access to the database, the database to authenticate our identity, check our identity is valid, there are two kinds of user authentication, general Oracle, a certification system (OS), is a database authentication (DB), when we logged in users, such as Scott, the database will refer to the data dictionary to see if the user, check the password, this way is DB certification. In addition, before the library is not open, did not start the data dictionary, no DB authentication method, but sys users, is an administrator can use operating system authentication, the system is generally Oracle users and Oracle users must be a member of the DBA group, then sys $sqlplus / as SYSDBA users will be able to log in, but if do not belong to this group, it is necessary to use the password file to check that, through a remote connection directly with the password file authentication. In remote connections, the password file is also related to the following parameters, SQLshow pramater remote Authentication for remote login of sys users (remote_login_passwordfile parameter = exclusive = VALUE) can be logged in remotely If the SQLalter system set remote_login_passwordfile = none scope= SPFILE; / / will not restart the remote login on The location of the password file: $ORACLE_HOME/dbs/orapwSID //SID is the name of the database. After the password file is deleted, the missing permissions are displayed in the attempt to log on to the database Create a password file: orapwd file = orapwuser01 password = Oracle entries = 3 force = y //entries is the number of users can access the force, if there is the database password file, then it will cover. 2, create create database command scripts CREATE BATABASE user01 USER SYS IDENTFIED BY ORACLE / / sys to modify the user password, the password is initial, usually to modify USER SYSTEM IDENTF