SQL> ALTER SYSTEM DISABLE RESTRICTED SESSION Turn off the spooling of script results to the log file:ĭisable the RESTRICTED SESSION feature for the instance: The value of OWM_VERSION is the new version of Workspace Manager. Verify the current version of Workspace Manager: To recover one or more tables that were left in an inconsistent state because of the upgrade failure, use the RecoverAllMigratingTables or RecoverAllMigratingTables procedure, both of which are described in Chapter 4. If it has any rows, the upgrade did not complete successfully. SQL> whether or not the upgrade was successful: SQL> the system to spool results to a log file for later verification of success. If the WM_INSTALLATION view does not exist, run the following script to create the view. Use DisableVersioning on all version-enabled tables, uninstall the old release of Workspace Manager using the old uninstall script, and install the new release of the Workspace Manager software. If the OWM_VERSION value is BETA_RELEASE, the upgrade is not supported. If the OWM_VERSION value is NOT_INSTALLED, Workspace Manager is not currently installed. If you are upgrading to the Workspace Manager release that is included in the current Oracle Database 10 g installation, change to $ORACLE_HOME/rdbms/admin.Ĭonnect to the database instance as a user with SYSDBA privileges.ĭetermine the current release of the Workspace Manager software by finding the value of OWM_VERSION in the WM_INSTALLATION view: To upgrade to the current Workspace Manager release from a previous release, perform the following steps.Īt a system prompt, change to the installation directory of the release to which you are upgrading. You do not need to disable versioning before performing an upgrade or downgrade. If you are using Workspace Manager with Oracle Database 10 g but need to go back to release 9.2 or 9.0.1, you can downgrade to release 9.2 or 9.0.1 to preserve your existing work and then continue working with release 9.2 or 9.0.1.įor an upgrade or downgrade operation, the tables can remain version-enabled. (Note that an Oracle Workspace Manager release lower than 10.1 could have been installed on a release 8.1.6.0.0 or higher Oracle database.) If you have been working with version-enabled tables with a previous Oracle Workspace Manager release (9.0.1.0.0 or higher), you can upgrade to release 10.1 to preserve your existing work and then continue working with release 10.1. You can either upgrade to the current release or downgrade to a previous major release (no earlier than release 9.0.1). This appendix describes how to migrate version-enabled tables from one release of Workspace Manager to another release. 18/22 B Migrating to Another Workspace Manager Release
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |