WEB开发网
开发学院数据库Oracle Oracle手动创建数据库 阅读

Oracle手动创建数据库

 2012-05-16 17:11:25 来源:WEB开发网   
核心提示:orcl.__java_pool_size=4194304orcl.__large_pool_size=4194304orcl.__shared_pool_size=226492416orcl.__streams_pool_size=0*.audit_file_dest='/u01/app/oracle/adm
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__shared_pool_size=226492416
orcl.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.background_dump_dest='/u01/app/oracle/admin/orcl/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/oradata/orcl/control02.ctl','/u01/app/oracle/oradata/orcl/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/orcl/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='orcl'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.job_queue_processes=10
*.log_archive_dest_1='location=/u01/app/oracle/arch'
*.log_archive_dest_2='location=usr_db_recovery_file_dest'
*.open_cursors=300
*.pga_aggregate_target=299892736
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=901775360
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/orcl/udump'
 
创建数据库脚本文件:
dbca.sql
 
CREATE DATABASE orcl
   USER SYS IDENTIFIED BY tiger
   USER SYSTEM IDENTIFIED BY tiger
   LOGFILE GROUP 1 ('/u01/app/oracle/oradata/orcl/redo01.log') SIZE 100M,
           GROUP 2 ('/u01/app/oracle/oradata/orcl/redo02.log') SIZE 100M,
           GROUP 3 ('/u01/app/oracle/oradata/orcl/redo03.log') SIZE 100M
   MAXLOGFILES 5
   MAXLOGMEMBERS 5
   MAXLOGHISTORY 1
   MAXDATAFILES 100
   MAXINSTANCES 1
   CHARACTER SET US7ASCII
   NATIONAL CHARACTER SET AL16UTF16
   DATAFILE '/u01/app/oracle/oradata/orcl/system01.dbf' SIZE 325M REUSE
   EXTENT MANAGEMENT LOCAL
   SYSAUX DATAFILE '/u01/app/oracle/oradata/orcl/sysaux01.dbf' SIZE 325M REUSE
   DEFAULT TEMPORARY TABLESPACE tempts1
      TEMPFILE '/u01/app/oracle/oradata/orcl/temp01.dbf'
      SIZE 20M REUSE
   UNDO TABLESPACE undotbs1
      DATAFILE '/u01/app/oracle/oradata/orcl/undotbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
 
创建密码文件:
$orapwd file=$ORACLE_HOME/dbs/orapwdorcl password=tiger entries=10
创建数据库基本目录:
$mkdir -p /u01/app/oracle/admin/orcl/adump
$mkdir -p /u01/app/oracle/admin/orcl/bdump

Tags:Oracle 手动 创建

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接