Home » RDBMS Server » Server Administration » CREATE PLUGGABLE DATABASE fails
CREATE PLUGGABLE DATABASE fails [message #675350] Fri, 22 March 2019 09:16 Go to previous message
a100
Messages: 34
Registered: March 2019
Member
Hello,

(please forgive my ignorance - I am not oracle admin and we don't have any oracle admin - I am just unix sysadmin tasks to create a database for testing purposes)

I am trying to create PDB in Oracle 12 and have the following error:
CREATE PLUGGABLE DATABASE ORCLPDB
  ADMIN USER admin IDENTIFIED BY pass
  STORAGE (MAXSIZE 10G)
  DEFAULT TABLESPACE users 
    DATAFILE '/u02/app/oracle/oradata/orclpdb/orclpdb.dbf' SIZE 250M AUTOEXTEND ON
  PATH_PREFIX = '/u02/app/oracle/oradata/orclpdb/'
  FILE_NAME_CONVERT = ('/u02/app/oracle/oradata/ORCLCDB/pdbseed/', '/u02/app/oracle/oradata/orclpdb/');

Query execution failed

Reason:
SQL Error [65005] [99999]: ORA-65005: missing or invalid file name pattern for file - /u02/app/oracle/oradata/ORCL/pdbseed/system01.dbf
Can anyone hint me what should I change to get it working ?

[Updated on: Fri, 22 March 2019 09:17]

Report message to a moderator

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: LOCK USER AT A SPECIFIC DATE
Next Topic: drop sub partition on table
Goto Forum:
  


Current Time: Thu Apr 25 10:15:09 CDT 2024