| Running DBCA in Silent Mode issue... [message #541128] |
Fri, 27 January 2012 13:51  |
amazing
Messages: 46
Registered: September 2007
Location: Venezuela
|
Member |
|
|
Hi to everyone. I'm trying to run dbca in silent mode and works perfect, this is how the code look like:
dbca -silent -createDatabase -templateName Transaction_Processing.dbc -gdbName test.mydomain -sid test
-sysPassword passoracle -systemPassword passoracle -emConfiguration LOCAL -dbsnmpPassword passoracle
-sysmanPassword passoracle -characterSet WE8ISO8859P1
-initParams "open_cursors=500"
The problem is when I specify more than one initialization parameter in -initParams. If I try something like
-initParams "open_cursors=500, parallel_max_server=0"
Then I get this error
Exception in thread "main"
Any help would be appreciated
[Updated on: Fri, 27 January 2012 14:09] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: Running DBCA in Silent Mode issue... [message #541331 is a reply to message #541131] |
Mon, 30 January 2012 09:07  |
amazing
Messages: 46
Registered: September 2007
Location: Venezuela
|
Member |
|
|
With out spaces between parameters still the same error. Then I tried to create a custom template based on transaction_processing.dbc with those parameters configured so the code will be like:
dbca -silent -createDatabase -templateName custom_template.dbc -gdbName test.mydomain -sid test
-sysPassword passoracle -systemPassword passoracle -emConfiguration LOCAL -dbsnmpPassword passoracle
-sysmanPassword passoracle -characterSet WE8ISO8859P1
And it works fine...but still the same error Exception in thread "main"
-initParams "open_cursors=500,parallel_max_server=0"
|
|
|
|
| Re: Running DBCA in Silent Mode issue... [message #541346 is a reply to message #541331] |
Mon, 30 January 2012 13:11 |
 |
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
|
Senior Member |
|
|
You may need to edit the template using text editor to add the parameters.
Here is a template I used before:
<DatabaseTemplate name="Create 10g DB" description="Create Standard Oracle 10g Database on WinDoze" version="10.2.0.4.0">
<CommonAttributes>
<option name="ISEARCH" value="true"/>
<option name="OMS" value="false"/>
<option name="JSERVER" value="true"/>
<option name="SPATIAL" value="false"/>
<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="false">
<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="false"/>
<option name="DV" value="false"/>
<option name="NET_EXTENSIONS" value="false"/>
</CommonAttributes>
<Variables/>
<CustomScripts Execute="false"/>
<InitParamAttributes>
<InitParams>
<initParam name="control_files" value="("F:\oradata\{DB_NAME}\control01.ctl", "K:\oraredo\{DB_NAME}\control02.ctl", "G:\oraarch\{DB_NAME}\control03.ctl")"/>
<initParam name="pga_aggregate_target" value="64" unit="MB"/>
<initParam name="processes" value="555"/>
<initParam name="sga_target" value="9120" unit="MB"/>
<initParam name="compatible" value="10.2.0.3.0"/>
<initParam name="background_dump_dest" value="{ORACLE_BASE}\admin\{DB_UNIQUE_NAME}\bdump"/>
<initParam name="job_queue_processes" value="10"/>
<initParam name="db_name" value="ORCLPROD"/>
<initParam name="user_dump_dest" value="{ORACLE_BASE}\admin\{DB_UNIQUE_NAME}\udump"/>
<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="300"/>
<initParam name="db_block_size" value="16" unit="KB"/>
<initParam name="db_recovery_file_dest" value="G:\oraarch\flash_recovery_area"/>
<initParam name="core_dump_dest" value="{ORACLE_BASE}\admin\{DB_UNIQUE_NAME}\cdump"/>
<initParam name="remote_login_passwordfile" value="EXCLUSIVE"/>
<initParam name="undo_tablespace" value="UNDOTBS1"/>
<initParam name="undo_management" value="AUTO"/>
<initParam name="db_file_multiblock_read_count" value="16"/>
<initParam name="db_flashback_retention_target" value="0"/>
<initParam name="log_archive_format" value="{SID}_%S_%R.%T"/>
<initParam name="os_authent_prefix" value=""/>
</InitParams>
<MiscParams>
<databaseType>MULTIPURPOSE</databaseType>
<maxUserConn>20</maxUserConn>
<percentageMemTOSGA>13</percentageMemTOSGA>
<customSGA>false</customSGA>
<characterSet>AL32UTF8</characterSet>
<nationalCharacterSet>AL16UTF16</nationalCharacterSet>
<archiveLogMode>false</archiveLogMode>
<initParamFileName>{ORACLE_BASE}\admin\{DB_UNIQUE_NAME}\pfile\init.ora</initParamFileName>
</MiscParams>
<SPfile useSPFile="true">{ORACLE_HOME}\database\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="F:\oradata\{DB_NAME}\"/>
<image name="control02.ctl" filepath="K:\oraredo\{DB_NAME}\"/>
<image name="control03.ctl" filepath="G:\oraarch\{DB_NAME}\"/>
</ControlfileAttributes>
<DatafileAttributes id="F:\oradata\{DB_NAME}\sysaux01.dbf">
<tablespace>SYSAUX</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">1200</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="MB">64</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="F:\oradata\{DB_NAME}\system01.dbf">
<tablespace>SYSTEM</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">1000</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="MB">64</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="F:\oradata\{DB_NAME}\users01.dbf">
<tablespace>USERS</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">100</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="KB">1280</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="I:\oratemp\{DB_NAME}\temp01.dbf">
<tablespace>TEMP</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">1500</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="MB">100</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<DatafileAttributes id="J:\oraundo\{DB_NAME}\undotbs01.dbf">
<tablespace>UNDOTBS1</tablespace>
<temporary>false</temporary>
<online>true</online>
<status>0</status>
<size unit="MB">1200</size>
<reuse>true</reuse>
<autoExtend>true</autoExtend>
<increment unit="MB">128</increment>
<maxSize unit="MB">-1</maxSize>
</DatafileAttributes>
<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>-1</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">64</initSize>
<increment unit="KB">64</increment>
<incrementPercent>50</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>4096</maxExtends>
<minExtendsSize unit="KB">64</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>true</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="F:\oradata\{DB_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>-1</blockSize>
<allocation>3</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">64</initSize>
<increment unit="KB">64</increment>
<incrementPercent>50</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>-1</maxExtends>
<minExtendsSize unit="KB">64</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>true</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="F:\oradata\{DB_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>-1</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">64</initSize>
<increment unit="KB">64</increment>
<incrementPercent>0</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>0</maxExtends>
<minExtendsSize unit="KB">64</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>true</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="I:\oratemp\{DB_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>-1</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">512</initSize>
<increment unit="KB">512</increment>
<incrementPercent>50</incrementPercent>
<minExtends>8</minExtends>
<maxExtends>4096</maxExtends>
<minExtendsSize unit="KB">512</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>true</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="J:\oraundo\{DB_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>-1</blockSize>
<allocation>1</allocation>
<uniAllocSize unit="KB">-1</uniAllocSize>
<initSize unit="KB">128</initSize>
<increment unit="KB">128</increment>
<incrementPercent>0</incrementPercent>
<minExtends>1</minExtends>
<maxExtends>4096</maxExtends>
<minExtendsSize unit="KB">128</minExtendsSize>
<logging>true</logging>
<recoverable>false</recoverable>
<maxFreeSpace>0</maxFreeSpace>
<autoSegmentMgmt>true</autoSegmentMgmt>
<bigfile>false</bigfile>
<datafilesList>
<TablespaceDatafileAttributes id="F:\oradata\{DB_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="redo01a.log" filepath="K:\oraredo\{DB_NAME}\"/>
<member ordinal="1" memberName="redo01b.log" filepath="K:\oraredo\{DB_NAME}\"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="2">
<reuse>false</reuse>
<fileSize unit="KB">51200</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo02a.log" filepath="K:\oraredo\{DB_NAME}\"/>
<member ordinal="2" memberName="redo02b.log" filepath="K:\oraredo\{DB_NAME}\"/>
</RedoLogGroupAttributes>
<RedoLogGroupAttributes id="3">
<reuse>false</reuse>
<fileSize unit="KB">51200</fileSize>
<Thread>1</Thread>
<member ordinal="0" memberName="redo03a.log" filepath="K:\oraredo\{DB_NAME}\"/>
<member ordinal="0" memberName="redo03b.log" filepath="K:\oraredo\{DB_NAME}\"/>
</RedoLogGroupAttributes>
</StorageAttributes>
</DatabaseTemplate>
Good luck!
PS: Notice you need to code the db_name once in the template.
[Updated on: Mon, 30 January 2012 14:29] by Moderator Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
