ORA-19809: limit exceeded for recovery files: In this article we will be discuss about the ORA-19809: limit exceeded for recovery files. This same solution is also working for the error ORA-00257: archiver error. Connect internal only, until freed. Error: Cause: db_recovery_file_dest_size used space was filled. Solution: Check the db_recovery_file_dest_size value and the space usage in … Read more
ORA-01274: cannot add data file that was originally created as: In this paragraph i will discuss about ORA-01274 database error. When you getting ORA-01274 error follow below steps to resolve the issue. Problem: After adding a datafile in primary database, recovery process in standby database stopped with below error. Primary Side: After adding a datafile … Read more
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: 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 ‘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
