Filter
Top Products
9. Enter the Database alias (for example, Learning2).
10. Click Next.
11. Unselect Register this database for ODBC and click Next.
12. Click Next on Step for Add Database Wizard.
13. Check Configure security options and click Next.
14. Click Finish and test your connection.
15. Repeat for this procedure for the DS and Audit databases.
Oracle database creation for the Learning Management System
In this example, the Learning Management System requires several distinct schemas to operate. There is an LMM
and Audit schema to support LMM on the Learning Management System Server and one schema for each DS
database.
These schemas are logically distinct, and can be located on the same Oracle instance - or different instances. The
database can be located on the application server but for performance and security reasons is usually on a dedicated
database server. This installation involves the following
• editing the scripts for site specific considerations (for example, file placement and size)
• running the scripts
• running scripts that create site-specific seed data (these are called from the schema creation scripts)
Installation requirements
• Client and server should have the same version of Oracle. There are known problems running an Oracle 8i
client (JDBC driver) against an Oracle 9i RDBMS.
• Installed Oracle software.
• Unicode codeset. For multilingual support, a unicode (UTF-8) codeset must be used for database creation.
An example database creation script is included.
• Sufficient disk space and memory.
Database creation details
Oracle instance database creation can be done during the Oracle software GUI installation. Specify the UTF-8
character set during the installation.
If you want to create a database outside of the GUI, example scripts cr_oradb_8i.sql or cr_oradb_9i.sql can be
edited and run to create an Oracle 8i or Oracle 9i database.
Use the following procedures to create the Oracle databases.
Creating a Learning Management System schema
1. Create a user to be the database owner. You can do this by editing the cr_oraown_lmm.sql script and then
running it. (The script actually creates two users: lmm, which designates the database owner, and lmm_app,
which you can ignore.) To run the script from the sqlplus command line, type the following:
sqlplus system/<password>@<database> @cr_oraown_lmm.sql
2. Run the schema creation script for the Learning Management System owner account created in the previous
step as follows. This script will also call the seed data script.
44 IBM Lotus LMS Release 1 Installation Guide