Installation of Genesys 8.5 Configuration DB on Oracle

Summary

This post discusses deployment of the Genesys Config DB on to an existing Oracle 11g instance.

Implementation

• The Config Server installation includes directory of SQL scripts for various RDMS flavors.  The included Oracle scripts below:

ls sql_scripts/oracle
CfgLocale_ora.sql  drop_tables_ora.sql  init_multi_multilang_ora.sql  init_multi_ora.sql

• Installation of these scripts requires use of the Oracle command line tool, sqlplus.  That tool is located in the /u01/app/oracle/product/11.2.0/xe/bin directory.  Adding this directory to your PATH can be accomplished via execution of the included environment script in the same directory. This can also be added to your .bashrc script to automatically get the Oracle environment set up on login

. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh

• The individual SQL scripts can now be executed from the sqlplus command line.  Example below. Assumes the command is being executed from the scripts directory.

sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on Tue Dec 19 11:39:15 2017

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Enter user-name: yourusername
Enter password: yourpassword

Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL> @drop_tables_ora.sql

• An alternative to executing each of the 3 scripts separately is the one-liner below:

(echo @init_multi_ora.sql; echo @CfgLocale_ora.sql) | sqlplus yourusername/yourpassword @drop_tables_ora.sql

Copyright ©1993-2024 Joey E Whelan, All rights reserved.