Home / Errors/Workarounds10g (page 2)

Errors/Workarounds10g

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 »

Enterprise Manager DB Control/DB Console (OEM) is not working after Changing Hostname or IP Address

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 …

Read More »

ORA-12720: operation requires database is in EXCLUSIVE mode

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 …

Read More »