- 浏览: 99587 次
文章分类
最新评论
-
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 1264If you ever came across this wa ... -
manually drop and delete an Oracle database
2012-10-06 19:43 765Using DBCA command line to dele ... -
cold back up an oracle database
2012-10-06 19:23 800Refrence: search "Oracle ... -
manually create a new oracle database
2012-10-06 18:25 915using dbca to create a database ... -
Start/shutdown oracle
2012-10-06 16:26 877## set the database to logon ex ... -
老是忘记的Oracel sql statements
2012-07-04 14:09 812-- find oracle version SELECT * ... -
ORA-12541: TNS no listener
2012-07-04 14:02 1191cannot connect to oracle due to ...
相关推荐
在Oracle数据库的安装过程中,有时会遇到DBCA(Database Configuration Assistant)无法正常执行的问题,这通常是由于系统环境或安装过程中的某些配置不正确导致的。本文将针对标题和描述中提到的问题,即在CentOS...
Oracle Database Configuration Assistant (DBCA) 是一个图形化工具,用于简化Oracle数据库的创建和配置过程。它通过一系列直观的向导指导用户完成整个数据库创建流程。DBCA支持在多种操作系统上运行,包括Windows、...
RAC dbca静默建库所需的响应文件
oracle配置文件dbca.rsp
Oracle自动安装脚本是数据库管理员和系统管理员在部署Oracle数据库时常用的一种工具,它通过自动化流程简化了安装过程,减少了人为错误的可能性。Oracle数据库是一款功能强大的关系型数据库管理系统,广泛应用于企业...
在Linux环境下,Oracle数据库的DBCA(Database Configuration Assistant)和NETCA(Network Configuration Assistant)工具在处理汉字时可能会出现乱码问题,表现为汉字显示为一个个方框。这通常是由于系统缺少对...
从上述命令可以看出,作者尝试通过`dbca-silent-createDatabase`命令结合一系列参数来创建RAC数据库。然而,在执行命令后,发现创建出来的数据库并非预期的RAC数据库,而是单实例数据库。 #### 1.5 解决方案 #####...
- `dbca -silent -responseFile /home/oracle/dbca.rsp` #### 四、验证数据库状态 - **登录到SQL*Plus**:`sqlplus / as sysdba` - **查询数据库状态**:`select status from v$instance;` #### 五、总结 通过...
在探讨如何使用Oracle Database Configuration Assistant (DBCA)来建立Oracle 9i资料库之前,让我们先简要回顾Oracle 9i环境下的资料库管理概念。Oracle 9i是一款由甲骨文公司开发的企业级数据库管理系统,提供了...
"oracle-create-database.rar_create database orac_linux oracle_ora"这个压缩包文件显然是为在Linux环境下创建Oracle数据库而准备的。下面将详细阐述在Linux下创建Oracle数据库的关键步骤、涉及的技术点以及可能...
oracle 12c 静默安装 ,数据库应用安装模板文件,dbca.rsp ,已经编辑好了,可按博客中介绍直接使用
DBCA(Database Configuration Assistant)是Oracle数据库管理系统提供的一种图形化工具,用于简化数据库的创建、配置和管理。在Oracle 9i版本中,DBCA提供了一种直观且用户友好的方式来创建数据库,尤其适合那些不...
本文将详细介绍如何利用Database Configuration Assistant (DBCA) 创建一个Oracle 9i数据库。 Oracle 9i是Oracle数据库的一个版本,它在2001年发布,引入了许多新特性和改进,如数据仓库优化、自动存储管理(ASM)...
1. **创建数据库 (Create a database)**:允许用户通过图形界面快速创建一个新的Oracle数据库。 2. **配置数据库各项设定 (Configure database options in a database)**:用于调整现有数据库的各项配置选项。 3. **...
DBCA(Database Configuration Assistant)是 Oracle 提供的一种图形化工具,用于创建、配置和管理 Oracle 数据库。在本节中,我们将详细介绍使用 DBCA 创建数据库的步骤和过程。 选择 DBCA 程序 在开始创建数据库...
本文将详细讲解如何使用Oracle Database Configuration Assistant (DBCA) 创建数据库以及使用SQL Developer创建用户。 首先,Oracle DBCA是Oracle提供的一款图形化工具,它简化了数据库的创建过程。在已安装好...
理解Oracle Universal Installer(OUI)和Database Configuration Assistant(DBCA)的使用是关键。 3. **SQL与PL/SQL基础**:Oracle数据库的基础是SQL,用于查询和管理数据。PL/SQL是Oracle特有的过程语言,用于...
创建一个新的数据库是一个复杂但重要的任务,特别是在Oracle Certified Master (OCM) 实验考试中,考生可能需要手动执行这个过程,而不能依赖于图形化的Database Configuration Assistant (DBCA)工具。以下是一个...