(Les03 DB_DBCA) [20180206], les0320180206

(Les03 DB_DBCA) [20180206], les0320180206
Objective: To Use Database Configuration Assistant (DBCA) create a database use DBCA to generate a database creation script use DBCA to manage the database design template use DBCA to execute other tasks to plan the logical storage structure of the database and the number of physical implementation disks of the database? What is the storage type used? How many data files are required? (Planning to consider future growth) How many table spaces are used? What types of data are stored? Are there any special storage requirements? Overall database design database backup policy database example general database (OLAP) and transaction processing database (OLTP) online transaction processing (OLTP) System Custom multi-purpose database (combining OLTP and database warehouse functions) data Warehouse (requires long-term data storage) research and marketing data collection data professional certification data selection appropriate Character Set Oracle DB supports multiple character encoding (three, single-byte/variable-width multi-byte and General) single-byte character set-7-8-bit multi-Byte Character Set, including the Unicode Character Set is selected when the database is created, after selecting a character set, it is difficult to change it. In general, Unicode is recommended, because it is the most flexible character set, the 7-bit character set, the 7-bit American Information Interchange Standard Code (ASCII) (US7ASCII) 8-bit character set Western European International Standard Organization (ISO) 8859-1 (WE8ISO8859P1) 8-bit Western European DEC (WE8DEC) 8-bit extended binary encoding decimal interchange code (EBCDIC) code Page 1144 (I8I8EBCDI C1144) a variable-width multi-byte character set. Each character is represented by one or more bytes. Unicode is a common encoding character set that supports the use of a single character set to store any language. Variable-width multibyte 16-bit Japanese Shift-JIS (JA16SJIS) MS Windows code page 950 (ZHT16HKSCS) Unicode 4.0 HKSCS-2001 universal character set (AL32UTF8) using the Hong Kong supplemental Character Set UTF-8) -- a variable-width encoding type and strict ASCII superset Unicode (ALI16UTF16) -The 16-bit Unicode encoding used by Microsoft Windows 2000 and Windows XP. If the character set Oracle Net is used, the NLS_LANG setting on the client is compared with the character set on the server. If needed, transparent conversion is automatically performed (the server character set is a superset of the client character set or the same does not perform verification or conversion, otherwise transparent conversion is performed ). If the NLS_LANG parameter on the client is incorrectly set, invalid data is entered in the database. The NLS_LANG parameter is correctly set. The database can automatically convert the data imported from the client operating system. The setting of the NLS_LANG parameter is incorrect. The input data Database Configuration Assistant (DBCA) is not correctly converted) the Database Configuration assistant uses the oracle software installation account to call dbca. Select the operation to be executed, Create a Database, Create a Database, and select the template used by the Database (Database Templates) General Purpose or Transaction Procession (General or Transaction processing) custom Database (Custom Database) Data Warehouse (Database Warehouse) Database Identification (Database identifier) enter the Database Name and system identifier SID Management Options (Management Options) Oracle Enterprise Manager Management Database (OEM) start automatic maintenance tasks, such as optimizing program statistics and collecting and Preventive guidance reports. Database Credentials (Database Authentication) SYS and SYSTEM password specify Database File Locations (Database File location) Automatic Storage Management (ASM) Automatic Storage Management File System (File SYSTEM) multiplex Redo Logs and Control Files (multiplexing Redo Logs and Control Files) Adjust ORACLE_BASE/ORACLE_HOME/DB_NAME/DB_UNIQUE_NAME/SID Recovery Configuration (Restore Configuration) configure the quick recovery zone Database Content (Database Content) to contain sample objects, such as HR and other test materials Initialization Parameters (Initialization Parameters) Memory Typical or Custion custom Sizing to adjust the size of specified data blocks Ch Aracter Sets character set best tip: Oracle Corporation recommends Unicode as the database character set. Connect Mode connection Mode Dedicated Server Mode Shared Server Mode Note: Some initialization parameters remain unchanged during the Database lifecycle, such as DB_BLOCK_SIZE parameter Database Storage (Database Storage) create Options) after DBCA is complete, you need to record the location of the following Installation Log File: Global Database Name system identifier SID server parameter file name and location: Oracle Enterprise Manager URL (OEM Management) three methods for creating a database template to create a model database based on the existing template use DBCA to delete a database based on the existing database (structure and data). Note: the database to be deleted must be valid and running so that DBCA can connect to the database to determine the file location. Manually delete the database drop database must meet the following conditions: the DATABASE must have been loaded and the DATABASE has been closed must be loaded in an exclusive manner. The DATABASE must have started startup restrict force mount in RESTRICT mode; drop database; the drop database statement does not support archiving files and does not support database backup. It is best to use recovery manager (RMAN) to delete backups and archives. Use DBCA to complete other tasks, Oracle Label Security Administrator's Guide, Oracle Database Vault Administrator's Guide