S2: Creating the databases

The databases are created using the SQL scripts supplied with the Lotus Connections installation files. All SQL scripts are located in the Lotus_Connections_Install/connections.sql//oracle folder. You must run these scripts on the Oracle machine from the Oracle SQLplus command line processor.

The following figure displays information created for this database, such as ORACLE_SID, Schema, and User. It is worth noting that the schema names listed below cannot be changed. while the database application user can be named as required with the exception of HOMEPAGEUSER and BLOGSUSER which cannot changed.

Copy the SQL scripts to a convenient location on the Oracle server (/software/LC25/connections.sql).

To create the databases, follow these steps from within the terminal on the Oracle machine:

If required, set ORACLE_HOME using the following command:
export ORACLE_HOME=/opt/oracle/10gR2
There are a number of SQL commands that must be run to create each database on each instance of Oracle. The following steps describe this process for the Activities database. It is important to note that you must repeat these steps for each database.

Set the ORACLE_SID to that of the instance on which you want to create the database:
export ORACLE_SID=activities
From the Oracle bin directory (/opt/oracle/10gR2/bin), run the SQLplus command as follows:
./sqlplus /NOLOG
Log in as the administrative user. You are prompted for these credentials when you enter the following command:
connect as sysdba
After you log in, you can run the SQL scripts using the following commands:

@/software/LC25/connections.sql/activities/oracle/createDb.sql

The @ symbol allows Oracle to run the SQL commands from a file. You must provide the password argument. This password is used for the Oracle user, that is created by these scripts for each database (as listed in the figure above). If you do not provide the password argument, you are prompted for it during database creation. After running this script, you should run the following script to grant access privileges for this feature:

@/software/LC25/connections.sql/activities/oracle/appGrants.sql

You must run both scripts for all eight databases to be created. It is important to remember to change the ORACLE_SID as required to make changes on the correct Oracle instance.

To run this script for each component, simply change the “/activities/” section of the command to that of the component that you want to create databases (for example, “/communities/” or “/wikis/”).

After these scripts are run for each feature, the databases are created for each feature. To complete this process, you must run additional SQL scripts. These are as follows:

@/software/LC25/connections.sql/homepage/oracle/initData.sql

@/software/LC25/connections.sql/dogear/oracle/createHistogramStatsJob.sql

@/software/LC25/connections.sql/communities/oracle/createDb_forum.sql
@/software/LC25/connections.sql/communities/appGrants_forum.sql

Remember to start SQLplus with the correct ORACLE SID to run each of these commands (homepage, dogear and communities respectively).