Oracle Database Material

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 …

 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 …

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 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 …

Today we will learn how to install Oracle Database Release 12.2.0.1 on Oracle Enterprise Linux(OEL) 6.4 First download the media from below given link: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html For creating a Virtual machine …

Installation Of  Oracle Database Release 11.2.0.3 on Oracle Enterprise Linux(OEL) 6.4   First download the media from below given link: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html For creating a Virtual machine kindly refer to the …