Creation of a new database in DBMS Oracle

Before placing the geo database ArcSDE in the database Oracle, you must create this database.

This item contains a description for the sequence of actions to create the database Oracle and a description of the parameters that must be installed in the database.

Creation of a new Oracle database is performed by the regular means of DBMS Oracle in the following sequence.

1)  Run the configuration tool of databases – «Database Configuration Assistant». Select «Create of Database», go to the next window (click on «Next»).

2)  In the following form select a template to create the database, leave the default option «General Purpose of Transactional Processing».

3)  Next you need to specify «Global Database Name» and «SID» (System identifier) for the newly created database. It is proposed to specify meaningful values. For example, to export layers DTM of scale 1: 25,000 from format GIS Panorama to the geo database ArcSDE proposed name VN25PAN.

4)  In the window «Configure Enterprise Manager», it is recommended to remain the options offered by default, that is, remain the option «Configure Enterprise Manager» enabled with the mode «Configure Database Control for local management».

5)  At the fifth stage of the database creation, it is suggested to specify the administrative passwords of system users. You must either specify a unique password for each of them, or assign one common password to everyone (as shown in the figure). The entered password(s) must be remembered.

6)  If you select the storage option to host the database files, you must select the storage type – the file system «File System». The location of the files is either left by default (in this case, the paths to the files are taken from the server settings), or to specify a specific location with the directory specified («Use Common Location for All Database Files»).

7)  In step 7, the configuration of the database recovery is configured. It is recommended to remain the default values (see the figure).

8)  The eighth step proposes to provide additional filling of the created database. Additional filling of the database does not apply

9)  At the 9th stage in the dialog «Initialization Parameters» it is mandatory to specify encoding «Use Unicode (AL32UTF8)» on the tab «Character Sets». Otherwise, there may be problems with recording and reading values in national languages that require multi-byte character encoding (for example, in Vietnamese). In addition, on the tab «Connection Mode», set the connection mode «Dedicated Server Mode». It is recommended to remain the remaining parameters as default.

10)  At the tenth step, the dialog will prompt you to configure the data store for the database in more detail. If necessary, make the appropriate settings, otherwise remain the default values.

11)  In the window «Creation Options», select the required action – creating a database («Create Database»).

When you click on the button «Finish», the process of creating a database will begin. The progress will be displayed on the screen.

When the database creation process is complete, a corresponding message will be displayed on the screen. In this dialog, if necessary, you can change the previously set passwords for embedded registry records. If such operation is required, click the button «Password Management…». To exit, press the button «Exit».