Setting Up Oracle 9i Instance on Sun Solaris 9

[Dameon2004]

Hi All,

I am New to Sun and I am setting up a LUN, (Clustered)

My Questions is for the Oracle 9 Environment
I have 4 Data Bases to Export and Import from Oracle 8 (HP-UX)

Should each Database be installed on a separate Volume, or can I install all the databases on the same volume?

Please Advise

Thanks

 

[comtec17]

Best practice is to have each database on a seperate LUN and for the index to have a LUN and the Arhive logs with a LUN.

 

[sunbiker]

Are you talking about 4 Database Instances, or 4 complete different databases.

In either case i suggest keept your database files on seperate LUN's or disks for performance reasons.
Technically it will work on one LUN/DISK but this makes no sense because your I-O to that specific LUN will be large and you may observe a loss of performance.

If you are talking of 4 instances you may install the binaries once, an slpit your intance-databasefiles across serveral disks.

 

[Dameon2004]

Thanks for assistance, All done and working well.