Home » RDBMS Server » Server Administration » Configuring a new Solaris server for Oracle 10g (Solaris 10 (OS) 64 bit, Oracle 10.2.0.3)
Configuring a new Solaris server for Oracle 10g [message #322892] Mon, 26 May 2008 12:05 Go to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
Hi,

We have obtained a brand new Sun T1000 server. It has 16 gb ram and two hard disks of 146 GB. I have to work on getting oracle 10g on this. I have to decide on mount points and its sizes. Following is one suggesion:

For Disk 1:
20GB / -- root partition

10GB /tmp

10GB /var

15GB /home

20GB /apps -- application binaries (oracle, etc)

70GB /backup -- backup data

For DISK 2
146GB /oradata -- all oracle db files

Assuming that most of the space (as much as possible) should be left for the database, is this a good design? - I know that redo logs should be spread across disks so that is one thing I know already, any additional suggestions should be very helpful.

Basically for the Solaris OS to work , how much space should be left (in the root, var and other such partiions) is not clear to me.

Thanks,
Nirav




Re: Configuring a new Solaris server for Oracle 10g [message #322896 is a reply to message #322892] Mon, 26 May 2008 14:02 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
I assume this is just a prototype box? If RAID isn't an option for you, then you should also consider multiplexing the control files and, if needed, the archive logs. Depending on how big the database is going to be and how many backups you may want to maintain, the /backup mount may need to be bigger.

Here are the System Requirements and General Disk Space Planning and Recommendations for Solaris 10.
Re: Configuring a new Solaris server for Oracle 10g [message #323142 is a reply to message #322896] Tue, 27 May 2008 07:45 Go to previous messageGo to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
Thank you Ebrian. This is very helpful. A few more questions:

Is it better to have raid -if so what level of raid should we plan for? (This is a server to be used for Development and QA databases.)

Does it help to have index and data tablespaces on different disks?

Thanks,
Nirav
Re: Configuring a new Solaris server for Oracle 10g [message #323153 is a reply to message #323142] Tue, 27 May 2008 08:10 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
With only two drives, your only option would be RAID 1. RAID will at least cover you if one of the drives fails, but effectively cuts your storage capacity in half.

I wouldn't concern yourself with separating the tables and indexes.
Re: Configuring a new Solaris server for Oracle 10g [message #323156 is a reply to message #323153] Tue, 27 May 2008 08:34 Go to previous messageGo to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
Ebrian,

Since with Raid 1 , storage gets halved, and we plan for effective database back ups and this is a Dev and QA environment, so I guess it would be good to avoid Raid 1 and rely on DB backups right? - we want to maximize the space available to dbs...

Thanks again
Nirav

[Updated on: Tue, 27 May 2008 08:36]

Report message to a moderator

Re: Configuring a new Solaris server for Oracle 10g [message #323159 is a reply to message #323156] Tue, 27 May 2008 08:46 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
With two drives your options are very limited. If your database isn't that big, you could still do RAID 1 and have the backups on disk. That way, if one drive fails, you still have your complete system available on the other drive. You could pull out the failed drive and pop in a new drive to automatically rebuild the RAID drives.

It's ultimately going to depend on how big the database currently is or is going to grow to be.

Another option would be to use external storage for the backups.
Previous Topic: checkpoint and redo log files
Next Topic: Session Block
Goto Forum:
  


Current Time: Mon Dec 05 10:54:19 CST 2016

Total time taken to generate the page: 0.11201 seconds