Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Unable to obtain lock on NFS files
Top Forums UNIX for Dummies Questions & Answers Unable to obtain lock on NFS files Post 302934342 by admin_db on Friday 6th of February 2015 08:58:05 AM
Old 02-06-2015
Unable to obtain lock on NFS files
Hello ,

I am creating a controlfile of database in linux and below is the error coming:

Code:
SQL> CREATE CONTROLFILE REUSE set DATABASE "newdbcln" RESETLOGS  NOARCHIVELOG
  2      MAXLOGFILES 5
  3      MAXLOGMEMBERS 5
    MAXDATAFILES 100
  4    5      MAXINSTANCES 1
  6      MAXLOGHISTORY 292
LOGFILE
  7    8    GROUP 1 '/lvclone2/newdbcln/onlinelog/redo01.log'  SIZE 100M BLOCKSIZE 512,
  9    GROUP 2 '/lvclone2/newdbcln/onlinelog/redo02.log'  SIZE 100M BLOCKSIZE 512,
 10    GROUP 3 '/lvclone2/newdbcln/onlinelog/redo03.log'  SIZE 100M BLOCKSIZE 512
 11  -- STANDBY LOGFILE
 12  DATAFILE
 13    '/lvsnap/newdb/datafile/system01.dbf',
 14    '/lvsnap/newdb/datafile/sysaux01.dbf',
 15    '/lvsnap/newdb/datafile/undotbs01.dbf',
 16    '/lvsnap/newdb/datafile/users01.dbf'
 17  CHARACTER SET US7ASCII
 18  ;
CREATE CONTROLFILE REUSE set DATABASE "newdbcln" RESETLOGS  NOARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-00200: control file could not be created
ORA-00202: control file: '/lvclone2/newdbcln/controlfile/control6.ctl'
ORA-27086: unable to lock file - already in use
Linux-x86_64 Error: 37: No locks available
Additional information: 10

When I changed the location to non-nfs it started working fine so this is not able to lock files on nfs while read write is working fine

NFS Server

Code:
[root@cindb1003a lvclone2]# cat /etc/exports
/lvsnap 10.65.150.0/24(rw,sync)
/lvclone2 10.65.150.0/24(rw,sync)


NFS Client

Code:
[root@cindb1002a /]# cat /etc/fstab
LABEL=DBSYS             /                       ext3    defaults        1 1
LABEL=BOOT              /boot                   ext3    defaults,nodev        1 1
LABEL=DBORA             /u01                    ext3    defaults,nodev  1 1
tmpfs                   /dev/shm                tmpfs   defaults,size=219585m 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0
LABEL=SWAP              swap                    swap    defaults        0 0
10.65.150.69:/lvclone2 /lvclone2 nfs rw,bg,lock,hard,nointr,tcp,vers=3,timeo=600,rsize=32768,wsize=32768
10.65.150.69:/lvsnap /lvsnap nfs rw,bg,lock,hard,nointr,tcp,vers=3,timeo=600,rsize=32768,wsize=32768


Best regards,
Vishal
 

10 More Discussions You Might Find Interesting

1. AIX

Unable to mount NFS share during boot

Hello Everyone, I have a pseries machine running AIX 4.3.3 that has an invalid IP in /etc/hosts. During a boot the system hangs because it's trying to mount an NFS share to this invalid IP. I've tried to boot the system from a mksysb (not sure if the device was defined as rmt0) and AIX CD... (0 Replies)
Discussion started by: jlslhills
0 Replies

2. Linux

groupadd: unable to lock group file

Hi guys, i encountered this error when i try to create a group. What is the problem here? I created a few groups weeks before this. I was recommended to reboot the machine, but i am not the owner of the machine, thus i would prefer to know the cause and any other solution other than rebooting the... (1 Reply)
Discussion started by: Daven81
1 Replies

3. UNIX for Advanced & Expert Users

"Unable to obtain clipboard ownership"

Help! I work on a PC running Windows XP. I have installed the Hummingbird Suite Exceed 10.0. I launch 4 Xconfig sessions based on different *.cfg files along with the standard Xserver Xconfig (Exceed.cfg). I do this because I need to run graphical apps in separate windows. In any event,... (0 Replies)
Discussion started by: richmeeker
0 Replies

4. Linux

Unable to Lock User

Hi, I am trying to lock a user by executing "passwd -l xxxx" but the system is returning following error: Locking password for user xxxx. passwd: Error (password not set?) I do see the passwd for this user encrypted in shadow file thou! Anyone have any ideas why am getting this error? ... (5 Replies)
Discussion started by: harjitsingh
5 Replies

5. Solaris

Unable to release package administration lock for this system

Hi, I created a Solaris package, but at the end of installation (on a Solaris 10 sparc) I get : #pkgadd -d MyApp_version__SunOS_sparc.pkg ... Installation of <MyAppName> was successful. pkgadd: ERROR: ERROR: Unable to release package administration lock for this system; try again later... (0 Replies)
Discussion started by: potro
0 Replies

6. Shell Programming and Scripting

Unable to obtain the desired output

Hi, I am unable to get beyond the exit function. The shell script is used to look for masked files and copy paste them to another location. Please refer to the code below for more information. Thanks Brinjit #!/usr/bin/ksh... (10 Replies)
Discussion started by: brinjit
10 Replies

7. UNIX for Dummies Questions & Answers

Unable to write to a mounted NFS share

Hi All, I created a nfs share in the server(Solaris 10) with the following command and also updated the dfstab file share -F nfs -o rw=server_name2,anon=0 /to_share And then in the client(solaris 10) added the following command to mount the share mount -F nfs server_name1:/to_share... (4 Replies)
Discussion started by: Rossdba
4 Replies

8. UNIX for Dummies Questions & Answers

Unable to mount NFS

Hello, While mounting NFS below error is coming: # mount -t nfs 10.65.150.69:/lvsnap /lvsnap mount: mount to NFS server '10.65.150.69' failed: RPC Error: Program not registered. Please advise. Best regards, Vishal (2 Replies)
Discussion started by: admin_db
2 Replies

9. HP-UX

Unable to write to NFS mounted directory

Hi, I have exported a few nfs mounts from one server to the nfs clients. This is my nfs server dfstab : # cat /etc/dfs/dfstab # place share(1M) commands here for automatic execution # on entering init state 3. # # share <pathname> # .e.g, # share -F... (3 Replies)
Discussion started by: anaigini45
3 Replies

10. IP Networking

Unable to search NFS Share

My customer has created a share on a Windows Server 2012 system and exported it as a NFS share. I can mount the share on a SCO system, but I only have read/write access. So I am unable to list the contents of the share. It is as if the directories had 0666 permissions. My customer says that this... (5 Replies)
Discussion started by: jgt
5 Replies

LEARN ABOUT REDHAT

create_group

CREATE 
GROUP(7) 						   SQL Commands 						   CREATE GROUP(7)

NAME

       CREATE GROUP - define a new user group

SYNOPSIS

       CREATE GROUP name [ [ WITH ] option [ ... ] ]

       where option can be:

	    SYSID gid
	  | USER  username [, ...]

   INPUTS
       name   The name of the group.

       gid    The SYSID clause can be used to choose the PostgreSQL group id of the new group. It is not necessary to do so, however.

	      If this is not specified, the highest assigned group id plus one, starting at 1, will be used as default.

       username
	      A list of users to include in the group. The users must already exist.

   OUTPUTS
       CREATE GROUP
	      Message returned if the command completes successfully.

DESCRIPTION

       CREATE  GROUP  will create a new group in the database installation.  Refer to the Administrator's Guide for information about using groups
       for authentication.  You must be a database superuser to use this command.

       Use ALTER GROUP [alter_group(7)] to change a group's membership, and DROP GROUP [drop_group(7)] to remove a group.

USAGE

       Create an empty group:

       CREATE GROUP staff;

       Create a group with members:

       CREATE GROUP marketing WITH USER jonathan, david;

COMPATIBILITY

   SQL92
       There is no CREATE GROUP statement in SQL92.  Roles are similar in concept to groups.

SQL - Language Statements					    2002-11-22							   CREATE GROUP(7)
All times are GMT -4. The time now is 02:14 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy