English | English
German | Deutsch
Indonesian | Indonesia
Italian | Italiano
Spanish | Español
Turkish | Türkçe
3.2.4. Installing Oracle Database
IMPORTANT. Oracle Database is not supported when you use a server cluster on E2K processors.
The database server is installed from Oracle Database distribution packages.
Oracle Database versions supported by 1C:Enterprise are published at: http://v8.1c.ru/requirements/http://v8.1c.ru/requirements/.
Installation information is available in the server documentation:
- Oracle Database 10g Release 2: http://download.oracle.com/docs/cd/B19306_01/em.102/b16227/toc.htmhttp://download.oracle.com/docs/cd/B19306_01/em.102/b16227/toc.htm.
- Oracle Database 11g Release 1: http://download.oracle.com/docs/cd/B28359_01/em.111/b31207/toc.htmhttp://download.oracle.com/docs/cd/B28359_01/em.111/b31207/toc.htm.
- Oracle Database 11g Release 2: http://docs.oracle.com/cd/E11882_01/em.112/e12255/toc.htmhttp://docs.oracle.com/cd/E11882_01/em.112/e12255/toc.htm.
- Oracle Database 12с Release 1: http://docs.oracle.com/database/121/nav/portal_11.htmhttp://docs.oracle.com/database/121/nav/portal_11.htm.
The database server in terms of 1C:Enterprise corresponds to the concept of DATABASE in terms of Oracle Database. Database in 1C:Enterprise corresponds to data schema in Oracle Database. When you create an infobase in 1C:Enterprise, an infobase user and their data schema are created in Oracle Database.
1C:Enterprise 8 uses the following tablespaces in Oracle Database operations:
- For data: v81c_data.
- For indexes: V81C_INDEX.
- For LOB: V81C_LOB.
- For temporary files: V81C_TEMP.
If tablespaces with such names exist, they will be used. If not, they will be created along with an infobase and datafiles will have default paths.
The V81_INDEX_BIG tablespace is used for index operations. It is created when index creation resulted in error ORA-01450. If this tablespace already exists, it will be used.
When you create a DATABASE, set the CHARACTER SET parameter to AL32UTF8 for this DATABASE.
Before using the Oracle Database server with 1C:Enterprise, you need to configure multilingual collation for the database server. To do this, follow these steps:
- Copy the lx327c6.nlt file from the Additional\OracleDatabase directory of 1C:Enterprise distribution package to an empty directory on the hard drive of the computer where Oracle Database is installed.
- Run Oracle Locale Builder (lbuilder).
- Start generation of nlb files (Tools – Generate NLB) specifying the folder with the lx327c6.nlt file.
- Stop all Oracle Database services running from the Oracle Database home directory (ORACLE_HOME).
- Create a backup of the lx0boot.nlb and lx1boot.nlb files from the ORACLE_HOME/nls/data folder.
- Copy the lx1boot.nlb and lx327c6.nlb files from the folder where they were created by the Oracle Locale Builder utility to ORACLE_HOME/nls/data. While copying, agree to overwrite the lx1boot.nlb file.
- Start Oracle Database services.