• Upgrade the Knowledge Center Database Manually
  • Upgrade the Knowledge Center Database Manually
  • "07e93a49-42b9-405f-8c6a-51e9b0bddbe6
  • You can manually update the Knowledge Center database by running scripts on the database server before you run the installer to upgrade the web server.
  • To update an existing Oracle schema for Knowledge Center and all the objects, two scripts are run. One script, AlterSystemObjects, requires system administrator privileges. It updates 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, AlterSchemaObjects, updates the schema objects necessary to run Knowledge Center. This script should be run by the schema owner account created from the previous installation of Knowledge Center.
  • If you are using a Microsoft SQL Server, 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 does 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.
  • 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.
  • Warning:
  • To upgrade the Oracle database manually before you upgrade the 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 update the schema using the
  • AlterSchemaObjects.sql
  • 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 update the schema objects by running the
  • AlterSchemaObjects.sql
  • Warning!
  • Standard SQL*Plus syntax
  • Note:
  • sqlplus -s <SCHEMA_OWNER>/<SCHEMA_OWNER_PASSWORD>@<SERVER_INSTANCE> @"AlterSchemaObjects.sql" <SCHEMA_OWNER> <SCHEMA_USER>
  • <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 upgrade the Microsoft SQL Server database manually before you upgrade the 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 upgrade the database using the
  • AlterDBObjects.sql
  • Warning!
  • Standard sqlcmd syntax
  • Note:
  • Example with default install parameters
  • Confirm the parameters and run the script.
  • Enter
  • exit
  • ENTER