Posts Tagged ‘oracle’
1:访问EM 2:由于在运行大数据量操作时,db_recovery_file_dest目录被急剧增加的归档占满,em报出archiver在归档日志的时候出错 3:用rmam,delete noprompt archivelog all;(说明测试数据库所以归档日志不重要可以删除) 3:继续访问EM,无法成功,报错信息如下 Enterprise Manager is not able to connect to the database instance. The state of the components are listed below. Details Archiver is unable to archive a redo log because the output device is full or unavailable. 还提示是否需要进行实例恢复 4:原以为真是数据库实例出了问题,重新sqlplus 访问并检查数据状态,发现是正常的 5:只好重启一下em了,emctl stop dbconsole然后emctl start dbconsole以后,访问em的地址就正常了 6:看来em这块功能还是有些不够完好。
Status Open But Unavailable
Host localhost.localdomain
Port 1521
SID test
Oracle Home /oracle/product/10.2.0/db_1
The instance is open.
Tags: oracle