Oracle Database Creation

2. Open Database Configuration Assistant

4. Next
   
6. Select "Advanced Mode" next
   
7. Choose the type of database you are creating (typically select Data Warehouse)
   (general purpose or transaction processing?:?thatOLTP(online transaction processing). The general data volume is small,DMLfrequent.
   Data Warehouse:?thatOLAP, the volume of data is large,DMLless
   the key to your data isOLTPor is OLAP
   OLTP : Online transaction processing, representing many transactions, but the execution of most of the short, concurrent large database, such as daily invoicing operations;
   OLAP:? on-Line Analytical processing, which indicates less transactions, but performs mostly longer, less concurrent databases, such as Data Warehouse-based operations;
   The general system isOLTP, tens of millions of data are differentiatedOLTPand theOLAPthe basis.
   DDL: database schema definition language,Key WordsCreate
   DML: Database Manipulation Language,Key Words, Insert,update,delete
   DCL: Database Control Language,Key WordsGrant,remove
   DQL: database Query Language,Key WordsSelect
   )
   
9. Enter the database name
   
11. Direct Next
    
12. Set password (usually I set the password same as the current user name O (∩_∩) o~)
    
    2. Network configuration (currently there is no need to check the listener)
       
    4. Storage location just the next step.
       
    6. database option, and also the next step is good
       
    8. Initialize the parameters and set them on demand.
       
    10. Create options, Direct next
        
    12. The previous condition check will appear following interface
        
    14. Click Done to wait for database creation to complete
        
    16. As soon as the progress bar runs, click "Password Management"
        
    17. Password management: Set the passwords for each of the following 3 users.
        Sys,system,dbsnmp
        
        SYS:The default password isChange_on_install,When you create a database,SYSthe user will be created by default and grantedDBAroles, the base tables and views in all database data dictionaries are stored in theSYSscenarios, these basic tables and views are forOracleThe operation of the database is very important. In order to maintain the authenticity of the data dictionary,SYSthe tables in the scenario can only be maintained by the system, and they cannot be modified by any user or database administrator, and no user canSYSCreate a table in the scenario.
        SYSTEM: The default password isMANAGER, withSYS, in creatingOracledatabase,SYSTEMThe user is created by default and is grantedDBAroles, which create tables or views that display management information, and are used by variousOraclecontent tables or views used by database applications and tools. ?
        dbsnmp: is aOraclein the database for Smart agents (Intelligent AgentUsers, who are used to monitor and manage database-related performance, cannot extract relevant data if the user is stopped;
        Sysman: is aOraclein the database forEMmanage the user, if you do not use the user, can also be deleted;
    19. Get here Oracle Create the database and you're done.

Oracle Database Creation