Monday, June 1, 2015

[ODA] How to create a database in Oracle Database Appliance on an existing Oracle Home


Is not the same… there are different opinions about creating databases in ODA (Oracle Database Appliance). There are Team oackli and Team DBCA. Regarding ODA, I'm totally supporting Team oackli.

As far as I read, when you create databases in ODA with DBCA tool, some "hidden parameters"  are not set in the parameter file of your database (for me this is an urban legend, but let's believe it for this time). So the guide recommends you create your database with the oackli tool. (very ODA)


First let’s create a parameter file, from root execute the following syntax:

[root@my-oda1 ~]# oakcli create db_config_params -conf odadb17
Please select one of the following for Database Block Size  [1 .. 4]:
1    => 4096
2    => 8192
3    => 16384
4    => 32768
2
Selected value is: 8192

Specify the  Database Language (1. AMERICAN 2. Others) [1]:1
Selected value is: AMERICAN

Specify the  Database Characterset (1. AL32UTF8 2. Others) [1]:2


If you need another character set different than AL32UTF8, you will need to enter “0” until you find the number that match the character set that you need, in my case I needed WE8ISO8859P1, which number is 95 (from 116 Characterset). Fact, you need to choose the number characterset in the range given by the tool to avoid this error:


'95' is out of range: Please provide the input again:
So it begins the questions:

Please select one of the following for Database Characterset    [0 .. 10] :
0    => Others
1    => AL32UTF8
2    => AR8ADOS710
3    => AR8ADOS710T
4    => AR8ADOS720
5    => AR8ADOS720T
6    => AR8APTEC715
7    => AR8APTEC715T
8    => AR8ARABICMACS
9    => AR8ASMO708PLUS
10    => AR8ASMO8X
0

Please select one of the following for Database Characterset    [0 .. 21] :
11    => AR8HPARABIC8T
12    => AR8ISO8859P6
13    => AR8MSWIN1256
14    => AR8MUSSAD768
15    => AR8MUSSAD768T
16    => AR8NAFITHA711
17    => AR8NAFITHA711T
18    => AR8NAFITHA721
19    => AR8NAFITHA721T
20    => AR8SAKHR706
21    => AR8SAKHR707
0

Please select one of the following for Database Characterset    [0 .. 32] :
22    => AR8SAKHR707T
23    => AZ8ISO8859P9E
24    => BG8MSWIN
25    => BG8PC437S
26    => BLT8CP921
27    => BLT8ISO8859P13
28    => BLT8MSWIN1257
29    => BLT8PC775
30    => BN8BSCII
31    => CDN8PC863
32    => CEL8ISO8859P14
0

Please select one of the following for Database Characterset    [0 .. 43] :
33    => CL8ISO8859P5
34    => CL8ISOIR111
35    => CL8KOI8R
36    => CL8KOI8U
37    => CL8MACCYRILLICS
38    => CL8MSWIN1251
39    => EE8ISO8859P2
40    => EE8MACCES
41    => EE8MACCROATIANS
42    => EE8MSWIN1250
43    => EE8PC852
0

Please select one of the following for Database Characterset    [0 .. 54] :
44    => EL8DEC
45    => EL8ISO8859P7
46    => EL8MACGREEKS
47    => EL8MSWIN1253
48    => EL8PC437S
49    => EL8PC851
50    => EL8PC869
51    => ET8MSWIN923
52    => HU8ABMOD
53    => HU8CWI2
54    => IN8ISCII
0

Please select one of the following for Database Characterset    [0 .. 65] :
55    => IS8PC861
56    => IW8ISO8859P8
57    => IW8MACHEBREWS
58    => IW8MSWIN1255
59    => IW8PC1507
60    => JA16EUC
61    => JA16EUCTILDE
62    => JA16SJIS
63    => JA16SJISTILDE
64    => JA16VMS
65    => KO16KSC5601
0

Please select one of the following for Database Characterset    [0 .. 76] :
66    => KO16KSCCS
67    => KO16MSWIN949
68    => LA8ISO6937
69    => LA8PASSPORT
70    => LT8MSWIN921
71    => LT8PC772
72    => LT8PC774
73    => LV8PC1117
74    => LV8PC8LR
75    => LV8RST104090
76    => N8PC865
0

Please select one of the following for Database Characterset    [0 .. 87] :
77    => NE8ISO8859P10
78    => NEE8ISO8859P4
79    => RU8BESTA
80    => RU8PC855
81    => RU8PC866
82    => SE8ISO8859P3
83    => TH8MACTHAIS
84    => TH8TISASCII
85    => TR8DEC
86    => TR8MACTURKISHS
87    => TR8MSWIN1254
0

Please select one of the following for Database Characterset    [0 .. 98] :
88    => TR8PC857
89    => US8PC437
90    => UTF8
91    => VN8MSWIN1258
92    => VN8VN3
93    => WE8DEC
94    => WE8DG
95    => WE8ISO8859P1
96    => WE8ISO8859P15
97    => WE8ISO8859P9
98    => WE8MACROMAN8S
95
Selected value is: WE8ISO8859P1


Specify the  Database Territory (1. AMERICA 2. Others) [1]:
Selected value is: AMERICA

Specify the  Component Language (1. en 2. Others) [1]:
Selected value is: en

Finally you will receive the next message:

Successfully generated the Database parameter file 'odadb17.out'

Where is the parameter file I just created?

[root@my-oda1 /]# cd /opt/oracle/oak/install/dbconf/
[root@
my-oda1 dbconf]# ls -l
total 8
-rw-rw-rw- 1 root root 102 Aug 12 17:13 odadb17.dbconf


Now, let’s create our database (if you don’t remember your Oracle Home name you can check on your inventory.xml under your ../oraInventory/ContentXML  directory) 

oakcli create database -db test -oh OraDb11204 -params odadb17.dbconf


After this you will have your database. Hope this helps.