手动创建数据库
１、建路径
mkdir -p /u01/app/oracle/admin/db1/bdump
mkdir -p /u01/app/oracle/admin/db1/udump
mkdir -p /u01/app/oracle/admin/db1/cdump
mkdir -p /u01/app/oracle/admin/db1/pfile
mkdir -p /u01/app/oracle/admin/db1/create
mkdir -p /u01/app/oracle/admin/db1/archive
mkdir -p /u01/app/oracle/admin/db1/data
２、参数文件
*.aq_tm_processes=1
*.background_dump_dest='/u01/app/oracle/admin/db1/bdump'
*.user_dump_dest='/u01/app/oracle/admin/db1/udump'
*.core_dump_dest='/u01/app/oracle/admin/db1/cdump'

*.compatible='9.2.0.0.0'
*.control_files='/u01/app/oracle/admin/db1/data/control01.ctl','/u01/app/oracle/admin/db1/data/control02.ctl','/u01/app/oracle/admin/db1/data/control03.ctl'

*.db_block_size=8192
*.db_cache_size=33554432
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='db1'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=db1XDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=FALSE
*.instance_name='db1'
*.java_pool_size=83886080
*.job_queue_processes=10
*.large_pool_size=16777216
*.log_archive_dest_1='location=/u01/app/oracle/admin/db1/archive'
*.log_archive_start=TRUE
*.open_cursors=500
*.pga_aggregate_target=16777216
*.processes=300
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=83886080
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=18000
*.undo_tablespace='UNDOTBS1'

3、建口令文件、配置监听和TNSNAMES

4、在MOUNT状态下创建ＤＢ
[oracle@db1 admin]$ cat createDB.sql
CREATE DATABASE db1
   USER SYS IDENTIFIED BY oracle
   USER SYSTEM IDENTIFIED BY oracle
   LOGFILE GROUP 1 ('/u01/app/oracle/admin/db1/data/redo01.log') SIZE 10M,
           GROUP 2 ('/u01/app/oracle/admin/db1/data/redo02.log') SIZE 10M,
           GROUP 3 ('/u01/app/oracle/admin/db1/data/redo03.log') SIZE 10M
   MAXLOGFILES 5
   MAXLOGMEMBERS 5
   MAXLOGHISTORY 1
   MAXDATAFILES 100
   MAXINSTANCES 1
   CHARACTER SET ZHS16GBK
   NATIONAL CHARACTER SET AL16UTF16
   DATAFILE '/u01/app/oracle/admin/db1/data/system01.dbf' SIZE 325M REUSE
   EXTENT MANAGEMENT LOCAL
   DEFAULT TEMPORARY TABLESPACE tempts1
      TEMPFILE '/u01/app/oracle/admin/db1/data/temp01.dbf'
      SIZE 20M REUSE
   UNDO TABLESPACE undotbs1
      DATAFILE '/u01/app/oracle/admin/db1/data/undotbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;


５、Create Additional Tablespaces
CONNECT SYS/password AS SYSDBA
-- create a user tablespace to be assigned as the default tablespace for users
CREATE TABLESPACE users LOGGING
     DATAFILE '/u01/app/oracle/admin/db1/data/users01.dbf'
     SIZE 25M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED
     EXTENT MANAGEMENT LOCAL;
-- create a tablespace for indexes, separate from user tablespace
CREATE TABLESPACE indx LOGGING
     DATAFILE '/u01/app/oracle/admin/db1/data/indx01.dbf'
     SIZE 25M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED
     EXTENT MANAGEMENT LOCAL;
EXIT

６、 Run Scripts to Build Data Dictionary Views
Run the scripts necessary to build views, synonyms, and PL/SQL packages:

CONNECT SYS/password AS SYSDBA
@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql
EXIT

CATALOG.SQL
Creates the views of the data dictionary tables, the dynamic performance views, and public synonyms for many of the views. Grants PUBLIC access to the synonyms.

CATPROC.SQL
Runs all scripts required for or used with PL/SQL.

ITPub博客

手动创建数据库的过程

最新文章