dbca_11.2.rsp.erb 44 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032
  1. ##############################################################################
  2. ## ##
  3. ## DBCA response file ##
  4. ## ------------------ ##
  5. ## Copyright 1998, 2011, Oracle Corporation. All Rights Reserved. ##
  6. ## ##
  7. ## Specify values for the variables listed below to customize Oracle ##
  8. ## Database Configuration installation. ##
  9. ## ##
  10. ## Each variable is associated with a comment. The comment identifies the ##
  11. ## variable type. ##
  12. ## ##
  13. ## Please specify the values in the following format : ##
  14. ## Type : Example ##
  15. ## String : "<value>" ##
  16. ## Boolean : True or False ##
  17. ## Number : <numeric value> ##
  18. ## StringList : {"<value1>","<value2>"} ##
  19. ## ##
  20. ## Examples : ##
  21. ## 1. dbca -progress_only -responseFile <response file> ##
  22. ## Display a progress bar depicting progress of database creation ##
  23. ## process. ##
  24. ## ##
  25. ## 2. dbca -silent -responseFile <response file> ##
  26. ## Creates database silently. No user interface is displayed. ##
  27. ## ##
  28. ## 3. dbca -silent -createDatabase -cloneTemplate ##
  29. ## -responseFile <response file> ##
  30. ## Creates database silently with clone template. The template in ##
  31. ## responsefile is a clone template. ##
  32. ## ##
  33. ## 4. dbca -silent -deleteDatabase -responseFile <response file> ##
  34. ## Deletes database silently. ##
  35. ##############################################################################
  36. #-----------------------------------------------------------------------------
  37. # GENERAL section is required for all types of database creations.
  38. #-----------------------------------------------------------------------------
  39. [GENERAL]
  40. #-----------------------------------------------------------------------------
  41. # Name : RESPONSEFILE_VERSION
  42. # Datatype : String
  43. # Description : Version of the database to create
  44. # Valid values : "11.1.0"
  45. # Default value : None
  46. # Mandatory : Yes
  47. #-----------------------------------------------------------------------------
  48. RESPONSEFILE_VERSION = "11.2.0"
  49. #-----------------------------------------------------------------------------
  50. # Name : OPERATION_TYPE
  51. # Datatype : String
  52. # Description : Type of operation
  53. # Valid values : "createDatabase" \ "createTemplateFromDB" \ "createCloneTemplate" \ "deleteDatabase" \ "configureDatabase" \ "addInstance" (RAC-only) \ "deleteInstance" (RAC-only)
  54. # Default value : None
  55. # Mandatory : Yes
  56. #-----------------------------------------------------------------------------
  57. OPERATION_TYPE = "<%= @operationType %>"
  58. #-----------------------*** End of GENERAL section ***------------------------
  59. #-----------------------------------------------------------------------------
  60. # CREATEDATABASE section is used when OPERATION_TYPE is defined as "createDatabase".
  61. #-----------------------------------------------------------------------------
  62. [CREATEDATABASE]
  63. #-----------------------------------------------------------------------------
  64. # Name : GDBNAME
  65. # Datatype : String
  66. # Description : Global database name of the database
  67. # Valid values : <db_name>.<db_domain> - when database domain isn't NULL
  68. # <db_name> - when database domain is NULL
  69. # Default value : None
  70. # Mandatory : Yes
  71. #-----------------------------------------------------------------------------
  72. GDBNAME = "<%= @globalDbName %>"
  73. #-----------------------------------------------------------------------------
  74. # Name : RACONENODE
  75. # Datatype : Boolean
  76. # Description : Set to true for RAC One Node database
  77. # Valid values : TRUE\FALSE
  78. # Default value : FALSE
  79. # Mandatory : No
  80. #-----------------------------------------------------------------------------
  81. #RACONENODE = "false"
  82. #-----------------------------------------------------------------------------
  83. # Name : RACONENODESERVICENAME
  84. # Datatype : String
  85. # Description : Service is required by application to connect to RAC One
  86. # Node Database
  87. # Valid values : Service Name
  88. # Default value : None
  89. # Mandatory : No [required in case RACONENODE flag is set to true]
  90. #-----------------------------------------------------------------------------
  91. #RACONENODESERVICENAME =
  92. #-----------------------------------------------------------------------------
  93. # Name : POLICYMANAGED
  94. # Datatype : Boolean
  95. # Description : Set to true if Database is policy managed and
  96. # set to false if Database is admin managed
  97. # Valid values : TRUE\FALSE
  98. # Default value : FALSE
  99. # Mandatory : No
  100. #-----------------------------------------------------------------------------
  101. #POLICYMANAGED = "false"
  102. #-----------------------------------------------------------------------------
  103. # Name : CREATESERVERPOOL
  104. # Datatype : Boolean
  105. # Description : Set to true if new server pool need to be created for database
  106. # if this option is specified then the newly created database
  107. # will use this newly created serverpool.
  108. # Multiple serverpoolname can not be specified for database
  109. # Valid values : TRUE\FALSE
  110. # Default value : FALSE
  111. # Mandatory : No
  112. #-----------------------------------------------------------------------------
  113. #CREATESERVERPOOL = "false"
  114. #-----------------------------------------------------------------------------
  115. # Name : FORCE
  116. # Datatype : Boolean
  117. # Description : Set to true if new server pool need to be created by force
  118. # if this option is specified then the newly created serverpool
  119. # will be assigned server even if no free servers are available.
  120. # This may affect already running database.
  121. # This flag can be specified for Admin managed as well as policy managed db.
  122. # Valid values : TRUE\FALSE
  123. # Default value : FALSE
  124. # Mandatory : No
  125. #-----------------------------------------------------------------------------
  126. #FORCE = "false"
  127. #-----------------------------------------------------------------------------
  128. # Name : SERVERPOOLNAME
  129. # Datatype : String
  130. # Description : Only one serverpool name need to be specified
  131. # if Create Server Pool option is specified.
  132. # Comma-separated list of Serverpool names if db need to use
  133. # multiple Server pool
  134. # Valid values : ServerPool name
  135. # Default value : None
  136. # Mandatory : No [required in case of RAC service centric database]
  137. #-----------------------------------------------------------------------------
  138. #SERVERPOOLNAME =
  139. #-----------------------------------------------------------------------------
  140. # Name : CARDINALITY
  141. # Datatype : Number
  142. # Description : Specify Cardinality for create server pool operation
  143. # Valid values : any positive Integer value
  144. # Default value : Number of qualified nodes on cluster
  145. # Mandatory : No [Required when a new serverpool need to be created]
  146. #-----------------------------------------------------------------------------
  147. #CARDINALITY =
  148. #-----------------------------------------------------------------------------
  149. # Name : SID
  150. # Datatype : String
  151. # Description : System identifier (SID) of the database
  152. # Valid values : Check Oracle11g Administrator's Guide
  153. # Default value : <db_name> specified in GDBNAME
  154. # Mandatory : No
  155. #-----------------------------------------------------------------------------
  156. SID = "<%= @dbName %>"
  157. #-----------------------------------------------------------------------------
  158. # Name : NODELIST
  159. # Datatype : String
  160. # Description : Comma-separated list of cluster nodes
  161. # Valid values : Cluster node names
  162. # Default value : None
  163. # Mandatory : No (Yes for RAC database-centric database )
  164. #-----------------------------------------------------------------------------
  165. #NODELIST=
  166. #-----------------------------------------------------------------------------
  167. # Name : TEMPLATENAME
  168. # Datatype : String
  169. # Description : Name of the template
  170. # Valid values : Template file name
  171. # Default value : None
  172. # Mandatory : Yes
  173. #-----------------------------------------------------------------------------
  174. TEMPLATENAME = "General_Purpose.dbc"
  175. #-----------------------------------------------------------------------------
  176. # Name : OBFUSCATEDPASSWORDS
  177. # Datatype : Boolean
  178. # Description : Set to true if passwords are encrypted
  179. # Valid values : TRUE\FALSE
  180. # Default value : FALSE
  181. # Mandatory : No
  182. #-----------------------------------------------------------------------------
  183. #OBFUSCATEDPASSWORDS = FALSE
  184. #-----------------------------------------------------------------------------
  185. # Name : SYSPASSWORD
  186. # Datatype : String
  187. # Description : Password for SYS user
  188. # Valid values : Check Oracle11g Administrator's Guide
  189. # Default value : None
  190. # Mandatory : Yes
  191. #-----------------------------------------------------------------------------
  192. SYSPASSWORD = "<%= @sysPassword %>"
  193. #-----------------------------------------------------------------------------
  194. # Name : SYSTEMPASSWORD
  195. # Datatype : String
  196. # Description : Password for SYSTEM user
  197. # Valid values : Check Oracle11g Administrator's Guide
  198. # Default value : None
  199. # Mandatory : Yes
  200. #-----------------------------------------------------------------------------
  201. SYSTEMPASSWORD = "<%= @systemPassword %>"
  202. #-----------------------------------------------------------------------------
  203. # Name : EMCONFIGURATION
  204. # Datatype : String
  205. # Description : Enterprise Manager Configuration Type
  206. # Valid values : CENTRAL|LOCAL|ALL|NONE
  207. # Default value : NONE
  208. # Mandatory : No
  209. #-----------------------------------------------------------------------------
  210. EMCONFIGURATION = "<%= @emConfiguration %>"
  211. #-----------------------------------------------------------------------------
  212. # Name : DISABLESECURITYCONFIGURATION
  213. # Datatype : String
  214. # Description : Database Security Settings
  215. # Valid values : ALL|NONE|AUDIT|PASSWORD_PROFILE
  216. # Default value : NONE
  217. # Mandatory : No
  218. #-----------------------------------------------------------------------------
  219. #DISABLESECURITYCONFIGURATION = "NONE"
  220. #-----------------------------------------------------------------------------
  221. # Name : SYSMANPASSWORD
  222. # Datatype : String
  223. # Description : Password for SYSMAN user
  224. # Valid values : Check Oracle11g Administrator's Guide
  225. # Default value : None
  226. # Mandatory : Yes, if LOCAL specified for EMCONFIGURATION
  227. #-----------------------------------------------------------------------------
  228. #SYSMANPASSWORD = "password"
  229. #-----------------------------------------------------------------------------
  230. # Name : DBSNMPPASSWORD
  231. # Datatype : String
  232. # Description : Password for DBSNMP user
  233. # Valid values : Check Oracle11g Administrator's Guide
  234. # Default value : None
  235. # Mandatory : Yes, if EMCONFIGURATION is specified
  236. #-----------------------------------------------------------------------------
  237. #DBSNMPPASSWORD = "password"
  238. #-----------------------------------------------------------------------------
  239. # Name : CENTRALAGENT
  240. # Datatype : String
  241. # Description : Grid Control Central Agent Oracle Home
  242. # Default value : None
  243. # Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION
  244. #-----------------------------------------------------------------------------
  245. #CENTRALAGENT =
  246. #-----------------------------------------------------------------------------
  247. # Name : HOSTUSERNAME
  248. # Datatype : String
  249. # Description : Host user name for EM backup job
  250. # Default value : None
  251. # Mandatory : Yes, if ALL is specified for EMCONFIGURATION
  252. #-----------------------------------------------------------------------------
  253. #HOSTUSERNAME =
  254. #-----------------------------------------------------------------------------
  255. # Name : HOSTUSERPASSWORD
  256. # Datatype : String
  257. # Description : Host user password for EM backup job
  258. # Default value : None
  259. # Mandatory : Yes, if ALL is specified for EMCONFIGURATION
  260. #-----------------------------------------------------------------------------
  261. #HOSTUSERPASSWORD=
  262. #-----------------------------------------------------------------------------
  263. # Name : BACKUPSCHEDULE
  264. # Datatype : String
  265. # Description : Daily backup schedule in the form of hh:mm
  266. # Default value : 2:00
  267. # Mandatory : Yes, if ALL is specified for EMCONFIGURATION
  268. #-----------------------------------------------------------------------------
  269. #BACKUPSCHEDULE=
  270. #-----------------------------------------------------------------------------
  271. # Name : DVOWNERNAME
  272. # Datatype : String
  273. # Description : DataVault Owner
  274. # Valid values : Check Oracle11g Administrator's Guide
  275. # Default value : None
  276. # Mandatory : Yes, if DataVault option is chosen
  277. #-----------------------------------------------------------------------------
  278. #DVOWNERNAME = ""
  279. #-----------------------------------------------------------------------------
  280. # Name : DVOWNERPASSWORD
  281. # Datatype : String
  282. # Description : Password for DataVault Owner
  283. # Valid values : Check Oracle11g Administrator's Guide
  284. # Default value : None
  285. # Mandatory : Yes, if DataVault option is chosen
  286. #-----------------------------------------------------------------------------
  287. #DVOWNERPASSWORD = ""
  288. #-----------------------------------------------------------------------------
  289. # Name : DVACCOUNTMANAGERNAME
  290. # Datatype : String
  291. # Description : DataVault Account Manager
  292. # Valid values : Check Oracle11g Administrator's Guide
  293. # Default value : None
  294. # Mandatory : No
  295. #-----------------------------------------------------------------------------
  296. #DVACCOUNTMANAGERNAME = ""
  297. #-----------------------------------------------------------------------------
  298. # Name : DVACCOUNTMANAGERPASSWORD
  299. # Datatype : String
  300. # Description : Password for DataVault Account Manager
  301. # Valid values : Check Oracle11g Administrator's Guide
  302. # Default value : None
  303. # Mandatory : No
  304. #-----------------------------------------------------------------------------
  305. #DVACCOUNTMANAGERPASSWORD = ""
  306. #-----------------------------------------------------------------------------
  307. # Name : DATAFILEJARLOCATION
  308. # Datatype : String
  309. # Description : Location of the data file jar
  310. # Valid values : Directory containing compressed datafile jar
  311. # Default value : None
  312. # Mandatory : No
  313. #-----------------------------------------------------------------------------
  314. #DATAFILEJARLOCATION =
  315. #-----------------------------------------------------------------------------
  316. # Name : DATAFILEDESTINATION
  317. # Datatype : String
  318. # Description : Location of the data file's
  319. # Valid values : Directory for all the database files
  320. # Default value : $ORACLE_BASE/oradata
  321. # Mandatory : No
  322. #-----------------------------------------------------------------------------
  323. DATAFILEDESTINATION ="<%= @dataFileDestination %>"
  324. #-----------------------------------------------------------------------------
  325. # Name : RECOVERYAREADESTINATION
  326. # Datatype : String
  327. # Description : Location of the data file's
  328. # Valid values : Recovery Area location
  329. # Default value : $ORACLE_BASE/flash_recovery_area
  330. # Mandatory : No
  331. #-----------------------------------------------------------------------------
  332. RECOVERYAREADESTINATION="<%= @recoveryAreaDestination %>"
  333. #-----------------------------------------------------------------------------
  334. # Name : STORAGETYPE
  335. # Datatype : String
  336. # Description : Specifies the storage on which the database is to be created
  337. # Valid values : FS (CFS for RAC), ASM
  338. # Default value : FS
  339. # Mandatory : No
  340. #-----------------------------------------------------------------------------
  341. STORAGETYPE=<%= @storageType %>
  342. #-----------------------------------------------------------------------------
  343. # Name : DISKGROUPNAME
  344. # Datatype : String
  345. # Description : Specifies the disk group name for the storage
  346. # Default value : DATA
  347. # Mandatory : No
  348. #-----------------------------------------------------------------------------
  349. DISKGROUPNAME=<%= @asmDiskgroup %>
  350. #-----------------------------------------------------------------------------
  351. # Name : ASMSNMP_PASSWORD
  352. # Datatype : String
  353. # Description : Password for ASM Monitoring
  354. # Default value : None
  355. # Mandatory : No
  356. #-----------------------------------------------------------------------------
  357. ASMSNMP_PASSWORD=<%= @asmSnmpPassword %>
  358. #-----------------------------------------------------------------------------
  359. # Name : RECOVERYGROUPNAME
  360. # Datatype : String
  361. # Description : Specifies the disk group name for the recovery area
  362. # Default value : RECOVERY
  363. # Mandatory : No
  364. #-----------------------------------------------------------------------------
  365. RECOVERYGROUPNAME=<%= @recoveryDiskgroup %>
  366. #-----------------------------------------------------------------------------
  367. # Name : CHARACTERSET
  368. # Datatype : String
  369. # Description : Character set of the database
  370. # Valid values : Check Oracle11g National Language Support Guide
  371. # Default value : "US7ASCII"
  372. # Mandatory : NO
  373. #-----------------------------------------------------------------------------
  374. CHARACTERSET = "<%= @characterSet %>"
  375. #-----------------------------------------------------------------------------
  376. # Name : NATIONALCHARACTERSET
  377. # Datatype : String
  378. # Description : National Character set of the database
  379. # Valid values : "UTF8" or "AL16UTF16". For details, check Oracle11g National Language Support Guide
  380. # Default value : "AL16UTF16"
  381. # Mandatory : No
  382. #-----------------------------------------------------------------------------
  383. NATIONALCHARACTERSET= "<%= @nationalCharacterSet %>"
  384. #-----------------------------------------------------------------------------
  385. # Name : REGISTERWITHDIRSERVICE
  386. # Datatype : Boolean
  387. # Description : Specifies whether to register with Directory Service.
  388. # Valid values : TRUE \ FALSE
  389. # Default value : FALSE
  390. # Mandatory : No
  391. #-----------------------------------------------------------------------------
  392. #REGISTERWITHDIRSERVICE= TRUE
  393. #-----------------------------------------------------------------------------
  394. # Name : DIRSERVICEUSERNAME
  395. # Datatype : String
  396. # Description : Specifies the name of the directory service user
  397. # Mandatory : YES, if the value of registerWithDirService is TRUE
  398. #-----------------------------------------------------------------------------
  399. #DIRSERVICEUSERNAME= "name"
  400. #-----------------------------------------------------------------------------
  401. # Name : DIRSERVICEPASSWORD
  402. # Datatype : String
  403. # Description : The password of the directory service user.
  404. # You can also specify the password at the command prompt instead of here.
  405. # Mandatory : YES, if the value of registerWithDirService is TRUE
  406. #-----------------------------------------------------------------------------
  407. #DIRSERVICEPASSWORD= "password"
  408. #-----------------------------------------------------------------------------
  409. # Name : WALLETPASSWORD
  410. # Datatype : String
  411. # Description : The password for wallet to created or modified.
  412. # You can also specify the password at the command prompt instead of here.
  413. # Mandatory : YES, if the value of registerWithDirService is TRUE
  414. #-----------------------------------------------------------------------------
  415. #WALLETPASSWORD= "password"
  416. #-----------------------------------------------------------------------------
  417. # Name : LISTENERS
  418. # Datatype : String
  419. # Description : Specifies list of listeners to register the database with.
  420. # By default the database is configured for all the listeners specified in the
  421. # $ORACLE_HOME/network/admin/listener.ora
  422. # Valid values : The list should be space separated names like "listener1 listener2".
  423. # Mandatory : NO
  424. #-----------------------------------------------------------------------------
  425. #LISTENERS = "listener1 listener2"
  426. #-----------------------------------------------------------------------------
  427. # Name : VARIABLESFILE
  428. # Datatype : String
  429. # Description : Location of the file containing variable value pair
  430. # Valid values : A valid file-system file. The variable value pair format in this file
  431. # is <variable>=<value>. Each pair should be in a new line.
  432. # Default value : None
  433. # Mandatory : NO
  434. #-----------------------------------------------------------------------------
  435. #VARIABLESFILE =
  436. #-----------------------------------------------------------------------------
  437. # Name : VARIABLES
  438. # Datatype : String
  439. # Description : comma separated list of name=value pairs. Overrides variables defined in variablefile and templates
  440. # Default value : None
  441. # Mandatory : NO
  442. #-----------------------------------------------------------------------------
  443. #VARIABLES =
  444. #-----------------------------------------------------------------------------
  445. # Name : INITPARAMS
  446. # Datatype : String
  447. # Description : comma separated list of name=value pairs. Overrides initialization parameters defined in templates
  448. # Default value : None
  449. # Mandatory : NO
  450. #-----------------------------------------------------------------------------
  451. INITPARAMS ="<%= @initParams %>"
  452. #-----------------------------------------------------------------------------
  453. # Name : SAMPLESCHEMA
  454. # Datatype : Boolean
  455. # Description : Specifies whether or not to add the Sample Schemas to your database
  456. # Valid values : TRUE \ FALSE
  457. # Default value : FASLE
  458. # Mandatory : No
  459. #-----------------------------------------------------------------------------
  460. SAMPLESCHEMA="<%= @sampleSchema %>"
  461. #-----------------------------------------------------------------------------
  462. # Name : MEMORYPERCENTAGE
  463. # Datatype : String
  464. # Description : percentage of physical memory for Oracle
  465. # Default value : None
  466. # Mandatory : NO
  467. #-----------------------------------------------------------------------------
  468. MEMORYPERCENTAGE = "<%= @memoryPercentage %>"
  469. #-----------------------------------------------------------------------------
  470. # Name : DATABASETYPE
  471. # Datatype : String
  472. # Description : used for memory distribution when MEMORYPERCENTAGE specified
  473. # Valid values : MULTIPURPOSE|DATA_WAREHOUSING|OLTP
  474. # Default value : MULTIPURPOSE
  475. # Mandatory : NO
  476. #-----------------------------------------------------------------------------
  477. DATABASETYPE = "<%= @databaseType %>"
  478. #-----------------------------------------------------------------------------
  479. # Name : AUTOMATICMEMORYMANAGEMENT
  480. # Datatype : Boolean
  481. # Description : flag to indicate Automatic Memory Management is used
  482. # Valid values : TRUE/FALSE
  483. # Default value : TRUE
  484. # Mandatory : NO
  485. #-----------------------------------------------------------------------------
  486. #AUTOMATICMEMORYMANAGEMENT = "TRUE"
  487. #-----------------------------------------------------------------------------
  488. # Name : TOTALMEMORY
  489. # Datatype : String
  490. # Description : total memory in MB to allocate to Oracle
  491. # Valid values :
  492. # Default value :
  493. # Mandatory : NO
  494. #-----------------------------------------------------------------------------
  495. TOTALMEMORY = "<%= @memoryTotal %>"
  496. #-----------------------*** End of CREATEDATABASE section ***------------------------
  497. #-----------------------------------------------------------------------------
  498. # createTemplateFromDB section is used when OPERATION_TYPE is defined as "createTemplateFromDB".
  499. #-----------------------------------------------------------------------------
  500. [createTemplateFromDB]
  501. #-----------------------------------------------------------------------------
  502. # Name : SOURCEDB
  503. # Datatype : String
  504. # Description : The source database from which to create the template
  505. # Valid values : The format is <host>:<port>:<sid>
  506. # Default value : none
  507. # Mandatory : YES
  508. #-----------------------------------------------------------------------------
  509. SOURCEDB = "myhost:1521:orcl"
  510. #-----------------------------------------------------------------------------
  511. # Name : SYSDBAUSERNAME
  512. # Datatype : String
  513. # Description : A user with DBA role.
  514. # Default value : none
  515. # Mandatory : YES
  516. #-----------------------------------------------------------------------------
  517. SYSDBAUSERNAME = "system"
  518. #-----------------------------------------------------------------------------
  519. # Name : SYSDBAPASSWORD
  520. # Datatype : String
  521. # Description : The password of the DBA user.
  522. # You can also specify the password at the command prompt instead of here.
  523. # Default value : none
  524. # Mandatory : YES
  525. #-----------------------------------------------------------------------------
  526. #SYSDBAPASSWORD = "password"
  527. #-----------------------------------------------------------------------------
  528. # Name : TEMPLATENAME
  529. # Datatype : String
  530. # Description : Name for the new template.
  531. # Default value : None
  532. # Mandatory : Yes
  533. #-----------------------------------------------------------------------------
  534. TEMPLATENAME = "My Copy TEMPLATE"
  535. #-----------------------*** End of createTemplateFromDB section ***------------------------
  536. #-----------------------------------------------------------------------------
  537. # createCloneTemplate section is used when OPERATION_TYPE is defined as "createCloneTemplate".
  538. #-----------------------------------------------------------------------------
  539. [createCloneTemplate]
  540. #-----------------------------------------------------------------------------
  541. # Name : SOURCEDB
  542. # Datatype : String
  543. # Description : The source database is the SID from which to create the template.
  544. # This database must be local and on the same ORACLE_HOME.
  545. # Default value : none
  546. # Mandatory : YES
  547. #-----------------------------------------------------------------------------
  548. SOURCEDB = "orcl"
  549. #-----------------------------------------------------------------------------
  550. # Name : SYSDBAUSERNAME
  551. # Datatype : String
  552. # Description : A user with DBA role.
  553. # Default value : none
  554. # Mandatory : YES, if no OS authentication
  555. #-----------------------------------------------------------------------------
  556. #SYSDBAUSERNAME = "sys"
  557. #-----------------------------------------------------------------------------
  558. # Name : SYSDBAPASSWORD
  559. # Datatype : String
  560. # Description : The password of the DBA user.
  561. # You can also specify the password at the command prompt instead of here.
  562. # Default value : none
  563. # Mandatory : YES
  564. #-----------------------------------------------------------------------------
  565. #SYSDBAPASSWORD = "password"
  566. #-----------------------------------------------------------------------------
  567. # Name : TEMPLATENAME
  568. # Datatype : String
  569. # Description : Name for the new template.
  570. # Default value : None
  571. # Mandatory : Yes
  572. #-----------------------------------------------------------------------------
  573. TEMPLATENAME = "My Clone TEMPLATE"
  574. #-----------------------------------------------------------------------------
  575. # Name : DATAFILEJARLOCATION
  576. # Datatype : String
  577. # Description : Location of the data file jar
  578. # Valid values : Directory where the new compressed datafile jar will be placed
  579. # Default value : $ORACLE_HOME/assistants/dbca/templates
  580. # Mandatory : NO
  581. #-----------------------------------------------------------------------------
  582. #DATAFILEJARLOCATION =
  583. #-----------------------*** End of createCloneTemplate section ***------------------------
  584. #-----------------------------------------------------------------------------
  585. # DELETEDATABASE section is used when DELETE_TYPE is defined as "deleteDatabase".
  586. #-----------------------------------------------------------------------------
  587. [DELETEDATABASE]
  588. #-----------------------------------------------------------------------------
  589. # Name : SOURCEDB
  590. # Datatype : String
  591. # Description : The source database is the SID
  592. # This database must be local and on the same ORACLE_HOME.
  593. # Default value : none
  594. # Mandatory : YES
  595. #-----------------------------------------------------------------------------
  596. SOURCEDB = "<%= @dbName %>"
  597. #-----------------------------------------------------------------------------
  598. # Name : SYSDBAUSERNAME
  599. # Datatype : String
  600. # Description : A user with DBA role.
  601. # Default value : none
  602. # Mandatory : YES, if no OS authentication
  603. #-----------------------------------------------------------------------------
  604. SYSDBAUSERNAME = "sys"
  605. #-----------------------------------------------------------------------------
  606. # Name : SYSDBAPASSWORD
  607. # Datatype : String
  608. # Description : The password of the DBA user.
  609. # You can also specify the password at the command prompt instead of here.
  610. # Default value : none
  611. # Mandatory : YES, if no OS authentication
  612. #-----------------------------------------------------------------------------
  613. SYSDBAPASSWORD = "<%= @sysPassword %>"
  614. #-----------------------*** End of deleteDatabase section ***------------------------
  615. #-----------------------------------------------------------------------------
  616. # GENERATESCRIPTS section
  617. #-----------------------------------------------------------------------------
  618. [generateScripts]
  619. #-----------------------------------------------------------------------------
  620. # Name : TEMPLATENAME
  621. # Datatype : String
  622. # Description : Name of the template
  623. # Valid values : Template name as seen in DBCA
  624. # Default value : None
  625. # Mandatory : Yes
  626. #-----------------------------------------------------------------------------
  627. TEMPLATENAME = "New Database"
  628. #-----------------------------------------------------------------------------
  629. # Name : GDBNAME
  630. # Datatype : String
  631. # Description : Global database name of the database
  632. # Valid values : <db_name>.<db_domain> - when database domain isn't NULL
  633. # <db_name> - when database domain is NULL
  634. # Default value : None
  635. # Mandatory : Yes
  636. #-----------------------------------------------------------------------------
  637. GDBNAME = "orcl11.us.oracle.com"
  638. #-----------------------------------------------------------------------------
  639. # Name : SCRIPTDESTINATION
  640. # Datatype : String
  641. # Description : Location of the scripts
  642. # Valid values : Directory for all the scripts
  643. # Default value : None
  644. # Mandatory : No
  645. #-----------------------------------------------------------------------------
  646. #SCRIPTDESTINATION =
  647. #-----------------------*** End of deleteDatabase section ***------------------------
  648. #-----------------------------------------------------------------------------
  649. # CONFIGUREDATABASE section is used when OPERATION_TYPE is defined as "configureDatabase".
  650. #-----------------------------------------------------------------------------
  651. [CONFIGUREDATABASE]
  652. #-----------------------------------------------------------------------------
  653. # Name : SOURCEDB
  654. # Datatype : String
  655. # Description : The source database is the SID
  656. # This database must be local and on the same ORACLE_HOME.
  657. # Default value : none
  658. # Mandatory : YES
  659. #-----------------------------------------------------------------------------
  660. #SOURCEDB = "orcl"
  661. #-----------------------------------------------------------------------------
  662. # Name : SYSDBAUSERNAME
  663. # Datatype : String
  664. # Description : A user with DBA role.
  665. # Default value : none
  666. # Mandatory : YES, if no OS authentication
  667. #-----------------------------------------------------------------------------
  668. #SYSDBAUSERNAME = "sys"
  669. #-----------------------------------------------------------------------------
  670. # Name : SYSDBAPASSWORD
  671. # Datatype : String
  672. # Description : The password of the DBA user.
  673. # You can also specify the password at the command prompt instead of here.
  674. # Default value : none
  675. # Mandatory : YES, if no OS authentication
  676. #-----------------------------------------------------------------------------
  677. #SYSDBAPASSWORD =
  678. #-----------------------------------------------------------------------------
  679. # Name : REGISTERWITHDIRSERVICE
  680. # Datatype : Boolean
  681. # Description : Specifies whether to register with Directory Service.
  682. # Valid values : TRUE \ FALSE
  683. # Default value : FALSE
  684. # Mandatory : No
  685. #-----------------------------------------------------------------------------
  686. #REGISTERWITHDIRSERVICE= TRUE
  687. #-----------------------------------------------------------------------------
  688. # Name : UNREGISTERWITHDIRSERVICE
  689. # Datatype : Boolean
  690. # Description : Specifies whether to unregister with Directory Service.
  691. # Valid values : TRUE \ FALSE
  692. # Default value : FALSE
  693. # Mandatory : No
  694. #-----------------------------------------------------------------------------
  695. #UNREGISTERWITHDIRSERVICE= TRUE
  696. #-----------------------------------------------------------------------------
  697. # Name : REGENERATEDBPASSWORD
  698. # Datatype : Boolean
  699. # Description : Specifies whether regenerate database password in OID/Wallet
  700. # Valid values : TRUE \ FALSE
  701. # Default value : FALSE
  702. # Mandatory : No
  703. #-----------------------------------------------------------------------------
  704. #REGENERATEDBPASSWORD= TRUE
  705. #-----------------------------------------------------------------------------
  706. # Name : DIRSERVICEUSERNAME
  707. # Datatype : String
  708. # Description : Specifies the name of the directory service user
  709. # Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified
  710. #-----------------------------------------------------------------------------
  711. #DIRSERVICEUSERNAME= "name"
  712. #-----------------------------------------------------------------------------
  713. # Name : DIRSERVICEPASSWORD
  714. # Datatype : String
  715. # Description : The password of the directory service user.
  716. # You can also specify the password at the command prompt instead of here.
  717. # Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified
  718. #-----------------------------------------------------------------------------
  719. #DIRSERVICEPASSWORD= "password"
  720. #-----------------------------------------------------------------------------
  721. # Name : WALLETPASSWORD
  722. # Datatype : String
  723. # Description : The password for wallet to created or modified.
  724. # You can also specify the password at the command prompt instead of here.
  725. # Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified
  726. #-----------------------------------------------------------------------------
  727. #WALLETPASSWORD= "password"
  728. #-----------------------------------------------------------------------------
  729. # Name : DISABLESECURITYCONFIGURATION
  730. # Datatype : String
  731. # Description : Database Security Settings
  732. # Valid values : ALL|NONE|AUDIT|PASSWORD_PROFILE
  733. # Default value : NONE
  734. # Mandatory : No
  735. #-----------------------------------------------------------------------------
  736. #DISABLESECURITYCONFIGURATION = "NONE"
  737. #-----------------------------------------------------------------------------
  738. # Name : ENABLESECURITYCONFIGURATION
  739. # Datatype : String
  740. # Description : Database Security Settings
  741. # Valid values : true|false
  742. # Default value : true
  743. # Mandatory : No
  744. #-----------------------------------------------------------------------------
  745. #ENABLESECURITYCONFIGURATION = "true"
  746. #-----------------------------------------------------------------------------
  747. # Name : EMCONFIGURATION
  748. # Datatype : String
  749. # Description : Enterprise Manager Configuration Type
  750. # Valid values : CENTRAL|LOCAL|ALL|NONE
  751. # Default value : NONE
  752. # Mandatory : No
  753. #-----------------------------------------------------------------------------
  754. #EMCONFIGURATION = "NONE"
  755. #-----------------------------------------------------------------------------
  756. # Name : SYSMANPASSWORD
  757. # Datatype : String
  758. # Description : Password for SYSMAN user
  759. # Valid values : Check Oracle11g Administrator's Guide
  760. # Default value : None
  761. # Mandatory : Yes, if LOCAL specified for EMCONFIGURATION
  762. #-----------------------------------------------------------------------------
  763. #SYSMANPASSWORD = "password"
  764. #-----------------------------------------------------------------------------
  765. # Name : DBSNMPPASSWORD
  766. # Datatype : String
  767. # Description : Password for DBSNMP user
  768. # Valid values : Check Oracle11g Administrator's Guide
  769. # Default value : None
  770. # Mandatory : Yes, if EMCONFIGURATION is specified
  771. #-----------------------------------------------------------------------------
  772. #DBSNMPPASSWORD = "password"
  773. #-----------------------------------------------------------------------------
  774. # Name : CENTRALAGENT
  775. # Datatype : String
  776. # Description : Grid Control Central Agent Oracle Home
  777. # Default value : None
  778. # Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION
  779. #-----------------------------------------------------------------------------
  780. #CENTRALAGENT =
  781. #-----------------------------------------------------------------------------
  782. # Name : HOSTUSERNAME
  783. # Datatype : String
  784. # Description : Host user name for EM backup job
  785. # Default value : None
  786. # Mandatory : Yes, if ALL is specified for EMCONFIGURATION
  787. #-----------------------------------------------------------------------------
  788. #HOSTUSERNAME =
  789. #-----------------------------------------------------------------------------
  790. # Name : HOSTUSERPASSWORD
  791. # Datatype : String
  792. # Description : Host user password for EM backup job
  793. # Default value : None
  794. # Mandatory : Yes, if ALL is specified for EMCONFIGURATION
  795. #-----------------------------------------------------------------------------
  796. #HOSTUSERPASSWORD=
  797. #-----------------------------------------------------------------------------
  798. # Name : BACKUPSCHEDULE
  799. # Datatype : String
  800. # Description : Daily backup schedule in the form of hh:mm
  801. # Default value : 2:00
  802. # Mandatory : Yes, if ALL is specified for EMCONFIGURATION
  803. #-----------------------------------------------------------------------------
  804. #BACKUPSCHEDULE=
  805. #-----------------------*** End of CONFIGUREDATABASE section ***------------------------
  806. #-----------------------------------------------------------------------------
  807. # ADDINSTANCE section is used when OPERATION_TYPE is defined as "addInstance".
  808. #-----------------------------------------------------------------------------
  809. [ADDINSTANCE]
  810. #-----------------------------------------------------------------------------
  811. # Name : DB_UNIQUE_NAME
  812. # Datatype : String
  813. # Description : DB Unique Name of the RAC database
  814. # Valid values : <db_unique_name>
  815. # Default value : None
  816. # Mandatory : Yes
  817. #-----------------------------------------------------------------------------
  818. DB_UNIQUE_NAME = "orcl11g.us.oracle.com"
  819. #-----------------------------------------------------------------------------
  820. # Name : INSTANCENAME
  821. # Datatype : String
  822. # Description : RAC instance name to be added
  823. # Valid values : Check Oracle11g Administrator's Guide
  824. # Default value : <sid_prefix>+<highest_current_thread+1>
  825. # Mandatory : No
  826. #-----------------------------------------------------------------------------
  827. #INSTANCENAME = "orcl1"
  828. #-----------------------------------------------------------------------------
  829. # Name : NODELIST
  830. # Datatype : String
  831. # Description : Node on which to add new instance
  832. # (in 10gR2, instance addition is supported on 1 node at a time)
  833. # Valid values : Cluster node name
  834. # Default value : None
  835. # Mandatory : Yes
  836. #-----------------------------------------------------------------------------
  837. NODELIST=
  838. #-----------------------------------------------------------------------------
  839. # Name : OBFUSCATEDPASSWORDS
  840. # Datatype : Boolean
  841. # Description : Set to true if passwords are encrypted
  842. # Valid values : TRUE\FALSE
  843. # Default value : FALSE
  844. # Mandatory : No
  845. #-----------------------------------------------------------------------------
  846. #OBFUSCATEDPASSWORDS = FALSE
  847. #-----------------------------------------------------------------------------
  848. # Name : SYSDBAUSERNAME
  849. # Datatype : String
  850. # Description : A user with DBA role.
  851. # Default value : none
  852. # Mandatory : YES
  853. #-----------------------------------------------------------------------------
  854. SYSDBAUSERNAME = "sys"
  855. #-----------------------------------------------------------------------------
  856. # Name : SYSDBAPASSWORD
  857. # Datatype : String
  858. # Description : The password of the DBA user.
  859. # Default value : none
  860. # Mandatory : YES
  861. #-----------------------------------------------------------------------------
  862. #SYSDBAPASSWORD = "password"
  863. #-----------------------*** End of ADDINSTANCE section ***------------------------
  864. #-----------------------------------------------------------------------------
  865. # DELETEINSTANCE section is used when OPERATION_TYPE is defined as "deleteInstance".
  866. #-----------------------------------------------------------------------------
  867. [DELETEINSTANCE]
  868. #-----------------------------------------------------------------------------
  869. # Name : DB_UNIQUE_NAME
  870. # Datatype : String
  871. # Description : DB Unique Name of the RAC database
  872. # Valid values : <db_unique_name>
  873. # Default value : None
  874. # Mandatory : Yes
  875. #-----------------------------------------------------------------------------
  876. DB_UNIQUE_NAME = "orcl11g.us.oracle.com"
  877. #-----------------------------------------------------------------------------
  878. # Name : INSTANCENAME
  879. # Datatype : String
  880. # Description : RAC instance name to be deleted
  881. # Valid values : Check Oracle11g Administrator's Guide
  882. # Default value : None
  883. # Mandatory : Yes
  884. #-----------------------------------------------------------------------------
  885. INSTANCENAME = "orcl11g"
  886. #-----------------------------------------------------------------------------
  887. # Name : NODELIST
  888. # Datatype : String
  889. # Description : Node on which instance to be deleted (SID) is located
  890. # Valid values : Cluster node name
  891. # Default value : None
  892. # Mandatory : No
  893. #-----------------------------------------------------------------------------
  894. #NODELIST=
  895. #-----------------------------------------------------------------------------
  896. # Name : OBFUSCATEDPASSWORDS
  897. # Datatype : Boolean
  898. # Description : Set to true if passwords are encrypted
  899. # Valid values : TRUE\FALSE
  900. # Default value : FALSE
  901. # Mandatory : No
  902. #-----------------------------------------------------------------------------
  903. #OBFUSCATEDPASSWORDS = FALSE
  904. #-----------------------------------------------------------------------------
  905. # Name : SYSDBAUSERNAME
  906. # Datatype : String
  907. # Description : A user with DBA role.
  908. # Default value : none
  909. # Mandatory : YES
  910. #-----------------------------------------------------------------------------
  911. SYSDBAUSERNAME = "sys"
  912. #-----------------------------------------------------------------------------
  913. # Name : SYSDBAPASSWORD
  914. # Datatype : String
  915. # Description : The password of the DBA user.
  916. # Default value : none
  917. # Mandatory : YES
  918. #-----------------------------------------------------------------------------
  919. #SYSDBAPASSWORD = "password"
  920. #-----------------------*** End of DELETEINSTANCE section ***------------------------