HI Guys, We were put in a Situation that we had to Create the New data files for the tablespaces in the RECO diskgroup …
Read More »ORACLE
Correction of Corrupted UNDO tablespace.
If the Oracle UNDO table space is corrupted, it may be possible to get the error as follows. ORA-00376: file string cannot be read …
Read More »AWR baseline drop operation
The generated AWR baselines cause the snapshots to be stored, so you will not be allowed to delete old snapshots. Therefore, it is necessary …
Read More »14 Tips for upgrading Oracle RAC from 11g to 12c
Note: These tips were based on upgrades from 11.2.0.4 to 12.1.0.2 (Linux and Solaris ONLY) OS user grid was the “owner” of the Grid …
Read More »Querying Oracle alert.log Errors With SQL Query
You can query errors in Alert.log by sql query. You can use the following queries for this. The following query returns with 20 rows. …
Read More »ORA-04031 Unable To Allocate 720 Bytes of Shared Memory
The error ORA-04031 occurs on the shared pool which can indicate one of two things: 1) Insufficient space for the shared pool OR 2) …
Read More »Oracle Data Pump (expdp and impdp)
Oracle data pump is new version of imp and exp utilities. It is faster and flexible to the imp and exp utilities used in previous Oracle …
Read More »Reconfiguring Grid Infrastructure Components
If you have cloned an existing server as another server, even if ASM disks and all files are moved, then services like ohas css …
Read More »How To Cancel Concurrent Request from Back End
There are 2 Steps for Cancelling Concurrent Request from Back End : Step 1 :- 1. Run the below SQL query. Give the …
Read More »Exadata cell server ORA-700 ORA-600
For disk errors such as ORA-700 or ORA-600 on the cell server, first check whether there is a physical fault. If there is a …
Read More »