linux 5 快速手工建库
- 建立参数文件
- $cd $ORACLE_HOME/dbs
- $cat init.ora|grep -v ^#|grep -v ^$>init$ORACLE_SID.sql
2 修改参数文件如下
- db_name=orcl
- db_files=180
- processes=150
- max_dump_file_size=10240
- global_names=TRUE
- control_files=('/u01/app/oracle/oradata/orcl/control01.ora','/u01/app/oracle/oradata/orcl/control02.ora','/u01/app/oracle/oradata/orcl/control03.ora')
- sga_target=400m
- undo_management='AUTO'
- undo_tablespace='UNDOTBS'
3 建立密码文件
- $orapw file=$ORACLE_HOME/dbs/orapworcl.ora password=oracle entries=10
4 启动listener
- $lsnrctl start
5 建立spfile
- $sqlplus / as sysdba
- SQL>create spfile from pfile;
6 编辑建库脚本
- $cat /tmp/credb.sql
- conn / as sysdba
- startup nomount;
- CREATE DATABASE orcl
- USER SYS IDENTIFIED BY pz6r58
- USER SYSTEM IDENTIFIED BY y1tz5p
- 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 UTF8
- NATIONAL CHARACTER SET UTF8
- 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 undotbs
- DATAFILE '/u01/app/oracle/oradata/orcl/undotbs01.dbf'
- SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
7 建库
- $mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/{a,b,c,d,u}dump
- $mkdir -p $ORACLE_BASE/oradata/$ORACLE_SID
- sqlplus -S /nolog <<EOF
- @/tmp/credb.sql;
- EOF
8 善后脚本
- $cat /tmp/creScript.sql
- conn / as sysdba
- @?/rdbms/admin/catalog.sql;
- @?/rdbms/admin/catproc.sql;
- @?/rdbms/admin/catblock.sql;
- @?/rdbms/admin/catoctk.sql;
- @?/rdbms/admin/owminstl.plb;
- @?/rdbms/admin/dbmspool.sql;
- conn system/oracle
- @?/sqlplus/admin/pupbld.sql
- exit
9 善后
- sqlplus -S /nolog <<EOF
- @/tmp/creScript.sql
- EOF
各个脚本用途
- catalog.sql 数据字典视图
- catproc.sql 存储过程包
- catblock.sql 锁相关视图
- catoctk.sql 密码工具包 dbms_crypto_toolkit
- owminst.plb 工作空间管理相关对象 dbms_wm
- dbmspool.sql 共享池管理包 DBMS_SHARED_POOL
转载于:https://blog.51cto.com/106560/895110