expdp linux-x86_64 error 37 no locks available Ellicott City Maryland

Address 3700 Koppers St, Halethorpe, MD 21227
Phone (410) 646-0638
Website Link https://www.dataprise.com
Hours

expdp linux-x86_64 error 37 no locks available Ellicott City, Maryland

its happening during "perl adcfgclone.pl appsTier". Register. 08-10-2011 #1 msachikanta View Profile View Forum Posts Private Message View Articles Just Joined! I believed this could be an issue of nfs mount option at OS level. Re: Weird expdp error - Unable to lock file. 26741 Apr 23, 2009 3:35 PM (in response to Actitud) I remember that when 10g RMAN came out, it was very particular

Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are you need to shutdown the source database in oracle with the shutdown immediate command, then after you copy the files, you issue the startup command. The time now is 10:24 AM. January 29, 2013 at 4:37 AM has anyone facing this problem on AIX?

Can anyone help on this issue..? Later the same has been taken care. ORACLE instance started. This is the disk I'm using.

hence onwards whenever the server gets rebooted the nfslock services will automatically startup. Actitud Apr 23, 2009 3:13 PM (in response to 26741) Hello Hermant. Re: Weird expdp error - Unable to lock file. 770125 Jun 2, 2010 6:45 PM (in response to 26741) I have a 11.1.0.6 on RH linux 2.6.18-92.1.10.0.1.el5 #1 SMP and got I'm not having the issue with Red Hat.

ir a principal | Ir a lateral Home Content RSS Log in Marko Sutic's Database Blog Search for: Home About Twitter Contact Datapump fails with ORA-27086 on NFS Tuesday, May 31, Newer Post Older Post Home Subscribe to: Post Comments (Atom) Oracle ACE About Me Osama Mustafa Osama Mustafa is a database specialist, Oracle ACE Director , Certified Oracle Professional (10g, 11g), Thanks. Join Date Aug 2011 Posts 14 Error - Linux-x86_64 Error: 37: No locks available Hi, While cloning Oracle 10.2.0.5 Database we are getting the below error.

Immediately post running the export job it got failed. Total System Global Area 1073741824 bytes Fixed Size 2101672 bytes Variable Size 427822680 bytes Database Buffers 629145600 bytes Redo Buffers 14671872 bytes CREATE CONTROLFILE REUSE SET DATABASE "PMFPCIT" * ERROR at Other info: Oracle 11.2 the nfs mount is EmC data domain.# $EXPDP oradba/xxxxxxxxxxxxx DIRECTORY=ddbkup_dir DUMPFILE=expdp_$SID$EXT.dmp LOGFILE=expdp_$SID$EXT.log SCHEMAS=ORADBAExport: Release 11.2.0.1.0 - Production on Sun Sep 8 15:48:46 2013Copyright (c) 1982, 2009, Oracle Datapump fails with ORA-27086 on NFS Related Posts Widget Labels: Troubleshooting, Unix/Linux 5 comments: June 17, 2011 at 3:03 PM This issue solved my problem too.Thanks June 27, 2011 at 5:23

Please find the error details below. --------------------------------------------------------------- SQL*Plus: Release 10.2.0.5.0 - Production on Sat Aug 6 12:10:08 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. I am facing this issue. It was something related to the NFS mount.

Note that If the nfslock services need to get auto start after a reboot then we need to use chkconfig nfslock on. You can not post a blank message. DBelton View Public Profile Find all posts by DBelton #3 22nd August 2011, 08:44 PM msachikanta Offline Registered User Join Date: Aug 2011 Posts: 6 Re: ERROR - Join Date Aug 2011 Posts 14 Added more points related to the issue.

View my complete profile Soical Network Linked In My Twitter My Book oracle penetration testing Blogroll Kevin Closson Kellyn PotVin-Gorman Gokhan Atil Blog HeliFromFinland Blog Archive ► 2016 (26) ► October Please type your message and try again. Powered by vBulletin Version 4.2.2Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. Re: Weird expdp error - Unable to lock file.

could you please help me to find out the root cause.. All Rights Reserved. Awesome Inc. Re: Weird expdp error - Unable to lock file.

Show 31 replies 15. All Rights Reserved. Thanks Hermant!. FedoraForum.org is privately owned and is not directly sponsored by the Fedora Project or Red Hat, Inc.

Privacy Policy | Term of Use | Posting Guidelines | Archive | Contact Us | Founding MembersPowered by vBulletin® Copyright ©2000 - 2012, vBulletin Solutions, Inc. Gather System Statistics Another Linux Command Drop Undo Tablespace Online ORA-04068: existing state of packages has been dis... The privileges are the same on the new directory (LOCAL) and in the old one (NFS). Now I have to solve this out since I have many databases and the NFS device was supposed to be the directory for all the databases.

Checking if 'nfslock' service is running: # service nfslock status rpc.statd is stopped Start 'nfslock' service: # /etc/init.d/nfslock start Starting NFS statd: [ OK ] Status: # service nfslock status rpc.statd But with the other node I am not able to mount the database. Re: Weird expdp error - Unable to lock file. 695939 Apr 23, 2009 3:09 PM (in response to 26741) Entering DIRECTORY=dirobj1 and DUMPFILE=dirobj2:file.dmp should be perfectly fine to do. Export: Release 11.2.0.3.0 - Production on Sat Mar 8 05:53:37 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates.

There shouldn't be any issue trying to expdp into NFS device. This tool uses JavaScript and much of it will not work correctly without it enabled. we re-triggered the export job. Like Show 0 Likes(0) Actions 22.

Skip navigationOracle Community DirectoryOracle Community FAQLog inRegisterMy Oracle Support Community (MOSC)SearchSearchCancelGo Directly To Oracle Technology Network CommunityMy Oracle Support CommunityOPN Cloud ConnectionOracle Employee CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: Alex. This tool uses JavaScript and much of it will not work correctly without it enabled. Edited by: dhe on Jun 2, 2010 11:44 AM Like Show 0 Likes(0) Actions 26.

Finally you should Reboot your server. John Like Show 0 Likes(0) Actions 19. You may have to register before you can post: click the register link above to proceed. Re: Weird expdp error - Unable to lock file.

Bad Request The request could not be understood by server due to malformed syntax. All rights reserved. ;;; Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORA-39000: bad dump file Re: Weird expdp error - Unable to lock file. 26741 Apr 23, 2009 3:12 PM (in response to Actitud) Is the destination directory (OS level) local or an NFS mount point He also works on troubleshooting and the implementation of database projects.He spends his free time on Oracle OTN forums and publishes many articles, including Oracle database articles, in his bloghttp://osamamustafa.blogspot.com.