SSO not working after changind EBS server — Oracle Analytics

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

SSO not working after changind EBS server

Received Response
12
Views
16
Comments
Chinmay Joshi
Chinmay Joshi Rank 2 - Community Beginner
edited Aug 13, 2024 6:13PM in Oracle Analytics Cloud and Server

Hi All,

First of all I apologise if I ask something very stupid, as I am very very new to OBIEE world.. So , here is the scenario we recently moved our oracle EBS server from server A to server B. After this move I changed TNS entry for it on OBIEE server and reports are opening correctly . But, direct link from EBS to OBIEE is not opening. If I open OBIEE using IP Address url it is working fine though.

I tried steps from this url :  Integrating with Oracle E-Business Suite Security

But , in step 10.2.3 Updating instanceconfig.xml  where we update server name to new EBS server there is comment : <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->  and indeed after restarting services it is updating this file to use previous EBS server name..

Please help how can I fix this ?

«1

Answers

  • handat
    handat Rank 5 - Community Champion

    You will need to update the hostname from the em console, ie http://hostname.domain:port/em

  • Chinmay Joshi
    Chinmay Joshi Rank 2 - Community Beginner

    can you tell me how to update hostname in there ?

  • handat
    handat Rank 5 - Community Champion

    Login to em console and open the mbean browser which is a representation of the config file. You can update the value from the mbean, see the following document for more details on how to get to the mbean: Configuring the Oracle Business Intelligence System

  • Chinmay Joshi
    Chinmay Joshi Rank 2 - Community Beginner

    If possible can you please provide step by step screenshot for the same ?? I know I am asking for too much, but I am very new in OBIEE and finding pretty difficult to find it out in EM

  • Chinmay Joshi
    Chinmay Joshi Rank 2 - Community Beginner

    Or is it possible to let me know in MBean browser exactly which values I need to change ?? It's a huge list of MBean nodes

  • handat
    handat Rank 5 - Community Champion

    You will need to navigate to oracle.biee.admin, Domain:bifoundation_domain, BIDomain, BIDomain.

    I'm sorry that I cannot be more detailed as I am doing this from memory. I currently do not have access to a system in order to take screenshots.

    Btw, when you were updating instanceconfig.xml, did you shut down the system first or were you editing it while the system was running and restarting it after you made the changes?

  • Chinmay Joshi
    Chinmay Joshi Rank 2 - Community Beginner

    Thanks.. I have gone there but not able to see any attribute to set EBS server name

    pastedImage_0.png

    About instanceconfig.xml update I did it after stopping services and then once I started services it went back to previous state (i.e. with old EBS server name)

  • handat
    handat Rank 5 - Community Champion

    Look under Presentation Server.

  • Chinmay Joshi
    Chinmay Joshi Rank 2 - Community Beginner

    Sorry but nothing in that as well ..

    pastedImage_0.png

  • Shams Abbasi
    Shams Abbasi Rank 5 - Community Champion

    Hello Chinmany,

    quick questions,

    Where are you seeing hostname changes in instanceconfig.xml, can you please attach a screenshot.

    Did yo do changes to authenticationschemas.xml? That is where you have to define the hostname

    for eg:

    <RequestVariable source="cookie" type="auth" nameInSource="xyz"

    biVariableName="NQ_SESSION.ICX_SESSION_COOKIE" />

    Also it is mentioned in the documentation you were following

    Ignore the comment in instanceconfig.xml that says this setting is centrally managed. EBS-ICX must be manually added to the EnabledSchemas element.

    So i dont think you can control it from Enterprise manager.

    Please let me know what changes did you do in authenticationschemas.xml and RPD.