Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

ONS enabled by default with upgrade to 12.2.1.4

Received Response
194
Views
4
Comments
user2775307
user2775307 Rank 1 - Community Starter
edited Aug 13, 2024 5:24PM in Oracle Analytics Cloud and Server

After upgrading from 12.2.1.2 to v12.2.1.4 I see activity on port 6200 (default port for ONS service) going to Oracle database server (RAC with  ONS service) from my OBEE server. I renamed the ons.jar file on OBIEE apps, restarted the app, but it looks like the ONS is still running.

I compared my old installation 12.2.1.2 ands' see that the ons.jar file is also there, but it was never active/enabled by default. I am trying to disable the ONS serviceon my OBIEE site, but no success. I talked to Oracle support but so far  no much help.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    First let me say that I have no idea of what ONS is as it's related to your DB more than OBIEE ...

    Could it be Weblogic and not OBIEE? Things like what https://blogs.oracle.com/weblogicserver/ons-configuration-in-wls  talks about.

  • Joel Acha
    Joel Acha Rank 8 - Analytics Strategist

    ONS is a Oracle RAC feature (https://docs.oracle.com/cd/E11882_01/java.112/e16548/apxracfan.htm#JJDBC28934 ) which is enabled by default in OBIEE for some odd reason. The workaround is to rename the ons.jar file -

    Oracle Support Document 2318187.1 (OBIEE 12.2.1.3 Installation Failing At Configuration Step with oracle.ons.NoServersAvailable: Subscription time out) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2318187.1

  • user2775307
    user2775307 Rank 1 - Community Starter

    I  did rename the ons.jar file , restarted the OBIEE, but it did not solve the issue. FYI the link in your reply comes from my conversation with Oracle support. To give you more information why is it important  for me to fix the mystery with the ONS service running on my Linux OBIEE server is that there is  firewall between the OBIEE server and the  Oracle server OBIEE connects; port 6200 is not open there. When I use netstat command I see tons of entries from nqsserver on port 6200 in SYN_SENT status , they don't get released. I have two options:  disable the ons on OBIEE part or open port 6200, so the connection can be established. I am thinking that disabling the service wpuld be easier since I don't care much about using ONS. I can't stop running ONS on the Oracle RAC serve since more apps using it. Thank you.

  • Joel Acha
    Joel Acha Rank 8 - Analytics Strategist

    I see. Can you try moving the ons.jar file to a different directory?