Unable to connect catalog manager in 11g

User_IS9SB

Server version - Build: 11.1.1.7.1.BISERVER_11.1.1.7.0BIBP_LINUX.X64_150103.1212

We installed BI Admin tool - 11.1.1.9.0 version, since the version 11.1.1.7.0(installed in older machine) is not compatible with Windows2019 OS.

We don't have any issues in connecting administrator tool.through both online and offline.

But facing issues while connecting through catalog manager and getting below error.

We referred to the oracle document(Doc ID 2417977.1) and followed the steps, but still getting the error.

Steps:

The online Catalog Manager might fail to connect to Oracle BI Presentation Services when the HTTP Web server for Oracle BI is enabled for SSL. You must import the SSL server certificate or CA certificate from the Web server into the Java
Keystore of the JVM that is specified by the system JAVA_HOME variable.
To import the exported Web server certificate to Java's default truststore:

1. Navigate to Java's default trust store located at JAVA_HOME/jre/lib/security. For example, <MW_HOME>\jrocket_160_17_R28.0.0-679\jre\lib\security. The default trust store is named cacerts.

2. Copy the certificate exported from the Web server to the same location as Java's default truststore.

3. Execute the command to import the certificate to the default truststore:
keytool -import -trustcacerts -alias bicert -file $WebServerCertFilename -keystore cacerts -storetype JKS
where the Web server certificate file $WebserverCertFilename is imported into Java's default trust store named cacerts under an alias of bicert.
For example if using the Oracle WebLogic Server default demonstration certificate, then use the full path to the certificate located in <WLS_HOME>/server/lib/CertGenCA.der.

4. Restart Catalog Manager.

Note: You must start Catalog Manager using the secure HTTPS URL.

After restarted and used the URL with https, getting below error.

For the above error, oracle suggested the document (Doc ID 2010444.1), which also has the same steps.

Can you please let us know if any configurations need to be modified or components need to be added.

Thanks in advance!!

Gianni Ceresa

Hi,

You seem to be mixing all the possible existing versions of OBIEE. You just need to add some "solution" for a 10g issue and one for OAC and you are good

You can't freely mix versions!

The admin tool can open on older version of the RPD (between 11.1.1.7 and 11.1.1.9), but you can't save the RPD or edit it. If you do, the OBIEE server will not accept it anymore as it will be flagged as a 11.1.1.9 file and a 11.1.1.7 server can't accept it.

The Catalog Manager use the WSDL webservice heavily.

The error message you are getting is that your Catalog Manager try to use v10 of the WSDL, but 11.1.1.7 comes with up to v7 or v8 at the best (can't remember exactly).

You are doing everything to get tons of issues and kill your 11.1.1.7 OBIEE server.

The easy, simple, supported, suggested way to do is to use a VM where you install the right OS to be able to use the 11.1.1.7 client tools.

11.1.1.7 is extremely old and not supported anymore, that's for a reason. You can't expect Windows 2019 to be supported for a product released in 2013.

User_IS9SB

thanks for your quick reply Gianni.

which recent OS recommended to use the 11.1.1.7.0?

Gianni Ceresa

Based on the certification matrix Windows 7 or Windows 2008 R2. As you can see "recent" isn't really a thing: old tool = old OS.

User_IS9SB

Thanks for valuable reply Gianni.

One more thing, i can able to open the same 11.1.1.7.0 RPD in online mode in 12.2.1.1.0 and able to access the layers. is there any impact or will it create any issue? also is there any difference opening 11g RPD in 12c version? will i miss any functions?

Gianni Ceresa

I would avoid opening it in online mode. Download the RPD and open it offline as you are using a different version of the Admintool. If by mistake you edit/save/commit back in the RPD and it is really performed, your BI server will for sure not start anymore next time you start it, and will also probably stop working right after the commit as the RPD isn't compatible anymore.

I would really take a safer approach of downloading the RPD and opening it offline as you anyway can't change it with any other Admintool than the exact 11.1.1.7 coming with your server.

There are some changes in 12c compared to 11g, but you will probably still be able to see everything you look for. The function you miss is that you can't change that RPD: if you do, your server doesn't accept it anymore.

User_IS9SB

thank you for your clarification.

As you suggested, windows 7 or windows 2008R2 would be compatible for 11.1.1.7.0 and we usually connecting through RDC(remote desktop cooncetion) to windows 2008R2 and it is going to be decommissioned and replacing the server with windows2019 OS, however it is not compatible.So we have only option to request them for windows 2012 server.

My question here, will same BI version should work in Windows2012?

Gianni Ceresa

The certification matrix (https://www.oracle.com/technetwork/middleware/bi/bi-11gr1certmatrix-ps6-1928219.xls ) doesn't mention Windows 2012 as a supported OS for the client of 11.1.1.7.

If you want an official answer on it you could try asking Oracle with a SR.

You can stick to your Windows 2019 install, but run a VM inside it with the old OS just for the client tools. That's the easier way to do things...

User_IS9SB

yes gianni.. have checked in oracle certifications matrix.. can you please confirm is this right one?

for reference, https://support.oracle.com/epmos/faces/CertifyResults?_adf.ctrl-state=5zjzbv26p_4&searchCtx=st%255EANY%257Cpa%255Epi%255…

Gianni Ceresa

Look at the Excel file I linked above. There is a sheet for "System" which is for the server, and that one mention Windows 2012. There is another sheet for "Client System" which explicitly mention the Administration Tool and the Catalog Manager and there Windows 2012 isn't listed at all.

The server is one thing, the clients are something else.

The Excel is more detailed in the split between the various certified things compared to your link which doesn't say much.

Does it means Windows 2012 doesn't work? No idea, I'm not Oracle and I don't have a Windows 2012 where I try to install the 11.1.1.7 clients

Install it and try to use it: if it works you are good to go. For example if you try to install on Windows 10 it will work, but when you try to open the Admin Tool it will take 30-40 minutes and once open nothing will work.

It isn't a server which strictly must be certified, the client either work or not in the end ...