RE: Top (<=10) Issues faced by Oracle DBAs Deploying in a

Unfortunately, we are always adding a new database. The new SAN commission in June-July was supposed to hold 6 databases. Then it became 7 databases in August. Now it is 8 this month and the count will go up to 9 databases by December.

As the SAN Storage Admin and Unix SA roles are handled by two people [apart from me, the DBA], I haven't been able to get additional file systems available on the SunCluster accessing the SAN. I have been "cramming" in 8 databases into file systems sized for 6.

Hemant

At 09:09 AM 29-09-03 -0800, you wrote:
>Hemant --
>
>I just came off a gig where I was the storage/Unix/DBA geek, and, in my
>opinion, while the level of expertise *does* need to be higher, *and
>different*, for in that environment, it's all front-end. Once you have the
>database configured and the backup and recovery scripts written and tested,
>you can go back to having just straight DBAs. At least that's what they did
>at my last site, and I haven't heard any complaints from them.
>
>Bambi.
>
>-----Original Message-----
>Sent: Saturday, September 27, 2003 11:50 AM
>To: Multiple recipients of list ORACLE-L
>
>
>
>As an Oracle DBA , I have no problems putting my Databases on SANs [yes,
>we have seperate SANs, from different vendors].
>
>However, I find that Storage and Unix Admin skill requirements for a SAN
>seem to be higher. When Clustered servers access the SAN, it seems to
>be even more difficult to get an additional mount point made available to
>the DBA.
>
>Hemant
>At 10:59 AM 25-09-03 -0800, you wrote:
> >Fellow Listers,
> >
> >If you don't deal with Oracle databases on SAN/NAS
> >environments, this posting may not interest you. If
> >so, my apologies, please delete this. Otherwise,
> >please read on.
> >
> >In an effort to better understand what issues you face
> >when deploying an Oracle database in a SAN/NAS
> >environment, I am writing to you to get some "real
> >life" feedback. Although I have a fair idea, where
> >some of the pain lies, it would be much more valuable
> >if you could tell me. Kind of like "From the horse's
> >mouth..."...;-) And I truly meant that as a
> >compliment...:-)
> >
> >My goal is to fully understand where the "real pain"
> >lies, so that appropriate solutions can be built to
> >alleviate or even eliminate the pain. You can be as
> >broad or narrow in your responses using the following
> >topics as guidelines:
> >
> >* Initial SAN/NAS Configuration for Database Creation
> > and Application Deployment
> >* Ongoing Storage Volume Management in a SAN/NAS
> >* Ongoing Storage Administration (Growth, Resizing)
> >* Performance Optimization & Troubleshooting
> >* Things that require automation
> >* Anything else you think is important that I have
> > missed
> >
> >I do really appreciate you taking the time to put your
> >feedback in "black and white". Those of you who take
> >the time and effort to provide feedback, will be
> >entered in a raffle to for some T-shirts and other
> >freebies. Oh, BTW, when you do send your response,
> >please provide your full contact information, so that
> >I know where to mail the goodies.
> >
> >In the interest of not "flooding the list", please
> >send me your feedback directly to gaja_at_veritas.com. As
> >a courtesy to my fellow listers, I will collate all
> >responses and post a summary in the near future. You
> >can count on me to do that.
> >
> >
> >Best regards,
> >
> >
> >Gaja
> >
> >=====
> >Gaja Krishna Vaidyanatha | E-Mail: gaja_at_veritas.com
> >Principal Technical Product Manager | Phone: (650)-527-3180
> >Application Performance Management | Web: http://www.veritas.com
> >Veritas Corporation |
> >
> >__________________________________
> >Do you Yahoo!?
> >The New Yahoo! Shopping - with improved product search
> >http://shopping.yahoo.com
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >--
> >Author: Gaja Krishna Vaidyanatha
> > INET: oraperfman_at_yahoo.com
> >
> >Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> >San Diego, California -- Mailing list and web hosting services
> >---------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
>Hemant K Chitale
>Oracle 9i Database Administrator Certified Professional
>My personal web site is : http://hkchital.tripod.com
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Hemant K Chitale
> INET: hkchital_at_singnet.com.sg
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Bellow, Bambi
> INET: bbellow_at_chi.navtech.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).