Oracle Database 12.2 New Features (Part I) - Application Express

As you know, Oracle Open World 2016 conferences continue at San Francisco (September 18-22, 2016).

At keynote Session, Larry Ellison (CTO of Oracle Corporation) annoucemented the Oracle Database Exadata Express Cloud Service on new database version 12.2. Here is released cloud documentation

There have very interesting little guide for new features of Oracle Database 12c Release 2.
Why littel , because it is not all features of Oracle Database 12c Release 2, have more interesting features will come with new version, I know. (I attended #OOW15) :)

I want share something about released new feature of Oracle Database 12.2.

Application Development

Oracle Application Express is (first name is HTMLDB 2.0, I used it at 2005 year) very interesting tool for developers. This tool for helping to create applications very rapidly.

Oracle Application Express 5.0.4 is latest version, released on July 12, 2016 and Application Express 5.1 Early Adopter 2 now available.

Oracle JET integrated with Oracle Appplication Express 5.1.

We can install Oracle Application Express 5.0 to another versions of Oracle Database. Application Express 5.0.2 come with Oracle Database 12.2 default. (4.2 version is default in 12.1.0.2)

SQL> select comp_name, version, schema, status from dba_registry;

COMP_NAME                               VERSION       SCHEMA     STATUS
---------------------------------------------------------------------------------------
Oracle Database Catalog Views           12.2.0.0.0    SYS         VALID
Oracle Database Packages and Types      12.2.0.0.0    SYS         VALID
JServer JAVA Virtual Machine            12.2.0.0.0    SYS         VALID
Oracle XDK                              12.2.0.0.0    SYS         VALID
Oracle Database Java Packages           12.2.0.0.0    SYS         VALID
OLAP Analytic Workspace                 12.2.0.0.0    SYS         VALID
Oracle Real Application Clusters        12.2.0.0.0    SYS         OPTION OFF
Oracle XML Database                     12.2.0.0.0    XDB         VALID
Oracle Workspace Manager                12.2.0.0.0    WMSYS       VALID
Oracle Text                             12.2.0.0.0    CTXSYS      VALID
Oracle Multimedia                       12.2.0.0.0    ORDSYS      VALID
Spatial                                 12.2.0.0.0    MDSYS       VALID
Oracle OLAP API                         12.2.0.0.0    OLAPSYS     VALID
Oracle Database Vault                   12.2.0.0.0    DVSYS       VALID
Oracle Label Security                   12.2.0.0.0    LBACSYS     VALID
Oracle Application Express              5.0.2.00.01   APEX_050000 VALID


16 rows selected.

Oracle using Application Express in Oracle cloud also. So, you can use schema as service in Oracle Cloud, Oracle give this service with Oracle Application Express.

If you want start cloud development, start from learn Oracle Application Express 5.0.


Best Regards
Mahir M. Quluzade

Location: Baku, Azerbaijan

Comments

Post a Comment

Popular posts from this blog

Oracle Data Guard 11g - How to safely remove a Data Guard Broker configuration?

Image
When you need safely remove broker-managed Data Guard Configuration then, oracle recommend following steps… You know dg_broker_start parameter is TRUE and data guard configuration information contains in broker configuration files dg_broker_config_file1, dg_broker_config_file2 with broker-managed Data Guard Configuration. Following steps I use on my test machines witch is running on Oracle Virtual Box. I captures video on this machines, too. Primary and Standby Database running on Oracle Linux Server 6.2 and installed Oracle Database 11g Release 2 (11.2.0.3). DG – is my breoker-managed Data Guard configuration. admdb is primary database, stldb – is standby database. DGMGRL> show configuration Configuration - dg Protection Mode: MaxPerformance Databases: admdb - Primary database stldb - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS Archive log destinations like as SQL> show parameter log_archive_dest_ NAME ...
Read more

Oracle Database 18c - Install On-Premises for Linux

Image
Oracle Database 18c was available on Oracle Cloud. Now everybody can download Oracle Database 18c On-Premises for Linux ( LINUX.X64_180000_db_home.zip ) Oracle change a little on installation file. OUI does not copy files to Oracle Home You just extract the zip file to Oracle Home directly and OUI only linking binaries. I installed Oracle Database 18c on Linux 7.1. Before installation, I set Oracle environments such as (ORACLE_HOME, ORACLE_BASE). You can add these settings in oracle user .bash_profile. You can watch my little installation video: You can also read all about the new features in the 18c documentation Best Regards Mahir M. Quluzade Oracle ACE
Read more

Cluvfy error : Framework setup check failed on all the nodes

Hi As you know Oracle recommends before installation Oracle Real Application Clusters 11g Release 2 run Cluster Verification utility with stage previous and post installation cluster ware or database. Cluster verification utility help you for getting error before and after installation Oracle Grid Infrastructure and Real Application Clusters Database. I getting following error : [grid@oel62-rac1 grid]$ ./runcluvfy.sh stage -pre crsinst -n oel62-rac1,oel62-rac2 –verbose ….. Checking user equivalence... Check: User equivalence for user "grid"   Node Name                             Status                    ------------------------------------  ------------------------   oel62-rac2     ...
Read more