由于数据库IP发生变化,只在console中修改了数据源中的IP,已经BIEE服务器上的TNS,重启后发现Scheduler及essbaseserver1启动失败,查看日志后发现时ORA-12514错误,修改步骤如下:
1. Scheduler
日志目录为:/u01/biee/instances/instance1/diagnostics/logs/OracleBISchedulerComponent/coreapplication_obisch1/nqscheduler.log
1)打开em,点到coreapplication,锁定和编辑配置 部署-->调度程序,修改IP,点击右上角应用,保存,重启
2. essbaseserver1
日志路径为:/u01/biee/instances/instance1/diagnostics/logs/Essbase/essbaseserver1/essbase/Essbase.log
1) cd /u01/biee/instances/instance1/config/foundation/11.1.2.0
2)备份 reg.properties
3)修改reg.properties
4) 启动essbaseserver1 命令为:./opmnctl restartproc ias-component=essbaseserver1