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 »ORACLE
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-6703f6dda45f8105544086/] Help Command: [crayon-6703f6dda45fc016021331/] 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 »How To Change e-mail Alert Settings on Exadata cell servers
Cellcli can be used to change e-mail alert settings on cell servers. To find out the current situation: [crayon-6703f6dda4b91140455099/] To change: [crayon-6703f6dda4b94553834688/] …
Read More »ORA-04030: out of process memory
ERROR: When a query is executed, an error “ORA-04030: out of process memory when trying to allocate nn kilobytes” is being received. SOLUTION: Decrease pga …
Read More »Oracle IAS BIND (Address already in use)
ERROR: When opmn services are started, the following error is being received. BIND (Address already in use) x.x.x.x: 393478144 – listener BIND failed [crayon-6703f6dda4d5c060960714/] When …
Read More »Ioctl ASYNC_CONFIG error, errno = 1 (HP-UX)
You can encounter this problem on HP-UX platforms. PROBLEM: Many trace files are being created with the error “Ioctl ASYNC_CONFIG error, errno = 1”. …
Read More »ORA-01187 and ORA-01110 errors Regarding Temp Files
Assume that the default temp table space of the system is TMP. ERROR: ORA-01187: can not read from file because it failed verification tests …
Read More »ORA-24247: network access denied by access control list (ACL)
Assume that the user receiving the error is SCOTT. In this case a checklist should be created for the SCOTT user. You can use …
Read More »