Real Application Cluster Acronyms GCS Global Cache Services in memory database containing current locks and awaiting locks, also known as PCM GES Global Enqueue Services coordinates the requests of all …
Read More »Multi-tenant container database architecture in Oracle Database 12cr1
Multi-tenant container database architecture in Oracle Database 12cr1 The Oracle Database 12c Release1 introduced the Oracle Multi-tenant architecture, which allowed consolidation of multiple pluggable databases (PDBs) together in a multi-tenant container …
Read More »ORA-16038: log cannot be archived ORA-19809: limit exceeded forrecovery files
ERROR ARC3: Error 19809 Creating archive log file to ‘+DISKS’ Errors in file /u01/oracle/diag/rdbms/orcl/orcl/trace/orcl_arc1_6598.trc: ORA-19815: WARNING: db_recovery_file_dest_size of 42687547752 bytes is 100.00% used, and has 0 remaining bytes available. …
Read More »ORA-03113: END-OF-FILE ON COMMUNICATION CHANNEL
ERROR SQL> connect / as sysdba Connected to an idle instance. SQL> startup; ORACLE instance started.
Read More »ORA-01586: database must be mounted EXCLUSIVE and not open for this operation
ERROR ORA-01586: database must be mounted EXCLUSIVE and not open for this operation
Read More »ORA-02082: a loopback database link must have a connection qualifier
ERROR ORA-02082: a loopback database link must have a connection qualifier
Read More »ORA-29532: Java call terminated by uncaught Java exception: java.security.AccessControlException
ERROR ORA-29532: Java call terminated by uncaught Java exception: java.security.AccessControlException
Read More »rlwrap: error: Cannot execute sqlplus: No such file or directory
ERROR $ sqlplus / as sysdba rlwrap: error: Cannot execute sqlplus: No such file or directory SOLUTION Add the following to the environment file: export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib …
Read More »ERROR ORA-00020 maximum number of processes (%s) exceeded
ERROR ERROR ORA-00020 maximum number of processes (%s) exceeded
Read More »ORA-12645 Parameter does not exist, Oracle error code
ERROR Translation of the error message from Oracle’s support site: ORA-12645: Parameter does not exist. Cause: A sqlnet.ora parameter from which a value was needed does not exist. Action: Set …
Read More »