I have a problem with the export via EXPDP for Oracle12 databases.
When the export is local, no problem. When I use an NFS share, the export starts, creates the log file, then nothing.
VM where the database is located: Oracle Linux Server - 6.10
Database version: Database Jan 2022 Release Update : 12.2.0.1.220118
VM where the NFS share is located: CentOS 7
Export NFS:
/MY/PATH IP_DB_VM(rw,no_root_squash,sync)
FSTAB:
IP_NFS_VM:/MY/PATH /NFS_MOUNT_PATH nfs rw,bg,hard,rsize=32768,wsize=32768,nfsvers=4,nointr,timeo=600,actimeo=0,tcp,nolock 0 0
I manage to mount the share, to write on it with the user oracle. But when I run the expdp utility, it hangs.
My expdp command:
expdp MY_USER@MY_DB full=y directory=MY_NFS_SHARE_DIRECTORY dumpfile=expdp_MYDB.dmp logfile=expdp_MYDB.log
The export appears in DEFINING when I look at its state in the database, and I am then forced to kill the process (the KILL_JOB does not work)
If you have any idea what might be causing this behavior, and how to fix it!
Thanks in advance!