一、 用responseFile静默建实例
1.1 找到responsefile
解压介质后生成的database文件夹下面的response里,dbca_rsp
建议复制一份,然后修改里面的配置
注意几个参数(根据自己需求设定吧)
OPERATION_TYPE = "createDatabase" GDBNAME = "test1" SID = "test1" TEMPLATENAME = "General_Purpose.dbc" 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/