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

Last updated on JANUARY 27, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms