Errors/Workarounds11g

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 …

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 …