Surachart Opun's Blog: apex

Showing posts with label apex. Show all posts

Saturday, March 22, 2014

Oracle APEX Cookbook : Second Edition

Oracle Application Express is the great tool for developing Web Application with SQL and PL/SQL. Users can develop and deploy Web based applications for desktops and mobile devices. If We will be talking about books about APEX. I mention a book title Oracle APAC Cookbook - Second Edition by Michel Van Zoest and Marcel Van Der Plas. I had a chance as technical viewer on this book. So, I found it is interesting book about Oracle APEX. It was written to cover Oracle APEX 4.0 - 4.2 with 14 Chapters.

Explore APEX to build applications with the latest techniques in AJAX and Javascript using features such as plugins and dynamic actions
With HTML5 and CSS3 support, make the most out of the possibilities that APEX has to offer
Part of Packt's Cookbook series: Each recipe is a carefully organized sequence of instructions to complete the task as efficiently as possible

Examples in a book are very useful. Readers can follow each topic (example) and practice it. A book is for some people who are new with Oracle APEX and want to start it. For some people who know and work with Oracle APEX, they can use this book like reference and learn something new in APEX. So, I think it's a good idea to keep this book in your APEX shelf. I still believe a book is easy for reading... and learning in APEX.

Monday, December 16, 2013

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

Sunday, December 15, 2013

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.

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.

Wednesday, September 25, 2013

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

Tuesday, September 24, 2013

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.

Multitenant Self-Service Provisioning - Drop PDB

It's too easy for dropping PDB on Oracle Multitenant Self-Service Provisioning. Just select "Drop", then select Datafiles - whether Including Datafiles (will remove datafiles) or Keep Datafiles.

Multitenant Self-Service Provisioning - Unplug/Plug In PDB

When use PDB, users want to plug & unplug PDB. I just wanted to unplug PDB on Oracle Multitenant Self-Service Provisioning. If PDB mode = OPEN, users must close PDB before.