Home
Create Oracle databases manually
Create Oracle databases with SQL scripts instead of using the Lotus Connections database wizard.
Follow this procedure if you do not want to use the database wizard to create your databases.
You must specify the Unicode AL32UTF8 character set.
This task describes how to use SQL scripts to create Oracle databases for Lotus Connections features. Complete this task only if you do not want to use the database wizard. To manually create the feature database tables...
- Log in with the same user ID that you used to install the Oracle database system.
- Copy the Lotus Connections SQL scripts for creating databases to the Oracle system. The SQL scripts are located in the Lotus_Connections_Install on the installation media:
- AIX or Linux
/Lotus_Connections_Install/connections.sql/<feature_subdirectory>/oracle
- Microsoft Windows
\Lotus_Connections_Install\connections.sql\<feature_subdirectory>\oracle
where <feature_subdirectory> is the directory that contains the SQL scripts for each feature. Choose from the following subdirectories:
- activities
- blogs
- communities
- dogear
- files
- homepage
- profiles
- wikis
- Create an Oracle user ID with system database administrator privileges that you can use to manage the database tables. Alternatively, use an existing ID that has administrative privileges, such as sys.
- Set the ORACLE_SID.
If you created multiple databases, specify the database on which to install the tables by providing the SID for that database.
- Run SQL Plus by entering the following command:
sqlplus /NOLOG
- Log in as an administrator with the sysdba role by entering the following command:
connect as sysdba
- Enter the Oracle user ID and password.
- For each feature, change to that feature's SQL scripts directory and enter the following command to create the feature's database tables:
@<feature_subdirectory>/createDb.sql <password>
Notes
- Repeat this step for each Lotus Connections feature that you plan to install.
- Begin the command with the @ symbol.
- The createDB script creates a dedicated user ID for the JDBC connector for a feature database. Later, when you run the Lotus Connections installation wizard, provide the user ID that you specify in this step. You can specify one of the following default user IDs:
- Activities: OAUSER
- Blogs: BLOGS
- Communities: SNCOMMUSER
- Dogear: DOGEARUSER
- Files: FILESUSER
- Home page: HOMEPAGE
- Profiles: PROFUSER
- Wikis: WIKISUSER
Notes
- Each of these default user IDs has a narrower set of privileges than an administrative user ID.
- You can change the passwords for these database users later in Oracle Enterprise Manager Console. If you change the passwords there, also change them in the J2C authentication alias in the WAS admin console.
- (Home page only.) Run the following command:
@<feature_subdirectory>/initData.sql
- Optional: (Communities forums only.) Run the following command:
@<feature_subdirectory>/createDb_forum.sql <password>
- Optional: (Dogear only.) Run the following command:
@<feature_subdirectory>/createHistogramStatsJob.sql
This script creates a job to collect histogram statistics and improves performance.
- Run the following command to grant access privileges for each feature:
@<feature_subdirectory>/appGrants.sql
- Optional: (Communities forums only.) Run the following command:
@<feature_subdirectory>/appGrants_forum.sql
- Close the SQL Plus window.
Create databases with SQL scripts