还是采用静默安装,手工建库完成后。在安装的OEM的时候一直报这个错误。这里稍微记载以下解决方案:
Database connection through listener failed. Fix the error and run EM Configuration Assistant again. Some of the possible reasons may be: ) Listener port provided is incorrect. Provide the correct port.
) Listener is not up. Start the Listener.
) Database service orcl is not registered with listener. Register the database service.
) Listener is up on physical host and ORACLE_HOSTNAME environment variable is set to virtual host. Unset ORACLE_HOSTNAME environment variable.
) Listener is up on virtual host. Set environment variable ORACLE_HOSTNAME=<virtual host>.
) /etc/hosts does not have correct entry for hostname. Refer to the log file at /u01/app/oracle/10.2./db_2/cfgtoollogs/emca/orcl/emca_2014--29_11---AM.log for more details.
Could not complete the configuration. Refer to the log file at /u01/app/oracle/10.2./db_2/cfgtoollogs/emca/orcl/emca_2014--29_11---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