ORACLE 11g R2 RAC OEM 显示错误

dada_base

求助OEM显示错误的解决方案，问题描述如下：
DB VERSION:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0   RAC
OS:OEL 5.8

/home/oracle/.bash_profile:
PATH=$PATH:$HOME/bin

export PATH
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/11.2.0/db_1
export ORACLE_UNQNAME=jyzx2
export ORACLE_SID=jyzx2
export ORACLE_TERM=xterm
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

/home/grid/.bash_profile:
PATH=$PATH:$HOME/bin

export PATH
export ORACLE_SID=+ASM2
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/11.2.0/grid
export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"
export PATH=$ORACLE_HOME/bin:$PATH
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

OEM显示截图：

OEM的trace文件：

Maclean Liu(刘相兵

ODM FINDING:

EM Database Control Performance Page displays error : java.lang.Exception: Invalid BoundDataSource: no class, method or dataSource provided

Enterprise Manager 10g Database Control version 10.2 fails to display the Performance page charts such as CPU Load and Memory Utilization

In their place is an error of the form:
Error

Unhandled exception during generation of chart <chart_name>.
1. java.lang.Exception: Invalid BoundDataSource: no class, method or dataSource provided.
2. at

oracle.sysman.emSDK.chart.EmChartBoundDataSourceBean.initDataSource(EmChartBoundDataSourceBean.java:97)
Cause

Bug 5467238 JAVA.LANG.EXCEPTION , ON OPEN HOST PERFORMANCE PAGE IN DBCONSOLE

This Bug causes the hostname to be truncated in the URL that is created to display the Performance page.

This can be verified by checking the emoms.trc file for the database control application which will have the following errors if hitting this Bug:
<timestamp>
[EMUI_07_34_22_/console/monitoring/hostSummary$pageType=current$selTab=1$target=<truncated_hostname>
....$type=host] ERROR host.HostSummaryDataObject
getHostSummary.588 - ORA-20206:
ORA-6512: at "SYSMAN.EMD_MNTR_HOST", line 342
ORA-1403: no data found
ORA-6512: at line 1


NOTE: There are several issues that may occur if you use a Hostname that has more than 32 characters.  Please see the referenced Notes for details.
Solution

Workaround 1: Recreate Database Control to use the hosts shortname for the hostname instead of the FQDN.

1. Drop the current database control application and repository:
set|export ORACLE_SID=<database_sid>
set|export ORACLE_HOME=<oracle_home>
cd to ORACLE_HOME/bin
./emca -deconfig dbcontrol db -repos drop
NOTE: The previous command quiesces the database for a short time and so will need to be done during a maintenance window or at a time of low system activity.


2. Create a database control application using the shortname of the host.
set|export ORACLE_HOSTNAME=<shortname>
./emca -config dbcontrol db -repos create


NOTE: The ORACLE_HOSTNAME parameter will have to be set in the environment in order to start and
stop Database Control successfully. This may be added to the Environment Section in Windows if
the DBCONTROL service fails to start.


Workaround 2: Manually fix the URL that is generated when accessing the performance page by completing the hostname.

e.g change "target=<truncated_hostname>...." to "target=<full_hostname>" in the URL of the page
that shows the error.

Maclean Liu(刘相兵

workaround

如上述操作 ，重建em repos 可以绕过该问题

dada_base

谢谢ML 今天下班时间测试下

dada_base

经尝试仍然失败，在测试过程中发现EM出现显示错误的原因可能完全不是上述原因导致，经检测RAC的监听的管理用户是GRID用户，bin路径：/u01/app/11.2.0/grid/bin/lsnrctl：
[oracle@jyptdb2 ~]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 13-NOV-2013 18:27:41

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-01190: The user is not authorized to execute the requested listener command

/////////////////////////////////////////////////////////////////////////////////////////////
[grid@jyptdb2 ~]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 13-NOV-2013 18:31:26

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
The command completed successfully

请问ML，这种情况下我该如何处理，是否应该重新建listener？

另：在重建EM的过程中，数据库并没有处在静默模式，尚不知原因：

SQL> select status,active_state from v$instance;

STATUS       ACTIVE_ST
------------ ---------
OPEN         NORMAL

dada_base

重建EM的时候，报了一个warning，如下：
Do you wish to continue? [yes(Y)/no(N)]: y
Nov 13, 2013 6:13:58 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/jyzx/emca_2013_11_13_18_13_10.log.
Nov 13, 2013 6:13:59 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Nov 13, 2013 6:22:07 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Nov 13, 2013 6:22:10 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Nov 13, 2013 6:23:24 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Nov 13, 2013 6:23:24 PM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for jyptdb2.gzcepc.com
Nov 13, 2013 6:23:26 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Nov 13, 2013 6:23:33 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Nov 13, 2013 6:23:33 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Nov 13, 2013 6:23:56 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Nov 13, 2013 6:23:56 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://jyptdb2.gzcepc.com:1158/em <<<<<<<<<<<
Nov 13, 2013 6:23:58 PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************  WARNING  ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: /u01/app/oracle/11.2.0/db_1/jyptdb2_jyzx/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost.

Maclean Liu(刘相兵

应当是配置文件有问题， 例如sqlnet.ora 和listener.ora 或者权限