Monday, September 24, 2018

db_upg_diag_UAT



 

 

*** Start of LogFile ***

 

Oracle Database Upgrade Diagnostic Utility 09-07-2018 13:16:28

 

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

Hostname

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

 

TJPSB007.ebs.in

 

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

Database Name

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

 

UAT

 

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

Database Uptime

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

 

12:20 17-AUG-18

 

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

Database Wordsize

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

 

This is a 64-bit database

 

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

Software Version

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

 

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

CORE 11.2.0.4.0 Production

TNS for Linux: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 - Production

 

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

Compatibility

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

 

Compatibility is set as 11.2.0

 

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

Archive Log Mode

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

 

Database log mode No Archive Mode

Automatic archival Disabled

Archive destination /ORADB/oradata/UAT/archive

Oldest online log sequence 55

Current log sequence 56

 

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

Auditing Check

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

 

 

NAME TYPE VALUE

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

audit_file_dest string /ORADB/app/orauat/11.2.0/rdbms

/audit

audit_sys_operations boolean TRUE

audit_syslog_level string

audit_trail string NONE

 

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

Cluster Check

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

 

NAME TYPE VALUE

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

cluster_database boolean FALSE

cluster_database_instances integer 1

 

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

DOC>

DOC> If CLUSTER_DATABASE is set to TRUE, change it to FALSE before

DOC> upgrading the database

DOC>

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

DOC>#

 

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

Tablespace and the owner of the aud$ table ( IF Oracle Label Security and Oracle Database Vault are installed then aud$ will be in SYSTEM.AUD$)

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

 

OWNER TABLESPACE_NAME

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

SYS SYSTEM

 

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

count of records in the sys.aud$ table where dbid is null- Standard Auditing

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

 

 

0

 

 

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

count of records in the system.aud$ when dbid is null, Std Auditing with OLS or DV installed

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

select count(*) from system.aud$ where dbid is null

*

ERROR at line 1:

ORA-00942: table or view does not exist

 

 

 

 

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

count of records in the sys.fga_log$ when dbid is null, Fine Grained Auditing

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

 

0

 

 

 

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

Oracle Label Security is installed or not

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

 

Oracle Label Security is NOT installed at database level

 

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

Number of AQ Records in Message Queue Tables

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

 

SYS - ALERT_QT - 0

SYS - AQ$_MEM_MC - 0

SYS - AQ_EVENT_TABLE - 0

SYS - AQ_PROP_TABLE - 0

SYS - KUPC$DATAPUMP_QUETAB - 0

SYS - KUPC$DATAPUMP_QUETAB_1 - 0

SYS - SCHEDULER$_EVENT_QTAB - 0

SYS - SCHEDULER$_REMDB_JOBQTAB - 0

SYS - SCHEDULER_FILEWATCHER_QT - 0

SYS - SYS$SERVICE_METRICS_TAB - 0

SYSTEM - DEF$_AQCALL - 0

SYSTEM - DEF$_AQERROR - 0

SYSTEM - TBLMIG_MSG_QTAB - 0

 

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

Time Zone version

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

 

 

14

 

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

Local Listener

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

 

 

UAT_LOCAL

 

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

Default and Temporary Tablespaces By User

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

 

 

USERNAME TEMPORARY_TABLESPACE DEFAULT_TABLESPACE

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

TJPSDBVIEW$ TEMP3 APPS_RO_DATA

TJTGHRP TEMP3 USERS

DNN9 TEMP3 TJTG

TJTG TEMP3 TJTG

JSW TEMP3 TJTG

APPS_VIEW TEMP3 TJTG

MDSYS TEMP3 SYSAUX

DMSYS TEMP3 SYSAUX

XDB TEMP3 SYSAUX

ANONYMOUS TEMP3 SYSAUX

OLAPSYS TEMP3 SYSAUX

APPQOSSYS TEMP3 SYSAUX

JTS TEMP3 APPS_TS_TX_DATA

JTM TEMP3 APPS_TS_TX_DATA

AHL TEMP3 APPS_TS_TX_DATA

OKB TEMP3 APPS_TS_TX_DATA

XNI TEMP3 APPS_TS_TX_DATA

HR TEMP3 APPS_TS_TX_DATA

IMC TEMP3 APPS_TS_TX_DATA

OKO TEMP3 APPS_TS_TX_DATA

BEN TEMP3 APPS_TS_TX_DATA

HXT TEMP3 APPS_TS_TX_DATA

OTA TEMP3 APPS_TS_TX_DATA

QA TEMP3 APPS_TS_TX_DATA

ICX TEMP3 APPS_TS_TX_DATA

AZ TEMP3 APPS_TS_TX_DATA

BIS TEMP3 APPS_TS_TX_DATA

OKI TEMP3 APPS_TS_TX_DATA

IZU TEMP3 APPS_TS_TX_DATA

IPD TEMP3 APPS_TS_TX_DATA

ENI TEMP3 APPS_TS_TX_DATA

POS TEMP3 APPS_TS_TX_DATA

AHM TEMP3 APPS_TS_TX_DATA

ASP TEMP3 APPS_TS_TX_DATA

BIV TEMP3 APPS_TS_TX_DATA

PN TEMP3 APPS_TS_TX_DATA

PO TEMP3 APPS_TS_TX_DATA

JG TEMP3 APPS_TS_TX_DATA

JL TEMP3 APPS_TS_TX_DATA

PMI TEMP3 APPS_TS_TX_DATA

JTF TEMP3 APPS_TS_TX_DATA

OZP TEMP3 APPS_TS_TX_DATA

OZS TEMP3 APPS_TS_TX_DATA

PSB TEMP3 APPS_TS_TX_DATA

PSP TEMP3 APPS_TS_TX_DATA

MWA TEMP3 APPS_TS_TX_DATA

FV TEMP3 APPS_TS_TX_DATA

IGC TEMP3 APPS_TS_TX_DATA

PSA TEMP3 APPS_TS_TX_DATA

OKR TEMP3 APPS_TS_TX_DATA

PV TEMP3 APPS_TS_TX_DATA

MSR TEMP3 APPS_TS_TX_DATA

FEM TEMP3 APPS_TS_TX_DATA

SSP TEMP3 APPS_TS_TX_DATA

VEH TEMP3 APPS_TS_TX_DATA

HXC TEMP3 APPS_TS_TX_DATA

RLM TEMP3 APPS_TS_TX_DATA

VEA TEMP3 APPS_TS_TX_DATA

POM TEMP3 APPS_TS_TX_DATA

FRM TEMP3 APPS_TS_TX_DATA

BSC TEMP3 APPS_TS_TX_DATA

WIP TEMP3 APPS_TS_TX_DATA

XTR TEMP3 APPS_TS_TX_DATA

RHX TEMP3 APPS_TS_TX_DATA

XNM TEMP3 APPS_TS_TX_DATA

XNP TEMP3 APPS_TS_TX_DATA

XNC TEMP3 APPS_TS_TX_DATA

XNS TEMP3 APPS_TS_TX_DATA

QP TEMP3 APPS_TS_TX_DATA

WSH TEMP3 APPS_TS_TX_DATA

WMS TEMP3 APPS_TS_TX_DATA

WPS TEMP3 APPS_TS_TX_DATA

WSM TEMP3 APPS_TS_TX_DATA

AMW TEMP3 APPS_TS_TX_DATA

XLE TEMP3 APPS_TS_TX_DATA

ASN TEMP3 APPS_TS_TX_DATA

MST TEMP3 APPS_TS_TX_DATA

FUN TEMP3 APPS_TS_TX_DATA

GCS TEMP3 APPS_TS_TX_DATA

XDO TEMP3 APPS_TS_TX_DATA

ZX TEMP3 APPS_TS_TX_DATA

LNS TEMP3 APPS_TS_TX_DATA

IA TEMP3 APPS_TS_TX_DATA

FPA TEMP3 APPS_TS_TX_DATA

ZPB TEMP3 APPS_TS_TX_DATA

EAM TEMP3 APPS_TS_TX_DATA

JMF TEMP3 APPS_TS_TX_DATA

ITA TEMP3 APPS_TS_TX_DATA

FTP TEMP3 APPS_TS_TX_DATA

PFT TEMP3 APPS_TS_TX_DATA

GMO TEMP3 APPS_TS_TX_DATA

DNA TEMP3 APPS_TS_TX_DATA

IPM TEMP3 APPS_TS_TX_DATA

IBW TEMP3 APPS_TS_TX_DATA

CS TEMP3 APPS_TS_TX_DATA

AP TEMP3 APPS_TS_TX_DATA

AR TEMP3 APPS_TS_TX_DATA

 

USERNAME TEMPORARY_TABLESPACE DEFAULT_TABLESPACE

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

OE TEMP3 APPS_TS_TX_DATA

OSM TEMP3 APPS_TS_TX_DATA

PA TEMP3 APPS_TS_TX_DATA

CN TEMP3 APPS_TS_TX_DATA

MFG TEMP3 APPS_TS_TX_DATA

INV TEMP3 APPS_TS_TX_DATA

BOM TEMP3 APPS_TS_TX_DATA

ENG TEMP3 APPS_TS_TX_DATA

MRP TEMP3 APPS_TS_TX_DATA

CRP TEMP3 APPS_TS_TX_DATA

CZ TEMP3 APPS_TS_TX_DATA

PJM TEMP3 APPS_TS_TX_DATA

FLM TEMP3 APPS_TS_TX_DATA

MSC TEMP3 APPS_TS_TX_DATA

CE TEMP3 APPS_TS_TX_DATA

FTE TEMP3 APPS_TS_TX_DATA

IGI TEMP3 APPS_TS_TX_DATA

ITG TEMP3 APPS_TS_TX_DATA

BIX TEMP3 APPS_TS_TX_DATA

EC TEMP3 APPS_TS_TX_DATA

GMA TEMP3 APPS_TS_TX_DATA

GMD TEMP3 APPS_TS_TX_DATA

GME TEMP3 APPS_TS_TX_DATA

GMF TEMP3 APPS_TS_TX_DATA

GMI TEMP3 APPS_TS_TX_DATA

GML TEMP3 APPS_TS_TX_DATA

GMP TEMP3 APPS_TS_TX_DATA

GR TEMP3 APPS_TS_TX_DATA

CUS TEMP3 APPS_TS_TX_DATA

CUI TEMP3 APPS_TS_TX_DATA

CUP TEMP3 APPS_TS_TX_DATA

IEO TEMP3 APPS_TS_TX_DATA

OKC TEMP3 APPS_TS_TX_DATA

OKS TEMP3 APPS_TS_TX_DATA

CSC TEMP3 APPS_TS_TX_DATA

BIC TEMP3 APPS_TS_TX_DATA

CSD TEMP3 APPS_TS_TX_DATA

ASF TEMP3 APPS_TS_TX_DATA

CSF TEMP3 APPS_TS_TX_DATA

AMS TEMP3 APPS_TS_TX_DATA

AMV TEMP3 APPS_TS_TX_DATA

BIM TEMP3 APPS_TS_TX_DATA

XDP TEMP3 APPS_TS_TX_DATA

BIL TEMP3 APPS_TS_TX_DATA

IES TEMP3 APPS_TS_TX_DATA

AST TEMP3 APPS_TS_TX_DATA

CCT TEMP3 APPS_TS_TX_DATA

IBP TEMP3 APPS_TS_TX_DATA

IBY TEMP3 APPS_TS_TX_DATA

IBE TEMP3 APPS_TS_TX_DATA

IBU TEMP3 APPS_TS_TX_DATA

FII TEMP3 APPS_TS_TX_DATA

HRI TEMP3 APPS_TS_TX_DATA

ISC TEMP3 APPS_TS_TX_DATA

OPI TEMP3 APPS_TS_TX_DATA

POA TEMP3 APPS_TS_TX_DATA

MSO TEMP3 APPS_TS_TX_DATA

ONT TEMP3 APPS_TS_TX_DATA

MSD TEMP3 APPS_TS_TX_DATA

CUF TEMP3 APPS_TS_TX_DATA

CUA TEMP3 APPS_TS_TX_DATA

IGS TEMP3 APPS_TS_TX_DATA

IPA TEMP3 APPS_TS_TX_DATA

ASG TEMP3 APPS_TS_TX_DATA

IEX TEMP3 APPS_TS_TX_DATA

OKX TEMP3 APPS_TS_TX_DATA

ASO TEMP3 APPS_TS_TX_DATA

CSP TEMP3 APPS_TS_TX_DATA

OZF TEMP3 APPS_TS_TX_DATA

IEU TEMP3 APPS_TS_TX_DATA

IEM TEMP3 APPS_TS_TX_DATA

OKE TEMP3 APPS_TS_TX_DATA

ECX TEMP3 APPS_TS_TX_DATA

GMS TEMP3 APPS_TS_TX_DATA

IGW TEMP3 APPS_TS_TX_DATA

CSR TEMP3 APPS_TS_TX_DATA

IEB TEMP3 APPS_TS_TX_DATA

IGF TEMP3 APPS_TS_TX_DATA

ASL TEMP3 APPS_TS_TX_DATA

IEC TEMP3 APPS_TS_TX_DATA

CSE TEMP3 APPS_TS_TX_DATA

JE TEMP3 APPS_TS_TX_DATA

JA TEMP3 APPS_TS_TX_DATA

APPLSYS TEMP3 APPS_TS_TX_DATA

APPLSYSPUB TEMP3 APPS_TS_TX_DATA

ALR TEMP3 APPS_TS_TX_DATA

AX TEMP3 APPS_TS_TX_DATA

AK TEMP3 APPS_TS_TX_DATA

XLA TEMP3 APPS_TS_TX_DATA

RRS TEMP3 APPS_TS_TX_DATA

GL TEMP3 APPS_TS_TX_DATA

RG TEMP3 APPS_TS_TX_DATA

FA TEMP3 APPS_TS_TX_DATA

RLA TEMP3 APPS_TS_TX_DATA

ABM TEMP3 APPS_TS_TX_DATA

EAA TEMP3 APPS_TS_TX_DATA

EVM TEMP3 APPS_TS_TX_DATA

 

USERNAME TEMPORARY_TABLESPACE DEFAULT_TABLESPACE

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

CUN TEMP3 APPS_TS_TX_DATA

FPT TEMP3 APPS_TS_TX_DATA

ME TEMP3 APPS_TS_TX_DATA

CSS TEMP3 APPS_TS_TX_DATA

IBA TEMP3 APPS_TS_TX_DATA

APPS TEMP3 APPS_TS_TX_DATA

CUE TEMP3 APPS_TS_TX_DATA

CSI TEMP3 APPS_TS_TX_DATA

CSL TEMP3 APPS_TS_TX_DATA

CUG TEMP3 APPS_TS_TX_DATA

IMT TEMP3 APPS_TS_TX_DATA

CLN TEMP3 APPS_TS_TX_DATA

XNB TEMP3 APPS_TS_TX_DATA

BNE TEMP3 APPS_TS_TX_DATA

QRM TEMP3 APPS_TS_TX_DATA

PON TEMP3 APPS_TS_TX_DATA

OKL TEMP3 APPS_TS_TX_DATA

IBC TEMP3 APPS_TS_TX_DATA

AMF TEMP3 APPS_TS_TX_DATA

QOT TEMP3 APPS_TS_TX_DATA

CSM TEMP3 APPS_TS_TX_DATA

DOM TEMP3 APPS_TS_TX_DATA

EGO TEMP3 APPS_TS_TX_DATA

DDD TEMP3 APPS_TS_TX_DATA

PJI TEMP3 APPS_TS_TX_DATA

ZFA TEMP3 APPS_TS_TX_DATA

ZSA TEMP3 APPS_TS_TX_DATA

EDR TEMP3 APPS_TS_TX_DATA

PRP TEMP3 APPS_TS_TX_DATA

DPP TEMP3 APPS_TS_TX_DATA

MTH TEMP3 APPS_TS_TX_DATA

QPR TEMP3 APPS_TS_TX_DATA

DDR TEMP3 APPS_TS_TX_DATA

INL TEMP3 APPS_TS_TX_DATA

SQLTXPLAIN TEMP3 APPS_TS_TX_DATA

SQLTXADMIN TEMP3 APPS_TS_TX_DATA

SSOSDK TEMP3 PORTAL

ODM TEMP3 ODM

ODM_MTR TEMP3 ODM

OWAPUB TEMP3 OWAPUB

CTXSYS TEMP3 CTXD

SYS TEMP3 SYSTEM

SYSTEM TEMP3 SYSTEM

OUTLN TEMP3 SYSTEM

ORDSYS TEMP3 SYSTEM

ORDPLUGINS TEMP3 SYSTEM

MGDSYS TEMP3 SYSTEM

SCOTT TEMP3 SYSTEM

DIP TEMP3 SYSTEM

AD_MONITOR TEMP3 SYSTEM

SI_INFORMTN_SCHEMA TEMP3 SYSTEM

MDDATA TEMP3 SYSTEM

EM_MONITOR TEMP3 SYSTEM

ORACLE_OCM TEMP3 SYSTEM

XS$NULL TEMP3 SYSTEM

ORDDATA TEMP3 SYSTEM

SPATIAL_WFS_ADMIN_USR TEMP3 SYSTEM

SPATIAL_CSW_ADMIN_USR TEMP3 SYSTEM

DBSNMP TEMP3 SYSTEM

 

 

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

Component Status

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

 

Comp ID Component Status Version Org_Version Prv_Version

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

AMD OLAP Catalog VALID 11.2.0.4.0 10.2.0.3.0 10.2.0.3.0

APS OLAP Analytic Workspace VALID 11.2.0.4.0 9.2.0.5.0 10.2.0.3.0

CATALOG Oracle Database Catalog Views VALID 11.2.0.4.0 9.2.0.5.0 9.2.0.5.0

CATJAVA Oracle Database Java Packages VALID 11.2.0.4.0 9.2.0.5.0 10.2.0.3.0

CATPROC Oracle Database Packages and Types VALID 11.2.0.4.0 9.2.0.5.0 10.2.0.3.0

CONTEXT Oracle Text VALID 11.2.0.4.0 9.2.0.5.0 10.2.0.3.0

JAVAVM JServer JAVA Virtual Machine VALID 11.2.0.4.0 9.2.0.5.0 10.2.0.3.0

ODM Oracle Data Mining VALID 11.2.0.4.0 9.2.0.5.0 10.2.0.3.0

ORDIM Oracle Multimedia VALID 11.2.0.4.0 9.2.0.5.0 10.2.0.3.0

RAC Oracle Real Application Clusters INVALID 11.2.0.4.0 9.2.0.5.0 10.2.0.3.0

SDO Spatial VALID 11.2.0.4.0 9.2.0.5.0 10.2.0.3.0

XDB Oracle XML Database VALID 11.2.0.4.0 10.2.0.1.0 10.2.0.3.0

XML Oracle XDK VALID 11.2.0.4.0 9.2.0.7.0 10.2.0.3.0

XOQ Oracle OLAP API VALID 11.2.0.4.0 9.2.0.5.0 10.2.0.3.0

 

 

 

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

List of Invalid Database Objects Owned by SYS / SYSTEM

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

 

 

Number of Invalid Objects

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

There are no Invalid Objects

 

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

DOC>

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

DOC>

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

DOC>#

 

 

no rows selected

 

 

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

List of Invalid Database Objects

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

 

 

Number of Invalid Objects

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

There are no Invalid Objects

 

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

DOC>

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

DOC>

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

DOC>#

 

 

no rows selected

 

 

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

Count of Invalids by Schema

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

 

 

OWNER OBJECT_TYPE COUNT(*)

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

APPS FUNCTION 1

APPS PACKAGE 2

APPS PACKAGE BODY 21

APPS PROCEDURE 30

APPS VIEW 4

JSW VIEW 1

TJPSDBVIEW$ SYNONYM 16

TJTG FUNCTION 1

TJTGHRP FUNCTION 6

TJTGHRP PROCEDURE 12

TJTGHRP TRIGGER 9

TJTGHRP TYPE 1

TJTGHRP VIEW 1

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

Identifying whether a database was created as 32-bit or 64-bit

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

 

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

DOC>

DOC> Result referencing the string 'B023' ==> Database was created as 32-bit

DOC> Result referencing the string 'B047' ==> Database was created as 64-bit

DOC> When String results in 'B023' and when upgrading database to 10.2.0.3.0

DOC> (64-bit) , For known issue refer below articles

DOC>

DOC> Note 412271.1 ORA-600 [22635] and ORA-600 [KOKEIIX1] Reported While

DOC> Upgrading Or Patching Databases To 10.2.0.3

DOC> Note 579523.1 ORA-600 [22635], ORA-600 [KOKEIIX1], ORA-7445 [KOPESIZ] and

DOC> OCI-21500 [KOXSIHREAD1] Reported While Upgrading To 11.1.0.6

DOC>

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

DOC>#

 

 

Metadata Initial DB Creation Info

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

B023 Database was created as 32-bit

 

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

Number of Duplicate Objects Owned by SYS and SYSTEM

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

 

Counting duplicate objects ....

 

 

COUNT(1)

----------

0

 

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

Duplicate Objects Owned by SYS and SYSTEM

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

 

Querying duplicate objects ....

 

 

DOC>

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

DOC>Below are expected and required duplicates objects and OMITTED in the report .

DOC>

DOC>Without replication installed:

DOC>INDEX AQ$_SCHEDULES_PRIMARY

DOC>TABLE AQ$_SCHEDULES

DOC>

DOC>If replication is installed by running catrep.sql:

DOC>INDEX AQ$_SCHEDULES_PRIMARY

DOC>PACKAGE DBMS_REPCAT_AUTH

DOC>PACKAGE BODY DBMS_REPCAT_AUTH

DOC>TABLE AQ$_SCHEDULES

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>#

 

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

Password protected roles

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

 

DOC>

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

DOC>

DOC> In version 11.2 password protected roles are no longer enabled by default so if

DOC> an application relies on such roles being enabled by default and no action is

DOC> performed to allow the user to enter the password with the set role command, it

DOC> is recommended to remove the password from those roles (to allow for existing

DOC> privileges to remain available). For more information see:

DOC>

DOC> Note 745407.1 : What Roles Can Be Set as Default for a User?

DOC>

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

DOC>#

 

Querying for password protected roles ....

 

 

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

JVM Verification

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

 

 

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

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>

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

DOC>

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

DOC>#

 

 

no rows selected

 

 

DOC>

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

DOC>

DOC> If the JAVAVM component is not installed in the database (for

DOC> example, after creating the database with custom scripts), the

DOC> next query will report the following error:

DOC>

DOC> select dbms_java.longname('foo') "JAVAVM TESTING" from dual

DOC> *

DOC> ERROR at line 1:

DOC> ORA-00904: "DBMS_JAVA"."LONGNAME": invalid identifier

DOC>

DOC> If the JAVAVM component is installed, the query should succeed

DOC> with 'foo' as result.

DOC>

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

DOC>#

 

 

JAVAVM TESTING

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

foo

 

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

Oracle Multimedia/InterMedia status

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

 

.

Oracle Multimedia/interMedia is installed and listed with the following version: 11.2.0.4.0 and status: VALID

.

Checking for installed Database Schemas...

ORDSYS user exists.

ORDPLUGINS user exists.

MDSYS user exists.

SI_INFORMTN_SCHEMA user exists.

ORDDATA user exists.

.

Checking for Prerequisite Components...

JAVAVM installed and listed as valid

XDK installed and listed as valid

XDB installed and listed as valid

Validating Oracle Multimedia/interMedia...(no output if component status is valid)

 

PL/SQL procedure successfully completed.

 




*** End of LogFile ***

 

 

No comments:

Post a Comment

[ERROR]: The value of s_patch_service_name is not set correctly in atleast one of the context files.

[ERROR]: The value of s_patch_service_name is not set correctly in atleast one of the context files. I got the issue below wh...