Database Utilities (MOSC)

MOSC Banner

ahow to create pluggable database in oracle e-business suite database

edited Jul 11, 2019 5:07AM in Database Utilities (MOSC) 6 commentsAnswered

hi experts, I have installed fresh oracle e-business suite R12.2.8 along with database R12.1.0.2. Here i need to create multiple sachems in separate database. Hence need to create pluggable database. I dont have any idea to do so. Please guide me to so this.

here i have checked my database with following query and it is showing that the ebs database is pluggable database.

select decode(sys_context('USERENV', 'CON_NAME'),'CDB$ROOT',sys_context('USERENV',

'DB_NAME'),sys_context('USERENV', 'CON_NAME')) DB_NAME,

  decode(sys_context('USERENV','CON_ID'),1,'CDB','PDB') TYPE

   from DUAL;

DB_NAME                        TYPE

------------------------------ --------------------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center