Forum Stats

  • 3,770,408 Users
  • 2,253,104 Discussions
  • 7,875,445 Comments

Discussions

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.

Tagged: