OraFAQ Forum: Server Administration » Configuring a new Solaris server for Oracle 10g

Home » RDBMS Server » Server Administration » Configuring a new Solaris server for Oracle 10g (Solaris 10 (OS) 64 bit, Oracle 10.2.0.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Configuring a new Solaris server for Oracle 10g [message #322892]

Mon, 26 May 2008 12:05

orausern
Messages: 826
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

Report message to a moderator

Re: Configuring a new Solaris server for Oracle 10g [message #322896 is a reply to message #322892]

Mon, 26 May 2008 14:02

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.

Report message to a moderator

Re: Configuring a new Solaris server for Oracle 10g [message #323142 is a reply to message #322896]

Tue, 27 May 2008 07:45

orausern
Messages: 826
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

Report message to a moderator

Re: Configuring a new Solaris server for Oracle 10g [message #323153 is a reply to message #323142]

Tue, 27 May 2008 08:10

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.

Report message to a moderator

Re: Configuring a new Solaris server for Oracle 10g [message #323156 is a reply to message #323153]

Tue, 27 May 2008 08:34

orausern
Messages: 826
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

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.

Report message to a moderator

Previous Topic:	checkpoint and redo log files
Next Topic:	Session Block

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 06 14:02:54 CDT 2024