• Upgrade the Developer Database Manually
  • Upgrade the Developer Database Manually
  • "0312f623-cf62-4bf5-887e-22bc1c8dfbea
  • To update the existing Oracle schema for Developer and all the objects, two scripts must be 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 Developer objects are created.
  • The second script, AlterSchemaObjects, updates the schema objects necessary to run Developer. This script should be run by the schema owner account created from the previous installation of Developer.
  • If you are using a Microsoft SQL Servre, 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.
  • From the Windows Start menu, open a Command Prompt window.
  • To update the schema using the
  • AlterSystemObjects.sql
  • \db scripts\ORACLE\Developer\Upgrade
  • Standard SQL*Plus syntax
  • Note:
  • Warning!
  • 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:
  • Run the following:
  • sqlplus -s <SCHEMA_OWNER>/<SCHEMA_OWNER_PASSWORD>@<SERVER_INSTANCE> @"AlterSchemaObjects.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 upgrade the Microsoft SQL Server database manually and then upgrade the server:
  • From the Windows Start menu, open a Command Prompt window.
  • Update the database objects by running the AlterDBObjects.sql script. The script contains variables that are replaced with the text supplied for the values.
  • Standard sqlcmd syntax
  • Note:
  • Example with default install parameters
  • Confirm the parameters and run the script.
  • Close the Command Prompt window.