Re: help me : got error while creating datafile in NAS(nfs file system) on HPUX ()
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Fri, 23 Apr 2010 06:18:00 -0700 (PDT)
Message-ID: <0d2a410b-9b70-4d77-8bd8-5fcbbf0c0046_at_r1g2000yqb.googlegroups.com>
On Apr 23, 7:38 am, "jayendra.ahmedabad.acute" <i.jayen..._at_gmail.com> wrote:
> *. as far as considering $ORACLE_HOME/bin/oracle (for root.sh running
> matter we have already ran the same shell and we have got no issue
> with that)
> and for your knowlwdge base we are already having one small test
> database running in the native hard drive and working fine only issue
> arise when trying to create datafile in newly attached storage "NAS".
>
> *. we have not applied any patch to database and database version is
> as same as on oracle site (version is 10.2.0.1 for HP-UX IA)
>
> *. even i have gone through the link watever the kernal parameter
> asking to configure i found nothing in
> system(nfs_new_lock_code,async_read_avoidance_enabled,page_text_to_local)
>
> thank you
Date: Fri, 23 Apr 2010 06:18:00 -0700 (PDT)
Message-ID: <0d2a410b-9b70-4d77-8bd8-5fcbbf0c0046_at_r1g2000yqb.googlegroups.com>
On Apr 23, 7:38 am, "jayendra.ahmedabad.acute" <i.jayen..._at_gmail.com> wrote:
> *. as far as considering $ORACLE_HOME/bin/oracle (for root.sh running
> matter we have already ran the same shell and we have got no issue
> with that)
> and for your knowlwdge base we are already having one small test
> database running in the native hard drive and working fine only issue
> arise when trying to create datafile in newly attached storage "NAS".
>
> *. we have not applied any patch to database and database version is
> as same as on oracle site (version is 10.2.0.1 for HP-UX IA)
>
> *. even i have gone through the link watever the kernal parameter
> asking to configure i found nothing in
> system(nfs_new_lock_code,async_read_avoidance_enabled,page_text_to_local)
>
> thank you
Perhaps this is not an NFS related error but rather the error seems to indicate that the file already exists which would mean the tablespace already exists. That or you are referencing a datafile that belongs to and is being used by another database.
If you check the full path at the OS level do the files exist? Are the datafile names correct for the database in question?
Are the nfs parameters you posted the ones listed in the platform specific installation manual or from a disk hardware vendor document?
HTH -- Mark D Powell -- Received on Fri Apr 23 2010 - 08:18:00 CDT