Multitenant Self-Service Provisioning - BETA 2 - No emails out for ADMIN user

What did I mean? Actually, I thought how to rename "ADMIN" user?or How to rename "Email Address" on  Multitenant Self-Service Provisioning? Why I interested in it?

I created New Database by using "ADMIN" user.

I didn't get email about credentials (Because no email address for ADMIN user). So, I didn't know about PDB_ADMIN password for this PDB.

Then,I tested creating New Database with other users.

Other users, they are email address. When I used them to create New Database on Multitenant Self-Service Provisioning. Email was sent to users for credentials.
Example Email:

In emails, users should see credentials about PDB_ADMIN schema (Database Schema Credential) and 
ADMIN (APEX Credential).

So, Users should use other users to create Database (PDB) and users should be email address (real email addresses).
Note: Don't miss to set Server be able to send email out.

Related Posts:
Multitenant Self-Service Provisioning - BETA 2 - Started to play
Multitenant Self-Service Provisioning - BETA 2 - Role
Multitenant Self-Service Provisioning - BETA 2 - Connect SQL Developer with pdb_admin

Multitenant Self-Service Provisioning - BETA 2 - Connect SQL Developer with pdb_admin

I didn't write about setting SQL Developer to connect PDB. I just tested connection by using SQL Developer with pdb_admin. As you know - The PDB_ADMIN user in newly created PDBs has SYSDBA system privilege so it can fully manage the PDB.

SQL> conn / as sysdba
Connected.
SQL> alter session set container=pdb1;

Session altered.

SQL> alter user pdb_admin identified by password;

User altered.

SQL> connect pdb_admin/password@test12c/pdb1
Connected.
SQL> show user;
USER is "PDB_ADMIN"
SQL>

How to connect "pdb1" through SQL Developer? Set it on SQL Developer?... Actually Users can download xml file on  Multitenant Self-Service Provisioning web.

After downloaded, A User import xml file on SQL Developer as example.

Now! pdb_admin user is able to connect PDB1 through SQL Developer.

Related Posts:
Multitenant Self-Service Provisioning - BETA 2 - Started to play
Multitenant Self-Service Provisioning - BETA 2 - Role

Multitenant Self-Service Provisioning - BETA 2 - Role

Last post, I posted about Oracle Multitenant Self-Service Provisioning - BETA 2 and read more about what changes have been made in this Beta 2 release.

Users with the PDBA role in the Oracle Multitenant Self-Service Provisioning application can only view PDBs that they created or have been made an administrator of. Because of this, the "Privileges" filter is not displayed. Users with the CDBA role will still see all PDBs as well as the "Privileges" filter.

So, I added New User with Pluggable Database Administrator (PDBA), then logged in with New User and added New Database (PDB2). So, I only found what PDB, that New User created.

After checking more, I changed role to be Container Database Administrator (CDBA) on New User and re-logged in again.

Related Post:
Multitenant Self-Service Provisioning - BETA 2 - Started to play

Multitenant Self-Service Provisioning - BETA 2 - Started to play

Got news on tweeter about Multitenant Self-Service Provisioning - BETA 2. It's very interesting. You will find something change. For example On Oracle Multitenant Self Service Provisioning - BETA 1 runs in APEX pdb.
(Downloaded pdbss_1030.zip and installed)
This version, the Oracle Multitenant Self-Service Provisioning application now runs in CDB$ROOT instead of a PDB.

SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT

SQL> select name, open_mode from v$pdbs;

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY

... some.. The PDB_ADMIN user in newly created PDBs has SYSDBA system privilege so it can fully manage the PDB.

SQL> select con_id, name, open_mode from v$pdbs;

    CON_ID NAME                           OPEN_MODE
---------- ------------------------------ ----------
         2 PDB$SEED                       READ ONLY

SQL> select con_id, username from cdb_users where username ='PDB_ADMIN';

no rows selected

*** Created PDB ***

SQL>  select name, open_mode from v$pdbs;
NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
PDB1                           READ WRITE

SQL> select con_id, username from cdb_users where username ='PDB_ADMIN';

    CON_ID USERNAME
---------- ---------------------------------------------------
         3 PDB_ADMIN

Oops!

SQL> SELECT * FROM V$PWFILE_USERS;

USERNAME                       SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM     CON_ID
------------------------------ ----- ----- ----- ----- ----- ----- ----------
SYS                            TRUE  TRUE  FALSE FALSE FALSE FALSE          0
SYSDG                          FALSE FALSE FALSE FALSE TRUE  FALSE          1
SYSBACKUP                      FALSE FALSE FALSE TRUE  FALSE FALSE          1
SYSKM                          FALSE FALSE FALSE FALSE FALSE TRUE           1
C##PDBMGR                      TRUE  FALSE FALSE FALSE FALSE FALSE          0
PDB_ADMIN                      TRUE  FALSE FALSE FALSE FALSE FALSE          3

6 rows selected.

Install Patch 17027533 on Multitenant (CDB/PDB)

Today, I got email about Critical Patch Update - October 2013. I found Oracle Patch for 12c Database. I checked some requirements.

OPatch requirement for October 2013:
- OPatch 12.1.0.1.1 for Database PSU 12.1.0.1.1
- OPatch 12.1.0.1.2 for GI PSU 12.1.0.1.1

Anyway, I wanted to patch for Database only. So, I downloaded "Patch 17027533: DATABASE PATCH SET UPDATE 12.1.0.1.1" and tested for patching.

Note: 17272829 GRID INFRASTRUCTURE PATCH SET UPDATE 12.1.0.1.1 (INCLUDES DB PSU 12.1.0.1.1) 

If Users use Oracle GI 12c and Database 12c, User can use PSU 17272829 to patch GI and DB.

After downloaded, It was time for test on my Database.
- Check Opatch version and some command-lines.

[oracle@test12c ~]$ /u01/app/oracle/product/12.1.0/dbhome_1/OPatch/opatch version
OPatch Version: 12.1.0.1.0
OPatch succeeded.
[oracle@test12c ~]$ type make
make is /usr/bin/make
[oracle@test12c ~]$ type ar
ar is /usr/bin/ar
[oracle@test12c ~]$ type ld
ld is /usr/bin/ld
[oracle@test12c ~]$ type nm
nm is /usr/bin/nm
[oracle@test12c ~]$

- Uncompress PSU file, Check conflict with the PSU.

[oracle@test12c ~]$ unzip p17027533_121010_Linux-x86-64.zip
[oracle@test12c ~]$ cd 17027533
[oracle@test12c 17027533]$ export PATH=$PATH:/u01/app/oracle/product/12.1.0/dbhome_1/OPatch
[oracle@test12c 17027533]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.
PREREQ session
Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version    : 12.1.0.1.0
OUI version       : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2013-10-16_09-22-53AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@test12c 17027533]$ cat  /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2013-10-16_09-22-53AM_1.log
[Oct 16, 2013 9:22:54 AM]    PREREQ session
[Oct 16, 2013 9:22:54 AM]    OPatch invoked as follows: 'prereq CheckConflictAgainstOHWithDetail -ph ./ -invPtrLoc /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc '
[Oct 16, 2013 9:22:54 AM]    OUI-67077:
                             Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_1
                             Central Inventory : /u01/app/oraInventory
                                from           : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
                             OPatch version    : 12.1.0.1.0
                             OUI version       : 12.1.0.1.0
                             OUI location      : /u01/app/oracle/product/12.1.0/dbhome_1/oui
                             Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2013-10-16_09-22-53AM_1.log
[Oct 16, 2013 9:22:54 AM]    Patch history file: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
[Oct 16, 2013 9:22:54 AM]    Invoking prereq "checkconflictagainstohwithdetail"
[Oct 16, 2013 9:22:56 AM]    Patch 17027533 is not subset of any other patch processed till now
[Oct 16, 2013 9:22:56 AM]    Patch ID  17027533
[Oct 16, 2013 9:22:56 AM]    Patches that conflict: [  ]
[Oct 16, 2013 9:22:56 AM]    Checking conflicts for patch: 17027533
[Oct 16, 2013 9:22:56 AM]    Checking conflicts/supersets for patch: 17027533 with patch:17027533
[Oct 16, 2013 9:22:56 AM]    Prereq "checkConflictAgainstOHWithDetail" passed.
[Oct 16, 2013 9:22:56 AM]    Finishing PrereqSession at Wed Oct 16 09:22:56 ICT 2013
[oracle@test12c 17027533]$

No Conflict with the PSU.
- Shutdown Database and Stop Listener. (I tested with Multitenant Database)

[oracle@test12c 17027533]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Wed Oct 16 09:24:00 2013
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> select name, open_mode from v$pdbs;
NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
APEX                           READ WRITE
TESTPDB                        READ WRITE
OPUNPDB                        READ WRITE
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@test12c 17027533]$ lsnrctl stop
LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 16-OCT-2013 09:26:08
Copyright (c) 1991, 2013, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test12c)(PORT=1521)))
The command completed successfully

- Patch Database software and Check.

[oracle@test12c 17027533]$ pwd
/home/oracle/17027533
[oracle@test12c 17027533]$ opatch apply
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version    : 12.1.0.1.0
OUI version       : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/17027533_Oct_16_2013_09_27_59/apply2013-10-16_09-27-59AM_1.log
Applying interim patch '17027533' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Verifying environment and performing prerequisite checks...
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0/dbhome_1')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Patching component oracle.rdbms, 12.1.0.1.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.1.0...
Patching component oracle.rdbms.rsf, 12.1.0.1.0...
Patching component oracle.ldap.rsf, 12.1.0.1.0...
Patching component oracle.ldap.rsf.ic, 12.1.0.1.0...
Verifying the update...
Patch 17027533 successfully applied
Log file location: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/17027533_Oct_16_2013_09_27_59/apply2013-10-16_09-27-59AM_1.log
OPatch succeeded.
[oracle@test12c 17027533]$ less /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/17027533_Oct_16_2013_09_27_59/apply2013-10-16_09-27-59AM_1.log
[oracle@test12c 17027533]$
[oracle@test12c 17027533]$
[oracle@test12c 17027533]$ opatch lsinventory -detail
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version    : 12.1.0.1.0
OUI version       : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2013-10-16_09-32-36AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2013-10-16_09-32-36AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 12c                                                  12.1.0.1.0
There are 1 products installed in this Oracle Home.

Installed Products (131):
Assistant Common Files                                               12.1.0.1.0
Buildtools Common Files                                              12.1.0.1.0
Cluster Verification Utility Common Files                            12.1.0.1.0
Database Configuration and Upgrade Assistants                        12.1.0.1.0
Database Migration Assistant for Unicode                             12.1.0.1.0
Database SQL Scripts                                                 12.1.0.1.0
Database Workspace Manager                                           12.1.0.1.0
Deinstallation Tool                                                  12.1.0.1.0
Enterprise Edition Options                                           12.1.0.1.0
Expat libraries                                                       2.0.1.0.2
Generic Connectivity Common Files                                    12.1.0.1.0
HAS Common Files                                                     12.1.0.1.0
HAS Files for DB                                                     12.1.0.1.0
Installation Common Files                                            12.1.0.1.0
Installation Plugin Files                                            12.1.0.1.0
Installer SDK Component                                              12.1.0.1.0
JAccelerator (COMPANION)                                             12.1.0.1.0
LDAP Required Support Files                                          12.1.0.1.0
OLAP SQL Scripts                                                     12.1.0.1.0
Oracle Advanced Security                                             12.1.0.1.0
Oracle Application Express                                           12.1.0.1.0
Oracle Bali Share                                                    11.1.1.6.0
Oracle Call Interface (OCI)                                          12.1.0.1.0
Oracle Clusterware RDBMS Files                                       12.1.0.1.0
Oracle Configuration Manager                                         10.3.7.0.3
Oracle Configuration Manager Client                                  10.3.2.1.0
Oracle Configuration Manager Deconfiguration                         10.3.1.0.0
Oracle Containers for Java                                           12.1.0.1.0
Oracle Core Required Support Files                                   12.1.0.1.0
Oracle Core Required Support Files for Core DB                       12.1.0.1.0
Oracle Core XML Development Kit                                      12.1.0.1.0
Oracle Data Mining RDBMS Files                                       12.1.0.1.0
Oracle Database 12c                                                  12.1.0.1.0
Oracle Database 12c                                                  12.1.0.1.0
Oracle Database 12c Multimedia Files                                 12.1.0.1.0
Oracle Database Deconfiguration                                      12.1.0.1.0
Oracle Database Gateway for ODBC                                     12.1.0.1.0
Oracle Database Plugin for Oracle Virtual Assembly Builder           12.1.0.1.0
Oracle Database User Interface                                       11.0.0.0.0
Oracle Database Utilities                                            12.1.0.1.0
Oracle Database Vault option                                         12.1.0.1.0
Oracle DBCA Deconfiguration                                          12.1.0.1.0
Oracle Extended Windowing Toolkit                                    11.1.1.6.0
Oracle Globalization Support                                         12.1.0.1.0
Oracle Globalization Support                                         12.1.0.1.0
Oracle Globalization Support For Core                                12.1.0.1.0
Oracle Help for Java                                                 11.1.1.6.0
Oracle Help Share Library                                            11.1.1.6.0
Oracle Ice Browser                                                   11.1.1.6.0
Oracle Internet Directory Client                                     12.1.0.1.0
Oracle Java Client                                                   12.1.0.1.0
Oracle Java Layout Engine                                            11.0.0.0.0
Oracle JDBC Server Support Package                                   12.1.0.1.0
Oracle JDBC/OCI Instant Client                                       12.1.0.1.0
Oracle JDBC/THIN Interfaces                                          12.1.0.1.0
Oracle JFC Extended Windowing Toolkit                                11.1.1.6.0
Oracle JVM                                                           12.1.0.1.0
Oracle JVM For Core                                                  12.1.0.1.0
Oracle Label Security                                                12.1.0.1.0
Oracle LDAP administration                                           12.1.0.1.0
Oracle Locale Builder                                                12.1.0.1.0
Oracle Message Gateway Common Files                                  12.1.0.1.0
Oracle Multimedia                                                    12.1.0.1.0
Oracle Multimedia Client Option                                      12.1.0.1.0
Oracle Multimedia Java Advanced Imaging                              12.1.0.1.0
Oracle Multimedia Locator                                            12.1.0.1.0
Oracle Multimedia Locator Java Required Support Files                12.1.0.1.0
Oracle Multimedia Locator RDBMS Files                                12.1.0.1.0
Oracle Net                                                           12.1.0.1.0
Oracle Net Java Required Support Files                               12.1.0.1.0
Oracle Net Listener                                                  12.1.0.1.0
Oracle Net Required Support Files                                    12.1.0.1.0
Oracle Net Services                                                  12.1.0.1.0
Oracle Netca Client                                                  12.1.0.1.0
Oracle Notification Service                                          12.1.0.1.0
Oracle Notification Service (eONS)                                   12.1.0.1.0
Oracle Notification Service for Instant Client                       12.1.0.1.0
Oracle ODBC Driver                                                   12.1.0.1.0
Oracle ODBC Driverfor Instant Client                                 12.1.0.1.0
Oracle OLAP                                                          12.1.0.1.0
Oracle OLAP API                                                      12.1.0.1.0
Oracle OLAP RDBMS Files                                              12.1.0.1.0
Oracle One-Off Patch Installer                                       12.1.0.1.0
Oracle Partitioning                                                  12.1.0.1.0
Oracle Programmer                                                    12.1.0.1.0
Oracle Quality of Service Management (Client)                        12.1.0.1.0
Oracle R Enterprise Server Files                                     12.1.0.1.0
Oracle RAC Deconfiguration                                           12.1.0.1.0
Oracle RAC Required Support Files-HAS                                12.1.0.1.0
Oracle Real Application Testing                                      12.1.0.1.0
Oracle Recovery Manager                                              12.1.0.1.0
Oracle Security Developer Tools                                      12.1.0.1.0
Oracle Spatial and Graph                                             12.1.0.1.0
Oracle SQL Developer                                                 12.1.0.1.0
Oracle Starter Database                                              12.1.0.1.0
Oracle Text                                                          12.1.0.1.0
Oracle Text ATG Language Support Files                               12.1.0.1.0
Oracle Text for Core                                                 12.1.0.1.0
Oracle Text Required Support Files                                   12.1.0.1.0
Oracle Universal Connection Pool                                     12.1.0.1.0
Oracle Universal Installer                                           12.1.0.1.0
Oracle USM Deconfiguration                                           12.1.0.1.0
Oracle Wallet Manager                                                12.1.0.1.0
Oracle XML Development Kit                                           12.1.0.1.0
Oracle XML Query                                                     12.1.0.1.0
oracle.swd.oui.core.min                                              12.1.0.1.0
Parser Generator Required Support Files                              12.1.0.1.0
Perl Interpreter                                                     5.14.1.0.0
Perl Modules                                                         5.14.1.0.0
PL/SQL                                                               12.1.0.1.0
PL/SQL Embedded Gateway                                              12.1.0.1.0
Platform Required Support Files                                      12.1.0.1.0
Precompiler Common Files                                             12.1.0.1.0
Precompiler Common Files for Core                                    12.1.0.1.0
Precompiler Required Support Files                                   12.1.0.1.0
Precompilers                                                         12.1.0.1.0
RDBMS Required Support Files                                         12.1.0.1.0
RDBMS Required Support Files for Instant Client                      12.1.0.1.0
RDBMS Required Support Files Runtime                                 12.1.0.1.0
Required Support Files                                               12.1.0.1.0
Sample Schema Data                                                   12.1.0.1.0
Secure Socket Layer                                                  12.1.0.1.0
SQL*Plus                                                             12.1.0.1.0
SQL*Plus Files for Instant Client                                    12.1.0.1.0
SQL*Plus Required Support Files                                      12.1.0.1.0
SQLJ Runtime                                                         12.1.0.1.0
SSL Required Support Files for InstantClient                         12.1.0.1.0
Sun JDK                                                              1.6.0.37.0
XDK Required Support Files                                           12.1.0.1.0
XML Parser for Java                                                  12.1.0.1.0
XML Parser for Oracle JVM                                            12.1.0.1.0
There are 131 products installed in this Oracle Home.

Interim patches (1) :
Patch  17027533     : applied on Wed Oct 16 09:29:44 ICT 2013
Unique Patch ID:  16677152
Patch description:  "Database Patch Set Update : 12.1.0.1.1 (17027533)"
   Created on 27 Sep 2013, 05:30:33 hrs PST8PDT
   Bugs fixed:
     17034172, 16694728, 16448848, 16863422, 16634384, 16465158, 16320173
     16313881, 16910734, 16816103, 16911800, 16715647, 16825779, 16707927
     16392068, 14197853, 16712618, 17273253, 16902138, 16524071, 16856570
     16465149, 16705020, 16689109, 16372203, 16864864, 16849982, 16946613
     16837842, 16964279, 16459685, 16978185, 16845022, 16195633, 14536110
     16964686, 16787973, 16850996, 16674842, 16838328, 16178562, 15996344
     16503473, 16842274, 16935643, 17000176, 14355775, 16362358, 16994576
     16485876, 16919176, 16928832, 16864359, 16617325, 16921340, 16679874
     16788832, 16483559, 16733884, 16784167, 16286774, 15986012, 16660558
     16674666, 16191248, 16697600, 16993424, 16946990, 16589507, 16173738
     16784143, 16772060, 16991789, 17346196, 16495802, 16859937, 16590848
     16910001, 16603924, 16427054, 16730813, 16227068, 16663303, 16784901
     16836849, 16186165, 16457621, 16007562, 16170787, 16663465, 16524968
     16543323, 17027533, 16675710, 17005047, 16795944, 16668226, 16070351
     16212405, 16523150, 16698577, 16621274, 16930325, 17330580, 16443657
   Files Touched:
     /kcb.o --> ORACLE_HOME/lib/libserver12.a
     /kcbo.o --> ORACLE_HOME/lib/libserver12.a
     /kcl.o --> ORACLE_HOME/lib/libserver12.a
     /kjzd.o --> ORACLE_HOME/lib/libserver12.a
     /kjzn.o --> ORACLE_HOME/lib/libserver12.a
     /kjb.o --> ORACLE_HOME/lib/libserver12.a
     /kjbl.o --> ORACLE_HOME/lib/libserver12.a
     /kjbm.o --> ORACLE_HOME/lib/libserver12.a
     /kjbr.o --> ORACLE_HOME/lib/libserver12.a
     /kjcts.o --> ORACLE_HOME/lib/libserver12.a
     /kjfc.o --> ORACLE_HOME/lib/libserver12.a
     /kjm.o --> ORACLE_HOME/lib/libserver12.a
     /dgl.o --> ORACLE_HOME/lib/libserver12.a
     /dgls.o --> ORACLE_HOME/lib/libserver12.a
     /kxes.o --> ORACLE_HOME/lib/libserver12.a
     /kkm.o --> ORACLE_HOME/lib/libserver12.a
     /kql.o --> ORACLE_HOME/lib/libserver12.a
     /kqlb.o --> ORACLE_HOME/lib/libserver12.a
     /qol.o --> ORACLE_HOME/lib/libserver12.a
     /kqr.o --> ORACLE_HOME/lib/libserver12.a
     /ctc.o --> ORACLE_HOME/lib/libserver12.a
     /cvw.o --> ORACLE_HOME/lib/libserver12.a
     /kkeaf.o --> ORACLE_HOME/lib/libserver12.a
     /kkp.o --> ORACLE_HOME/lib/libserver12.a
     /kkt.o --> ORACLE_HOME/lib/libserver12.a
     /sol.o --> ORACLE_HOME/lib/libserver12.a
     /jskm.o --> ORACLE_HOME/lib/libserver12.a
     /jskq.o --> ORACLE_HOME/lib/libserver12.a
     /jscr.o --> ORACLE_HOME/lib/libserver12.a
     /krvrd.o --> ORACLE_HOME/lib/libserver12.a
     /krvt.o --> ORACLE_HOME/lib/libserver12.a
     /krvxb.o --> ORACLE_HOME/lib/libserver12.a
     /krvxr.o --> ORACLE_HOME/lib/libserver12.a
     /kmm.o --> ORACLE_HOME/lib/libserver12.a
     /kokl2.o --> ORACLE_HOME/lib/libserver12.a
     /kokt.o --> ORACLE_HOME/lib/libserver12.a
     /kwqic.o --> ORACLE_HOME/lib/libserver12.a
     /kwqr.o --> ORACLE_HOME/lib/libserver12.a
     /kwqv.o --> ORACLE_HOME/lib/libserver12.a
     /kwqmn.o --> ORACLE_HOME/lib/libserver12.a
     /kwslb.o --> ORACLE_HOME/lib/libserver12.a
     /kpdb.o --> ORACLE_HOME/lib/libserver12.a
     /kpdba.o --> ORACLE_HOME/lib/libserver12.a
     /kpdbc.o --> ORACLE_HOME/lib/libserver12.a
     /kpdbcv.o --> ORACLE_HOME/lib/libserver12.a
     /kpdbd.o --> ORACLE_HOME/lib/libserver12.a
     /kpdbe.o --> ORACLE_HOME/lib/libserver12.a
     /kpdbicd.o --> ORACLE_HOME/lib/libserver12.a
     /kpdbutl.o --> ORACLE_HOME/lib/libserver12.a
     /kpolon.o --> ORACLE_HOME/lib/libserver12.a
     /kpon.o --> ORACLE_HOME/lib/libserver12.a
     /opilof.o --> ORACLE_HOME/lib/libserver12.a
     /opiprs.o --> ORACLE_HOME/lib/libserver12.a
     /kfd.o --> ORACLE_HOME/lib/libserver12.a
     /kfda.o --> ORACLE_HOME/lib/libserver12.a
     /kff.o --> ORACLE_HOME/lib/libserver12.a
     /kffm.o --> ORACLE_HOME/lib/libserver12.a
     /kfgb.o --> ORACLE_HOME/lib/libserver12.a
     /kfi.o --> ORACLE_HOME/lib/libserver12.a
     /kfpkg.o --> ORACLE_HOME/lib/libserver12.a
     /kfvsu.o --> ORACLE_HOME/lib/libserver12.a
     /kdo.o --> ORACLE_HOME/lib/libserver12.a
     /kdu.o --> ORACLE_HOME/lib/libserver12.a
     /kdn.o --> ORACLE_HOME/lib/libserver12.a
     /kcc.o --> ORACLE_HOME/lib/libserver12.a
     /kcf.o --> ORACLE_HOME/lib/libserver12.a
     /kcfis.o --> ORACLE_HOME/lib/libserver12.a
     /kcvfdb.o --> ORACLE_HOME/lib/libserver12.a
     /krt.o --> ORACLE_HOME/lib/libserver12.a
     /knac.o --> ORACLE_HOME/lib/libserver12.a
     /knahf.o --> ORACLE_HOME/lib/libserver12.a
     /knahs.o --> ORACLE_HOME/lib/libserver12.a
     /knalf.o --> ORACLE_HOME/lib/libserver12.a
     /knals.o --> ORACLE_HOME/lib/libserver12.a
     /knalse.o --> ORACLE_HOME/lib/libserver12.a
     /knam.o --> ORACLE_HOME/lib/libserver12.a
     /knanr.o --> ORACLE_HOME/lib/libserver12.a
     /knas.o --> ORACLE_HOME/lib/libserver12.a
     /knasda.o --> ORACLE_HOME/lib/libserver12.a
     /knasp.o --> ORACLE_HOME/lib/libserver12.a
     /knasx.o --> ORACLE_HOME/lib/libserver12.a
     /knipg.o --> ORACLE_HOME/lib/libserver12.a
     /knl.o --> ORACLE_HOME/lib/libserver12.a
     /knlogc.o --> ORACLE_HOME/lib/libserver12.a
     /kkzl.o --> ORACLE_HOME/lib/libserver12.a
     /kxdam.o --> ORACLE_HOME/lib/libserver12.a
     /kxdofl.o --> ORACLE_HOME/lib/libserver12.a
     /aud.o --> ORACLE_HOME/lib/libserver12.a
     /kzap.o --> ORACLE_HOME/lib/libserver12.a
     /kzp.o --> ORACLE_HOME/lib/libserver12.a
     /kzr.o --> ORACLE_HOME/lib/libserver12.a
     /kzckm.o --> ORACLE_HOME/lib/libserver12.a
     /kzckmr.o --> ORACLE_HOME/lib/libserver12.a
     /kzekm.o --> ORACLE_HOME/lib/libserver12.a
     /kzmkr.o --> ORACLE_HOME/lib/libserver12.a
     /kzvdve.o --> ORACLE_HOME/lib/libserver12.a
     /zllc.o --> ORACLE_HOME/lib/libserver12.a
     /ktm.o --> ORACLE_HOME/lib/libserver12.a
     /ktsi.o --> ORACLE_HOME/lib/libserver12.a
     /ktsj.o --> ORACLE_HOME/lib/libserver12.a
     /ktt.o --> ORACLE_HOME/lib/libserver12.a
     /qesrc.o --> ORACLE_HOME/lib/libserver12.a
     /qerfx.o --> ORACLE_HOME/lib/libserver12.a
     /qkagby.o --> ORACLE_HOME/lib/libserver12.a
     /qksrc.o --> ORACLE_HOME/lib/libserver12.a
     /kewf.o --> ORACLE_HOME/lib/libserver12.a
     /kewm.o --> ORACLE_HOME/lib/libserver12.a
     /k2v.o --> ORACLE_HOME/lib/libserver12.a
     /fbadrv.o --> ORACLE_HOME/lib/libserver12.a
     /ktfa.o --> ORACLE_HOME/lib/libserver12.a
     /ktrv.o --> ORACLE_HOME/lib/libserver12.a
     /ksb.o --> ORACLE_HOME/lib/libserver12.a
     /ksfd.o --> ORACLE_HOME/lib/libserver12.a
     /ksfdaf.o --> ORACLE_HOME/lib/libserver12.a
     /ksfq.o --> ORACLE_HOME/lib/libserver12.a
     /ksk.o --> ORACLE_HOME/lib/libserver12.a
     /ksl.o --> ORACLE_HOME/lib/libserver12.a
     /ksp.o --> ORACLE_HOME/lib/libserver12.a
     /ksu.o --> ORACLE_HOME/lib/libserver12.a
     /ksws.o --> ORACLE_HOME/lib/libserver12.a
     /qmps.o --> ORACLE_HOME/lib/libserver12.a
     /jox.o --> ORACLE_HOME/rdbms/lib/libknlopt.a
     sqlpatch.pl --> ORACLE_HOME/sqlpatch/sqlpatch.pl
     sqlpatch.pm --> ORACLE_HOME/sqlpatch/sqlpatch.pm
     asmcmdcore --> ORACLE_HOME/bin/asmcmdcore
     asmcmdshare.pm --> ORACLE_HOME/lib/asmcmdshare.pm
     asmcmdexceptions.pm --> ORACLE_HOME/lib/asmcmdexceptions.pm
     asmcmddisk.pm --> ORACLE_HOME/lib/asmcmddisk.pm
     jox.o --> ORACLE_HOME/rdbms/lib/jox.o
     libosbws12.so --> ORACLE_HOME/lib/libosbws12.so
     librs12.so --> ORACLE_HOME/lib/librs12.so
     bundledata_PSU.xml --> ORACLE_HOME/rdbms/admin/bundledata_PSU.xml
     ins_rdbms.mk --> ORACLE_HOME/rdbms/lib/ikfod
     ins_rdbms.mk --> ORACLE_HOME/rdbms/lib/irenamedg
     ins_rdbms.mk --> ORACLE_HOME/rdbms/lib/ioracle
     ins_rdbms.mk --> ORACLE_HOME/rdbms/lib/client_sharedlib
     17027533_apply.sql --> ORACLE_HOME/sqlpatch/17027533/17027533_apply.sql
     17027533_rollback.sql --> ORACLE_HOME/sqlpatch/17027533/17027533_rollback.sql
     bug16286774.sql --> ORACLE_HOME/patch/scripts/bug16286774.sql
     bug16825779.sql --> ORACLE_HOME/patch/scripts/bug16825779.sql
     catbundle.sql --> ORACLE_HOME/rdbms/admin/catbundle.sql
     catbundleapply.sql --> ORACLE_HOME/rdbms/admin/catbundleapply.sql
     catbundlerollback.sql --> ORACLE_HOME/rdbms/admin/catbundlerollback.sql
     catuppst.sql --> ORACLE_HOME/rdbms/admin/catuppst.sql
     cdenv.sql --> ORACLE_HOME/rdbms/admin/cdenv.sql
     prvtlmd.plb --> ORACLE_HOME/rdbms/admin/prvtlmd.plb
     prvtbstr.plb --> ORACLE_HOME/rdbms/admin/prvtbstr.plb
     prvtbxstr.plb --> ORACLE_HOME/rdbms/admin/prvtbxstr.plb
     /kgl.o --> ORACLE_HOME/lib/libgeneric12.a
     /kgl2.o --> ORACLE_HOME/lib/libgeneric12.a
     /kgl4.o --> ORACLE_HOME/lib/libgeneric12.a
     /kxdcap.o --> ORACLE_HOME/lib/libgeneric12.a
     /kgh.o --> ORACLE_HOME/lib/libgeneric12.a
     oraus.msb --> ORACLE_HOME/rdbms/mesg/oraus.msb
     oraus.msg --> ORACLE_HOME/rdbms/mesg/oraus.msg
     libzt12.a --> ORACLE_HOME/lib/libzt12.a
     ins_net_client.mk --> ORACLE_HOME/network/lib/client_sharedlib
     libzt12.a --> ORACLE_HOME/lib/libzt12.a
     libnnzst12.a --> ORACLE_HOME/lib/libnnzst12.a
     libnnz12.so --> ORACLE_HOME/lib/libnnz12.so
   Patch Location in Inventory:
     /u01/app/oracle/product/12.1.0/dbhome_1/inventory/oneoffs/17027533
   Patch Location in Storage area:
     /u01/app/oracle/product/12.1.0/dbhome_1/.patch_storage/17027533_Sep_27_2013_05_30_33
--------------------------------------------------------------------------------
OPatch succeeded.

- Load Modified SQL Files into the Database and Check.

[oracle@test12c 17027533]$  sqlplus /nolog
SQL*Plus: Release 12.1.0.1.0 Production on Wed Oct 16 09:34:07 2013
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1636814848 bytes
Fixed Size                  2288968 bytes
Variable Size             973079224 bytes
Database Buffers          654311424 bytes
Redo Buffers                7135232 bytes
Database mounted.
Database opened.
SQL> alter pluggable database all open;

Pluggable database altered.
SQL> SQL>
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@test12c 17027533]$ cd $ORACLE_HOME/OPatch
[oracle@test12c OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.1.0.1.0 on Wed Oct 16 09:36:28 2013
Copyright (c) 2013, Oracle.  All rights reserved.
Connecting to database...OK
Determining current state...
Currently installed SQL Patches:
  PDB CDB$ROOT:
  PDB PDB$SEED:
  PDB APEX:
  PDB TESTPDB:
  PDB OPUNPDB:
Currently installed C Patches: 17027533
For the following PDBs: CDB$ROOT
  Nothing to roll back
  The following patches will be applied: 17027533
For the following PDBs: PDB$SEED
  Nothing to roll back
  The following patches will be applied: 17027533
For the following PDBs: APEX
  Nothing to roll back
  The following patches will be applied: 17027533
For the following PDBs: TESTPDB
  Nothing to roll back
  The following patches will be applied: 17027533
For the following PDBs: OPUNPDB
  Nothing to roll back
  The following patches will be applied: 17027533
Adding patches to installation queue...
Installing patches...
Validating logfiles...
Patch 17027533 apply (pdb CDB$ROOT): SUCCESS
  logfile: /u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_TESTCDB_CDBROOT_2013Oct16_09_36_40.log (no errors)
  catbundle generate logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTCDB_OPUNPDB_GENERATE_2013Oct16_09_40_43.log (no errors)
  catbundle apply logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTCDB_OPUNPDB_APPLY_2013Oct16_09_40_48.log (no errors)
Patch 17027533 apply (pdb PDB$SEED): SUCCESS
  logfile: /u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_TESTCDB_PDBSEED_2013Oct16_09_37_17.log (no errors)
  catbundle generate logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTCDB_OPUNPDB_GENERATE_2013Oct16_09_40_43.log (no errors)
  catbundle apply logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTCDB_OPUNPDB_APPLY_2013Oct16_09_40_48.log (no errors)
Patch 17027533 apply (pdb APEX): SUCCESS
  logfile: /u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_TESTCDB_APEX_2013Oct16_09_38_35.log (no errors)
  catbundle generate logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTCDB_OPUNPDB_GENERATE_2013Oct16_09_40_43.log (no errors)
  catbundle apply logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTCDB_OPUNPDB_APPLY_2013Oct16_09_40_48.log (no errors)
Patch 17027533 apply (pdb TESTPDB): SUCCESS
  logfile: /u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_TESTCDB_TESTPDB_2013Oct16_09_39_22.log (no errors)
  catbundle generate logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTCDB_OPUNPDB_GENERATE_2013Oct16_09_40_43.log (no errors)
  catbundle apply logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTCDB_OPUNPDB_APPLY_2013Oct16_09_40_48.log (no errors)
Patch 17027533 apply (pdb OPUNPDB): SUCCESS
  logfile: /u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_TESTCDB_OPUNPDB_2013Oct16_09_40_12.log (no errors)
  catbundle generate logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTCDB_OPUNPDB_GENERATE_2013Oct16_09_40_43.log (no errors)
  catbundle apply logfile: /u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_TESTCDB_OPUNPDB_APPLY_2013Oct16_09_40_48.log (no errors)
SQL Patching tool complete on Wed Oct 16 09:41:10 2013
[oracle@test12c OPatch]$

SQL> select * from cdb_registry_sqlpatch order by CON_ID;
  PATCH_ID ACTION          STATUS          ACTION_TIME                                                                 DESCRIPTION
---------- --------------- --------------- --------------------------------------------------------------------------- ---------------
LOGFILE                                                                                                                      CON_ID
------------------------------------------------------------------------------------------------------------------------ ----------
  17027533 APPLY           SUCCESS         16-OCT-13 09.41.00.582789 AM                                                bundle:PSU
/u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_TESTCDB_CDBROOT_2013Oct16_09_36_40.log                   1
  17027533 APPLY           SUCCESS         16-OCT-13 09.41.06.930702 AM                                                bundle:PSU
/u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_TESTCDB_PDBSEED_2013Oct16_09_37_17.log                   2
  17027533 APPLY           SUCCESS         16-OCT-13 09.41.09.974677 AM                                                bundle:PSU
/u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_TESTCDB_APEX_2013Oct16_09_38_35.log                      3
  17027533 APPLY           SUCCESS         16-OCT-13 09.41.10.276728 AM                                                bundle:PSU
/u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_TESTCDB_TESTPDB_2013Oct16_09_39_22.log                   4
  17027533 APPLY           SUCCESS         16-OCT-13 09.41.10.362787 AM                                                bundle:PSU
/u01/app/oracle/product/12.1.0/dbhome_1/sqlpatch/17027533/17027533_apply_TESTCDB_OPUNPDB_2013Oct16_09_40_12.log                   5

There was all right for patching on my Database. For Users, they might have to "Upgrade Oracle Recovery Manager Catalog".
BTW, Good Luck - "Patch 17027533 - 12.1.0.1.1 Patch Set Update".

Multitenant Self-Service Provisioning - Database Sizes

Why I try to post about Database Sizes on Oracle Multitenant Self-Service Provisioning. When I create New Database(PDB), I want other Maximum Storage sizes.

My idea is 500 GB and 2 TB... How to do? On "Self-Service Administration" - First, select "Self-Service System Configuration". Then select "Database Sizes".

 

Then, select "Add Size" and fill in...  After "Add Size Option"... It should show new size option.

Note: I added "500 GB" and "2 TB".
Go back to "New Database(PDB)"... It displayed "500 GB", but not display "2 TB"... Why?

OK... Go to "Self-Service Quotas" and changed something.

Changed "Storage Maximum in GB" from "1024" to "2048"

Go back to "New Database(PDB)" again!

Wow! Able to choose "2 TB".

Related Posts:
Multitenant Self-Service Provisioning (BETA) - Database 12c
Multitenant Self-Service Provisioning - Clone PDB
Multitenant Self-Service Provisioning - Close/Open PDB
Multitenant Self-Service Provisioning - Unplug/Plug In PDB
Multitenant Self-Service Provisioning - Drop PDB
Multitenant Self-Service Provisioning - Request an Account
Multitenant Self-Service Provisioning - Notifications

Multitenant Self-Service Provisioning - Notifications

A user can create notifications on Oracle Multitenant Self-Service Provisioning page. Notifications are displayed on the home page of this self-service application to communicate with users of this self-service system. Notifications are managed by application administrators but viewable by all users.
First, select "Administration", then select "Notifications".

Then, select "Add Notification" and fill in...

Finally, select "Create Notification" for creating.
After that, go Home and check!

Tried to use other accounts. It's all right... Found notification.

Related Posts:
Multitenant Self-Service Provisioning (BETA) - Database 12c
Multitenant Self-Service Provisioning - Clone PDB
Multitenant Self-Service Provisioning - Close/Open PDB
Multitenant Self-Service Provisioning - Unplug/Plug In PDB
Multitenant Self-Service Provisioning - Drop PDB
Multitenant Self-Service Provisioning - Request an Account

Multitenant Self-Service Provisioning - Request an Account

On Oracle Multitenant Self-Service Provisioning page."Request an Account", I thought that's very interesting for testing how it work.

Select "Request an Account" and Fill in as below picture(Please fill in available email).

Note: User are created by "Request an Account". They have Pluggable Database Administrator (PDBA) role.
- CDBAs have full access to all aspects of this self-service system.
- PDBAs can create Pluggable Databases but not perform administrative functions.

After requesting, ADMIN can check on "Self-Service Administration".

After approving... A user should receives email (Username/Password).
Example:

Then a user click Link in email, then login!

A New Account can create/perform PDBs (they are provided as ADMIN) and not perform administrative functions. As below picture, new user can clone/close/reopen/unplug/drop "OPUNPDB" pdb, but can not on "TESTPDB" pdb.

Related Posts:
Multitenant Self-Service Provisioning (BETA) - Database 12c
Multitenant Self-Service Provisioning - Clone PDB
Multitenant Self-Service Provisioning - Close/Open PDB
Multitenant Self-Service Provisioning - Unplug/Plug In PDB
Multitenant Self-Service Provisioning - Drop PDB