Forum Stats

  • 3,855,574 Users
  • 2,264,523 Discussions
  • 7,906,071 Comments

Discussions

ORA-01537 when I try to sync a PDB

Arturo Gutierrez
Arturo Gutierrez Member Posts: 337 Bronze Badge
edited Jun 12, 2019 11:11AM in Multitenant

Hi,

I've an application container called CRM_ROOT.

I several PDBs created under it.

I've installed an application that create a tablespace,user, tables and so on.

And when I try to sync the CRM_SPAIN pdb fails with this error:

SQL> show user

USER is "SYS"

SQL> show con_name

CON_NAME

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

CRM_SPAIN

SQL> ALTER PLUGGABLE DATABASE APPLICATION crm_app SYNC;

ALTER PLUGGABLE DATABASE APPLICATION crm_app SYNC

*

ERROR at line 1:

ORA-01537: cannot add file '/u01/app/oracle/oradata/CDB1/CRM_ROOT/crm_tbs.dbf'

- file already part of database

I've defined the parameter:

alter system set pdb_file_name_convert='/u01/app/oracle/oradata/CDB1/CRM_ROOT/','/u01/app/oracle/oradata/CDB1/CRM_SPAIN/';

But the same error happen.

And the PDB was created without OMF files.

CREATE PLUGGABLE DATABASE  CRM_SPAIN

ADMIN USER PDBADMIN IDENTIFIED BY oracle

ROLES=(CONNECT)

file_name_convert=('/u01/app/oracle/oradata/CDB1/CRM_ROOT/crm_seed/','/u01/app/oracle/oradata/CDB1/CRM_ROOT/CRM_SPAIN/')

STORAGE ( MAXSIZE UNLIMITED MAX_SHARED_TEMP_SIZE UNLIMITED)

/

I'm working with:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production  Version 19.3.0.0.0 on Linux.

Is possible to fix this issue?

Many thanks

Arturo

Best Answer

Answers