OraFAQ Forum: Server Administration » CREATE PLUGGABLE DATABASE fails

Home » RDBMS Server » Server Administration » CREATE PLUGGABLE DATABASE fails

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

CREATE PLUGGABLE DATABASE fails [message #675350]

Fri, 22 March 2019 09:16

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

Re: CREATE PLUGGABLE DATABASE fails [message #675355 is a reply to message #675350]

Fri, 22 March 2019 11:09

John Watson
Messages: 8960
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/'.

Report message to a moderator

Re: CREATE PLUGGABLE DATABASE fails [message #675358 is a reply to message #675355]

Fri, 22 March 2019 12:06

a100
Messages: 34
Registered: March 2019

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 ?

Report message to a moderator

Re: CREATE PLUGGABLE DATABASE fails [message #675359 is a reply to message #675358]

Fri, 22 March 2019 12:43

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What do you call "PDB admin user"?

Report message to a moderator

Re: CREATE PLUGGABLE DATABASE fails [message #675360 is a reply to message #675359]

Fri, 22 March 2019 16:56

a100
Messages: 34
Registered: March 2019

Member

The user which was specified as the admin user when creating PDB ?

Report message to a moderator

Re: CREATE PLUGGABLE DATABASE fails [message #675361 is a reply to message #675360]

Fri, 22 March 2019 17:24

a100
Messages: 34
Registered: March 2019

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 ...

Report message to a moderator

Re: CREATE PLUGGABLE DATABASE fails [message #675363 is a reply to message #675361]

Fri, 22 March 2019 18:56

a100
Messages: 34
Registered: March 2019

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 ?

Report message to a moderator

Re: CREATE PLUGGABLE DATABASE fails [message #675364 is a reply to message #675363]

Sat, 23 March 2019 01:26

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

John Watson
Messages: 8960
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

a100
Messages: 34
Registered: March 2019

Member

Thank you John and Michel - I have managed to create (and use successfully Wink

) the PDBs.
Really appreciate your help !

Report message to a moderator

Previous Topic:	LOCK USER AT A SPECIFIC DATE
Next Topic:	drop sub partition on table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 08:34:29 CST 2024