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

To Summarize,

I changed the mount points, removing forcedirectio and adding llock (solaris version of nolock).
Database creation was successful.

Thank you for your help,
Yonah

On Nov 22, 1:42 pm, Yonah Russ <yonah.r..._at_gmail.com> wrote:
> 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 - 10:58:33 CST