Re: help me : got error while creating datafile in NAS(nfs file system) on HPUX ()

From: joel garry <joel-garry_at_home.com>
Date: Thu, 22 Apr 2010 16:18:35 -0700 (PDT)
Message-ID: <38b3fb54-d342-43b1-82c1-f28c5364791a_at_s21g2000pri.googlegroups.com>

On Apr 22, 12:33 pm, "jayendra.ahmedabad.acute" <i.jayen..._at_gmail.com> wrote:
> ---extreamly sorry! the original query is described below
>
> CREATE TABLESPACE FCRDATA1
>  EXTENT MANAGEMENT LOCAL
>  SEGMENT SPACE MANAGEMENT AUTO
>  DATAFILE '/nasora/fcrdata1_01.dbf' SIZE 100 M REUSE AUTOEXTEND ON
> NEXT 1 M,
>  '/nasora/fcrdata1_02.dbf' SIZE 100 M REUSE AUTOEXTEND ON NEXT 1 M
> --,
> --    '/uatdata/oracle/oradata/FCR/fcrdata1_03.dbf' SIZE 10 M REUSE
> AUTOEXTEND ON NEXT 1 M
> AUTOALLOCATE
> LOGGING
> ONLINE
> PERMANENT
> BLOCKSIZE 8 K
> /
>
> --------------
> ls result
> -------------
> drwxrwxrwx   2 root       sys             96 Jul 13  2007 mnt
> drwxrwxrwx   5 oracle     oinstall       103 Apr 22 20:03 nasora
> (NOTE: this mount point is on "NAS")
> dr-xr-xr-x   2 root       root            96 Nov 17  2006 net
> dr-xr-xr-x  70 bin        bin           8192 Dec 21  2006 opt
> drwxrwxrwx  10 oracle     oinstall      1024 Apr 22 13:15 oracle
> -rw-r--r--   1 root       sys              0 Feb  4  2008 oracle.prefs
> drwxrwxrwx   5 root       sys           8192 Jun 26  2008 samba
> dr-xr-xr-x  15 bin        bin           8192 Dec 21  2006 sbin
> drwxrwxrwx   5 oracle     oinstall       103 Apr 22 20:03 uatdata
> (NOTE: this mount point is on "NAS")
>
> ---------------------------
> Error
> ---------------------------
> ORA-01119: error in creating database file '/uatdata/oracle/oradata/
> FCR/fcrdata1_01.dbf'
> ORA-27086: unable to lock file - already in use
> HPUX-ia64 Error: 13: Permission denied
> Additional information: 8
>
> ---------------------------
>
> ---------------------------
>
>  NAS(nfs file system) on HPUX
>
> NAS is os iomega (EMc system)
>
> please help me
>
> ##############################################################################################################################
> ------ answer to you questions are......
>
> *. no file exists in nas storage, i am just trying to create new one
> with above command...
>
> *. i have give full read/write/execute permission on both the mount
> point on "NAS"
>
> *. value for nfslock shown in kernal configuration is same as below
>
> nflocks                  4096        4096        yes        Supported
>
> *. i think there is no lock ,it is just new database containing only
> system tablespaces in regular attached hard drive and for resolving
> space issue  i am trying to create file in "NAS"
>
> *. abount veersion of system and nfs version
>
> # uname -a
> HP-UX fcrdb2 B.11.23 U ia64 1324355803 unlimited-user license
>
> # nfsstat -m
> /nasora from 192.168.0.16:/nfs/oracle  (Addr 192.168.0.16)
>  Flags:
> vers=3,proto=tcp,auth=unix,hard,intr,noac,link,symlink,devs,rsize=32768,wsize=32768,retrans=5
>  All:     srtt=  0 (  0ms), dev=  0 (  0ms), cur=  0 (  0ms)
>
> /uatdata from 192.168.0.16:/nfs/nas  (Addr 192.168.0.16)
>  Flags:
> vers=3,proto=tcp,auth=unix,hard,intr,link,symlink,devs,rsize=32768,wsize=32768,retrans=5
>  All:     srtt=  0 (  0ms), dev=  0 (  0ms), cur=  0 (  0ms)

OK, that's better, still need a couple more:

ll $ORACLE_HOME/bin/oracle (just to be sure you ran root.sh properly, offhand I can't remember which bugs were when on this).

and which patch level is oracle.

This is beyond the level I can help you, maybe someone else can, especially with those mount options. It likely is an OS issue, I know I've run into several things where nfs mounts are protected differently than docs lead me to expect (on nfs different than yours - sometimes things like simply telling the nfs to let me in). An emc or hp-ux oriented group may give better results (I've found the hp itrc forums helpful at times, hey, googled nfs flags oracle hp-ux and found http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1184963 so you can at least verify some things).

jg

--
_at_home.com is bogus.  I'm often asked the question, "Do you think there
is extraterrestrial intelligence?" I give the standard arguments --
there are a lot of places out there, and use the word *billions*, and
so on. And then I say it would be astonishing to me if there weren't
extraterrestrial intelligence, but of course there is as yet no
compelling evidence for it. And then I'm asked, "Yeah, but what do you
really think?" I say, "I just told you what I really think." "Yeah,
but what's your gut feeling?" But I try not to think with my gut.
Really, it's okay to reserve judgment until the evidence is in. - Carl
Sagan, The Burden Of Skepticism, The Skeptical Inquirer, Vol. 12, Fall
87

Received on Thu Apr 22 2010 - 18:18:35 CDT