Friday 28 September 2018

RMAN hangs with Direct NFS: please check that oradism is setuid

Issue: RMAN Restore command hang… Not progressing
[oracle]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Sep 28 04:42:19 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: testdb (not mounted)
RMAN> restore controlfile from '/u01/testdb/bkp/testdb_controlfile_20180923_987582616_s293297_p1';

Starting restore at 28-SEP-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2281 device type=DISK

Killed

Verified alert log and found below Direct NFS messages
Killed rman job which is suspend status

Alert log:
Fri Sep 28 04:27:05 2018
Direct NFS: please check that oradism is setuid
Fri Sep 28 04:28:06 2018
Direct NFS: please check that oradism is setuid
Fri Sep 28 04:29:06 2018
Direct NFS: please check that oradism is setuid
Fri Sep 28 04:30:06 2018
Direct NFS: please check that oradism is setuid
Fri Sep 28 04:31:07 2018
Direct NFS: please check that oradism is setuid
Fri Sep 28 04:32:07 2018
Direct NFS: please check that oradism is setuid
Fri Sep 28 04:33:08 2018
Direct NFS: please check that oradism is setuid
Fri Sep 28 04:34:08 2018
Direct NFS: please check that oradism is setuid
Fri Sep 28 04:35:09 2018

Solution: Check oradism permissions and change as per below
[oracle]$ ls -la $ORACLE_HOME/bin/oradism
-rwsr-x--- 1 oracle oinstall 71790 Aug 24  2013 /u01/app/oracle/product/11.2.0_64/bin/oradism

cd $ORACLE_HOME/bin/oradism
[root]# chown root:root oradism
[root]# chmod 4755 oradism

[oracle]$ ls -la $ORACLE_HOME/bin/oradism
-rwsr-xr-x 1 root root 71790 Aug 24  2013 /u01/app/oracle/product/11.2.0_64/bin/oradism
[oracle]$
 
RMAN Restore is successful after changing permission for oradism  

RMAN> restore controlfile from '/u01/testdb/bkp/testdb_controlfile_20180923_987582616_s293297_p1';

Starting restore at 28-SEP-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2281 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/testdb/control01.ctl
output file name=/u02/testdb/control02.ctl
Finished restore at 28-SEP-18

No comments:

Post a Comment