Uncategorized
Oracle Database Appliance Database Configuration Parameter file
When you create a database on Oracle Database Appliance (ODA) it uses a ‘default’ database configuration file which consists of a default parameters.
The default database configuration file uses the following parameters:
[root@odanode1 ~]# oakcli show db_config_params
The available DB configuration files are :
default
[root@odanode1 ~]# oakcli show db_config_params -conf default -detail
DATABASE_BLOCK_SIZE => 8192
DATABASE_LANGUAGE => AMERICAN
DATABASE_CHARACTERSET => AL32UTF8
DATABASE_TERRITORY => AMERICA
COMPONENT_LANGUAGES => en
NLS_NCHAR_CHARACTERSET => AL16UTF16
If you want to create a database with different database configuration parameter then you must create a database configuration file with your desired parameters. You can use the ‘oakcli create db_config_params’ command to create a database configuration file. The configuration files are created under the locatoin ‘/opt/oracle/oak/install/dbconf’ with a default extension of ‘.dbconf’.
In this article we will demonstrate how to create a database configuration file.
Steps to generate/create a database configuration file
Step 1: List the Database Configuration files
[root@odanode1 ~]# oakcli show db_config_params
The available DB configuration files are :
default
Step 2: Create Database Configuration file
[root@odanode1 dumpfiles]# oakcli create db_config_params -conf newdbconf
Please select one of the following for Database Block Size [1 .. 4] :
1 => 4096
2 => 8192
3 => 16384
4 => 32768
2 –> Enter the value. Here I entered 2 for 8k block size
The selected value is : 8192
Specify the Database Language (1. AMERICAN 2. Others) [1] : 1 –> Here I entered 1 for AMERICAN database language
The selected value is : AMERICAN
Specify the Database Characterset (1. AL32UTF8 2. Others) [1] : 2 –> Enter 2 for Other Characterset
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
<<Hit enter to display more characterset>>
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
<<Hit enter to display more characterset>>
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
<<Hit enter to display more characterset>>
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
<<Hit enter to display more characterset>>
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
<<Hit enter to display more characterset>>
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
<<Hit enter to display more characterset>>
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
<<Hit enter to display more characterset>>
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
<<Hit enter to display more characterset>>
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
96 –> Enter 96 to select WE8MSWIN1252 as characterset
The selected value is : WE8MSWIN1252
Specify the Database Territory (1. AMERICA 2. Others) [1] : –> Here I entered 1 for AMERICA database Territory
The selected value is : AMERICA
Specify the Component Language (1. en 2. Others) [1] : –> Here I entered 1 for en Component Language
The selected value is : en
Please select one of the following for NLS Characterset [1 .. 2] :
1 => AL16UTF16
2 => UTF8
1 –> Here I entered 1 for AL16UTF16 NLS Characterset
The selected value is : AL16UTF16
Successfully generated the Database parameter file ‘newdbconf’
Step 3: Verify the configuration file is created
[root@odanode1 ~]# oakcli show db_config_params
The available DB configuration files are :
newdbconf
default
Step 4: List the parameters for newly created configuration file
[root@odanode1 ~]# oakcli show db_config_params -conf newdbconf -detail
DATABASE_BLOCK_SIZE => 8192
DATABASE_LANGUAGE => AMERICAN
DATABASE_CHARACTERSET => WE8MSWIN1252
DATABASE_TERRITORY => AMERICA
COMPONENT_LANGUAGES => en
NLS_NCHAR_CHARACTERSET => AL16UTF16
Conclusion
In this article we have learned how to create a database configuration file with the desired parameters. The Default database configuration file parameters may not be applicable for all the databases. You can use the ‘oakcli create db_config_params’ command to create a database configuration file.
The default database configuration file uses the following parameters:
[root@odanode1 ~]# oakcli show db_config_params
The available DB configuration files are :
default
[root@odanode1 ~]# oakcli show db_config_params -conf default -detail
DATABASE_BLOCK_SIZE => 8192
DATABASE_LANGUAGE => AMERICAN
DATABASE_CHARACTERSET => AL32UTF8
DATABASE_TERRITORY => AMERICA
COMPONENT_LANGUAGES => en
NLS_NCHAR_CHARACTERSET => AL16UTF16
If you want to create a database with different database configuration parameter then you must create a database configuration file with your desired parameters. You can use the ‘oakcli create db_config_params’ command to create a database configuration file. The configuration files are created under the locatoin ‘/opt/oracle/oak/install/dbconf’ with a default extension of ‘.dbconf’.
In this article we will demonstrate how to create a database configuration file.
Steps to generate/create a database configuration file
Step 1: List the Database Configuration files
[root@odanode1 ~]# oakcli show db_config_params
The available DB configuration files are :
default
Step 2: Create Database Configuration file
[root@odanode1 dumpfiles]# oakcli create db_config_params -conf newdbconf
Please select one of the following for Database Block Size [1 .. 4] :
1 => 4096
2 => 8192
3 => 16384
4 => 32768
2 –> Enter the value. Here I entered 2 for 8k block size
The selected value is : 8192
Specify the Database Language (1. AMERICAN 2. Others) [1] : 1 –> Here I entered 1 for AMERICAN database language
The selected value is : AMERICAN
Specify the Database Characterset (1. AL32UTF8 2. Others) [1] : 2 –> Enter 2 for Other Characterset
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
<<Hit enter to display more characterset>>
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
<<Hit enter to display more characterset>>
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
<<Hit enter to display more characterset>>
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
<<Hit enter to display more characterset>>
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
<<Hit enter to display more characterset>>
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
<<Hit enter to display more characterset>>
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
<<Hit enter to display more characterset>>
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
<<Hit enter to display more characterset>>
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
96 –> Enter 96 to select WE8MSWIN1252 as characterset
The selected value is : WE8MSWIN1252
Specify the Database Territory (1. AMERICA 2. Others) [1] : –> Here I entered 1 for AMERICA database Territory
The selected value is : AMERICA
Specify the Component Language (1. en 2. Others) [1] : –> Here I entered 1 for en Component Language
The selected value is : en
Please select one of the following for NLS Characterset [1 .. 2] :
1 => AL16UTF16
2 => UTF8
1 –> Here I entered 1 for AL16UTF16 NLS Characterset
The selected value is : AL16UTF16
Successfully generated the Database parameter file ‘newdbconf’
Step 3: Verify the configuration file is created
[root@odanode1 ~]# oakcli show db_config_params
The available DB configuration files are :
newdbconf
default
Step 4: List the parameters for newly created configuration file
[root@odanode1 ~]# oakcli show db_config_params -conf newdbconf -detail
DATABASE_BLOCK_SIZE => 8192
DATABASE_LANGUAGE => AMERICAN
DATABASE_CHARACTERSET => WE8MSWIN1252
DATABASE_TERRITORY => AMERICA
COMPONENT_LANGUAGES => en
NLS_NCHAR_CHARACTERSET => AL16UTF16
Conclusion
In this article we have learned how to create a database configuration file with the desired parameters. The Default database configuration file parameters may not be applicable for all the databases. You can use the ‘oakcli create db_config_params’ command to create a database configuration file.