12 Replies Latest reply: Jul 27, 2013 12:33 AM by user12288492 RSS

    Create local user 12g DB

    user12155310

      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