I'm not so familiar with BI Apps. You might want to try Is what you're doing a supported upgrade route? For a three-way merge of this type you'd usually use a common parent, rather than blank, as the original RPD, so that the admin tool can establish correct lineage and commonalities.

What are the RPDs that you're actually trying to merge? Is it a genuine three-way merge, or just two RPDs with content that you want to merge together?

we could not keep the old IP for the machine.Need to change the host name on the server for our OBIEE 12 c platform Change the IP? OK, I guess. But change the host name ... isn't that one of the points of host names; that they allow you to refer to the host rather than the IP? Basically : can't you just update your DNS for…

Even if it's just the logo, you should deploy a custom skin in order that the customisation doesn't get lost in future upgrades/patches. The only reliable, documented, supported way to do it is through a custom skin. Specific documentation for 11.1.1.9:…

It's not "normal functionality" for OBIEE to be slow, no. It's a pretty broad question you're asking. I'd start here: https://www.rittmanmead.com/blog/2016/10/all-you-ever-wanted-to-know-about-obiee-performance-but-were-too-afraid-to-ask/

Maybe eDelivery. But seriously, why are you even trying to install something that is waaaaay out of support and years old? Since .5 there's been .7 (heading for end of support) and .9, plus 12c.

You should only need log level 2 to see physical query. Have you checked the nqquery.log file directly on disk?

this happens to only one user, which is why i am sceptical in updating to the version 11.1.1.6.7 @Andrew Fomin. has nailed it in terms of the issue you face. But, I just wanted to point out, echoing what Andrew said -- 11.1.1.6 is OLD. It's out of support, it's got several published CVE vulnerabilities, it's going to work…

Have you considered Oracle's Data Visualization Desktop tool? Could be a good fit, depending on how wide your user base is etc.

Can you get netcat (or similar) on Windows, and try connecting to the Oracle listener port directly from your windows server? That way you can at least isolate the problem to within OBIEE or within the virtualisation platform Can you ping unknownhost.example.com from your Windows machine? What about accessing it with SQL…

What's your virtualisation platform? How are you trying to connect from VA to the database? Does it work via the subject areas from VA? What's in the bi-server1 logfile? Can you get netcat (or similar) on Windows, and try connecting to the Oracle listener port directly from your windows server? That way you can at least…

Amen, @Christian Berg. @Rahul Huilgol Step away from the SQL, and into the world of logical modelling and RPDs. Only then, may you look at the SQL

You can see for sure by running your query with LOGLEVEL=2 and inspecting the query sent to the database in obis1-query.log

Before I give you what I think is the answer, let me pose a question of my own : did you try it? It's very easy to observe what's happening, by looking at the obis1-query log and Usage Tracking (how many rows returned from DB) and AdminTool (how many rows in the cache). So my answer (based on informed guesses - I have not…

If you're looking to do performance comparison then having 11g running at the same time wouldn't be valid. And if it's not running, then port clashes isn't an issue. I wouldn't share your view that OBIEE on VMs runs more slowly. I think that is just an issue with how the VMs are provisioned and/or configured on the host…

Assuming it's Linux, if you avoid port clashes, install in separate folders, use separate RCU schemas, and the server has the grunt available - no reason why it shouldn't. But, for just testing, a VM (e.g. SampleApp) would be a whole bunch easier & safer, and you can run it anyway, no need for a server (just 6-8GB on a…

+1 to @Michael Verzijl. Never delete your Usage Tracking data. Partition it to make it more manageable if you have to, archive it off to cold storage if you must - but don't delete it. It gives you so much useful information about who and how your system is used over time.

+1 to @Gianni Ceresa. Any mature software development practice should be using source control and automated deployments. Totally possible, and easy, with OBIEE, whether 11g or 12c.

BI Publisher yes, OBIEE no.

1. Is this a single BI domain, clustered across two nodes? 2. On node 2, what is CatalogPath set to in instanceconfig.xml? 3. Is the folder mounted on each node at the same filesystem point?