ORACLE创建OEM是老爱报的错误【weber出品】
2014-10-29 11:48 yaoweber 阅读(1077) 评论(0) 编辑 收藏 举报还是采用静默安装,手工建库完成后。在安装的OEM的时候一直报这个错误。这里稍微记载以下解决方案:
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 /u01/app/oracle/10.2.0/db_2/cfgtoollogs/emca/orcl/emca_2014-10-29_11-33-48-AM.log for more details. Could not complete the configuration. Refer to the log file at /u01/app/oracle/10.2.0/db_2/cfgtoollogs/emca/orcl/emca_2014-10-29_11-33-48-AM.log for more details.
上面提示的1-6条记录分别报的错误解决尝试方法:
1.检查一下$ORACLE_HOME/network/admin/listener.ora里面的端口号是否有正确的设置成1521;
2.检查一下 监听器的状态:lsnrctl status 看一下是否正常启动
3.如果监听器中没有注册orcl这个实例的服务的话需要注册一下。
sqlplus / as sysdba
alter system register
5.就是说监听器只启动在虚拟主机上,这个要查看你的虚拟主机的ORACLE_HOSTNAME,很有可能是你手残一不小心去更改了主机名后导致的错误。
export ORACLE_HOSTNAME= 服务名
6.如果你的服务器是自动获取IP地址的,而你在/etc/hosts下设置的ip地址又是设置成某一个值,一旦IP地址变化了以后就会报这个错误。
ifconfig 查看一下ip地址是多少。
vi /etc/hosts
将里面的ip地址更换一下。
7.如果以上方法都没有用的话,如果报错:用户名密码错误,请先创建口令文件:
orapwd file=$ORACLE_HOME/dbs/orapworcl password=a