You can install the Knowledge Center database manually by running the scripts provided with the software. You must have the proper administrative credentials for the database server to create and populate the schema or database.
Note: A Microsoft SQL Server must be configured with mixed mode authentication.
Warning: It is necessary to run the SQLPlus command line application for Oracle and the SQLCmd command line application for Microsoft SQL from the folder location that contains the script you are running.
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:
cd c:\temp\setup\db scripts\ORACLE\KnowledgeCenter
Enter sqlplus, and at the SQLPlus command prompt, enter the user name and password of the administrator account to connect to the Oracle database.
To create the schema using the CreateSchemaObjects.sql script, enter the following at the command prompt:
<scriptname> - The name of the script to be run.
schema_owner - The schema owner name is limited to 20 characters.
password - This will be the password used for the schema owner account and the schema_app account (this account is created automatically).
tablespace - The name of the tablespace.
tablespace_datafile - The tablespace location plus the name of the tablespace you used in the previous parameter.
temp_tablespace - The tablespace name plus _temp.
temp_tablespace_datafile - The tablespace location plus the name of the tablespace you used in the previous parameter.