Oracle Software 12.1.0.2.0 installation –
1.
Download the software from
below link
2.
Install the Software - Initiate
the ./runInstaller
3.
Install 12.1.0.2 Example cd in
12.1.0.2 oracle home –
Export
ORACLE_HOME=/ora01/ora11g/oracle/product/12.1.2.0
Database Upgrade:
1.
Stop the database listener
service
2.
export OLAP analytical
workspaces (conditional)
No OLAP objects
/ora01/apps/oracle/product/12.1.2.0
3.
RUN utlu121i.sql from new
oracle_home(12.1.2.0)
|
SQL>
@/ora01/ebscnv/orcnv/oracle/product/12.1.0.2/rdbms/admin/preupgrd.sql;
Loading Pre-Upgrade Package...
***************************************************************************
Executing Pre-Upgrade Checks in EBSCNV...
***************************************************************************
************************************************************
====>> ERRORS FOUND
for EBSCNV <<====
The following are *** ERROR LEVEL CONDITIONS
*** that must be addressed
prior to attempting your
upgrade.
Failure to do so will result in a
failed upgrade.
1)
Check Tag: PURGE_RECYCLEBIN
Check Summary: Check that recycle bin is empty prior to upgrade
Fixup Summary:
"The recycle bin will be purged."
You MUST resolve the above error
prior to upgrade
************************************************************
************************************************************
====>> PRE-UPGRADE
RESULTS for EBSCNV <<====
ACTIONS REQUIRED:
1. Review results of the pre-upgrade
checks:
2. Execute in the SOURCE environment
BEFORE upgrade:
3. Execute in the NEW environment AFTER
upgrade:
/ora01/ebscnv/orcnv/oracle/product/11.2.0/cfgtoollogs/EBSCNV/preupgrade/postupgrade_fixups.sql
************************************************************
Pre-Upgrade Checks in EBSCNV Completed.
***************************************************************************
SQL>
|
4.
RUN DBUA from new oracle
home(12.1.0.2)
Database contains INVALID objects prior to
upgrade. The list of invalid SYS/SYSTEM objects was written to
registry$sys_inv_objs. The list of non-SYS/SYSTEM objects was written to
registry$nonsys_inv_objs unless there were over 5000. Use utluiobj.sql after
the upgrade to identify any new invalid objects due to the upgrade.
Details: SYS |||HEADER |||PACKAGE,SYS |||DB01_TOOLS |||PACKAGE
BODY,SYSTEM |||QUEST_SL_REPOS_SAVE |||FUNCTION,SYSTEM |||QUEST_SL_REPOS_ROLE
|||PROCEDURE,SYSTEM |||MERLIN_ONHAND_INVENTORY_V |||VIEW,SYSTEM
|||MERLIN_ONHAND_INVENT_PRE_OLD_V |||VIEW,SYSTEM |||PA_VALID_PROJECTS_TASKS_V
|||VIEW,SYSTEM |||PEOPLE_MODULES |||VIEW Cause: Invalid
object found in the database. Action: It is recommended
that utlprp.sql be run to attempt to validate objects
Invalid objects count –
Time taken – 1:48 pm to
Post upgrade scripts -
@?/rdbms/admin/awrupd12.sql
@?/rdbms/admin/catuppst.sql
@?/rdbms/admin/utlrp.sql
@?/rdbms/admin/utluiobj.sql
@?/rdbms/admin/awrupd12.sql
@?/rdbms/admin/catuppst.sql
@?/rdbms/admin/utlrp.sql
@?/rdbms/admin/utluiobj.sql
|
10:25:40
SQL> @?/rdbms/admin/utluiobj.sql
.
Oracle
Database 12.1 Post-Upgrade Invalid Objects Tool 12-29-2017 10:26:17
.
This
tool lists post-upgrade invalid objects that were not invalid
prior
to upgrade (it ignores pre-existing pre-upgrade invalid objects).
.
Owner Object Name Object Type
.
SENSIS ZFWB_WS_PRIVILEGES VIEW
SENSIS ZFWB_WS_REVOCATIONS VIEW
10:26:17
SQL>
|
No comments:
Post a Comment