| Oracle® Retail Advanced Inventory Planning Installation Guide Release 14.1.2 E70815-01 |
|
 Previous |
 Next |
| Oracle® Retail Advanced Inventory Planning Installation Guide Release 14.1.2 E70815-01 |
|
Previous |
Next |
This appendix provides information on database requirements and sample database scripts.
At the physical database level, the following two conditions must be met in order to be Release 14.1.2 compatible:
Characterset
The characterset must be AL32UTF8.
Tablespaces
Rename the tablespace RETEK_DATA to RETAIL_DATA and rename the tablespace RETEK_INDEX to RETAIL_INDEX.
|
Note: Releases 14.0 and later no longer use tablespaces RETEK_DATA and RETEK_INDEX and they should be renamed to RETAIL_DATA and RETAIL_INDEX. It is absolutely essential that a complete backup has been taken before performing this task. |
This section provides information to create the database instance using the Oracle generic template; including:
The following prerequisites are required before creating the database instance:
Oracle 12c Enterprise Edition Release 1 (version 12.1.0.2) must already be installed along with the appropriate one-off hotfixes. Refer to One-off Patches for all the required one-off hotfixes.
Oracle Retail no longer delivers custom database template files. Instead, databases can be created using the Oracle-delivered generic template file in the directory: $ORACLE_HOME/assistant/dbca/template.
$ORACLE_HOME/assistantsdbca/templates>
--> ls -l General_Purpose.dbc
-rw-r--r-- 1 oracle rgbudba 4908 May 24 2013 General_Purpose.dbc
Perform the following steps to create the database instance using the Oracle-delivered generic template.
Ensure ORACLE_HOME and ORACLE_BASE is in the path:
export ORACLE_HOME=<Location for Oracle Home >
export ORACLE_BASE=<Location for Oracle Base>
export PATH=$ORACLE_HOME/bin:$PATH
.cd into $ORACLE_HOME/assistants/dbca/templates
Run the following command to create an instance:
$ORACLE_HOME/bin/dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName DB_NAME -sid DB_SID -createAsContainerDatabase true -SysPassword oracle1 -SystemPassword oracle1 -emConfiguration NONE -datafileDestination <Datafile Location> -characterSet AL32UTF8 -nationalCharacterSet AL16UTF16 -redoLogFileSize 100 -initParams nls_date_format=DD-MON-RR,nls_language=AMERICAN,nls_calendar=GREGORIAN,fast_start_mttr_target=900
|
Note: This command creates a container database using all the default parameters set by DBCA.Replace the pfile with a copy from To create a non-container database, replace |
Run the following command to create a pluggable database if this is a container environment:
CREATE PLUGGABLE DATABASE PDB_NAME ADMIN USER PDBADMIN IDENTIFIED BY pdbadmin_pwd ROLES=(CONNECT) file_name_convert=('<Old Locationof PDB Datafiles>','<New Location for PDB Datafiles>');alter pluggable database pdb_name open;alter system register;
Post Database Creation Setup.
The previous commands create a database with all files in one directory. Multiplex the redo logs and the control files following the OFA architecture.
Configure the listener and the tnsnames entry.
Log into the pluggable database to create the required tablespaces accordingly. For non-container databases, log into the database as normal to create the tablespaces.
The following code provides a sample parameter file. The commented code provides instructions about making the necessary modifications for your environment.
############################################################################## # Copyright (c) 2014 by Oracle Corporation # Oracle 12.1.0.x Parameter file # NOTES: Before using this script: # 1. Change <datafile_path>, <admin_path>, <utl_file_path>, <diag_path> and <hostname> # values as appropriate. # 2. Replace the word SID with the database name. # 3. Size parameters as necessary for development, test, and production environments. # ------------------------------------------------------------------------ *.audit_file_dest=full_path_of_audit_dir *.audit_trail='db' *.compatible='12.1.0.2.0' *.control_files='full_path_of_controlfile_1','full_path_of_controlfile_2' ########################################### # Memory Settings: # xxxM = Some reasonable starting value for your environment. ########################################### *.db_block_size=xxxM *.db_cache_size=xxxM *.java_pool_size=xxxM *.memory_target=xxxM *.pga_aggregate_target=xxxM *.shared_pool_size=xxxM *.streams_pool_size=xxxM ########################################### *.db_block_size=8192 *.db_domain='' *.db_name='dbName' *.diagnostic_dest='full_path_of_diag_dir' *.enable_pluggable_database=true|false *.fast_start_mttr_target=900 *.nls_calendar='GREGORIAN' *.nls_date_format='DD-MON-RR' *.nls_language='AMERICAN' *.nls_numeric_characters='.,' *.nls_sort=BINARY *.open_cursors=900 *.os_authent_prefix='' *.plsql_optimize_level=2 *.processes=2000 *.query_rewrite_enabled='true' *.remote_dependencies_mode='SIGNATURE' *.remote_login_passwordfile='EXCLUSIVE' *.remote_os_authent=true *.sec_case_sensitive_logon=false *.undo_tablespace='UNDOTBS1'
The tablespaces displayed in the following code example are required.
|
Note: Oracle Retail recommends the use of locally managed tablespaces with auto segment space management. |
Execute as: sysdba
Modify file paths and ORACLE_SID for your environment.
CREATE TABLESPACE RETAIL_INDEX DATAFILE
'/u01/oradata/$ORACLE_SID/retail_index01.dbf' SIZE 500M
AUTOEXTEND ON NEXT 100M MAXSIZE 2000M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
CREATE TABLESPACE RETAIL_DATA DATAFILE
'/u01/oradata/$ORACLE_SID/retail_data01.dbf' SIZE 500M
AUTOEXTEND ON NEXT 100M MAXSIZE 2000M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
CREATE TABLESPACE LOB_DATA DATAFILE
'/u01/oradata/$ORACLE_SID/lob_data01.dbf' SIZE 500M
AUTOEXTEND ON NEXT 100M MAXSIZE 2000M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
