Home » RDBMS Server » Server Administration » CREATE PLUGGABLE DATABASE fails
CREATE PLUGGABLE DATABASE fails [message #675350] Fri, 22 March 2019 09:16 Go to next message
a100
Messages: 24
Registered: March 2019
Junior 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

Re: CREATE PLUGGABLE DATABASE fails [message #675355 is a reply to message #675350] Fri, 22 March 2019 11:09 Go to previous messageGo to next message
John Watson
Messages: 8084
Registered: January 2010
Location: Global Village
Senior Member
I think you have the wrong name conversion string. It is searching for this '/u02/app/oracle/oradata/ORCLCDB/pdbseed/' but it should searching for this '/u02/app/oracle/oradata/ORCL/pdbseed/'.
Re: CREATE PLUGGABLE DATABASE fails [message #675358 is a reply to message #675355] Fri, 22 March 2019 12:06 Go to previous messageGo to next message
a100
Messages: 24
Registered: March 2019
Junior Member
Thanks John - that worked ! Razz

By the way - if I want to change a password for the PDB admin user do I need to do that from CDB ?
Re: CREATE PLUGGABLE DATABASE fails [message #675359 is a reply to message #675358] Fri, 22 March 2019 12:43 Go to previous messageGo to next message
Michel Cadot
Messages: 66728
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What do you call "PDB admin user"?

Re: CREATE PLUGGABLE DATABASE fails [message #675360 is a reply to message #675359] Fri, 22 March 2019 16:56 Go to previous messageGo to next message
a100
Messages: 24
Registered: March 2019
Junior Member
The user which was specified as the admin user when creating PDB ?
Re: CREATE PLUGGABLE DATABASE fails [message #675361 is a reply to message #675360] Fri, 22 March 2019 17:24 Go to previous messageGo to next message
a100
Messages: 24
Registered: March 2019
Junior Member
I said that the PDB has been created successfully but ... when I run this query:
SELECT name, open_mode from v$pdbs;
I get nothing ...
Re: CREATE PLUGGABLE DATABASE fails [message #675363 is a reply to message #675361] Fri, 22 March 2019 18:56 Go to previous messageGo to next message
a100
Messages: 24
Registered: March 2019
Junior Member
When I run this:
CREATE PLUGGABLE DATABASE ORCLPDB
  ADMIN USER admin IDENTIFIED BY pass
  ...
does that mean that 'admin' user is able to create all users in ORCLPDB and grant them permissions ?
Or do I need to grant him some additional permissions ?
Re: CREATE PLUGGABLE DATABASE fails [message #675364 is a reply to message #675363] Sat, 23 March 2019 01:26 Go to previous messageGo to next message
Michel Cadot
Messages: 66728
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Database Administrator's Guide, Chapter 38 Creating and Removing PDBs with SQL*Plus.

You have a quick start with the section "Examples of Creating a PDB from the Seed".

[Updated on: Sat, 23 March 2019 01:29]

Report message to a moderator

Re: CREATE PLUGGABLE DATABASE fails [message #675366 is a reply to message #675361] Sat, 23 March 2019 02:40 Go to previous messageGo to next message
John Watson
Messages: 8084
Registered: January 2010
Location: Global Village
Senior Member
a100 wrote on Fri, 22 March 2019 22:24
I said that the PDB has been created successfully but ... when I run this query:
SELECT name, open_mode from v$pdbs;
I get nothing ...
Perhaps you are connected to a different database, a non-CDB. v$containers is a better view to query.

[Updated on: Sat, 23 March 2019 02:41]

Report message to a moderator

Re: CREATE PLUGGABLE DATABASE fails [message #675409 is a reply to message #675366] Thu, 28 March 2019 01:08 Go to previous message
a100
Messages: 24
Registered: March 2019
Junior Member
Thank you John and Michel - I have managed to create (and use successfully Wink ) the PDBs.
Really appreciate your help !
Previous Topic: LOCK USER AT A SPECIFIC DATE
Next Topic: drop sub partition on table
Goto Forum:
  


Current Time: Fri Dec 13 07:35:08 CST 2019