ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

Posted on by Juan Andres Mercado in Impdp - Expdp
Unix filesystem

Utilizo con frecuencia un filesystem compartido NFS entre varios equipos para convertir el pasaje de archivos de un servidor a otro de la manera mas rápida posible.

Cuando trabajo con RMAN nunca tuve inconvenientes, pero al momento de importa o exportar un schema, tablas , etc me encuentro con el siguiente error:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/tsm/prod/apps/day/EXP_DAPRO.dmp" for read
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3

Buscando en varios lugares encontre de las mas variadas soluciones, que van desde utilizar un filesystem local no NFS (Como hago con un archivo de 30G o más ??) hasta colocar parametros inexistentes. 😀

La solución la encontre de la mano del párametro actimeo.

Veamos un ejemplo de lo que ocurre cuando escribimos (o leemos).

Si los cambios son realizados por un cliente y deben reflejarse en otros clientes con un mayor control, la duración (lifetime) de la vida del caché de atributos se puede reducir a segundos con la opción actimeo, que establece el archivo que regula la vida mínima y la vida máxima en el valor mismo.

Esto nos permite tener un minímo tiempo de acceso.

Seteamos el párametro actimeo en 0.

nfsrepo-noprod:/tsm_bd_noprod /tsm    nfs4    rw,hard,intr,timeo=600,actimeo=0,proto=tcp,bg,rsize=262144,wsize=262144 0 0
nfsrepo-noprod:/u03_bd_noprod /u03    nfs4    rw,hard,intr,timeo=600,actimeo=0,proto=tcp,bg,rsize=262144,wsize=262144 0 0

Desmontamos el filesystem.

# umount /tsm
# umount /u03

Lo montamos nuevamente.

# mount /tsm
# mount /u03

Ejecutamos el import del archivo con el comando impdp y transcurre sin problemas.

$ impdp system directory=DUMPDIR_DP dumpfile=EXP_DAPRO.dmp logfile=impdp_EXP_DAPRO.log remap_schema=DAPRO:DADES 

Import: Release 10.2.0.4.0 - 64bit Production on Friday, 20 May, 2011 16:56:04

Copyright (c) 2003, 2007, Oracle.  All rights reserved.
Password: 

UDI-00008: operation generated ORACLE error 28011
ORA-28011: the account will expire soon; change your password nowConnected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01":  system/******** directory=DUMPDIR_DP dumpfile=EXP_DAPRO.dmp logfile=impdp_EXP_DAPRO.log remap_schema=DAPRO:DADES
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"DADES" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Hasta la próxima !

Published by Juan Andres Mercado

MLops & Devops Leader Manager | Innovation & Tech Evangelist| Big Data & ML Enthusiast | Ex-DBA & Exadata Manager | Consultant | Father | Musician | Farmer | Environmentalist Argentina | juanmercadoit.com

3 thoughts on “ORA-27054: NFS file system where the file is created or resides is not mounted with correct options”

  1. muchas gracias por la info, solo una duds, como se hace el seteo del actime??solo ejecutando esta linea?
    nombre_punto_montaje nfs4 rw,hard,intr,timeo=600,actimeo=0,proto=tcp,bg,rsize=262144,wsize=262144 0 0

    Muchas gracias

    Like

  2. hello there and thank you for your info – I’ve definitely picked up anything new from right here. I did however expertise a few technical issues using this site, since I experienced to reload the web site lots of times previous to I could get it to load properly. I had been wondering if your web hosting is OK? Not that I’m complaining, but
    sluggish loading instances times will often affect your placement in
    google and can damage your high quality score if ads and marketing with Adwords.
    Well I’m adding this RSS to my e-mail and can look out for much more of your respective intriguing content. Make sure you update this again very soon.

    Like

  3. I searching a lot of in this topic, but this resolved my problem. Thank you! 🙂
    The full mount option, what is working for me: rw,bg,hard,rsize=32768,wsize=32768,proto=tcp,timeo=600,suid,noac,actimeo=0

    Liked by 1 person

Comments are closed.