Thank you, Christian. So, is there another way we can think about the problem? Since the instanceconfig solution isn't available, is there some other method we might try that could say "I have two Labs selected over here, and I want those same two Labs to be selected when I click to navigate over there?"

I cannot seem to delete the previous comment (i.e. passwords don't work). Passwords DO work. It would help greatly if I would have typed my password correctly. This WORKS!!

Yeah, I need to keep remembering that, Christian. So, now I'm using the same technique that I used in 11g and 12c on-prem, launching :7001/console, going to Security Realms, myrealm, Migration, Export, and I am exporting the identity store from system #1. Then I'm transferring the generated files to system #2 and doing an…

Ah, very good. I know how to do that. Thanks, Christian.

Because this is OAC, I don't think we have direct access to those parameters. In any event, we would have had no reason to change them from the defaults, and changing those defaults is not part of our standard setup. So I suspect that the answer to your question is "exactly what is shown here". Is there a way for us to…

Thank you. If I may ask you to read the thread entries, you will find that we have already crossed all of those bridges.

Steve, you included 'improper shutdown' as one of the possible issues. I think that is exactly what we have here. Our DBA killed database sessions that were started by the program nqsserver@servername more than 24 hours earlier. It was at that point that the ORA-01012 errors began. (Why did the DBA start killing sessions?…

More information to add: As I mentioned, we initially suspected something wrong with some changes in the repository in the affected subject area, so we uploaded the previous repository. That did not fix the problem. Next, we did a complete restoration from an OAC snapshot that had been created the previous day. After the…

At the present time, I do not have access to the server so that I can see the log files.

That's what it "felt like" to me as well, Gianni. Not the answer I wanted, but I think it's the correct one. Correct Answer awarded. As usual, thank you for your excellence.

Thank you for the information, Sherry. It isn't an answer to my exact question, but it is good to know.

Gianni, I had assumed that the .bar was just a .zip file. But after downloading it, 7-zip says that it is not a valid archive file. 'Can not open ... as an archive'. I have downloaded the snapshot twice - same results.

Thanks for the reply, Gianni. We're OK with a cloud-based answer. For example, if we need to create Oracle Cloud VMs and install OBIEE in them, that's fine. (We're currently using AWS, so it shouldn't be a big deal to just replicate at Oracle). We're just trying to keep the cost down, and Oracle's quote isn't helping. They…

And that complexity is why our Oracle Account Manager has the same question. It SEEMS logical to both of us that the same path should be no big deal, but we are looking for confirmation.

Gianni, I understand where this is going, and I like it. So, the usual download script in my on-prem OBIEE looks like this: call datamodel.cmd downloadrpd -O c:\obiee_12.2.1.2.0_client\bi\bifoundation\server\mystuff.rpd -W Admin123 -U myuid -P mypwd -SI ssi -y I want to run the download from my PC, where I have the Admin…

I would love to close the thread and give you the appropriate credit. The 'Mark as Correct' button is simply not here. 

It appears (in this undocumented system) that the problem was observed and fixed using that double quote. However, I do notice that I need to set the double-quote AND change the database type back to Oracle 11g. Setting the double-quote and leaving the database type set to 12c still throws an error. So, there may be…

Gianni, you are exactly right. I had looked at the database properties yesterday, and I just missed that property. It seems so obvious. THANK YOU!

Thanks, Gianni. I put the code into the column formula as a concatenated string. Works great. Thanks also for the HTML tip. I'm completely unqualified to write HTML, so I mostly do the OBIEE stuff, get the HTML working well enough to get by, and hand it off to someone more knowledgeable about HTML (who rolls his eyes and…

Got it. After I had manually typed the join condition, the little operator field still showed =. I removed everything from the join field, removed the keys from the dimension table in the physical layer, then rebuilt the join by copying/pasting what I had there before, and now the operator shows COMPLEX, and it was…