静默DBCA 建实例

一、 用responseFile静默建实例

 

1.1 找到responsefile

解压介质后生成的database文件夹下面的response里，dbca_rsp

建议复制一份，然后修改里面的配置

注意几个参数（根据自己需求设定吧）

OPERATION_TYPE = "createDatabase" GDBNAME = "test1" SID = "test1" TEMPLATENAME = "General_Purpose.dbc" CHARACTERSET = "ZHS16GBK" MEMORYPERCENTAGE = "60" DATABASETYPE = "OLTP" #-----------------------*** End of CREATEDATABASE section ***------------------------ 这之后的就可以不用设置了

 

dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname test1 -sid test1 -responseFile NO_VALUE -characterSet ZHS16GBK -memoryPercentage 60

 

1.2 静默建实例

 

指定为上面修改的responsefile

（会要求输入sys和system密码）

[oracle@localhost response]$ dbca -silent -responseFile /oraapp/oracle/database/response/new_dbca.rsp Enter SYS user password:   Enter SYSTEM user password:   Copying database files 1% complete 3% complete 11% complete 18% complete 26% complete 37% complete Creating and starting Oracle instance 40% complete 45% complete 50% complete 55% complete 56% complete 60% complete 62% complete Completing Database Creation 66% complete 70% complete 73% complete 85% complete 96% complete 100% complete Look at the log file "/oraapp/oracle/cfgtoollogs/dbca/test1/test1.log" for further details.

 

1.3 查看状态

能看到数据库实例已经起来

[oracle@localhost response]$ ps -ef|grep smon oracle   62207     1  0 21:03 ?        00:00:01 ora_smon_test1

 

启动下监听，看到监听也有了，数据库也注册进去了

[oracle@localhost admin]$ lsnrctl start   LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 07-AUG-2016 23:06:12   Copyright (c) 1991, 2009, Oracle.  All rights reserved.   Starting /oraapp/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...   TNSLSNR for Linux: Version 11.2.0.1.0 - Production Log messages written to /oraapp/oracle/diag/tnslsnr/localhost/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))   Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias                     LISTENER Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date                07-AUG-2016 23:06:13 Uptime                    0 days 0 hr. 0 min. 1 sec Trace Level               off Security                  ON: Local OS Authentication SNMP                      OFF Listener Log File         /oraapp/oracle/diag/tnslsnr/localhost/listener/alert/log.xml Listening Endpoints Summary...   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))) The listener supports no services The command completed successfully   [oracle@localhost admin]$ lsnrctl status   LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 07-AUG-2016 23:06:30   Copyright (c) 1991, 2009, Oracle.  All rights reserved.   Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias                     LISTENER Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date                07-AUG-2016 23:06:13 Uptime                    0 days 0 hr. 0 min. 17 sec Trace Level               off Security                  ON: Local OS Authentication SNMP                      OFF Listener Log File         /oraapp/oracle/diag/tnslsnr/localhost/listener/alert/log.xml Listening Endpoints Summary...   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))) Services Summary... Service "test1" has 1 instance(s).   Instance "test1", status READY, has 1 handler(s) for this service... Service "test1XDB" has 1 instance(s).   Instance "test1", status READY, has 1 handler(s) for this service... The command completed successfully

 

可以看下参数

SQL> show parameter sga;   NAME                                     TYPE      VALUE ------------------------------------ ----------- ------------------------------ lock_sga                        boolean         FALSE pre_page_sga                       boolean         FALSE sga_max_size                        big integer 1360M sga_target                             big integer 1360M SQL> show parameter pga;   NAME                                     TYPE      VALUE ------------------------------------ ----------- ------------------------------ pga_aggregate_target                big integer 336M

 

1360+336=1696

系统的内存是2807M，上面改配置文件是设定了60%，2807*0.6=1684

 

选择的是OLTP系统，pga给的是20%，sga是80%

二、 静默删除实例

 

[oracle@localhost response]$ dbca -silent -deleteDatabase -sourceDB test1 -sysDBAUserName sys -sysDBAPassword oracle Connecting to database 4% complete 9% complete 14% complete 19% complete 23% complete 28% complete 47% complete Updating network configuration files 52% complete Deleting instance and datafiles 76% complete 100% complete Look at the log file "/oraapp/oracle/cfgtoollogs/dbca/test1.log" for further details.

 

 

三、直接指定参数静默建实例

 

另一种建实例方法，直接指定参数，不用responsefile

 

[oracle@localhost response]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname test1 -sid test1 -responseFile NO_VALUE -characterSet ZHS16GBK -memoryPercentage 60 Enter SYS user password:   Enter SYSTEM user password:   Copying database files 1% complete 3% complete 11% complete 18% complete 26% complete 37% complete Creating and starting Oracle instance 40% complete 45% complete 50% complete 55% complete 56% complete 60% complete 62% complete Completing Database Creation 66% complete 70% complete 73% complete 85% complete 96% complete 100% complete Look at the log file "/oraapp/oracle/cfgtoollogs/dbca/test1/test10.log" for further details.

 

 

[oracle@localhost response]$ sqlplus / as sysdba   SQL*Plus: Release 11.2.0.1.0 Production on Mon Aug 8 02:31:54 2016   Copyright (c) 1982, 2009, Oracle.  All rights reserved.   s Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options   SQL>show parameter name;   NAME                                     TYPE      VALUE ------------------------------------ ----------- ------------------------------ db_file_name_convert                string db_name                               string     test1 db_unique_name                          string     test1 global_names                       boolean         FALSE instance_name                              string     test1 lock_name_space                        string log_file_name_convert               string service_names                               string     test1 SQL> show parameter sga;   NAME                                     TYPE      VALUE ------------------------------------ ----------- ------------------------------ lock_sga                        boolean         FALSE pre_page_sga                       boolean         FALSE sga_max_size                        big integer 1264M sga_target                             big integer 1264M SQL> show parameter pga;   NAME                                     TYPE      VALUE ------------------------------------ ----------- ------------------------------ pga_aggregate_target                big integer 420M

 

默认的类型是：MULTIPURPOSE，PGA占了25%

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30935525/viewspace-2123421/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30935525/viewspace-2123421/