ORA-845: MEMORY_TARGET not supported on this system

Applies to: Database Management Softwere Oracle 11g std and Enterperise Edition After re size MEMORY_MAX_SIZE, I restart my database and...

PRVE-0029 : Hardware clock synchronization check could not run on node

I have SUSE Linux Enterprise Server 10 SP4  (x86_64) on one of my server. I was trying to install Database Management Softwre Oracle 11.2.0...

Collect stats for Large Partitioned table

Applies to: Database Management Software Oracle 11g all editions A partitioned table of size 70G, When i start gathering stats, it goes ...

Moving between two Oracle Homes

I have two Oracle versions installed on my system. Database Management Software Oracle 11.2.0.1 and Database Management Software Oracle 11...

IMPDP ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified

Applies to: Database Managemet Software Oracle 11g all editions Issue: ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specif...

Oracle 11.2.0.3.0 Release Details

Oracle 11.2.0.3 is availiable as patch " 10404530 ". This can be download from support.oracle.com . Oracle 11.2.0.3 is only availi...

ORA-12162: TNS:net service name is incorrectly specified

[oracle@ oracle]$ sqlplus SQL*Plus: Release 11.2.0.1.0 Production on Tue Oct 11 20:53:19 2011 Copyright (c) 1982, 2009, Oracle.  All ri...

-bash: sqlplus: command not found

Oracle S/W is installed on Unix server, but  below error message is there. [oracle@~]$ sqlplus -bash: sqlplus: command not found Sol...

ORA-2082: a loop-back database link must have a connection qualifier

ORA-2082: a loop-back database link must have a connection qualifier  Description: You are trying to create a database link to the sam...

Unable to Unschedule Propagation. Streams Queue is Invalid ORA-24085

Symptoms Exec dbms_aqadm.unschedule_propagation('STRMADMIN.Q_PLN40_DTD_TRADE','PSGDTD40.WORLD') ERROR at line 1: ORA-2...

RMAN backup & Restoration for Database Upgrade

Steps for RMAN backup & Restoration for Database Upgrade. This document is only to verify Backup & Restoration activity. How to c...

Solaris Basics

How to see RAM size ? bash-3.00$ /usr/sbin/prtconf | head -3 |grep Mem Memory size: 6144 Megabytes Here 6G is the total memory. Ho...

Ora-600 [dbkc_init_bs_ctx-10] Error Found In The Alert Log

Applies to: Oracle Server - Enterprise Edition - Version: 11.1.0.7 - Release: 11.1 Information in this document applies to any ...

What is Android ?

A free open source operating system for mobile devices. Any handset manufacture can install and use it. It includes an operating system...

How to edit/list crontab in Sun Solaris and Unix

In Unix/Linux editing crontab is simple by using crontab –e, but in Solaris this command doesn’t work, Because In Unix default edition is...

Database Startup On Solaris 10 Fails With Ora-27102 Out Of Memory

I have Solaris 10 system with RMAN 16G size. I am starting database with 6G of SGA size but startup fails with the following errors. SQL&g...

Oracle Buys Pillar Data Systems

News Facts: Oracle today announced that it has entered into an agreement to acquire Pillar Data Systems, a leading provider of innovativ...