MULTIPLE DATABASES IN A SINGLE ORACLE HOME

/* CREATION OF MULTIPLE DATABASES IN A SINGLE ORACLE HOME*/

step 1: copied the environement file from the target database and modified the ORACLE_SID and ORACLE_BASE .

step 2:created the admin ,oradata and archive directories in the test ORACLE_BASE, also created the physical structure of the database..

$mkdir -m 777 /ora2/test/oradata
$mkdir -m 777 /ora2/test/admin
$mkdir -m 777 /ora2/test/arch
$mkdir -m 777 /ora2/test/oradata/test{sid}
$mkdir -m 777 /ora2/test/admin/test{sid}
$mkdir -m 777 /ora2/test/admin/test/bdump /ora2/test/admin/test/udump /ora2/test/admin/test/cdump


step 3:Copied the target database pfile , modified its name to inittest.ora also changed the necessary parameters

these changes are required in the parameter file..

control_files ='/ora2/test/oradata/test/control01.ctl','/ora2/test/oradata/test/control02.ctl','/ora2/test/oradata/test/control03.ctl'

db_name=test
instance_name=test

also archivelog locations

*.log_archive_dest_1='location=/ora2/test/arch/arch1 MANDATORY'
*.log_archive_dest_2='location=/ora2/test/arch/arch2 MANDATORY'
*.log_archive_dest_3='location=/ora2/test/arch/arch3 MANDATORY'

background dump dest and udump

*.user_dump_dest='/ora2/test/admin/test/udump'
*.background_dump_dest='/ora2/test/admin/test/bdump'

step4 : Run the test environment file

$ .test.env
and then run the DBCA utility to create the new database in the command prompt.

Step5 : Follow the screens and also verify that all initialization parameters are correct

I followed these steps to create databsae by using dbca

Select the operation you want to perform>>>>> create a database
>>>>> general purpose

and it will ask for global database name and oracle sid also it will ask for the default mode of the database ( Shared server or Dedicated Server) and tune the Memory allocations for the database and then create the database .

Step 6: Add temp datafile to the temporary tablespace if necessary .