Thursday, 3 May 2018

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.

No comments:

Post a Comment

Oracle Transparent Data Encryption (TDE) On Exadata

Oracle Transparent Data Encryption (TDE) enables the organizations to encrypt sensitive application data on storage media completely transp...