Essbase: How to Connect to Essbase Studio Server When There are Multiple Instances (Doc ID 2443366.1)

Last updated on APRIL 23, 2021

Applies to:

Goal

The EPM Environment has a Disaster Recovery (DR) Setup for Essbase Studio and there are 2 instances of Studio.  The setup is using catalog authentication as per the alternative solution suggested in Hyperion Shared Services Console Only Displays the First of Multiple Installed and Registered and Working Essbase Studio Servers (Doc ID 2068235.1).  Both instances are configured with the same Shared Services server.

The Shared Services registry has the following entries:

ESSBASE_STUDIO_SERVER (ESSBASE_STUDIO_SERVER)
Object ID:   ####ID
Last Modified Date :   21-Aug-18 12:09:30
Properties:
Property Name    Property Value
ESSBASE_STUDIO_INSTANCE    /Oracle/Middleware/user_projects/StudioDRInstance/BPMS
server.datafile.dir    /Oracle/Middleware/user_projects/StudioDRInstance/BPMS/datafiles
version    11.1.2.0
url    http://server.<Domain_Name>:12081/eas
localhost_name    server.<Domain_Name>.com
catalog.url    oracle://oracle-scan-vip:1531/service_name
catalog.password    
entryPointPath    /eas?op=com.essbase.eas.essbase.defs.awb.AWBCommands.Deploy
instance_home    /Oracle/Middleware/user_projects/StudioDRInstance
server.httpPort    12081
SSL_Port    1985
catalog.username    StudioDR
Product name    Essbase Studio Server
catalog.db    StudioDR
catalog.autoinit    true
server.runInBackground    true
transport.port    5301
server.hss.bpmApplication    BPM:719


ESSBASE_STUDIO_SERVER (ESSBASE_STUDIO_SERVER)
Object ID:   #####ID
Last Modified Date :   23-Oct-15 12:24:53
Properties:
Property Name    Property Value
ESSBASE_STUDIO_INSTANCE    /Oracle/Middleware/user_projects/StudioMainInstance/BPMS
server.datafile.dir    /Oracle/Middleware/user_projects/StudioMainInstance/BPMS/datafiles
version    11.1.2.0
url    http://server.<Domain_Name>:12080/eas
localhost_name    server.<Domain_Name>
catalog.url    oracle://oracle-scan-vip:1531/service_name
catalog.password    
entryPointPath    /eas?op=com.essbase.eas.essbase.defs.awb.AWBCommands.Deploy
instance_home    /Oracle/Middleware/user_projects/StudioMainInstance
server.httpPort    12080
SSL_Port    1985
catalog.username    Studio
Product name    Essbase Studio Server
catalog.db    Studio
catalog.autoinit    true
server.runInBackground    true
transport.port    5300
server.hss.bpmApplication    BPM:719

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.