Re: dbca hangs - Oracle 10gR2 RAC, Solaris 10, NetApp NFS

On Nov 22, 10:30 am, DA Morgan <damor..._at_psoug.org> wrote:
> Yonah Russ wrote:
> > On Nov 21, 11:10 pm, DA Morgan <damor..._at_psoug.org> wrote:
> >> Yonah Russ wrote:
> >>> Hi,
> >>> We have RAC installed on 2 T2000 machines.
> >>> Solaris 10, patched
> >>> IPMP for failover on all interfaces
> >>> NetApp NFS for datafile,voting disk, etc.
> >>> Oracle installation, binaries, etc. are on local disks.
> >>> All configurations were according to Oracle/NetApp docs.
> >>> There were no issues during installation.
> >>> When we try to create the db using dbca, the process hangs during data
> >>> dictionary creation.
> >>> There is only one error message "Warning: aiowait timed out x times"
> >>> All the NFS partitions are mounted forcedirectio, and we have tried
> >>> with aio disabled in oracle.
> >>> We have also tried without forcedirectio, with nointr instead of intr.
> >>> If we create a db on the local disks there is no issue.
> >>> There are no problems using the NFS shares in general.
> >>> Any ideas?
> >>> Thanks
> >>> Yonah
> >> If your fstab looks substantively different from this ... change it.
> >> ntap270a:/vol/alpha /u01 nfs
> >> rw,bg,intr,hard,rsize=32768,wsize=32768,noac,nolock,tcp,vers=3 0 0
>
> >> in this case ntap270a is the volume being mounted as /u01.
>
> > The only difference I see is the nolock option.
> > We are using this:
> > rw,bg,vers=3,proto=tcp,hard,intr,rsize=32768,wsize=32768,forcedirectio,noac
>
> > Thanks,
> > Yonah
>
> >> --
> >> Daniel A. Morgan
> >> Oracle Ace Director & Instructor
> >> University of Washington
> >> damor..._at_x.washington.edu (replace x with u to respond)
> >> Puget Sound Oracle Users Groupwww.psoug.org
>
> You mean other than "forcedirectio" which is what is causing your
> problem. Remove it.

We have tried with and without the forcedirectio. It has not made a difference :( but I will try the combination of without forcedirectio and without locking.
Someone on another list suggested re-installing the Oracle because I applied a more recent libaio patch.
Is it possible that Oracle is statically linked against the old library?

Thanks,
Yonah

> --
> Daniel A. Morgan
> Oracle Ace Director & Instructor
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
Received on Thu Nov 22 2007 - 05:42:29 CST