Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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
