Database Reference
In-Depth Information
Table 1.5
Ports and Their Use
Major Version
Process
Default Port
Notes
ALL
ESSBASE
1423
• Port must be opened on firewall in order
for Essbase add-in to connect.
ALL
ESSSvr
32768-33768
• one process for each application.
Databases within applications all share
the same application process memory
space.
• Port must be opened on firewall in order
for Essbase add-in to connect.
• two consecutive ports will be used for
each application. you may change the
default starting and ending ports with
the essbase.cfg SErvErPortBEgIn
and SErvErPortEnD parameters.
6+
olapisrv
3388
• Essbase Integration Services is
commonly used to build cubes from star
schemas and/or provide drill-back to
relational tables.
11.1+
startServer
5300, 9080
• Beginning in 11.1.2 EPmA deployments
of cubes make use of Studio. 11.1.2.0
Studio used Sun Jvm, 11.1.2.1 Studio
begins using JroCkIt.
9.2-11.1.1
openldap
58089 (9.x)
28089 (11.x)
• open LDAP databases can become
corrupt if machine is not shutdown
properly or the process is terminated.
recovery procedures are documented in
oracle EPm guides. Corruption will
prevent Shared Services from starting.
11.1.2+
opmn
6711, 6712
• Starting in 11.1.2 oracle Process
manager monitors and starts Essbase
• review the file console~Essbase1~Essba
seAgent~AgEnt~1.log in cases where
Essbase will not start.
• This log file resides at: <EPmSyStEm>/
diagnostics/logs/oPmn/opmn
SErvErthrEADS setting list below, 60 mb of memory will be used for threads on
each ESSSvr process.
I treat the below configuration file (essbase.cfg) values as starting points.
SErvErtrhEADS should be the only value you need to increase on very large busy
applications.
; Number of threads each ESSSVR process is allocated.
SERVERTHREADS 100
; Number of threads ESSBASE is allocated
AGENTTHREADS 25
; Number of login requests - this value should never be above 10
AGTSVRCONNECTIONS 10
