ORA-28040: No matching authentication protocol error

ORA-28040: No matching authentication protocol error

ORA-28040: No matching authentication protocol error :- How to resolve ORA-28040 error. After upgrading Oracle database from 11g to 12c or higher version if you facing the same error then follow below steps. SQLNET parameters ALLOWED_LOGON_VERSION_CLIENT & ALLOWED_LOGON_VERSION_SERVER issue in Oracle 12c. Set the value to the minimum authentication protocol allowed while making connection to … Read more

ORA-12154: TNS could not resolve service name

ORA-12154: TNS could not resolve service name

ORA-12154: TNS could not resolve service name: In this article we will see how to resolve this error ORA-12154: TNS could not resolve service name. ORA-12514 is a common error which related to your database tnsnames.ora file and your database name. Solution : Make sure that your listener is listening for the same service name … Read more

ORA-39170: Schema expression does not correspond to any schemas

ORA-39170: Schema expression 'ORAKLDBA' does not correspond to any schemas

ORA-39170: Schema expression ‘ORAKLDBA’ does not correspond to any schemas : We are getting this error when we export/import in oracle. Suppose you need to take export backup of a schema or import dump of a schema which name contains string like, “ORAKLDBA.DB” or “ORAKLDBA$DB“. Some of the Places users are created with “Identified by … Read more