Step by Step oracle database 10gR2 upgrade to 11.2.0.2(五)

2014-11-24 08:58:48 · 作者: · 浏览: 5
#############

DOC>#

Metadata Initial DB Creation Info

-------- -----------------------------------

B047 Database was created as 64-bit

===================================================

Number of Duplicate Objects Owned by SYS and SYSTEM

===================================================

Counting duplicate objects ....

COUNT(1)

----------

4

=========================================

Duplicate Objects Owned by SYS and SYSTEM

=========================================

Querying duplicate objects ....

OBJECT_NAME OBJECT_TYPE

---------------------------------------- ----------------------------------------

AQ$_SCHEDULES TABLE

AQ$_SCHEDULES_PRIMARY INDEX

DBMS_REPCAT_AUTH PACKAGE

DBMS_REPCAT_AUTH PACKAGE BODY

DOC>

DOC>################################################################################

DOC>

DOC> If any objects found please follow below article.

DOC> Note 1030426.6 How to Clean Up Duplicate Objects Owned by SYS and SYSTEM schema

DOC> Read the Exceptions carefully before taking actions.

DOC>

DOC>################################################################################

DOC>#

================

JVM Verification

================

JAVAVM - Installed properly

================================================

Checking Existence of Java-Based Users and Roles

================================================

DOC>

DOC>################################################################################

DOC>

DOC> There should not be any Java Based users for database version 9.0.1 and above.

DOC> If any users found,it is faulty JVM.

DOC>

DOC>################################################################################

DOC>#

User Existence

---------------------------

No Java Based Users

DOC>

DOC>###############################################################

DOC>

DOC> Healthy JVM Should contain Six Roles.

DOC> If there are more or less than six role,JVM is inconsistent.

DOC>

DOC>###############################################################

DOC>#

Role

------------------------------

There are 6 JAVA related roles

Roles

ROLE

------------------------------

JAVAUSERPRIV

JAVAIDPRIV

JAVASYSPRIV

JAVADEBUGPRIV

JAVA_ADMIN

JAVA_DEPLOY

=========================================

List of Invalid Java Objects owned by SYS

=========================================

There are no SYS owned invalid JAVA objects

DOC>

DOC>#################################################################

DOC>

DOC> Check the status of the main JVM interface packages DBMS_JAVA

DOC> and INITJVMAUX and make sure it is VALID.

DOC> If there are no Invalid objects below will result in zero rows.

DOC>

DOC>#################################################################

DOC>#

no rows selected

INFO:Below query should succeed with 'foo' as result.

JAVAVM TESTING

---------------

foo

*** End of LogFile ***

not spooling currently

Upload db_upg_diag_DMSBHMC_19_Nov_2011_0837.log from "0" directory

3. 根据utlu112i.sql 的运行结果进行升级前的准备, 如下:

SQL> @ utlu112i.sql

Oracle Database 11.2 Pre-Upgrade I