Home / Oracle Database Material (page 5)

Oracle Database Material

What is the location of alert.log file in Oracle Database 11g?

 What is the location of alert.log file in Oracle Database 11g? SQL> select value from v$parameter where name='background_dump_dest'; VALUE -------------------------------------------------------------------------------- /u0/app/oracle/diag/rdbms/orcl/orcl/trace $ cd /u0/app/oracle/diag/rdbms/orcl/orcl/trace $ ls alert_orcl.log orcl_j001_25686.trm orcl_ora_20641.trc or …

Read More »

could not validate asmsnmp password due to following errorora-01031:insufficent privileges

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 …

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 »