Filter
Top Products
sqlplus lmm/lmm@<database> @lmm_oracle.sql
Creating an Audit schema
1. Create a user to be the database owner. You can do this by editing the cr_oraown_aud.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_aud.sql
2. Run the schema creation script for the Learning Management System owner account created in the previous
step. This script will also call the seed data script.
sqlplus aud/aud@<database> @audit_oracle.sql
Creating the DS schema(s)
1. Create a user to be the database owner. You can do this by editing the cr_oraown_ds.sql script for file 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 command line sqlplus, type:
sqlplus system/<password>@<database> @cr_oraown_ds.sql
2. Run the schema creation script for the Learning Management System owner account created in the previous
step.
sqlplus ds/ds@<database> @ds_oracle.sql
JDBC driver information
Make sure that you install the same version of Oracle client software on the application server as that which was
installed on the database server (for example, 9i database = 9i client). This will install Oracle’s thin JDBC driver,
which is used in the examples for configuring WAS.
MS SQL Server database creation for the Learning Management System
There is a Learning and Audit schema to support the Learning Management System on the Learning Management
System Server and one schema for each DS database. These databases are logically distinct, and can be located on
the same SQL Server instance, or different instances.
The database can be located on the application server, but for performance and security reasons are usually will 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 a script that creates site specific seed data
Installation requirements
• Installed and running MS SQL Server instance.
• MS SQL Server client installed on the machine from which Install is run.
• Sufficient disk space and memory.
Database creation details
Use the following procedure for creating the databases. Observe the following when running the scripts from the
command line:
Chapter 9: Installing and Configuring Database Servers and Schema 45