Essbase: How to Connect to Essbase Studio Server When There are Multiple Instances
(Doc ID 2443366.1)
Last updated on MAY 18, 2022
Applies to:
Hyperion Essbase Studio - Version 11.1.2.4.000 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |