Errors/Workarounds11g

ERROR SQL> connect / as sysdba Connected to an idle instance. SQL> startup; ORACLE instance started.

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 SQL> startup nomount; ORA-00845: MEMORY_TARGET not supported on this system SOLUTION [oracle@oel6 ~]$ df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg_oel6-lv_root 43G 15G 26G 37% / tmpfs …

ERROR startup of ASM instance failed with error: ORA-01078: failure in processing system parameters ORA-29701: unable to connect to Cluster Synchronization Service SOLUTION check services by command: crs_stat -t Name …

ERROR During Create new database, It shows following errors “could not validate asmsnmp password due to following error ora-01031:insufficent privileges” SOLUTION Step 1. Create Password file for ASM Instance $orapwd file=/u0/app/11.2.0/grid/dbs/orapw+ASM …