Generate a Database configuration file on Oracle Database Appliance (ODA HA X5-2)

This doc describe how to generate a database configuration file  on Oracle Database Appliance (ODA HA X5-2)

On ODA we use oakcli command line to generate a database configuration file.

1. Execute oakcli create db_config_params command as root user.
2. Select the Database Block Size.
3. Specify the  Database Language.
4. Specify the  Database Characterset.
5. Press Enter key to display more available database charactorset.
6. Specify the  Database Territory.
7. Specify the  Component Language.
8. Select NLS Characterset.
9. Verify the newly created Database Configuration  file.


Check the existing default DB-Config-Patams


[root@ABC1x5-2]# oakcli show db_config_params
The available DB configuration files are :
default


Use oakcli create db_config_params command to generate Database Configuration File.

[root@ABC1x5-2]# oakcli create db_config_params -conf odadbconfig
Please select one of the following for Database Block Size  [1 .. 4] :
1    => 4096
2    => 8192
3    => 16384
4    => 32768
2
The selected value is : 8192

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

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

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


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


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


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


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


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


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


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


Please select one of the following for Database Characterset  [0 .. 98] :
88    => VN8MSWIN1258
89    => VN8VN3
90    => WE8DEC
91    => WE8DG
92    => WE8ISO8859P1
93    => WE8ISO8859P15
94    => WE8ISO8859P9
95    => WE8MACROMAN8S
96    => WE8MSWIN1252
97    => WE8NCR4970
98    => WE8NEXTSTEP


Please select one of the following for Database Characterset  [0 .. 109] :
99    => WE8PC850
100    => WE8PC858
101    => WE8PC860
102    => WE8ROMAN8
103    => ZHS16CGB231280
104    => ZHS16GBK
105    => ZHT16BIG5
106    => ZHT16CCDC
107    => ZHT16DBT
108    => ZHT16HKSCS
109    => ZHT16MSWIN950


Please select one of the following for Database Characterset  [1 .. 113] :
110    => ZHT32EUC
111    => ZHT32SOPS
112    => ZHT32TRIS
113    => US7ASCII

'' is not within the range. Please provide the input again : 1
The selected value is : AL32UTF8

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

Please select one of the following for Database Territory [0 .. 10] :
0    => Others
1    => ALBANIA
2    => ALGERIA
3    => AMERICA
4    => ARGENTINA
5    => AUSTRALIA
6    => AUSTRIA
7    => AZERBAIJAN
8    => BAHRAIN
9    => BANGLADESH
10    => BELARUS


Please select one of the following for Database Territory  [0 .. 21] :
11    => BELGIUM
12    => BRAZIL
13    => BULGARIA
14    => CANADA
15    => CATALONIA
16    => CHILE
17    => CHINA
18    => COLOMBIA
19    => COSTA RICA
20    => CROATIA
21    => CYPRUS
1
The selected value is : ALBANIA

Specify the  Component Language (1. en 2. Others) [1] : 1
The selected value is : en
Please select one of the following for NLS Characterset  [1 .. 2] :
1    => AL16UTF16
2    => UTF8
1
The selected value is : AL16UTF16

Successfully generated the Database parameter file 'odadbconfig'


Verify the newly created Database Configuration  file.

[root@ABC1x5-2]# oakcli show db_config_params
The available DB configuration files are :
odadbconfig
default

Cheers!!!