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 »ORACLE
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 »Configuration of RMAN using Oracle 10g
There are many ways to setup the RMAN. Here i am using the separete database to store backup catalog information with windows Server 2008 …
Read More »Cellcli Commands
In this article we have examined many of CellCLI commands. CellCLI — Cell Command Line Interpreter (Exadata) [crayon-67d4245a12816752068915/] Help Command: [crayon-67d4245a1281e500137332/] Commands for obtaining …
Read More »Steps to implement Oracle Fine Grained Auditing (FGA)
Guarantee security on Data is a key element and auditing is one of them. FGA provides a flexible way to achive this goal. With …
Read More »