• Install the Knowledge Center Database Manually
  • Install the Knowledge Center Database Manually
  • "225360b7-1f26-4b8c-92ec-5166aa841660
  • You can choose to create the schema only without installing the Knowledge Center software. This allows you to create the schema on a dedicated server, and then install the Knowledge Center software on another server. If you choose to do this, you must create the schema before you install the Knowledge Center software. You can create the schema manually by running the scripts provided in the media pack.
  • To create an Oracle schema with all the objects, two scripts must be run. One script, CreateSystemObjects, requires system administrator privileges. It creates the tablespace, the schema owner and the application user schema that has access to the schema where the Knowledge Center objects are created.
  • The second script, CreateSchemaObjects, creates the schema objects necessary to run Knowledge Center. This script should be run by the schema owner account created from the CreateSystemObjects script.
  • If you are using a Microsoft SQL Server, one script references multiple scripts to create the database and the database user, as well as populate the database with the appropriate objects. The SQL scripts are intended to be run by an SQL administrator with either sysadmin or a combination of securityadmin and dbcreator privileges.
  • The database objects creation do not necessarily require these privileges, and could be performed by the user with db_owner privileges of the database. This would require modifications to the SQL scripts.
  • A Microsoft SQL Server must be configured with mixed mode authentication.
  • Note:
  • It is necessary to run the SQLPlus command line application for Oracle and the SQLCmd command line application for Microsoft SQL Server from the folder location that contains the script you are running.
  • Warning!
  • To install the database manually on an Oracle Database server:
  • From the Windows Start menu, open a Command Prompt window.
  • Using the cd command, change into the folder where the scripts are located in the software installation files; for example, if the files are located on the C: drive in a temp folder:
  • To create the schema using the
  • CreateSystemObjects.sql
  • Warning!
  • Standard SQL*Plus syntax
  • Note:
  • Example with default install parameters
  • Confirm the parameters and run the script. After the schema is created, enter
  • exit
  • ENTER
  • Next create the schema objects by running the
  • CreateSchemaObjects.sql
  • Warning!
  • Standard SQL*Plus syntax
  • Note:
  • Run the following:
  • sqlplus -s <SCHEMA_OWNER>/<SCHEMA_OWNER_PASSWORD>@<SERVER_INSTANCE> @"CreateSchemaObjects.sql" <SCHEMA_OWNER> <SCHEMA_USER>
  • The variables that need to be replaced are:
  • <SCHEMA_OWNER> - user created that is the schema owner
  • Example with default install parameters:
  • Confirm the parameters and run the script. After the script runs, enter
  • exit
  • ENTER
  • Enter
  • exit
  • ENTER
  • To install the database manually on a Microsoft SQL Server:
  • From the Windows Start menu, open a Command Prompt window.
  • Using the cd command, change into the folder where the scripts are located in the software installation files; for example, if the files are located on the C: drive in a temp folder:
  • To create the database using the
  • CreateDB.sql
  • Warning!
  • Standard sqlcmd syntax:
  • Note:
  • Example with default install parameters:
  • Confirm the parameters and run the script.
  • Create the database objects by running the
  • CreateDBObjects.sql
  • Warning!
  • Standard sqlcmd syntax:
  • Note:
  • Example with default install parameters:
  • Confirm the parameters and run the script.
  • Enter
  • exit
  • ENTER