What is happening is you have people using HSGETVALUES in spreadsheets and they are pulling a crazy amount of cells. In older provider services each cell uses a port on the server and someone with a large spreadsheet can refresh over and over and over and exhaust all ports on the server (yes it's a really poor design by Oracle in that instance). Newer Provider Services group the calls together and minimize the amount of traffic.
You will need to tune two settings to at least increase the amount of ports and also make those ports be available faster.
Review section 2.1.2 of the document: https://blogs.oracle.com/pa/resource/Oracle_EPM_11_1_2_1_Tuning_Guide_v4.pdf
There is also another setting called TcpTimedWaitDelay which works in conjunction with this. This timed wait delay determines when a port has been closed how long it sits idle. You want to change that to be 30 seconds which is the quickest you can free up a port.
John A. Booth
Scoring disabled. You must be logged in to score posts.