[Oracle] 静默安装我的常用配置

记录下我测试环境常用的文件。
db_install.rsp
dbca.rsp
netca.rsp

命令行:
Step1.静默安装,database是安装目录

$ cd /home/ap/ebd/database/
$ ./runInstaller -silent -responseFile /home/ap/ebd/database/response/db_install.rsp -ignorePrereq -ignoreDiskWarning
<a href="http://nonexttime.me/wp-content/uploads/2017/11/file.rar">file</a>
#连接Oracle
$ sqlplus /nolog
SQL>connect /as sysdba
#启动Database
SQL>startup

 

Step2.静默创建监听

$ $ORACLE_HOME/bin/netca /silent /responseFile /home/ap/ebd/database/response/netca.rsp
$ lsnrctl

 

Step3.静默建库

$ $ORACLE_HOME/bin/dbca -silent -responseFile /home/ap/ebd/database/response/dbca.rsp

Step4.创建表空间、用户

SQL> create tablespace ebda datafile '/home/ap/ebd/oracle/oradata/ebda/data_ebda.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;
SQL> create user dzyh identified by dzyh;
SQL> alter user dzyh default tablespace ebda;
SQL> grant create session,create table,unlimited tablespace to ebda;

附件:

 

附件

分类上一篇:     分类下一篇:无,已是最新文章

Leave a Reply