[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.

[EN] ORA-00230: operation disallowed: snapshot control file enqueue unavailable

Problem: 

Starting Control File and SPFILE Autobackup at 18-MAY-2012 08:03:33
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script db_alfa_backup_db_02
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_SBT_TAPE_1 channel at 05/18/2012 08:03:40
ORA-00230: operation disallowed: snapshot control file enqueue unavailable

Recovery Manager complete.
Backup process end time:Fri May 18 08:03:49 EEST 2012

[EN] Run root.sh from a directory that has read/execute access to the grid owner 'oracle'

Problem:
To configure Grid Infrastructure for a Stand-Alone Server run the following command as the root user:
/oracle/app/oracle/product/11.2.0/grid/perl/bin/perl -I/oracle/app/oracle/product/11.2.0/grid/perl/lib -I/oracle/app/oracle/product/11.2.0/grid/crs/install /oracle/app/oracle/product/11.2.0/grid/crs/install/roothas.pl

xynndp09:/oracle/app/oracle/product/11.2.0/grid/perl/bin/perl -I/oracle/app/oracle/product/11.2.0/grid/perl/lib -I/oracle/app/oracle/product/11.2.0/grid/crs/install /oracle/app/oracle/product/11.2.0/grid/crs/install/roothas.pl
Using configuration parameter file: /oracle/app/oracle/product/11.2.0/grid/crs/install/crsconfig_params
su: Illegal option -c
usage:   su  [-]  [username  [arguments]]
         su  [-]  -d  [username]
Run root.sh from a directory that has read/execute access to the grid owner 'oracle'