‘oracle’ Archives
Installing 10.2.0.5 EM using software-only on 10.2.0.4/11g DB (GUI)
In this article , I will discuss how to install 10.2.0.5 EM Grid using 10.2.0.4 database. This method can also be used with 11g database.When you carry out 10.2.0.1 EM Grid control installation, it creates a 10.1.0.4 Database by default which is no longer supported and [Read More]
Mview Complete Refresh and Atomic_refresh parameter
This post discusses issue faced by me while working on Materialized view (mview) creation at new site(database). Starting Oracle 10g, how atomic_refresh works with complete refresh has undergone a change. Atomic_refresh parameter is to allow either all of the tasks of a [Read More]
CleanUp Temporary Segments Occupying Permanent Tablespace
There are situations when we see “temporary segments” in permanent tablespaces hanging around and not getting cleaned up. These temporary segments in permanent tablespace can be created by DDL operations like CTAS and “alter index..rebuild” because [Read More]
Generating Datapump Export Dump with Dumpfile name Containing Current Date and Time
Few days back I got a request from development team to generate hourly export dumps of few schemas. Following were the requirements: 1. Dumpfile name should contain current date and timestamp information. 2. The generated dumpfile should be moved to a specific location. 3. [Read More]
Link: Best practices for AIX RAC Database on OTN
A new whitepaper has been published on OTN which primarily discusses best practices for AIX 5.2,5.3 and 6.1 for RAC database for avoiding node eviction due to Oprocd. It also mentions recommended AIX VMO parameters and recommended patches for Oracle RAC. You can find the [Read More]
Cloning database..Just do some Post checks !!
Well I will be covering some points which I believe should be part of post checklist for any cloned database environment. This might not be complete list as it contains point which I have encountered or heard of. 1) Change database Name and Database Id You should try to [Read More]
