The reason we got this error is because the large file tablespace can contain only one data file. ERROR : ORA-32774: More Than One File …
Read More »ORACLE
Recover Drop, Truncate Or Deleted Table With Flashback
In this article, I will talk about how to recover accidentally drop, truncate or deleted table in Production database by using flashback in standby database. …
Read More »Data Pump Architecture
In today’s article, we will be learning about Oracle Data Pump Architecture. It has 4 important components. -expdp (export data pump) -impdp (import data pump) …
Read More »ORA 12638 Credential Retrieval Failed
In today’s article, we will talk about ORA 12638 credential retrieval failed tips. For the solution, we need to make the following change in sqlnet.ora …
Read More »RMAN-06091: No Channel Allocated For Maintenance
In today’s article, I will share the solution of the error given below when the delete obsolete command is run. Error: [crayon-676b009fb109d604203110/] Before deleting crosscheck …
Read More »Performing SwitchOver
In today’s article we will be learning how to Performing SwitchOver. 1. First, we move the logs in our live database. (PRIMARY_1) [crayon-676b009fb1348177244519/] (PRIMARY_2) [crayon-676b009fb134d482247299/] …
Read More »Oracle ORA-00054 Resource Busy And Acquire With Nowait
If you get this error while operating on a table on Oracle Database, it means that the table is being used by someone else. Error: …
Read More »ORA-19599
I will share the solution of the error ORA-19599: block number 2678637 is corrupt in archived log /archive/1_547823_457765345.arc Error : ORA-19599: block number 2678637 is …
Read More »Client Connectivity – RAC
Today we will learn how to Automatically Connect Clients to New Primary in Role Changes (Client Connectivity – RAC). Management of database services in RAC …
Read More »NGINX HTTP Server install
In today’s article, I will talk about the installation and promotion of NGINX HTTP Server on Pardus Server. Nginx was first designed by a Russian …
Read More »