Wednesday, August 20, 2014

Install 10.2.0.5 oracle database on Windows server 2008 R2

Before you install ,You need to do the following changes.

Here in 10g  10.2.0.4 goes as a base cut. No need to install 10.2.0.1
Then you can  apply the patch for 10.2.0.5 


Before you Install the 10.2.0.4 you need to edit the following values in the installation 

1. C:\dumps\Oracle 10.2.0.4\database\install\oraparam.ini : 
// Change entry Windows=5.0,5.1,5.2,6.0 to Windows=5.0,5.1,5.2,6.0,6.1

2. C:\dumps\Oracle 10.2.0.4\database\stage\prereq\db\refhost.xml:  
//Include a tag for 6.1 also.

3. C:\dumps\Oracle 10.2.0.4\database\stage\prereq\db_prereqs\db\refhost.xml: 
//Include a tag for 6.1 also.s

Friday, August 1, 2014

Exporting data with expdp utility

Exporting Data from the database using expdp utility.This Expdp was developed with Oracle 11g version.

Here we create  only a pointer to a physical directory, creating it does not actually create the physical directory on the file system of the database server.It is a record for a control file.





Grant permission for user to  read and write  from db level.

Then you need to execute the expdp command on  cmd line as follows.