oracle 11g OEM配置时碰到的问题

shinee

今天在对至强平台下oracle 11g配置OEM的过程中出现了不成功的现象，OS是redhat 6.0 (2.6.32-100.34.1.el6uek.x86_64)


先用emca -config dbcontrol db -repos create命令创建之后不成功，报错信息如下：
SEVERE: Password file may be missing or configured incorrectly.
通过从网上查看资料，是由于缺少Password file导致的
需要用
orapwd file=%ORACLE_HOME%\database\pwd%ORACLE_SID%.ora password=oracle entries=10 来生成password file
或者用orapwd file=orapwDWDEV password=mypassword entries=10
好吧，我确实照做了..

再用emca -config dbcontrol db -repos recreate重建的时候仍然还是报：
SEVERE: Password file may be missing or configured incorrectly.
创建不成功的错误..

请高手指点一下...

Maclean Liu(刘相兵

/opt/oracle/cfgtoollogs/emca/orcl/emca_2012_05_08_02_42_48.log 也请一并 打包上传

shinee

日志就在附件中...请查收...谢谢..

Maclean Liu(刘相兵

ODM DATA:
CONFIG: isHAInstalled: false
May 8, 2012 2:42:55 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: SID value: orcl


action plan:


ls -l $ORACLE_HOME/dbs

shinee

感谢刘大的回复，结果如下：

[oracle@hpc ~]$ ls -l $ORACLE_HOME/dbs
total 76608
-rw-r----- 1 oracle dba 26564096 May  8 00:37 arch1_118_782692324.dbf
-rw-r----- 1 oracle dba 51762176 May  8 00:37 arch1_119_782692324.dbf
-rw-rw---- 1 oracle dba     1544 May  7 22:27 hc_DBUA0.dat
-rw-rw---- 1 oracle dba     1544 May  8 20:35 hc_orcl.dat
-rw-r--r-- 1 oracle dba     2851 May 15  2009 init.ora
-rw-r----- 1 oracle dba       24 Dec 30 12:34 lkORCL
-rw-r----- 1 oracle dba     1536 May  7 22:31 orapworcl
-rw-r----- 1 oracle dba     2560 May  7 23:03 spfileorcl.ora

Maclean Liu(刘相兵

action plan:


echo $ORACLE_HOME
echo $ORACLE_SID


sqlplus /nolog
conn / as sysdba

show parameter pass

show parameter instance_name


尝试远程登录数据库 这里的orcl是别名 自行修改

sqlplus  sys/oracle@orcl  as sysdba

shinee

这些都没有问题：
[oracle@hpc ~]$ echo $ORACLE_HOME
/opt/oracle/product/11.2.0/db_2
[oracle@hpc ~]$ echo $ORACLE_SID
orcl
SQL> show parameter pass

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
remote_login_passwordfile            string                 SHARED
SQL> show parameter instance_name

NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
instance_name                        string                 orcl

shinee

问题是OEM配置的过程中失败...

Maclean Liu(刘相兵

你的 remote_login_passwordfile   =SHARED

alter system set remote_login_passwordfile=exclusive  scope=spfile;

reboot instance

shinee

通过修改remote_login_passwordfile 解决了  Password file 的问题，但是又有了新的问题：
May 9, 2012 10:35:27 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /opt/oracle/cfgtoollogs/emca/orcl/emca_2012_05_09_22_35_12.log.
May 9, 2012 10:35:27 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
WARNING: ORA-01017: invalid username/password; logon denied
May 9, 2012 10:35:27 PM oracle.sysman.emcp.EMConfig perform
SEVERE:
Database connection through listener failed. Fix the error and run EM Configuration Assistant again.
Some of the possible reasons may be:
1) Listener port 1521 provided is incorrect. Provide the correct port.
2) Listener is not up. Start the Listener.
3) Database service orcl is not registered with listener. Register the database service.
4) Listener is up on physical host and ORACLE_HOSTNAME environment variable is set to virtual host. Unset ORACLE_HOSTNAME environment variable.
5) Listener is up on virtual host. Set environment variable ORACLE_HOSTNAME=<virtual host>.
6) /etc/hosts does not have correct entry for hostname.
Refer to the log file at /opt/oracle/cfgtoollogs/emca/orcl/emca_2012_05_09_22_35_12.log for more details.
Could not complete the configuration. Refer to the log file at /opt/oracle/cfgtoollogs/emca/orcl/emca_2012_05_09_22_35_12.log for more details.
详细的日志请见附件，谢谢。