Oracle Senior DBA Group

Information

Oracle Senior DBA Group

Learn database technology with Oracle Senior DBA Group. The group will feature latest updates, knowledge blogs, events and job postings. Contribute your oracle experience

Website: http://www.oracleconnections.com/
Members: 74
Latest Activity: Nov 30, 2015

Discussion Forum

Oracle DB backup questions

Started by Boyce Helgren. Last reply by Louie Ormand Jan 30, 2014. 1 Reply

Hi All,Sorry if I asked more questions below, please help to understand this.1. I have 2 ora databases in one server, have different SID and TNS.The backup for DB1 with SID1 in rman script is…Continue

Comment Wall

Comment by Dagmar Dubois on January 21, 2014 at 3:43pm

Hi.. when i am log in through PLSQL  developer at that time i am getting error " ORA-28040: NO MATCHING AUTHENTICATION PROTOCOL " Oracle Database 12C Enterprise Edition Release 12.1.0.1.0 - 64bit production Thanks..

Comment by Kory Wass on January 21, 2014 at 3:46pm

What version of JDBC driver you have. It has to be at least 11G JDBC driver.

KW

Comment by Dagmar Dubois on January 21, 2014 at 3:47pm

I have windows8 operating system so JDBC driver is not installed.

Comment by Kory Wass on January 21, 2014 at 3:48pm

Then how do you setup Oracle connection?

KW

Comment by Dagmar Dubois on January 21, 2014 at 3:50pm

Actually it is connecting through sql plus but from plsql developer (third party) it is not connection and showing ORA-28040: NO MATCHING AUTHENTICATION PROTOCOL).

Comment by Kory Wass on January 21, 2014 at 3:53pm

Then, most likely, third party tool is nor certified for 12C/11G. You could try adding SQLNET.ALLOWED_LOGON_VERSION to both client and server side SQLNET.ORA.

KW

Comment by Dagmar Dubois on January 21, 2014 at 3:55pm

we are using plsql developer tool of Allround Automations as well as oracle forms 6i  and after adding SQLNET.ALLOWED_LOGON_VERSION to both client and server side SQLNET.ORA. i am getting same error mesg...

Comment by Quincy Sunday on January 21, 2014 at 3:57pm

using plsql developer tool of Allround Automations as well as oracle forms 6i

You might be using an Oracle 8i client.  It wouldn't be certified with a 12c database.

Comment by Dagmar Dubois on January 21, 2014 at 3:58pm

I am using Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi.

Comment by Quincy Sunday on January 21, 2014 at 4:00pm

Forms 6i doesn't use a 10g client.

 

Check if Allround Automation and Forms 6i are using the same Oracle Client Home or two different Oracle Client Homes.

I presume, then, that Allround Automation is using the 10g client.

Comment

You need to be a member of Oracle Senior DBA Group to add comments!

 

Members (74)

 
 
 

© 2019   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service