Categories
OBIEE 12C connect string update
Hi Everyone,
I hope this is the right place to ask this question.
OBIEE12C
FMW 12.2.1.3.0
BI Platform 12.2.1.4.0
JDK: 8u251
OS: RHEL 7.8
DB: Oracle 12C
We replace our old OBIEE 11G with OBIEE 12C about a month ago, when we did the install we used the connection format example in the Graphical Installer to our then active DB, e.g server2:port:service_name.
After the install we updated the connection string for all the data sources to use the TNS type connection string so that we can use the Data Guard failover e.g.
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=server1.corp)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=server2.corp)(PORT=1521))(FAILOVER=on))(CONNECT_DATA=(SERVICE_NAME=db-service_name)(SERVER=DEDICATED)(FAILOVER_MODE=(TYPE=select)(METHOD=basic))))
Last night we wanted to failover to server1 so that we can get some maintenance done on server2. After the failover we test PDF generation from our application and it failed, we tried to restart the OBIEE and at first noticed this error:
Received error message from Node Manager Server: [Server start command for OBISCH server 'obisch1' failed due to: [Server failed to start up but Node Manager was not aware of the reason]. Please check Node Manager log and/or server 'obisch1' log for detailed information.]. Please check Node Manager log for details.
Failure to start one or more ManagedServers and or Components
Fatal: Failed to start one or more Servers (return 3)
Then further back in the startup sequence we noticed this error message:
Received error message from Node Manager Server: [Server start command for OBIS server 'obis1' failed due to: [Unexpected exception from Plugin: java.lang.RuntimeException: Failed to get environment
Unable to obtain Jdbc connection from DataSource
------------------------------------------------
SQL State : 08006
Error Code : 12514
Message : Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
At this point our application has failed over to the DB on server and we had no other errors. Only OBIEE did not start up.
I then did a grep through the config files in Oracle home and found the old config in the below two files.
user_projects/domains/nemo_bi/config/fmwconfig/jps-config-jse.xml
user_projects/domains/nemo_bi/config/fmwconfig/jps-config.xml
I manually edited the file to have the correct server details, trying both the TNS connection string style as well as the hostname:port:service_name style of connection string but neither worked.
The only thing that worked was to fail back to the old DB server and then everything started up. Now we in a situation were we cannot do a failover on the DB (Data Guard failover) because we depend on proper working of the OBIEE to generate our PDF files.