Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
ORA-28040 : No matching authentication protocol (OBBIE 12c Configuration Assistant)
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
Answers
-
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).
0
