SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) valueĢ.4. Timezone should less than or equal to target database timezone version: SQL> select TZ_VERSION from registry$database Disable any custom triggers that would get executed before / after DDL:Ģ.3. Take a cold or hot back up of the source database:ĭuring database upgradation cutover window, we can take backup. IF APEX is installed then it is recommended to upgrade APEX in the source DB first before upgrading DBĢ.1.Timezone should less than or equal to target database timezone version.If you upgrade an 11g database to Oracle Database 12c without deleting the 11g data security roles, then any data security policies that include a data security role are invalid in the Oracle Database 12c database. After the upgrade, you may use Analytic Workspace Manager 12c to define the data security roles again. Before you upgrade an 11g database to Oracle Database 12c, you must delete any data security roles that are defined in the 11g database. Data security roles defined in a release 11g Oracle Database instance are not automatically converted to ORAS.You can enable it once upgrade is completed. Disable any custom triggers that would get executed before / after DDL.Take a cold or hot back up of the source database.Requirements and recommendations for source database: Rollback to Earlier Version (11.2.0.4).ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |