This discussion is archived
12 Replies Latest reply: Jul 26, 2013 10:33 PM by user12288492 RSS

Create local user 12g DB

user12155310 Newbie
Currently Being Moderated

Hi,

 

I am trying to create a local test user  (DB 12g Win7 / 64) :

 

SQL> conn sys

 

SQL> alter session set container=PDBORCL;
Session altered.


SQL> show con_name

CON_NAME
------------------
PDBORCL


SQL> create user test identified by test;


==> ORA-01109 : Database is not opened.

select .. from v_$services;


0pdborcl2477889254pdborcl0
5db112gr1XDB1684560570db112gr1XDB25.07.134091627695
6db112gr11712327574db112gr125.07.134091627695
1SYS$BACKGROUND16595921928.06.133062388681
2SYS$USERS342705567628.06.133062388681



Sorry, I did not learn and understand the new common / local user concept yet.


How can I start the PDB and create a local user to handle normal grant as 11g DB schema users ?


Many thanks and regards

Friedhold



Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points