兴趣爱好
重建Oracle EM For EBS R12
Oracle EBS R12.1.1使用的是Oracle Databa 11R1数据库，但是Oracle Databa 11R1无法用像10g
以前的版本那样的通过文件就可以打开alter<SID>.log，只能通过EM查看alter，而在安装EBS R12时，默认是
不安装EM.导致无法查看Alter的信息.下面就介绍如何手工启动EM:
一、检查参数remote_login_passwordfile是否为EXCLUSIVE或SHARED
1).以sys用户登录
$sqlplus /nolog
SQL>conn /as sysdba
2).SQL>show parameter remote_login_passwordfile;
NAME TYPE VALUE
--------------------------- ----------- -----------
remote_login_passwordfile string EXCLUSIVE
3).如果VALUE的值不是EXCLUSIVE，可以用如下的命令修改emote_login_passwordfile的值
SQL>alter system t remote_login_passwordfile='exclusive' scope=spfile;
注：然后重启Databa;
二、检查是否存在用户被授予了sysdba或者sysoper权限
SQL> lect * from v$pwfile_urs;
USERNAME SYSDB SYSOP SYSAS
---------------- ----- ----- -----
SYS TRUE TRUE FALSE
如果全为空，请用如下命令创建密码文件:
orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=sys entries=5;
三、删除默认安装测试版的EM和重建EM
1).Delete DB Control Repository
$emca -deconfig dbcontrol db -repos drop
STARTED EMCA at Mar 19, 2010 10:51:30 AM
EM Configuration Assistant, Version 11.1.0.7.0 Production
Copyright (c) 2003, 2005, Oracle. All rights rerved.
Enter the following information:
金牛座是几月份
Databa SID: <ORACLE_SID>
Listener port number: <ORACLE_PORT>
Password for SYSMAN ur:<sysman passwd>
Do you wish to continue? [yes(Y)/no(N)]: y
…
…
……
2).Delete DB Control Repository Objects Manually
SQL> drop ur sysman cascade;
SQL> drop role MGMT_USER;
SQL> drop ur MGMT_VIEW cascade;
SQL> drop public synonym MGMT_TARGET_BLACKOUTS;
厉害
SQL> drop public synonym SETEMVIEWUSERCONTEXT;
3).create the DB Control Configuration Files and Repository
$emca -config dbcontrol db -repos create
STARTED EMCA at Mar 19, 2010 11:51:30 AM
厦门大学博士
EM Configuration Assistant, Version 11.1.0.7.0 Production
Copyright (c) 2003, 2005, Oracle. All rights rerved.
Enter the following information:
Databa SID: <ORACLE_SID>
神农架好玩吗
Listener port number: <ORACLE_PORT>
Password for SYS ur:<sys passwd>
Password for DBSNMP ur:<sysman passwd>
Password for SYSMAN ur:<sysman passwd>
Password for SYSMAN ur: Email address for notifications (optional):
Outgoing Mail (SMTP) rver for notifications (optional):
-----------------------------------------------------------------
You have specified the following ttings
Databa ORACLE_HOME ................ <ORACLE HOME>
Local hostname ................ <host name>
Listener port number ................ <ORACLE PORT>
Databa SID ..............
.. <ORACLE SID>
Email address for notifications ...............
Outgoing Mail (SMTP) rver for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
……
…
…
四、启动/关闭EM
$emctl start/stop dbconsole
$ emctl start dbconsole
Oracle Enterpri Manager 11g Databa Control Relea 11.1.0.7.0
Copyright (c) 1996, 2008 Oracle Corporation. All rights rerved.
:1158/em/console/aboutApplication
- An instance of Oracle Enterpri Manager 11g Databa Control is already running.
$ emctl stop dbconsole
Oracle Enterpri Manager 11g Databa Control Relea 11.1.0.7.0
Copyright (c) 1996, 2008 Oracle Corporation. All rights rerved.
:1158/em/console/aboutApplication
Stopping Oracle Enterpri Manager 11g Databa Control ...
... Stopped.
You have mail in /usr/spool/mail/root
五、oracle 控制台启动端口修改
$ emca -reconfig ports -dbcontrol_http_port 1159
$ emca -reconfig ports -agent_port 3939
克隆Oracle数据库(已经启用EM)，在异机上复活数据库系统是需要将EM删除，并重建新环境下EM，在操作前需要做如下操作：
1、修改emca文件(/d01/oracle/EBSTST01/db/tech_st/11.1.0/bin)
在emca文件中，将ORACLE_HOME修改实际路径，如下：
ORACLE_HOME="/d01/oracle/EBSTST01/db/tech_st/11.1.0"
2、修改emctl文件(/d01/oracle/EBSTST01/db/tech_st/11.1.0/bin)
在emctl文件中，将ORACLE_HOME及EM_OC4J_HOME修改为实际路径，如下：
ORACLE_HOME=/d01/oracle/EBSTST01/db/tech_st/11.1.0及EM_OC4J_HOME=/d01/oracle/EBSTST01/db/tech_st/11.1.0/oc4j/j2ee/OC4J_DBConsole
问题1：
Sep 11, 2010 4:56:54 PM p.util.PlatformInterface executeCommand
CONFIG: /d01/oracle/EBSTST01/db/tech_st/11.1.0/sysman/admin/scripts/emca/emcaDbUtil[40]: /fin/db/db/tech_st/11.1.0/perl/bin/perl: n
ot found.
Sep 11, 2010 4:56:54 PM p.util.PlatformInterface executeCommand
CONFIG: Error executing /d01/oracle/EBSTST01/db/tech_st/11.1.0/sysman/admin/scripts/emca/emcaDbUtil /d01/oracle/EBSTST01/db/tech_st/
11.1.0/perl/lib:/d01/oracle/EBSTST01/db/tech_st/11.1.0/perl/lib/site_perl:/d01/oracle/EBSTST01/db/tech_st/11.1.0/sysman/admin/script
s:/d01/oracle/EBSTST01/db/tech_st/11.1.0/bin: /fin/db/db/tech_st/11.1.0/perl/bin/perl /d01/oracle/EBSTST01/db/tech_st/11.1.0/sysman/
admin/scripts/emca/emcaDbUtil.pl /d01/oracle/EBSTST01/db/tech_st/11.1.0 EBSTST01 SYS SYSDBA declare repos_pwd varchar2(30); view_u
r varchar2(30); view_ur_pwd varchar2(30); view_ur_acc_status varchar2(30); begin repos_pwd := ?; __view_
ur(view_ur); lect account_status into view_ur_acc_status from sys.dba_urs where upper(urname) = upper ( view_ur ); IF
view_ur_acc_status like '%LOCKED%' THEN execute immediate 'alter ur ' || view_ur || ' account unlock'; END I
F; IF view_ur_ac
c_status like '%EXPIRED%' _view_priv.t_view_ur_creds ( repos_pwd ); _view_priv.GET_VIEW_USER_CREDS (
view_ur, view_ur_pwd ); execute immediate 'alter ur ' || view_ur || ' identified by ' || view_ur_pwd || ''; END IF; end; 1
SYSMAN_PWD
Sep 11, 2010 4:56:54 PM p.EMReposConfig unlockMGMTAccount
CONFIG: Failed to unlock mgmt_view account
Sep 11, 2010 4:56:54 PM p.EMReposConfig invoke
SEVERE: Failed to unlock all EM-related accounts
Sep 11, 2010 4:56:54 PM p.EMConfig perform
SEVERE: Failed to unlock all EM-related accounts
Refer to the log file at /d01/oracle/EBSTST01/db/tech_st/11.1.0/cfgtoollogs/emca/EBSTST01/emca_2010_09_11_16_56_25.log for more deta
小司机儿歌
ils.
Sep 11, 2010 4:56:54 PM p.EMConfig perform
CONFIG: Stack Trace:
p.exception.EMConfigException: Failed to unlock all EM-related accounts
at p.EMReposConfig.invoke(EMReposConfig.java:335)
at p.EMReposConfig.invoke(EMReposConfig.java:147)
at p.EMConfig.perform(EMConfig.java:222)
at p.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
at p.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
at p.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
at p.EMConfigAssistant.main(EMConfigAssistant.java:468)
$
解决方法：
修改emca.properties，具体路径如下：
/d01/oracle/EBSTST01/db/tech_st/11.1.0/sysman/config/emca.properties
将emca.properties文件中PERLBIN修改为如下内容：
PERLBIN=/d01/oracle/EBSTST01/db/tech_st/11.1.0/perl/bin
问题2：
CONFIG: l in
Source location: /fin/db/db/tech_st/11.1.0
Destination : /d01/oracle/EBSTST/db/tech_st/11.1.0/_EBSTST
l...
Sep 14, 2010 11:27:06 AM p.util.PlatformInterface executeCommand
CONFIG: Unable to open /fin/db/db/tech_st/11.1.0/sysman/emd/targets/xml
Sep 14, 2010 11:27:06 AM p.util.PlatformInterface executeCommand
WARNING: Error executing /d01/oracle/EBSTST/db/tech_st/11.1.0/perl/bin/perl /d01/oracle/EBSTST/db/tech_st/11.1.0/bin/targetdeploy.pl /d01/oracle/EBSTST/db/tech_st/11.1.0/_EBSTST EBSTST
Sep 14, 2010 11:27:06 AM p.EMAgentConfig instantiateEMConfigFiles
CONFIG: Failed to deploy state dirs
Sep 14, 2010 11:27:06 AM p.EMConfig perform
SEVERE: Error instantiating EM configuration files
Refer to the log file at /d01/oracle/EBSTST/db/tech_st/11.1.0/cfgtoollogs/emca/EBSTST/emca_2010
_09_14_11_11_20.log for more details.户太八号葡萄
Sep 14, 2010 11:27:06 AM p.EMConfig perform
CONFIG: Stack Trace:
p.exception.EMConfigExcepti
on: Error instantiating EM configuration files
at p.EMAgentConfig.updateAgentConfigFiles(EMAgentConfig.java:3093)
at p.EMAgentConfig.performConfiguration(EMAgentConfig.java:1287)
at p.EMAgentConfig.invoke(EMAgentConfig.java:252)
at p.EMAgentConfig.invoke(EMAgentConfig.java:230)
at p.EMConfig.perform(EMConfig.java:226)
at p.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
at p.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
at p.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)溺爱的近义词
at p.EMConfigAssistant.main(EMConfigAssistant.java:468)
解决方法：
找到targetdeploy.pl，具体路径如下：
/d01/oracle/EBSTST/db/tech_st/11.1.0/bin/targetdeploy.pl
将targetdeploy.pl文件中$ORACLE_HOME修改为如下内容：
$ORACLE_HOME="/d01/oracle/EBSTST01/db/tech_st/11.1.0";
