toasters

toasters@lists.teaparty.net

1 participants
13515 discussions

oracle coruption caused by NFS file system is full
by Li, Jackie (Yanhui) 09 Dec '08

09 Dec '08

Our firm runs oracle 9i using NFS file system from Netapp(3040 running 7.2), we have noticed few cases now that when the NFS file system is full, oracle database crash and can not even start after that. It turns out that database has logical corruption, does anybody experience similar issues? Thanks

8 9

RE: oracle coruption caused by NFS file system is full
by Li, Jackie (Yanhui) 08 Dec '08

08 Dec '08

Thanks everybody's input, I have get a lot of replies, the best thing to do is obvious not get volume full. In our scenario, these are test/development databases, all the oracle files are on single NFS volume , database is not Running in archive mode, The argument so far is : Is corruption a normal behavior after oracle file system is full or it should never? Could this be anything particular related to NFS since we had never observed this on SAN? Jackie Thanks -----Original Message----- From: ericgrancher(a)gmail.com [mailto:ericgrancher@gmail.com] On Behalf Of Eric Grancher Sent: Monday, December 08, 2008 1:13 PM To: Matthew Zito; Glenn Dekhayser; Li, Jackie (Yanhui); toasters(a)mathworks.com Subject: Re: oracle coruption caused by NFS file system is full dear all, (being quite silent on the list, I take the occasion to say that I appreciate very much the contributions and for once that I can contribute...) From my understanding and experience (we got hit once at CERN when we started using DOT devices/NFS for Oracle databases, then we understood the issue and took the right actions to prevent this from happening again), the issue can typically be linked with snapshots: one (or more) snapshots having been created on the volume, Oracle needs to update a block, which turns to the need of more space as the old copy has to be kept (to preserve the snapshot). If no space is available, the write operation is refused which Oracle sees as a "corruption". It is quite well described in TR-3633, pages 22-24. http://media.netapp.com/documents/tr-3633.pdf The operations to be performed (after having added space) to recover from this situation depends on the type of the affected file, the cases are listed as well in the mentioned document. It may actually not be linked with auto-extensibility of Oracle datafiles (which we use extensively without problem). Just updating redo-log files and/or changing blocks in datafiles can generate the issue. Regarding actions to avoid such an issue happening again, it very much depends on your usage of snapshots: -1- if the snapshots are not used, removing the snapshots and disabling the automatic creation of new snapshots is enough! -2- using the vol autosize feature and making sure that there is enough space at the aggregate level (and max-autosize not reached) is a possibile solution (DFM is our friend for this!) -3- using vol option try_first http://now.netapp.com/NOW/knowledge/docs/ontap/rel7251/html/ontap/cmdref/ma… linked with snap autodelete as decribed in http://now.netapp.com/NOW/knowledge/docs/ontap/rel7251/html/ontap/cmdref/ma… could be a solution (which we do not use, be careful with your snapshots if they are a key part of your backup strategy!) best regards, eric 2008/12/8 Matthew Zito <mzito(a)gridapp.com>: > This is also why you don't enable autoextend on tablespaces, and put your > archive logs on a separate filesystem. Space management is part of the day > to day responsibility of a DBA. Running out of space is a Very Bad Thing > for databases. > Thanks, > Matt

1 0

Unix <=> NTFS permissions question
by Oskar Pienkos 08 Dec '08

08 Dec '08

Hello Toaster Experts! We are currently mounting an NFS directory, e.g. /home/production from a filer to a Solaris 10 box. Security is done by local passwd entries. We need to export this directory via CIFS with read and write access to a group of windows developers ( a group in Active Directory.) Is there a way to do this without converting the filer security from UNIX to NTFS? The shares is owned by a single unix UID but will be accessed by multiple AD users. Is there a way to translate AD groups into Unix groups since usermap.cfg seems to translate only user IDs. We don't want to run mixed-mode security. Thanks a lot. Oskar

2 1

Re: Unix <=> NTFS permissions question
by Fox, Adam 08 Dec '08

08 Dec '08

You can't map groups, but if you can ensure that every Windows user belongs to a group that can read/write the files. Each CIFS user will map to a UNIX user with UNIX groups. If, by some chance the controller can't map to a UNIX user, you can set the option cifs.default_unix_user to the UNIX user who owns the files. But this only works if the controller can't map to a UNIX user. -- Adam Fox ------------------------ Typed with my thumbs on a very small keyboard. ----- Original Message ----- From: Oskar Pienkos <opienkos(a)sfu.ca> To: toasters(a)mathworks.com <toasters(a)mathworks.com> Sent: Fri Dec 05 17:36:06 2008 Subject: Unix <=> NTFS permissions question Hello Toaster Experts! We are currently mounting an NFS directory, e.g. /home/production from a filer to a Solaris 10 box. Security is done by local passwd entries. We need to export this directory via CIFS with read and write access to a group of windows developers ( a group in Active Directory.) Is there a way to do this without converting the filer security from UNIX to NTFS? The shares is owned by a single unix UID but will be accessed by multiple AD users. Is there a way to translate AD groups into Unix groups since usermap.cfg seems to translate only user IDs. We don't want to run mixed-mode security. Thanks a lot. Oskar

2 1

OSSV and Windows 2008
by Milazzo Giacomo 06 Dec '08

06 Dec '08

Hi all OSSV 2.5 and 2.6 does not include Windows 2008 Server in their compatibility matrix. Does anybody had the chance to test the OSSV agent on 2008 and NTFS volumes? Regards,

2 1

StoreVault (S550) Cifs Homedirectories
by ifstat 05 Dec '08

05 Dec '08

Hi this might be a bad question, but I'm sure many people have the same query. I've just found out that CIFS Homedirctories it not supported in the S-Series, now being familiar with the full version of Ontap i've managed to configure it. My question is; why is this not supported? Will enabling homedirectories cause a problem to the StoreVault including stabilty and in terms of managebility. I'm fine with doing this from console. Any other reason why doing this is a bad idea? -- View this message in context: http://www.nabble.com/StoreVault-%28S550%29-Cifs-Homedirectories-tp20852013… Sent from the Network Appliance - Toasters mailing list archive at Nabble.com.

1 0

Wiring question
by Peta Spies 04 Dec '08

04 Dec '08

Hi all, Thanks for your responses to my earlier question about swapping small disks for larger ones. Looks like we're going to have to get the mice in the comms room to pedal faster... Anyway, another query entirely. I've just found that one of my netapps is really poorly wired - it's a 3040C with two SATA shelves on one loop, and most of the wiring has IN and OUT ports swapped from the way it should be, aside from one example where it's the right way around. The netapp head can see the shelves though, so it's clearly not too much of a problem. I now want to add two more shelves to the loop. Is it worth recabling the whole thing so it's done correctly, bearing in mind that vol0 lives on the affected SATA shelves and there is production stuff on the other loop (FCAL shelves), I'm guessing the filer won't like it if vol0 goes away? Someone here suggested that the incorrect wiring may be affecting performance. Or does it make no difference and I can just add the new shelves with the wiring inthe same backwards manner? Peta

3 2

Win 2008 AD domain with StoreVault
by Paul Letta 04 Dec '08

04 Dec '08

Hi Everyone. I thought I should add a few more details. Our 2008 AD domain is now in a 2008 only mode with no backwards compatibility to 2003 AD. So that rules out keeping a 2003 AD server for this storevault to use. My next thought was to use either local passwords or NIS. This storevault only has a handful of users. But the data is in an NTFS style qtree. All of the ACLs are based on domain users/groups. Is there a way to map local users/groups to domain users/groups if the filer can't contact/use the domain ? I'm thinking I may just have to punt and move the data back to real NetApp that is working with 2008 AD. Thanks for any suggestions. Paul Hi Everyone. We have just upgraded our Windows AD domain from a 2003 domain to a 2008 domain. All of our filers are fine, because they are at 7.2.5.1. Except for one. A StoreVault. (I know..) It is at OnTap 7.2.1S9. StoreVault support says the 'newest' version is 7.2.1S10. And that StoreVault will not work with 2008 AD domains. I asked for a recommendation, they had none. I checked the CIFS compatibility matrix on NOW, but did not notice that 7.2.1S9 fell outside the chart. Is anyone on the list trying to use 2008 AD domain with a StoreVault ? Downgrading back to a 2003 AD domain is not an option. Thankfully, the number of users that depend on this StoreVault is small, so I may look to use the local /etc/password option during a cifs setup, but I'm not sure if that will work either. Suggestions ?? other than read the matrix better :-) Thanks, Paul

1 0

Win 2008 AD domain with StoreVault
by Paul Letta 04 Dec '08

04 Dec '08

Hi Everyone. We have just upgraded our Windows AD domain from a 2003 domain to a 2008 domain. All of our filers are fine, because they are at 7.2.5.1. Except for one. A StoreVault. (I know..) It is at OnTap 7.2.1S9. StoreVault support says the 'newest' version is 7.2.1S10. And that StoreVault will not work with 2008 AD domains. I asked for a recommendation, they had none. I checked the CIFS compatibility matrix on NOW, but did not notice that 7.2.1S9 fell outside the chart. Is anyone on the list trying to use 2008 AD domain with a StoreVault ? Downgrading back to a 2003 AD domain is not an option. Thankfully, the number of users that depend on this StoreVault is small, so I may look to use the local /etc/password option during a cifs setup, but I'm not sure if that will work either. Suggestions ?? other than read the matrix better :-) Thanks, Paul

2 1

Re: SD 6.01 / W2K8 x64 / iSCSI and NLB Cluster
by Raj Patel 04 Dec '08

04 Dec '08

Cheers Tom, We get slightly different errors on the nodes - * rpc error - mailbx1 * security package error - mailbx2 We did have a suggestion to completely disable the firewall service (not just switch it off in the control panel) - this worked until we rebooted both nodes and the problem came back. Why I asked about the NIC's was because I wondered if the RPC traffic was going out over the data network rather than the iSCSI network. The data network potentially has two addresses per host - its own and the failover cluster IP. I don't think we're doing anything particularly fancy - the cluster setup is obviously the complicating factor. There are a few NOW articles concerning cluster setup but they tend to relate to traditional shared disk rather than independent disk setups. Cheers, Raj. On Wed, Dec 3, 2008 at 11:00 PM, De Wit Tom (Consultant) <tom.de.wit(a)consultant.volvo.com> wrote: > Hey Raj, > > Setting the Preferred filer address is what will tie those RPC calls to a specific destination IP address. Normally you do this to make that traffic go over a specific source interface. The source IP address woudln't matter that much if the traffic can get back to the same host using that IP address. > > Are you experiencing these SD errors on both of your cluster nodes ? > > Tom > > -----Original Message----- > From: Raj Patel [mailto:phigmov@gmail.com] > Sent: dinsdag 2 december 2008 22:47 > To: De Wit Tom (Consultant) > Cc: toasters(a)mathworks.com > Subject: Re: SD 6.01 / W2K8 x64 / iSCSI and NLB Cluster > > Cheers Tom > > We've done some more troubleshooting - > > * if I do a clean w2k8 server install with two nics (one data and the > other iscsi) - SD 6.01 installs and works fine - the initiator even > prompts to open the FW ports on the server > > This made me think it was either something fishy with my previous > install or something funny with the cluster (which is purely failover > - no shared storage). > > * if we evict one of the cluster members (there are two mailbox > servers) the SD 6.01 RPC problem goes away immediately > > So now I'm running up some test VM's to replicate the setup and run up > SD first and then put the cluster on afterwards. > > What I'm wondering now is what part of the SD / SAN interaction is > making the RPC call - presumably over the clustered address ? Is > there any way to tie it to a particular IP or NIC ? > > We'll run another test with a couple of vm's, creating the luns and > then creating the cluster - see at what point the RPC error occurs. > > > Cheers, > > Raj. > > > On Tue, Dec 2, 2008 at 10:04 PM, De Wit Tom (Consultant) > <tom.de.wit(a)consultant.volvo.com> wrote: >> I know of two things that can cause such errors: >> >> - Fill in the "Preferred filer IP addresses". I don't have SD 6.x, on 4.2.1 it was located in MMC under Storage/Snapdrive/Disks, rightclick Disks, select properties. Then fill in the filer DNS/Netbios name and the corresponding IP address and restart Snapdrive services >> >> - Make sure the Snapdrive services is started with a domain user that has both local admin rights on the local server and admin rights on the Netapp filer. >> >> Grtz, >> Tom >> >

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

2000

1999

1998

1997

toasters