Oracle实例脚本安装

文档执行前提，本服务器已经安装Oracle SoftWare

1）创建相关路径 $ORACLE_SID=testdb

mkdir -p $ORACLE_BASE/flash_recovery_area

mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/adump

mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/dpdump

mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/pfile

mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/scripts

mkdir -p /u02/oradata/testdb

2）编辑pfile

vi /home/oracle/pfile.ora

*.audit_file_dest='/u01/app/oracle/admin/testdb/adump'

*.audit_trail='NONE'

*.compatible='11.2.0.4.0'

*.control_files='/u02/oradata/testdb/control01.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='testdb'

*.diagnostic_dest='/u01/app/oracle'

*.open_cursors=300

*.pga_aggregate_target=200M

*.processes=2000

*.remote_login_passwordfile='EXCLUSIVE'

*.session_cached_cursors=300

*.sga_max_size=500M

*.sga_target=500M

*.undo_tablespace='UNDOTBS1'

3）启动至nomount状态并创建spfile

SQL> startup nomount pfile='/home/oracle/pfile.ora';

SQL> create spfile from pfile='/home/oracle/pfile.ora';

SQL>

CREATE DATABASE testdb

   USER SYS IDENTIFIED BY oracle

   USER SYSTEM IDENTIFIED BY oracle

   LOGFILE GROUP 1 ('/u02/oradata/testdb/redolog01.log') SIZE 1024M,

           GROUP 2 ('/u02/oradata/testdb/redolog02.log') SIZE 1024M,

           GROUP 3 ('/u02/oradata/testdb/redolog03.log') SIZE 1024M

   MAXLOGFILES 5

   MAXLOGMEMBERS 5

   MAXLOGHISTORY 1

   MAXDATAFILES 100

   CHARACTER SET ZHS16GBK

   NATIONAL CHARACTER SET AL16UTF16

   EXTENT MANAGEMENT LOCAL

   DATAFILE '/u02/oradata/testdb/system01.dbf' SIZE 500M REUSE

   SYSAUX DATAFILE '/u02/oradata/testdb/sysaux01.dbf' SIZE 500M REUSE

   DEFAULT TABLESPACE users

      DATAFILE '/u02/oradata/testdb/users01.dbf'

      SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

   DEFAULT TEMPORARY TABLESPACE tempts1

      TEMPFILE '/u02/oradata/testdb/temp01.dbf'

      SIZE 1024M REUSE

   UNDO TABLESPACE undotbs1

      DATAFILE '/u02/oradata/testdb/undotbs01.dbf'

      SIZE 2048M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

4）运行以下脚本

SQL> @?/rdbms/admin/catalog.sql

SQL> @?/rdbms/admin/catproc.sql

SQL> @?/rdbms/admin/utlrp.sql

SQL> @?/sqlplus/admin/pupbld.sql