Errors/Workarounds10g

ERROR ORA-01586: database must be mounted EXCLUSIVE and not open for this operation

ERROR ORA-02082: a loopback database link must have a connection qualifier

ERROR ORA-29532: Java call terminated by uncaught Java exception: java.security.AccessControlException

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 …

ERROR   ERROR ORA-00020 maximum number of processes (%s) exceeded

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 …

ERROR sqlplus / as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jun 24 12:32:12 2013 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise …

ERROR Enterprise Manager DB Control/DB Console (OEM) is not working after Changing Hostname or IP Address   SOLUTION Step 1. Set $ORACLE_HOSTNAME to the old hostname export ORACLE_HOSTNAME=old_name Step 2. De-configure …

ERROR ORA-39700: database must be opened with upgrade option SOLUTION Step 1: Open with Upgrade Option SQL> startup upgrade;   Step 2: upgrade database – it means run script $ORACLE_HOME/rdbms/admin/catupgrd.sql SQL> …

ERROR CREATE CONTROLFILE ................................. ................................................. CHARACTER SET AL32UTF8; ERROR at line 1: ORA-01503: CREATE CONTROLFILE failed ORA-12720: operation requires database is in EXCLUSIVE mode SOLUTION SQL> alter system set cluster_database=FALSE …