[EN] "Oracle XML Database", "Oracle Multimedia", "Oracle Database Packages and Types" components invalid after 11gR2 upgrade because of LIBPATH OS variable

Problem:

After 11.2.0.3 upgrade from 10.2.0.5, "Oracle XML Database", "Oracle Multimedia" and "Oracle Database Packages and Types" components become invalid. They were valid on 10.2.0.5.

===> select substr(comp_name,1,40) comp_name, schema, status, substr(version,1,10) version from dba_registry order by comp_name
COMP_NAME                                SCHEMA                         STATUS      VERSION
---------------------------------------- ------------------------------ ----------- ----------
JServer JAVA Virtual Machine             SYS                            VALID       11.2.0.3.0
OLAP Analytic Workspace                  SYS                            VALID       11.2.0.3.0
OLAP Catalog                             OLAPSYS                        VALID       11.2.0.3.0
Oracle Data Mining                       DMSYS                          VALID       11.2.0.3.0
Oracle Database Catalog Views            SYS                            VALID       11.2.0.3.0
Oracle Database Java Packages            SYS                            VALID       11.2.0.3.0
Oracle Database Packages and Types       SYS                            INVALID     11.2.0.3.0
Oracle Enterprise Manager                SYSMAN                         VALID       11.2.0.3.0
Oracle Expression Filter                 EXFSYS                         VALID       11.2.0.3.0
Oracle Multimedia                        ORDSYS                         INVALID     11.2.0.3.0
Oracle OLAP API                          SYS                            VALID       11.2.0.3.0
Oracle Rule Manager                      EXFSYS                         VALID       11.2.0.3.0
Oracle Text                              CTXSYS                         VALID       11.2.0.3.0
Oracle Workspace Manager                 WMSYS                          VALID       11.2.0.3.0
Oracle XDK                               SYS                            VALID       11.2.0.3.0
Oracle XML Database                      XDB                            INVALID     11.2.0.3.0
Spatial                                  MDSYS                          VALID       11.2.0.3.0
17 rows selected.

[EN] EMD upload error: uploadXMLFiles skipped :: OMS version not checked yet.

Problem:


[XXXPRO1]/oracle/product/11.1.0/agent11g/bin $ ./emctl upload agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
EMD upload error: uploadXMLFiles skipped :: OMS version not checked yet. If this issue persists check trace files for ping to OMS related errors.

Solution:

When you get this warning you should also check "emctl status agent" output. 


[XXXPRO1]/oracle/product/11.1.0/agent11g/bin $ ./emctl status agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0 
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version     : 11.1.0.1.0
OMS Version       : 11.1.0.1.0
Protocol Version  : 11.1.0.0.0
Agent Home        : /oracle/product/11.1.0/agent11g/hostxxx01
Agent binaries    : /oracle/product/11.1.0/agent11g
Agent Process ID  : 8091
Parent Process ID : 8080
Agent URL         : https://hostxxx01:1830/emd/main
Repository URL    : https://hostemgrid01:1159/em/upload
Started at        : 2012-06-21 11:13:55
Started by user   : oracle
Last Reload       : 2012-06-21 11:13:55
Last successful upload                       : (none)
Last attempted upload                        : (none)
Total Megabytes of XML files uploaded so far :     0.00
Number of XML files pending upload           :      273
Size of XML files pending upload(MB)         :    52.42
Available disk space on upload filesystem    :    47.97%
Collection Status                            : Disabled by Upload Manager
Last attempted heartbeat to OMS              : 2012-06-21 11:26:12
Last successful heartbeat to OMS             : unknown
---------------------------------------------------------------
Agent is Running and Ready

[TR] Tablo Büyüme Boyut Tahmini

Bir tablonun zamanla ne kadar büyüyeceği aşağıdaki adım ve formüller kullanılarak tahmin edilebilir. Tahmin, tabloya zaman içerisinde düzenli veri yüklenmesi durumunda geçerlidir. Yani belli aralıklarda tabloya daha az yada daha yoğun veri yüklenmesi durumunda tahmin tutarsız olacaktır. Büyüme tahmini, aynı zamanda Enterprise Manager üzerinden de yapılabilir.