In this blog, we will discuss how to resolve the following Oracle Data Pump import error encountered while migrating an AWS RDS Oracle schema backup to Oracle ATP: Although the schema import completed successfully, a few rows failed to import into the table ORAKLDBA.P_ATTD_CONFIG_TAG_DTL. The import log showed the following warning: This issue occurs because … Read more
PRVG-2002 Encountered error in copying file “/etc/nsswitch.conf”: In this article we will discuss about how we can fix the error “PRVG-2002” at runcluvfy.sh execution time. Error: Verifying DNS/NIS name service …FAILEDnode-2: PRVG-2002 : Encountered error in copying file “/etc/nsswitch.conf”from node “node-2” to node “node-1”protocol error: filename does not match request Solution: To resolve this issue … Read more
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
