expdp backup on NFS mount point hangs due to Direct NFS: please check that oradism is setuid

Some days before we were trying to schedule expdp schema backup on one of the UAT environments. Expdp command was very simple & as follows:


expdp system/manager directory=data_pump_dir dumpfile=uatdb_test1.dmp logfile=uatdb_test1.log schemas=test1

Though schema size was hardly 300 MB, backup was taking ages just to start. Finally I canceled EXPDP session:


[oracle@UATDB] $ expdp system/manager directory=data_pump_dir dumpfile=uatdb_test1.dmp logfile=uatdb_test1.log schemas=test1
Export: Release 11.2.0.3.0 - Production on Tue Dec 30 09:14:59 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
^CUDE-00001: user requested cancel of current operation
UDE-01013: operation generated ORACLE error 1013
ORA-01013: user requested cancel of current operation

I checked alert log for getting some clue & got it. Alert log was showing following warnings:


DM00 started with pid=52, OS id=42757, job SYSTEM.SYS_EXPORT_SCHEMA_03
Direct NFS: please check that oradism is setuid
Tue Dec 30 09:16:01 2014
Direct NFS: please check that oradism is setuid

I checked for permissions for oradism binary


[oracle@UATDB] $ ls -la $ORACLE_HOME/bin/oradism
-rwxr-x--- 1 oracle oinstall 1340408 Sep 25 2011 /u01/app/oracle/UATDB/11.2.0.3/bin/oradism

Searched on metalink to find out correct permissions for oradism. Yes !! In my environment it was incorrectly set:


[root@UATDB] $ chown root:root /u01/app/oracle/UATDB/11.2.0.3/bin/oradism
[root@UATDB] $ chmod 4755 /u01/app/oracle/UATDB/11.2.0.3/bin/oradism 
[root@UATDB] $ ls -la $ORACLE_HOME/bin/oradism
-rwsr-xr-x 1 root root 1340408 Sep 25 2011 /u01/app/oracle/UATDB/11.2.0.3/bin/oradism

Now tried EXPDP operation & as expected it was successful!!

Hope so u will find this post very useful 🙂

Cheers

Regards,

Adityanath

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s