Learning goals using Database Configuration Assistant (DBCA) to create databases using DBCA to generate database creation scripts Use DBCA to manage database design templates Perform other tasks with DBCA Planning database database logical storage structure and its physical implementation Number of disks? Use the type of storage? How many data files are needed? (Plan to consider future growth) How many table spaces are used? What types of data are stored? Are there special types of storage requirements? Overall database design Database backup strategy Database example Universal database (OLAP) and transaction processing database (OLTP) Online transaction processing (OLTP) systems Customization Multipurpose databases (combined with OLTP and database warehouse capabilities) Data Warehouse ( Require long-term storage of data) Research and marketing data aggregated data Professional Certification data Select the appropriate character set Oracle DB supports multiple character encodings (three, single-byte/variable-width multibyte, and universal) Single-byte character set -7-bit -8-bit Multi-byte character set, Including the unicode character set is selected when the database is created, it is difficult to change after the selected character set Generally, it is recommended to select Unicode because it is the most flexible character set 7-bit character set 7-bit US Information Interchange Standard Code (ASCII) (US7ASCII) 8-bit character set Western European Standards Organization (ISO) 8859-1 (WE8ISO8859P1) 8-bit western Europe Dec (WE8DEC) 8-bit Italian extended binary encoded Decimal Interchange Code (EBCDIC) code page 1144 (i8i8ebcdic1144) multibyte Character set Wide-variable multibyte character set, where each character is represented by one or more bytes. Unicode is a universal coded character set that supports the habit of storing any one language using a single character set. Wide-variable multi-byte 16-digit Japanese Shift-jis (ja16sjis) &nbsP Using the Hong Kong supplementary character set HKSCS-2001 MS Windows code page 950 (ZHT16HKSCS) Unicode 4.0 UTF-8 Universal Character Set (Al32utf8)-A variable-width encoding type, also a strict superset of ASCII Unicode (ALI16UTF16)-microsoft 16-bit Unicode encoding used by Windows 2000 and Windows XP If using character set Oracle NET compares the Nls_lang settings on the client to the character set on the server. Automatic transparent conversion if required (the server character set is a superset of the client character set or the same does not perform validation or conversion, Others are transparently converted). Issues to avoid NLS in Client _lang parameter is not set correctly, invalid data is entered in the database. Nls_lang parameters are set correctly, The database can automatically convert incoming data from the client operating system. Nls_lang parameters are set incorrectly, Input data will not be converted correctly database configuration Assistant (DBCA) database Config Assistant Invoke dbca Select actions to perform using the Oracle Software Installation account Create a database creating databases Select database Templates General Purpose or Transaction procession (generic or transactional) Custom database (custom databases) data Warehouse (database warehouse) DB identification (Database ID) Enter database name and system identifier sid Management Options (tube Oracle Enterprise Manager Management Database (OEM) Start automatic maintenance tasks, such as optimizing program statistics, collecting and preventative guidance reports. Database Credentials (DB certification) SYS and system password designation Database file Locations (db files location) Automatic Storage Management (ASM) automatic storage Management & nbsp; File System (FileSystem) Multiplex Redo Logs and Control files (multiplexing redo logs and controls) & nbsp; Adjustment oracle_base/oracle_home/db_name/db_unique_name/sid Recovery configuration (Restore config) Configuring the quick Recovery Zone Database content (DB contents) includes sample objects such as HR and other test materials Initialization Parameters (initialization parameters) memory Ram Typical typical or custion customization & nbsp; Sizing resizing Specify data block size Character sets character set Best tips: Oracle Corporation recommends using Unicode as the database character set. Connect mode connection modes Dedicated Server mode dedicated server modes Shared server mode share servers modes Note: Some initialization parameters are constant throughout the database life cycle, such as db_block_size parameters Storage (Database storage) Create Options (Create options) Database creation summary Schema password management DBCA The following information to be recorded after completion Location of installation log files Global database name & nbsp; System identifiers sid & nbsp; Server parameter file name and location Oracle Enterprise manager URL (OEM management) Create a database template Three ways to create modeled Based on existing templates Based on existing database (structure only) Delete a database based on an existing database (structure and data) using DBCA 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 deleting a database drop database & nbsp must meet the following conditions The database must be mounted and closed The database must be loaded exclusively database must already be started in restrict mode STARTUP RESTRICT Force mount; & nbsp DROP database;   DROP DATABASE statements do not work on archive files, nor do backups of databases. Best use of recovery Manager (RMAN) to remove backups and archives. Complete other tasks with DBCA Oracle Label Security Administrator's Guide Oracle Database Vault Administrator ' s Guide
(Les03 DB_DBCA) [20180206]