Pages

Tuesday, April 25, 2017

creating common user # db12c ##

creating common user on container databases
SQL> create user c##nikhil identified by oracle;
User created.

SQL> grant sysdba to c##nikhil;
Grant succeeded.

SQL> grant create session to c##nikhil;
Grant succeeded.

SQL> select * from v$pwfile_users;
USERNAME       SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM     CON_ID
------------------------------ ----- ----- ----- ----- ----- ----- ----------
SYS                       TRUE  FALSE FALSE FALSE FALSE FALSE          1
SYSDG                 FALSE FALSE FALSE FALSE TRUE  FALSE          1
SYSBACKUP       FALSE FALSE FALSE TRUE  FALSE FALSE          1
SYSKM                 FALSE FALSE FALSE FALSE FALSE TRUE           1
SYSTEM               TRUE  FALSE FALSE FALSE TRUE  FALSE          1
DBSNMP              TRUE  FALSE FALSE FALSE TRUE  FALSE          1
C##NIKHIL          TRUE  FALSE FALSE FALSE FALSE FALSE          1
7 rows selected.

connecting using common user as sysdba#
[oracle@kansas ~]$ sqlplus c##nikhil/oracle as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Mon Apr 24 01:17:06 2017
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> 
SQL> show user;
USER is "SYS"

Connecting as common User “c##nikhil# to manage container database # 
[oracle@kansas ~]$ sqlplus
SQL*Plus: Release 12.1.0.1.0 Production on Mon Apr 24 01:18:04 2017
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Enter user-name: c##nikhil
Enter password: 
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> 
SQL> 
SQL> show user;
USER is "C##NIKHIL"


>> >> >>>
---Nikhil Tatineni---
---Oracle Database---