ORACLE DB:MIGRATING DATABASE FROM WINDOW OS TO LINUX OS

MIGRATING DATABASE FROM WINDOW OS TO LINUX RED HAT ENTERPRISE LINUX OS

1. INSTALL RHEL RED HAT ENTERPRISE LINUX    (here we are using RHEL4 EDITION).
2. INSTALL ORACLE ON LINUX OPERATING SYSTEM (here we using ORACLE 9i (9.2.0.4.0))
   (Note :
   some times during installation of oracle on linux when setup start creating DBCA it
   Dissappears and DBCA not fully installed and when you trying to create database through DBCA
   it shows some error related to segmentation fault then use COMMAND
   
   
   export THREADS_FLAG =native
   echo $THREADS_FLAG
   O/P: native)
   
   
   This error can be presolved by mentioning in BASH_PROFILE file when you are creating other parameters in BASH_PROFILE file.
3. CREATE ORACLE DATABASE
        There are two ways to create database on oracle
   (i) MANUALLY DATABASE CREATION.
   See article (Oracle DB: Manually Database Creation in Linux )
   
   
   OR
   
   
   (ii) WITH THE HELP OF DBCA (DATABASE CONFIGURATION ASSISTANT)
   FOR THIS
   (a) TYPE DBCA ON COMMAND LINE AND IT WILL OPEN THE DBCA CONFIGURATION PROMPT AND FOLLOW THE INSTRUCTIONS ACCORDING TO YOUR REQUIREMENT OF DATABASE.
   (b) IF YOU WANT TO CHANGE LOCATION OF YOUR DATAFILES THEN GO FOR THE OPTION NEW DATABASE IN DBCA.
   AND CREATE THE DATABASE.

            IMPORTANT NOTE ABOUT DATABASE CREATION

1. IF YOU WANT TO TAKE BETTER PERFORMANCE FROM DATABASE THEN ALLOCATE YOUR MAJOR DATABASE USERS ON DIFFERENT TABLESPACES
2. CREATE DIFFERENT TABLESPACES FOR INDEXES (FOR MAJOR USERS OF DATABASE).
3. PLACE DATA TABLESPACE SAND INDEX TABLESPACES ON DIFFERENT HARD DISKS.

STEP RELATED TO IMPORTING DATABASE

         4.   AFTER CREATION OF DATABASE IMPORT DATABASE ON NEWLY CREATED DATABASE  WITH THE COMMAND

                                       

                                          IMP 'USERNAME/PASSWORD@DATABASE_NAME'

                                          LOG=IMPORT_LOG.TXT(ANY VALID NAME) FILE=(EXPORT FILE ADDRESS)

                                         OR ANY OTHER IMPORT UTILITY COMMANDS COMBINATION

         5.   AFTER IMPORTING DUMP INTO NEWLY CREATED DATABASE CREATE NEW USERS THEIR PASSWORDS CHANGE ANY EXISTING

                     PARAMETERS WHICH YOU FORGET AT CREATION TIME OR WANT TO ADD NEW PARAMETERS.

                    (Note:

                               when we import our database some time it invalidate the

                               indexes so validating it use SQL query.

                              (ALTER INDEX INDEX_NAME REBUILD)

                              OR

                               validate it with the help of TOAD(right click on index and click rebuild )

           6. MIGRATION OF ORACLE DATABASE FROM WINDOWS OS TO LINUX OS

                   IS COMPLETE.