Database Administration (MOSC)

MOSC Banner

create pdb from source results in ora-01119 and ora-27040: how to prevent/fix?

I am creating a pdb from a non-cdb source via a dblink:

create pluggable database DB12 FROM NON$CDB@sourcedblink file_name_convert=('BANNOCDB','BANCDB/DB12') keystore identified by "xxxxxxxxxxx" parallel 32 tempfile reuse;

About 6 hours later, I get this error:

ERROR at line 1:

ORA-01119: error in creating database file '/u07/oradata/BANCDB/DB12/temp_BANCDB/DB12_1.dbf'

ORA-27040: file create error, unable to create file

SVR4 Error: 2: No such file or directory

Additional information: 1

The error is correct, the file or directory does not exist. In fact, the entire tree starting with DB12 does not exist when I first start. Why is the create pdb failing to create this directory and file?

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