OBIEE11g: Essbaseserver1 is Down After Changing OBIEE listener Database port in JDBC datasource (Doc ID 1636367.1)

Last updated on AUGUST 10, 2018

Applies to:

Symptoms

The essbaseserver1 is down we change the database listener port in the JDBC datasource.

The output of opmnctl status is shown as below:
Processes in Instance: instance1
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status  
---------------------------------+--------------------+---------+---------
essbasestudio1                   | EssbaseStudio      |   20060 | Alive  
essbaseserver1                   | Essbase            |     N/A | Down    
coreapplication_obiccs1          | OracleBIClusterCo~ |   19883 | Alive  
coreapplication_obisch1          | OracleBIScheduler~ |   19879 | Alive  
coreapplication_obijh1           | OracleBIJavaHostC~ |   19881 | Alive  
coreapplication_obips1           | OracleBIPresentat~ |   19880 | Alive  
coreapplication_obis1            | OracleBIServerCom~ |   19878 | Alive  

Changes

 Steps made in the JDBC datasource.

1. Login to Oracle Weblogic Admin console and navigate to:
--> Home Page
----> Domain Configurations
------> Services
---------> JDBC
-----------> Data Sources
Connection Pool for each Data Sources

2. update the URL property to the new listener port

from 

     jdbc:oracle:thin:@host02:1521/orcl

to

     jdbc:oracle:thin:@host02:1497/orcl

Cause