ORA-28040 : No matching authentication protocol (OBBIE 12c Configuration Assistant)

user8415568

I have installed Oracle 12c database in  VM-1(Oracle Linux), and trying to install OBIEE 12.2.1 in another VM-2. I am able to connect oracle database from VM-2 and successfully create RCU. When i run OBIEE 12c configuration vizard, and select create or use existing schema with all correct information, i am not able to connect database. It throwing error "ORA-28040" No matching authentication protocol.

Following  is page where i am not able to connect database.

Share the solution if you know...

Thanks in advance,

Message was edited by: user8415568

Gianni Ceresa

Hi,

Apparently it's the DB not accepting connection using an old JDBC driver (what the installer does).

There is a setting you can set on the DB server (in the sqlnet.ora file) to allow older clients too.

Have a look at https://docs.oracle.com/database/121/NETRF/sqlnet.htm#NETRF2016  and ORA-28040: No matching authentication protocol after upgrade to 12c - Red Stack Tech ,  it can maybe give you a working solution (even if done just for the time of the configuration).

Just to know, what exact version of the DB you installed? Standard install or you configured things yourself in detail? With 12.1.0.2 never had a single issue, never saw that. With 12.2 I saw on the forum somewhere that it was a bit more problematic (and 12.2 isn't a certified database for now).