Oracle 12C administration

Learnomate Technologies > Oracle 12C administration

How To Create Pluggable Database In Oracle 12c

Jan

Create Pluggable database in Oracle 12c In this blog, We will see How to create the pluggable database in oracle 12c. Now Connect to Sqlplus utility, check pdbs.

Posted in: Oracle DBA ,

Tags: Oracle 12C administration , Pluggable Database ,

How to change sys & System user password in Oracle 12C database

Jun

We cannot change the sys and system password in usual way as like till 11g. we have different method to do same. following blog describe the way to change user password in oracle 12c database. How to change SYS/SYSTEM password in 12C-Oracle 12C Administration =================================================== PDB1@ORCL= alter session set container=CDB$ROOT; Session altered. PDB1@ORCL=show con_id CON_ID […]

Posted in: Oracle DBA ,

Tags: How to change sys & System user password in Oracle 12C database , oracle , oracle 12c , Oracle 12C administration , Oracle 12C database , oracle admin , oracle Database , oracle dba , Oracle DBA Scripts ,

How to create user in oracle 12c ?- Interview question

Jun

In this bog, I will explain you how the user management work in oracle 12c. Starting from Oracle 12C there are two types of user. Common User Local User Common User Common user have the access to all PDB except seed pdb Common user start with C## prefix SYS and SYSTEM are the common user […]

Posted in: Oracle DBA ,