oracle 静默 建库,静默安装Oracle 11gR2软件并且手动建库

5、启动实例创建数据库

----------------------------------- 建库脚本-----------------

startup nomount pfile="/u01/app/product/11.2.0.1/db1/dbs/initora11g.ora";

CREATE DATABASE "ora11g"

MAXINSTANCES 8

MAXLOGHISTORY 1

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

DATAFILE '/u01/app/oradata/system01.dbf' SIZE 1024M REUSE

EXTENT MANAGEMENT LOCAL

SYSAUX DATAFILE '/u01/app/oradata/sysaux01.dbf' SIZE 500M REUSE

SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/app/oradata/temp01.dbf' SIZE 20M REUSE

SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE '/u01/app/oradata/undo01.dbf' SIZE 300M REUSE

CHARACTER SET ZHS16GBK

NATIONAL CHARACTER SET AL16UTF16

LOGFILE GROUP 1 ('/u01/app/oradata/log01.dbf') SIZE 50M,

GROUP 2 ('/u01/app/oradata/log02.dbf') SIZE 50M,

GROUP 3 ('/u01/app/oradata/log03.dbf') SIZE 50M;

创建USERS表空间

CREATE SMALLFILE TABLESPACE "USERS" LOGGING DATAFILE '/u01/app/oradata/user01.dbf' SIZE 1000M REUSE EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO;

ALTER DATABASE DEFAULT TABLESPACE "USERS";

------------------------------------------

SQL> create spfile from pfile;

File created.

------------------------------------------

使用sys用户编译以下脚本

sqlplus / as sysdba

SQL> show user;

@/u01/app/product/11.2.0.1/db1/rdbms/admin/catalog.sql;

@/u01/app/product/11.2.0.1/db1/rdbms/admin/catblock.sql;

@/u01/app/product/11.2.0.1/db1/rdbms/admin/catproc.sql;

@/u01/app/product/11.2.0.1/db1/rdbms/admin/catoctk.sql;

@/u01/app/product/11.2.0.1/db1/rdbms/admin/owminst.plb;

使用system用户编译

@/u01/app/product/11.2.0.1/db1/sqlplus/admin/pupbld.sql;

@/u01/app/product/11.2.0.1/db1/sqlplus/admin/help/hlpbld.sql helpus.sql;

使用sys用户编译

@/u01/app/product/11.2.0.1/db1/javavm/install/initjvm.sql;

@/u01/app/product/11.2.0.1/db1/xdk/admin/initxml.sql;

@/u01/app/product/11.2.0.1/db1/xdk/admin/xmlja.sql;

@/u01/app/product/11.2.0.1/db1/rdbms/admin/catjava.sql;

@/u01/app/product/11.2.0.1/db1/rdbms/admin/catexf.sql;

@/u01/app/product/11.2.0.1/db1/rdbms/admin/catqm.sql change_on_install SYSAUX TEMP YES;

@/u01/app/product/11.2.0.1/db1/rdbms/admin/catxdbj.sql;

@/u01/app/product/11.2.0.1/db1/rdbms/admin/catrul.sql;

spool /Oracle/admin/edidb/scripts/ordinst.log append

@/u01/app/product/11.2.0.1/db1/ord/admin/ordinst.sql SYSAUX SYSAUX;

spool off

spool /u01/app/admin/ora11g/scripts/interMedia.log append

@/u01/app/product/11.2.0.1/db1/ord/im/admin/iminst.sql;

spool off

set echo on

spool /oracle/admin/edidb/scripts/lockAccount.log append

BEGIN

FOR item IN ( SELECT USERNAME FROM DBA_USERS WHERE ACCOUNT_STATUS IN ('OPEN', 'LOCKED', 'EXPIRED') AND USERNAME NOT IN (

'SYS','SYSTEM') )

LOOP

dbms_output.put_line('Locking and Expiring: ' || item.USERNAME);

execute immediate 'alter user ' ||

sys.dbms_assert.enquote_name(

sys.dbms_assert.schema_name(

item.USERNAME),false) || ' password expire account lock' ;

END LOOP;

END;

/

spool off

--------静默安装是响应db_insatll.rsp文件的内容需要修改的地方

1、oracle.install.option=INSTALL_DB_SWONLY

2、ORACLE_HOSTNAME=linuxidc

3、UNIX_GROUP_NAME=oinstall

4、INVENTORY_LOCATION=/u01/app/oraInventory

5、ORACLE_HOME=/u01/app/product/11.2.0.1/db1

6、ORACLE_BASE=/u01/app

7、oracle.install.db.DBA_GROUP=dba

8、oracle.install.db.OPER_GROUP=oinstall

9、DECLINE_SECURITY_UPDATES=true