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 »ORACLE
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 »Enterprise manager : Environment variable ORACLE_UNQNAME not defined
Error: [crayon-676c6cba65396863022370/] Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name. Solution: It should be set as follows. ORACLE_UNQN average = XXXX …
Read More »Hadoop-3.1.0 Multi Node Connection and Configuration in easiest way
HADOOP MULTI NODE INSTALLATION PROCESS [ Note: I am creating multi node in most easiest way by creating and using everything in root mode on …
Read More »ORA-13716: Diagnostic Package License is needed for using this feature
You can get the below error when you run the ADDR AWR report in the Oracle Standard edition database. “ORA-13716: Diagnostic Package License is …
Read More »