Cellcli can be used to change e-mail alert settings on cell servers. To find out the current situation: [crayon-67d426a465a2c046626656/] To change: [crayon-67d426a465a32117536988/] …
Read More »ORACLE
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-67d426a465f3b436242205/] 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 »Enterprise Manager OC4J Configuration issue
ERROR : OC4J Configuration issue. <ORACLE_HOME> / oc4j / j2ee / OC4J_DBConsole_ <SERVER> _ <SID> not found. SOLUTION : The passwords of sysman and dbsnmp …
Read More »ORA-01552: cannot use system rollback segment for non-system tablespace ‘XXXX’
The problem was that the UNDO table space had several data files in recover mode. SOLUTION : Problematic files are recovered from backup and …
Read More »RDS to RDS Database Refresh-Oracle
This document covers steps involved in refreshing an Oracle database schema where source and target both are AWS RDS databases Prerequisites: RDS Instances …
Read More »ARCn:Switch failed , ARC1:Switch failed
This error is taken when the archive log target directory is filled in databases that are in archive log mode. SOLUTION: As a solution, …
Read More »