- 浏览: 97169 次
-
文章分类
最新评论
-
jXee:
lgs0626 写道求源码,兄弟给共享下吧 "jee ...
jee6 学习笔记 4 - CRUD 2: View Details, Primefaces row selection -
lgs0626:
求源码,兄弟给共享下吧
jee6 学习笔记 4 - CRUD 2: View Details, Primefaces row selection
Use Oracle DBCA silent mode to create new database from template
- 博客分类:
- Oracle
### command line to use Oracle DBCA (-silent) to create a new dabase, using a NoSeed template
### 1. replace "SIDofNewDb" with the "SID" for your new database
### 2. you can edit the template to meet your requirement for the new database: MobilisNewDB.dbt
### 3. when asked from password of user SYS and SYSTEM, enter password for user "SYS,SYSTEM"
dbca -silent -createDatabase -templateName ./MyNewDB.dbt -gdbname MyNewDB -sid MyNewDB -characterSet AL32UTF8 -memoryPercentage 40 -emConfiguration NONE
template "MyNewDB.dbt" defines the parameters for Oracle to create a new database. You this is called "no-seed" template in that, you define your most things in it, such as your table spaces etc.
The template is an XML file but with extension ".dbt", it defines tablespace "USER_DATA" and "USER_INDEX" etc. Here's the content of it:
<DatabaseTemplate name="newDBtemplate" description="template to create new database" version="11.1.0.0.0"> <CommonAttributes> <option name="ISEARCH" value="true"/> <option name="OMS" value="false"/> <option name="JSERVER" value="true"/> <option name="SPATIAL" value="true"/> <option name="IMEDIA" value="true"/> <option name="XDB_PROTOCOLS" value="true"> <tablespace id="SYSAUX"/> </option> <option name="ORACLE_TEXT" value="true"> <tablespace id="SYSAUX"/> </option> <option name="SAMPLE_SCHEMA" value="false"/> <option name="CWMLITE" value="true"> <tablespace id="SYSAUX"/> </option> <option name="EM_REPOSITORY" value="true"> <tablespace id="SYSAUX"/> </option> <option name="APEX" value="true"> <tablespace id="SYSAUX"/> </option> <option name="OWB" value="true"> <tablespace id="SYSAUX"/> </option> <option name="DV" value="false"/> </CommonAttributes> <Variables/> <CustomScripts Execute="false"/> <InitParamAttributes> <InitParams> <initParam name="diagnostic_dest" value="/u01/app/oracle"/> <initParam name="statistics_level" value="ALL"/> <initParam name="processes" value="150"/> <initParam name="db_recovery_file_dest_size" value="2147483648"/> <initParam name="control_files" value="("{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control01.ctl", "{ORACLE_BAS E}/oradata/{DB_UNIQUE_NAME}/control02.ctl", "{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control03.ctl")"/> <initParam name="compatible" value="11.1.0.0.0"/> <initParam name="memory_target" value="6144" unit="MB"/> <initParam name="log_archive_dest" value="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/archivelog"/> <initParam name="db_name" value=""/> <initParam name="dispatchers" value="(PROTOCOL=TCP) (SERVICE={SID}XDB)"/> <initParam name="audit_file_dest" value="{ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump"/> <initParam name="open_cursors" value="10000"/> <initParam name="db_block_size" value="8192"/> <initParam name="db_recovery_file_dest" value="{ORACLE_BASE}/flash_recovery_area"/> <initParam name="undo_tablespace" value="UNDOTBS1"/> <initParam name="log_archive_format" value="%t_%s_%r.dbf"/> <initParam name="remote_login_passwordfile" value="EXCLUSIVE"/> <initParam name="audit_trail" value="DB"/> </InitParams> <MiscParams> <characterSet>WE8MSWIN1252</characterSet> <nationalCharacterSet>UTF8</nationalCharacterSet> <archiveLogMode>true</archiveLogMode> <initParamFileName>{ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/pfile/init.ora</initParamFileName> </MiscParams> <SPfile useSPFile="true">{ORACLE_HOME}/dbs/spfile{SID}.ora</SPfile> </InitParamAttributes> <StorageAttributes> <ControlfileAttributes id="Controlfile"> <maxDatafiles>100</maxDatafiles> <maxLogfiles>16</maxLogfiles> <maxLogMembers>3</maxLogMembers> <maxLogHistory>1</maxLogHistory> <maxInstances>8</maxInstances> <image name="control01.ctl" filepath="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/"/> <image name="control02.ctl" filepath="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/"/> <image name="control03.ctl" filepath="{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/"/> </ControlfileAttributes> <DatafileAttributes id="/u03/oradata/{DB_UNIQUE_NAME}/studentdat01.dbf"> <tablespace>STUDENT_DATA</tablespace> <temporary>false</temporary> <online>true</online> <status>0</status> <size unit="MB">10240</size> <reuse>true</reuse> <autoExtend>true</autoExtend> <increment unit="MB">100</increment> <maxSize unit="MB">32767</maxSize> </DatafileAttributes> <DatafileAttributes id="/u03/oradata/{DB_UNIQUE_NAME}/studentidx01.dbf"> <tablespace>STUDENT_INDEX</tablespace> <temporary>false</temporary> <online>true</online> <status>0</status> <size unit="MB">5120</size> <reuse>true</reuse> <autoExtend>true</autoExtend> <increment unit="MB">100</increment> <maxSize unit="MB">32767</maxSize> </DatafileAttributes> <DatafileAttributes id="/u03/oradata/{DB_UNIQUE_NAME}/sysaux01.dbf"> <tablespace>SYSAUX</tablespace> <temporary>false</temporary> <online>true</online> <status>0</status> <size unit="MB">512</size> <reuse>true</reuse> <autoExtend>true</autoExtend> <increment unit="KB">10240</increment> <maxSize unit="MB">32767</maxSize> </DatafileAttributes> <DatafileAttributes id="/u03/oradata/{DB_UNIQUE_NAME}/system01.dbf"> <tablespace>SYSTEM</tablespace> <temporary>false</temporary> <online>true</online> <status>0</status> <size unit="MB">512</size> <reuse>true</reuse> <autoExtend>true</autoExtend> <increment unit="KB">10240</increment> <maxSize unit="MB">32767</maxSize> </DatafileAttributes> <DatafileAttributes id="/u03/oradata/{DB_UNIQUE_NAME}/temp01.dbf"> <tablespace>TEMP</tablespace> <temporary>true</temporary> <online>true</online> <status>0</status> <size unit="MB">1024</size> <reuse>true</reuse> <autoExtend>true</autoExtend> <increment unit="KB">640</increment> <maxSize unit="MB">32767</maxSize> </DatafileAttributes> <DatafileAttributes id="/u03/oradata/{DB_UNIQUE_NAME}/undotbs01.dbf"> <tablespace>UNDOTBS1</tablespace> <temporary>false</temporary> <online>true</online> <status>0</status> <size unit="MB">1024</size> <reuse>true</reuse> <autoExtend>false</autoExtend> <increment unit="KB">-2</increment> <maxSize unit="KB">-1</maxSize> </DatafileAttributes> <DatafileAttributes id="/u03/oradata/{DB_UNIQUE_NAME}/users01.dbf"> <tablespace>USERS</tablespace> <temporary>false</temporary> <online>true</online> <status>0</status> <size unit="MB">50</size> <reuse>true</reuse> <autoExtend>true</autoExtend> <increment unit="KB">1280</increment> <maxSize unit="MB">32767</maxSize> </DatafileAttributes> <TablespaceAttributes id="STUDENT_DATA"> <online>true</online> <offlineMode>1</offlineMode> <readOnly>false</readOnly> <temporary>false</temporary> <defaultTemp>false</defaultTemp> <undo>false</undo> <local>true</local> <blockSize>8192</blockSize> <allocation>1</allocation> <uniAllocSize unit="KB">-1</uniAllocSize> <initSize unit="KB">64</initSize> <increment unit="KB">0</increment> <incrementPercent>0</incrementPercent> <minExtends>1</minExtends> <maxExtends>2147483645</maxExtends> <minExtendsSize unit="KB">64</minExtendsSize> <logging>true</logging> <recoverable>false</recoverable> <maxFreeSpace>0</maxFreeSpace> <autoSegmentMgmt>true</autoSegmentMgmt> <bigfile>false</bigfile> <datafilesList> <TablespaceDatafileAttributes id="/u03/oradata/{DB_UNIQUE_NAME}/studentdat01.dbf"> <id>-1</id> </TablespaceDatafileAttributes> </datafilesList> </TablespaceAttributes> <TablespaceAttributes id="STUDENT_INDEX"> <online>true</online> <offlineMode>1</offlineMode> <readOnly>false</readOnly> <temporary>false</temporary> <defaultTemp>false</defaultTemp> <undo>false</undo> <local>true</local> <blockSize>8192</blockSize> <allocation>1</allocation> <uniAllocSize unit="KB">-1</uniAllocSize> <initSize unit="KB">64</initSize> <increment unit="KB">0</increment> <incrementPercent>0</incrementPercent> <minExtends>1</minExtends> <maxExtends>2147483645</maxExtends> <minExtendsSize unit="KB">64</minExtendsSize> <logging>true</logging> <recoverable>false</recoverable> <maxFreeSpace>0</maxFreeSpace> <autoSegmentMgmt>true</autoSegmentMgmt> <bigfile>false</bigfile> <datafilesList> <TablespaceDatafileAttributes id="/u03/oradata/{DB_UNIQUE_NAME}/studentidx01.dbf"> <id>-1</id> </TablespaceDatafileAttributes> </datafilesList> </TablespaceAttributes> <TablespaceAttributes id="SYSAUX"> <online>true</online> <offlineMode>1</offlineMode> <readOnly>false</readOnly> <temporary>false</temporary> <defaultTemp>false</defaultTemp> <undo>false</undo> <local>true</local> <blockSize>8192</blockSize> <allocation>1</allocation> <uniAllocSize unit="KB">-1</uniAllocSize> <initSize unit="KB">64</initSize> <increment unit="KB">0</increment> <incrementPercent>0</incrementPercent> <minExtends>1</minExtends> <maxExtends>2147483645</maxExtends> <minExtendsSize unit="KB">64</minExtendsSize> <logging>true</logging> <recoverable>false</recoverable> <maxFreeSpace>0</maxFreeSpace> <autoSegmentMgmt>true</autoSegmentMgmt> <bigfile>false</bigfile> <datafilesList> <TablespaceDatafileAttributes id="/u03/oradata/{DB_UNIQUE_NAME}/sysaux01.dbf"> <id>-1</id> </TablespaceDatafileAttributes> </datafilesList> </TablespaceAttributes> <TablespaceAttributes id="SYSTEM"> <online>true</online> <offlineMode>1</offlineMode> <readOnly>false</readOnly> <temporary>false</temporary> <defaultTemp>false</defaultTemp> <undo>false</undo> <local>true</local> <blockSize>8192</blockSize> <allocation>1</allocation> <uniAllocSize unit="KB">-1</uniAllocSize> <initSize unit="KB">64</initSize> <increment unit="KB">0</increment> <incrementPercent>0</incrementPercent> <minExtends>1</minExtends> <maxExtends>2147483645</maxExtends> <minExtendsSize unit="KB">64</minExtendsSize> <logging>true</logging> <recoverable>false</recoverable> <maxFreeSpace>0</maxFreeSpace> <autoSegmentMgmt>false</autoSegmentMgmt> <bigfile>false</bigfile> <datafilesList> <TablespaceDatafileAttributes id="/u03/oradata/{DB_UNIQUE_NAME}/system01.dbf"> <id>-1</id> </TablespaceDatafileAttributes> </datafilesList> </TablespaceAttributes> <TablespaceAttributes id="TEMP"> <online>true</online> <offlineMode>1</offlineMode> <readOnly>false</readOnly> <temporary>true</temporary> <defaultTemp>true</defaultTemp> <undo>false</undo> <local>true</local> <blockSize>8192</blockSize> <allocation>2</allocation> <uniAllocSize unit="KB">1024</uniAllocSize> <initSize unit="KB">1024</initSize> <increment unit="KB">1024</increment> <incrementPercent>0</incrementPercent> <minExtends>1</minExtends> <maxExtends>-1</maxExtends> <minExtendsSize unit="KB">1024</minExtendsSize> <logging>false</logging> <recoverable>false</recoverable> <maxFreeSpace>0</maxFreeSpace> <autoSegmentMgmt>false</autoSegmentMgmt> <bigfile>false</bigfile> <datafilesList> <TablespaceDatafileAttributes id="/u03/oradata/{DB_UNIQUE_NAME}/temp01.dbf"> <id>-1</id> </TablespaceDatafileAttributes> </datafilesList> </TablespaceAttributes> <TablespaceAttributes id="UNDOTBS1"> <online>true</online> <offlineMode>1</offlineMode> <readOnly>false</readOnly> <temporary>false</temporary> <defaultTemp>false</defaultTemp> <undo>true</undo> <local>true</local> <blockSize>8192</blockSize> <allocation>1</allocation> <uniAllocSize unit="KB">-1</uniAllocSize> <initSize unit="KB">64</initSize> <increment unit="KB">0</increment> <incrementPercent>0</incrementPercent> <minExtends>1</minExtends> <maxExtends>2147483645</maxExtends> <minExtendsSize unit="KB">64</minExtendsSize> <logging>true</logging> <recoverable>false</recoverable> <maxFreeSpace>0</maxFreeSpace> <autoSegmentMgmt>false</autoSegmentMgmt> <bigfile>false</bigfile> <datafilesList> <TablespaceDatafileAttributes id="/u03/oradata/{DB_UNIQUE_NAME}/undotbs01.dbf"> <id>-1</id> </TablespaceDatafileAttributes> </datafilesList> </TablespaceAttributes> <TablespaceAttributes id="USERS"> <online>true</online> <offlineMode>1</offlineMode> <readOnly>false</readOnly> <temporary>false</temporary> <defaultTemp>false</defaultTemp> <undo>false</undo> <local>true</local> <blockSize>8192</blockSize> <allocation>1</allocation> <uniAllocSize unit="KB">-1</uniAllocSize> <initSize unit="KB">64</initSize> <increment unit="KB">0</increment> <incrementPercent>0</incrementPercent> <minExtends>1</minExtends> <maxExtends>2147483645</maxExtends> <minExtendsSize unit="KB">64</minExtendsSize> <logging>true</logging> <recoverable>false</recoverable> <maxFreeSpace>0</maxFreeSpace> <autoSegmentMgmt>true</autoSegmentMgmt> <bigfile>false</bigfile> <datafilesList> <TablespaceDatafileAttributes id="/u03/oradata/{DB_UNIQUE_NAME}/users01.dbf"> <id>-1</id> </TablespaceDatafileAttributes> </datafilesList> </TablespaceAttributes> <RedoLogGroupAttributes id="1"> <reuse>false</reuse> <fileSize unit="KB">51200</fileSize> <Thread>1</Thread> <member ordinal="0" memberName="redo01.log" filepath="/u03/oradata/{DB_UNIQUE_NAME}/"/> </RedoLogGroupAttributes> <RedoLogGroupAttributes id="2"> <reuse>false</reuse> <fileSize unit="KB">51200</fileSize> <Thread>1</Thread> <member ordinal="0" memberName="redo02.log" filepath="/u03/oradata/{DB_UNIQUE_NAME}/"/> </RedoLogGroupAttributes> <RedoLogGroupAttributes id="3"> <reuse>false</reuse> <fileSize unit="KB">51200</fileSize> <Thread>1</Thread> <member ordinal="0" memberName="redo03.log" filepath="/u03/oradata/{DB_UNIQUE_NAME}/"/> </RedoLogGroupAttributes> <RedoLogGroupAttributes id="4"> <reuse>false</reuse> <fileSize unit="KB">51200</fileSize> <Thread>1</Thread> <member ordinal="0" memberName="redo04.log" filepath="/u03/oradata/{DB_UNIQUE_NAME}/"/> </RedoLogGroupAttributes> <RedoLogGroupAttributes id="5"> <reuse>false</reuse> <fileSize unit="KB">51200</fileSize> <Thread>1</Thread> <member ordinal="0" memberName="redo05.log" filepath="/u03/oradata/{DB_UNIQUE_NAME}/"/> </RedoLogGroupAttributes> <RedoLogGroupAttributes id="6"> <reuse>false</reuse> <fileSize unit="KB">51200</fileSize> <Thread>1</Thread> <member ordinal="0" memberName="redo06.log" filepath="/u03/oradata/{DB_UNIQUE_NAME}/"/> </RedoLogGroupAttributes> <RedoLogGroupAttributes id="7"> <reuse>false</reuse> <fileSize unit="KB">51200</fileSize> <Thread>1</Thread> <member ordinal="0" memberName="redo07.log" filepath="/u03/oradata/{DB_UNIQUE_NAME}/"/> </RedoLogGroupAttributes> <RedoLogGroupAttributes id="8"> <reuse>false</reuse> <fileSize unit="KB">51200</fileSize> <Thread>1</Thread> <member ordinal="0" memberName="redo08.log" filepath="/u03/oradata/{DB_UNIQUE_NAME}/"/> </RedoLogGroupAttributes> <RedoLogGroupAttributes id="9"> <reuse>false</reuse> <fileSize unit="KB">51200</fileSize> <Thread>1</Thread> <member ordinal="0" memberName="redo09.log" filepath="/u03/oradata/{DB_UNIQUE_NAME}/"/> </RedoLogGroupAttributes> <RedoLogGroupAttributes id="10"> <reuse>false</reuse> <fileSize unit="KB">51200</fileSize> <Thread>1</Thread> <member ordinal="0" memberName="redo10.log" filepath="/u03/oradata/{DB_UNIQUE_NAME}/"/> </RedoLogGroupAttributes> </StorageAttributes> </DatabaseTemplate>
发表评论
-
When to configure an XA datasource?
2012-11-16 12:58 1237If you ever came across this wa ... -
manually drop and delete an Oracle database
2012-10-06 19:43 723Using DBCA command line to dele ... -
cold back up an oracle database
2012-10-06 19:23 767Refrence: search "Oracle ... -
manually create a new oracle database
2012-10-06 18:25 893using dbca to create a database ... -
Start/shutdown oracle
2012-10-06 16:26 836## set the database to logon ex ... -
老是忘记的Oracel sql statements
2012-07-04 14:09 766-- find oracle version SELECT * ... -
ORA-12541: TNS no listener
2012-07-04 14:02 1134cannot connect to oracle due to ...
相关推荐
关于oracle安装所遇到的问题的解决方案,该问题为,无法启动netmgr页面,无法启动dbca页面。
用Oracle DBCA 工具创建新数据库
RAC dbca静默建库所需的响应文件
oracle配置文件dbca.rsp
Linux 下oracle启动dbca netca时汉字显示出一个个方框的解决方法。
使用DBCA创建Oracle数据库
oracle静默安装,
DBCA(Database Configuration Assistant)是 Oracle 提供的一种图形化工具,用于创建、配置和管理 Oracle 数据库。在本节中,我们将详细介绍使用 DBCA 创建数据库的步骤和过程。 选择 DBCA 程序 在开始创建数据库...
利用 DBCA 建立 Oracle 9i 资料库
除了如何利用 DBCA 来创建 ORACLE 数据库,还有在命令行下通过执行 CREATE DATABASE 命令来创建一个数据库,之所以演示命令行手工创建数据库给大家是因为在 OCM 的实验考试里面是不允许用 DBCA 来建库的。
主要给大家介绍了关于Oracle在dbca时报:ORA-12547: TNS:lost contact错误的解决方法,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友们下面来一起看看吧。
利用dbca建立oracle 9i资料库.
Oracle排错 DBCA建库诡异问题处理--rac环境不能创建rac库
东北大学软件学院 Exercise 1: Use the DBCA to Create a Database Exercise 4: Use the Alert Log
【DBCA -SILENT】静默安装之rac数据库安装【DBCA -SILENT】静默安装之rac数据库安装
oracle10管理 dbca使用详细图文教程,适合初学者。
安装好oracle database 11g后,可使用Database Configuration Assistant创建数据库,并使用Oracle自带的SQL Developer创建该数据库连接,新建用户。
Oracle12个实验完整实验报告。 从Exercise 1: Use the DBCA to Create a Database到Exercise 12: Create and Grant Roles都有。 有些涉及到文件路径的需要自行修改。
【DBCA -SILENT】静默安装如何启用归档模式.pdf【DBCA -SILENT】静默安装如何启用归档模式.pdf
1.1 Oracle Pluggable Database 6 1.1.1 可插拔数据库概述 6 1.1.2 Multitenant 多租户功能改进 7 1.1.3 Pluggable database适应场景 7 1.1.4 Pluggable Database 带来的好处 8 1.1.5 通过DBCA创建12c可插拔数据库...