Đang chuẩn bị liên kết để tải về tài liệu:
DBA Handbook for Oracle P2

Creating Databases Oracle Databases can be created either using the Database Configuration Assistant or a CREATE DATABASE statement. Using the DBCA is easier. Creating the database manually requires careful planning. Additional actions such as creating new users, tablespaces and data dictionary tables have to be performed in case the database is created manually. To create the database: Make sure that there is sufficient memory and disk space. Specify Oracle SID. $ ORACLE_SID = slx_db01; EXPORT ORACLE_SID; Create initialization parameter file by copying sample parameter file init.ora. Make sure that you customize the parameter to specific requirements since parameters such as BLOCK_SIZE cannot. | Chapter 3 Administration Activities 3.2 Creating Databases Oracle Databases can be created either using the Database Configuration Assistant or a CREATE DATABASE statement. Using the DBCA is easier. Creating the database manually requires careful planning. Additional actions such as creating new users tablespaces and data dictionary tables have to be performed in case the database is created manually. To create the database CF Make sure that there is sufficient memory and disk space. Specify Oracle SID. ORACLE_SID slx_db01 EXPORT ORACLE_SID Create initialization parameter file by copying sample parameter file init.ora. Make sure that you customize the parameter to specific requirements since parameters such as BLOCK_SIZE cannot be changed once set. Connect as internal in the server manager mode. SQL CONNECT SYS AS SYSDBA SQL STARTUP NOMOUNT Run the script to create a database. CREATE DATABASE slx_db01 USER SYS IDENTIFIED BY sol123 USER SYSTEM IDENTIFIED BY sol123 LOGFILE GROUP 1 mnt sdc1 1159 slx_db01 redo01.log SIZE 100M GROUP 2 mnt sdc1 1159 slx_db01 redo02.log SIZE 100M GROUP 3 mnt sdc1 1159 slx_db01 redo03.log SIZE 100M MAXLOGFILES 5 MAXLOGMEMBERS 5 MAXLOGHISTORY 1 MAXDATAFILES 100 MAXINSTANCES 1 CHARACTER SET US7ASCII NATIONAL CHARACTER SET AL16 UTF16DATAFILE mnt sdc1 1159 slx_db01 system01.dbf SIZE 325M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE mnt sdc1 1159 slx_db01 sysaux01.dbf SIZE 325M REUSE DEFAULT TABLESPACE tbs_1 DEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE mnt sdc1 1159 slx_db01 temp01.dbf SIZE 20M REUSE UNDO TABLESPACE undotbs DATAFILE mnt sdc1 1159 slx_db01 undotbs01.dbf SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED Run the catproc.sql and catalog.sql while connected as SYS. CF These actions result in the creation of the database with default datafiles control files redo log files system tablespace and data dictionary. The default users SYS and SYSTEM are also defined. SOLIX Technologies www.solix.com 29 Chapter 3 Administration Activities .