OLAP --ODS Error JBOSS 无法启动

  重启机器后,发现可以启动Informatica PowerCenter,但是在HTTPS连接时,无法连上JBOSS。

     查看\informatica\tomcat\node.log 的日志

    

2012-12-14 15:09:12,078 ERROR [main] [PCSF_10375] Failed to fetch [Domain] with error [[informatica][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
].
java.sql.SQLException: [informatica][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress

2012-12-14 15:09:12,078 FATAL [main] [NODE_10026] Unable to load domain [Domain_abc-ed6b3fb4ff4] configuration database because: [[PCSF_10375] Failed to fetch [Domain] with error [[informatica][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
].].
com.informatica.pcsf.common.exception.PCSFConfigException: [PCSF_10375] Failed to fetch [Domain] with error [[informatica][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
].
2012-12-14 15:09:12,078 FATAL [main] [NODE_10026] Unable to load domain [Domain_abc-ed6b3fb4ff4] configuration database because: [[PCSF_10375] Failed to fetch [Domain] with error [[informatica][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
].].
com.informatica.pcsf.common.exception.PCSFConfigException: [PCSF_10375] Failed to fetch [Domain] with error [[informatica][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
].
2012-12-14 15:09:12,078 FATAL [main] [NODE_10016] Node configuration failed to initialize with error: [[PCSF_10375] Failed to fetch [Domain] with error [[informatica][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
].].
com.informatica.pcsf.common.exception.PCSFConfigException: [PCSF_10375] Failed to fetch [Domain] with error [[informatica][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
].
2012-12-14 15:09:12,078 FATAL [main] [NODE_10016] Node configuration failed to initialize with error: [[PCSF_10375] Failed to fetch [Domain] with error [[informatica][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
].].
com.informatica.pcsf.common.exception.PCSFConfigException: [PCSF_10375] Failed to fetch [Domain] with error [[informatica][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
].

    显而易见,ORACLE 无法连接上。再回过头检查ORACLE ,发现ORACLE 实例出于启动状态,但是DATABASE 是shutdown .

   使用命令alter database open; 数据库无法启动,提示redo log 损坏。

  进一步DEBUG 查看alter.log 文件,发现是redo log顺坏的原因是 存储redo.log的磁盘已满,导致无法写。

  重新清理了archive.log 的过期文件。腾出了空间。

 重新启动数据库。  重启启动JBOSS,重启登陆,一切顺利。

posted @ 2012-12-14 15:38  jerry_xing8  阅读(566)  评论(0编辑  收藏  举报