Storage Management (ASM ACFS DNFS ODM) (MOSC)

MOSC Banner

Transportable tablespace datapump import fails when trying to read the ASM file

edited Jul 21, 2023 3:14PM in Storage Management (ASM ACFS DNFS ODM) (MOSC) 3 commentsAnswered

ODA X9-2 - newbie with ASM

Using document:

Using Transportable Tablespaces to Migrate Oracle E-Business Suite Release 12.2 Using Oracle Database 19c Enterprise Edition On a Multitenant Environment

I am trying to run the import step

impdp system/<system password> parfile=auimpfulltts.dat

but getting the following error:

21-JUL-23 16:13:00.092: ORA-39123: Data Pump transportable tablespace job aborted

ORA-01565: error in identifying file '+DATA/ASM/DATAFILE/ABMD.1824.1648.1142779605'

ORA-17503: ksfdopn:2 Failed to open file +DATA/ASM/DATAFILE/ABMD.1824.1648.1142779605

ORA-15260: permission denied on ASM disk group

-------------------------------------------------------

The file is there - it was copied in ASM from source directory to the target database ASM directory where it created an alias. I then amended the import file to point to the direct path and not use the alias path and name

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center