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 220.127.116.11.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 18.104.22.168.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/22.214.171.124/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/126.96.36.199/bin/oradism [root@UATDB] $ chmod 4755 /u01/app/oracle/UATDB/188.8.131.52/bin/oradism [root@UATDB] $ ls -la $ORACLE_HOME/bin/oradism -rwsr-xr-x 1 root root 1340408 Sep 25 2011 /u01/app/oracle/UATDB/184.108.40.206/bin/oradism
Now tried EXPDP operation & as expected it was successful!!
Hope so u will find this post very useful 🙂
Categories: Administration, backup & recovery
I want looking through and I believe this website got some truly utilitarian stuff on it! .
Thanks for visiting and appreciate your feedback.:-)
Lovely just what I was looking for.