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

From: jayendra.ahmedabad.acute <i.jayendra_at_gmail.com>
Date: Thu, 22 Apr 2010 12:33:48 -0700 (PDT)
Message-ID: <50b9bd55-ca0e-4733-bc77-ee03e516715b_at_u9g2000prm.googlegroups.com>



---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) Received on Thu Apr 22 2010 - 14:33:48 CDT

Original text of this message