If the service pack installer contains a database update, you can run the scripts manually. Consult the ReadMe to determine if there is a database update. After you update the database, you should then run the installer to update the web server and the library.
To update the Knowledge Center database manually on an Oracle server:
From the Windows Start menu, open a Command Prompt window.
To update the schema using the AlterSchemaObjects.sql script located in \db scripts\ORACLE\KnowledgeCenter in the software installation files, enter the following at the command prompt:
sqlplus - SQL*Plus is the command line application for Oracle Database.
-s - Run SQL*Plus without SQL*Plus messaging.
<adminuser> - The administrative user for the instance of the Oracle server.
<adminpwd>@<instance> - The password for the administrative user and the name of the instance.
<scriptlocation>\<scriptname> - The path to the location of the script and the name of the script to be run.
schema_owner - The schema owner name is limited to 20 characters.
password - The password used for the schema owner account and the schema_app account.