博客
Oracle 11g 手动创建库完整实施过程
- 2018年5月19日
- 作者: 茹憶
- 分类目录 Oracle
阅读1,103次
没有评论
Oracle数据库除了使用DBCA创建数据库的方式外,还可以使用命令手动创建数据库。本文为Oracle 11g手动创建数据库的完整过程,供大家参考使用。
1.修改oracle用户环境变量
$ vim .bash_profile
#oracle env NLS_LANG="SIMPLIFIED CHINESE_CHINA.UTF8" ORACLE_BASE=/home/oracle/product ORACLE_HOME=$ORACLE_BASE/11203/db1 export ORACLE_BASE ORACLE_HOME NLS_LANG ORACLE_SID=yhd export ORACLE_SID ORACLE_TERM=xterm export ORACLE_TERM PATH=$HOME/bin:$ORACLE_HOME/bin:$PATH export PATH NLS_LANG=AMERICAN_AMERICA.UTF8 export NLS_LANG
使设置生效
$ . .bash_profile
$ env |grep ORACLE
ORACLE_SID=yhd
ORACLE_BASE=/home/oracle/product
ORACLE_TERM=xterm
ORACLE_HOME=/home/oracle/product/11203/db1
2.创建数据文件目录和其他需要的目录
# mkdir -p /data/oradata/yhd
# chown -R oracle:oinstall /data/oradata
# su – oracle
$ mkdir -p /home/oracle/product/admin/yhd/adump
$ mkdir -p /home/oracle/product/admin/yhd/cdump
$ mkdir -p /home/oracle/product/admin/yhd/diag
3.创建参数文件
$ cd $ORACLE_HOME/dbs
$ cat init.ora |grep -v ^# > inityhd.ora
$ vim inityhd.ora
db_name='yhd' memory_target=8G processes = 150 audit_file_dest= /home/oracle/product/admin/yhd/adump audit_trail ='db' db_block_size=8192 db_domain='' db_recovery_file_dest='/data/oradata/flash_recovery_area' db_recovery_file_dest_size=6G diagnostic_dest='<ORACLE_BASE>' dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)' open_cursors=300 remote_login_passwordfile='EXCLUSIVE' undo_tablespace='UNDOTBS1' undo_management=auto control_files = ('/data/oradata/yhd/control01.ctl','/data/oradata/yhd/control02.ctl','/data/oradata/yhd/control03.ctl') sga_target = 4G compatible ='11.2.0' core_dump_dest=/home/oracle/product/admin/yhd/cdump diagnostic_dest=/home/oracle/product/admin/yhd/diag wmssh6.__db_cache_size=109521666048 wmssh6.__java_pool_size=268435456 wmssh6.__large_pool_size=268435456 wmssh6.__oracle_base='/home/oracle/app'#ORACLE_BASE set from environment wmssh6.__pga_aggregate_target=21474836480 wmssh6.__sga_target=118111600640 wmssh6.__shared_io_pool_size=0 wmssh6.__shared_pool_size=7516192768 wmssh6.__streams_pool_size=0 *._b_tree_bitmap_plans=FALSE *._in_memory_undo=FALSE *._memory_imm_mode_without_autosga=FALSE *._optim_peek_user_binds=FALSE *._optimizer_adaptive_cursor_sharing=FALSE *._optimizer_extended_cursor_sharing_rel='NONE' *._optimizer_extended_cursor_sharing='NONE' *.compatible='11.2.0' *.control_files='/data2/oracle/oradata/wmssh6/control01.ctl','/data2/oracle/oradata/wmssh6/control02.ctl','/data2/oracle/oradata/wmssh6/control03.ctl' *.db_block_size=8192 *.db_name='wmssh6' *.db_securefile='NEVER' *.db_unique_name='wmsshdg2' *.deferred_segment_creation=FALSE *.diagnostic_dest='/home/oracle/app' *.fal_client='wmsshdg2' *.fal_server='wmssh' *.filesystemio_options='SETALL' *.job_queue_processes=10 *.log_archive_config='DG_CONFIG=(wmssh,wmsshdg,wmsshdg2)' *.log_archive_dest_1='LOCATION=/data/oracle/arch' *.log_archive_dest_2='service=wmssh lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=wmssh' *.log_archive_dest_state_1='enable' *.log_archive_dest_state_2='enable' *.log_archive_format='%t_%s_%r.dbf' *.pga_aggregate_target=21474836480 *.processes=4000 *.remote_login_passwordfile='EXCLUSIVE' *.resource_manager_plan='' *.sga_max_size=118111600640 *.sga_target=118111600640 *.standby_file_management='AUTO' *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1'
4.创建密码文件
$ cd $ORACLE_HOME/dbs
$ orapwd file=orapwyhd password=oracle
5.启动数据库到nomount
$ sqlplus / as sysdba
SQL> startup nomount;
6.编写建库脚本
$ vim createdb.sql
CREATE DATABASE yhd USER SYS IDENTIFIED BY oracle USER SYSTEM IDENTIFIED BY oracle MAXINSTANCES 2 MAXDATAFILES 2048 MAXLOGMEMBERS 5 MAXLOGHISTORY 20 DATAFILE '/data/oradata/yhd/system01.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED SYSAUX DATAFILE '/data/oradata/yhd/sysaux01.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '/data/oradata/yhd/temp01.dbf' SIZE 500M UNDO TABLESPACE undotbs1 DATAFILE '/data/oradata/yhd/undotbs1.dbf' SIZE 200M AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED DEFAULT TABLESPACE yhd DATAFILE '/data/oradata/yhd/yhd01.dbf' SIZE 1G LOGFILE GROUP 1 ('/data/oradata/yhd/redo1_1.rdo','/data/oradata/yhd/redo1_2.dbf') SIZE 50M, GROUP 2 ('/data/oradata/yhd/redo2_1.rdo','/data/oradata/yhd/redo2_2.dbf') SIZE 50M, GROUP 3 ('/data/oradata/yhd/redo3_1.rdo','/data/oradata/yhd/redo3_2.dbf') SIZE 50M;
7.执行建库脚本
SQL> @/home/oracle/product/11203/db1/dbs/createdb.sql
8.运行数据字典
SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc.sql
SQL> @?/rdbms/admin/catblock.sql
9.新建sqlplus属性和帮助
SQL> conn system/oracle
SQL> @?/sqlplus/admin/pupbld.sql
SQL> @?/sqlplus/admin/help/hlpbld.sql helpus.sql
版权声明:本文为DBARUN原创文章,如需转载请注明本站作者及本文链接,DBARUN保留一切法律解释权。
本文链接:http://www.dbarun.com/oracle/oracle-11g-manual-create-database/
作者: 茹憶

PHP开发工程师(WEB开发认证)、曾就职于1号店高级MySQL DBA、现就职于中国平安,专注于MySQL架构设计和优化、Python技术研究、数据库自动化平台构建。开源天兔数据库监控系统(www.lepus.cc)开发作者。