Re: help me : got error while creating datafile in NAS(nfs file system) on HPUX ()
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