How to configure my SAN with Sun V880 servers to run Oracle 9i


 
Thread Tools Search this Thread
Operating Systems Solaris How to configure my SAN with Sun V880 servers to run Oracle 9i
# 1  
Old 08-13-2005
How to configure my SAN with Sun V880 servers to run Oracle 9i

Hi:

I am in the process of configuring the SAN for Solaris to host 6 oracle 9i databases. We have 30 -146 GB disks stiped with RAID 10 for SAN. Of which 11 are dedicated for databsaes related things. Then we have 2 v880 Sun Servers with 16 -73 GB disks and 24 GB memory.

The questions are:

1) How to associate the indvidual vdisks with the mount points? I am thinking of 12 LUNS for all my databases. Then should I create 12 mountpoints on Solaris servers as well?

I am not too clear as to how to link the SAN configuration with SUN.

Then how owuld I untilize the local disks on Sun box (16 -73 GB disks) to tie in with the SAN?

Thanks for the help


Mahesh
# 2  
Old 08-13-2005
The internal disks in a V880 are on an internal loop, and cannot participate in the SAN.

As for configuring the "SAN", that depends on the actual storage array, switches, & HBA's that you have. Generally speaking you will need to format the parity groups into LDEV's, run fiber, present LUN's to a port, configure LUN security, then configure the zones on the switch. Then assuming you are using Sun HBA's (QLogic) with the leadville drivers, you `cfgadm -c configure c# c#` the controllers, and put a VTOC on the disks.

You can use either Veritas Volume Manager and file system, or Veritas storage foundation for Oracle which also comes in an HA flavor (VCS). Veritas brings some flexibility, simplicity, and performance, but is expensive. Sun Disk Suite (SDS) and the ufs file system ship with Solaris.

If you are hardware RAID 10 on your array, I would use concatonated volumes. I usually put the ORACLE_BASE/HOME undert /app/oracle, and put the database under /u01 thru /u05, and use /u06 for archive logs. If I need a local slice for backups, I put it at /app/backups.

If using vxfs, make sure to use the largest block size that equals or is a multiple of your db/tablespace block size.

All of my V880's only have 6 internal 72GB disks. I usually use two for the OS mirrored with SDS, and the other four for rootdg with pre 4.0 vxvm. With 4.x, I make them a disk group, and would put your Oracle binaries and indexes on those disks, and the rest of the database on the SAN.

Realize that if you put disks on the SAN and the internal disks in the same disk group/set, you may have errors on boot or in single user because the drivers for the SAN HBA's have not loaded, and only part of the disk group will be visible.

Be sure to put noatime as a mount option in the vfstab, and if using ufs, also logging.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Solaris

Could you run this benchmark? (Especially if you have a V880 or V890)

Hi all I am currently using a T5120 to write and run some simulation code I've been working on which heavily relies on large matrix multiplication procedures. I am posting this to call out for some of you run and share the results of a simple benchmark I've written to compare the matrix... (1 Reply)
Discussion started by: toguro123
1 Replies

2. Hardware

Help needed for non-SUN-HDD (original Seagate) in V880

Hello, we have a hardware error on a 36GB HDD within a SunFire V880. Disk seems to be really dead, cause changing the slot of the disk, moves the error along. So we bought a similar, but original) Seagte-Disk (on ebay) and screwed it in the HDD-Cage. Disk is now known in format, but is... (5 Replies)
Discussion started by: etomer_sk
5 Replies

3. Solaris

How configure SAN to server?

Hi all, I have a server with Solaris version 9. I wanted to mount SAN storage to my server. I am new at this. Can anyone give me an overview on how to this. Any documents will be fine also. Please let me know if any information is required. Thanks in advance. Below shows the HBA port: ... (11 Replies)
Discussion started by: beginningDBA
11 Replies

4. Solaris

configure solaris 10 mail to relay email alerts from SAN switch

I want to be able to use an account on a solaris 10 server, eg root@myhost to act as a relay to forward mail to my domain account me@mycompany.com The reason for this is to configure root@myhost as a mail relay on Brocade SAN switches - so that when a port goes bad i get an email alert.... (0 Replies)
Discussion started by: wibidee
0 Replies

5. UNIX for Dummies Questions & Answers

unable to telnet from win xp to sun fire v880 server

Hi everybody i am trying to telnet to sun server from win xp machine but getting message "x21 error connection closed by remote user". i had make changes in /etc/default/login & /etc/fuser file still i have not getting telnet access. my win xp machines ip is 10.205.121.177 & sun server ip is... (1 Reply)
Discussion started by: pshelke
1 Replies

6. Solaris

Thoughts/experiences of SAN attaching V880 to EMC SAN

Hi everyone, I wonder if I can canvas any opinions or thoughts (good or bad) on SAN attaching a SUN V880/490 to an EMC Clarion SAN? At the moment the 880 is using 12 internal FC-AL disks as a db server and seems to be doing a pretty good job. It is not I/O, CPU or Memory constrained and the... (2 Replies)
Discussion started by: si_linux
2 Replies

7. Solaris

Sun V880

I have two mechine, one is SUN V880 and another is IBM p570. I run the same script on V880 and p570 , why the cpu usage always under 50% on V880 but the cpu usage can growth to 100% on p570. (4 Replies)
Discussion started by: golden
4 Replies

8. Solaris

Sun v440/v880 network adapter teaming

Is it possible to team two network adapters for fault tolerance in a Sun v440 or v880 Solaris 8 box? If so how would I go about doing so? (1 Reply)
Discussion started by: ghuber
1 Replies

9. UNIX Benchmarks

Sun V880 Solaris 9

notes: System Configuration: Sun Microsystems sun4u Sun Fire 880 System clock frequency: 150 MHz Memory size: 8192 Megabytes Run E$ CPU CPU Brd CPU MHz MB Impl. Mask --- --- ---- ---- ------- ---- A 0 750 8.0 US-III 5.4 B 1 ... (0 Replies)
Discussion started by: tnorth
0 Replies
Login or Register to Ask a Question