Difference between 10g, 11g and 12c

Difference between 10g, 11g and 12c

Oracle Database 10g New Features:

NID utility has been introduced to change the database name and id.

Automated Storage Management (ASM). ASMB, RBAL, ARBx are the new background processes related to ASM.

New memory structure in SGA i.e. Streams pool (streams_pool_size parameter), useful for datapump activities & streams replication.

From Oracle 10g, the spool command can append to an existing one.
SQL> spool result.log append

Ability to rename tablespaces (except SYSTEM and SYSAUX), whether permanent or temporary, using the following command:

SQL> ALTER TABLESPACE oldname RENAME TO newname;

Oracle Database 11g New Features:

Ability to mark a table as read only.
SQL> alter table table-name read only;

Temporary tablespace or it's tempfile can be shrinked, up to specified size.
SQL> alter tablespace temp-tbs shrink space;
SQL> alter tablespace temp-tbs shrink space keep n{K|M|G|T|P|E};

Introduction of ADR, single location of all error and trace data in the database, diagnostic_dump parameter

A new parameter is added in 11g, called MEMORY_TARGET, automatic memory management for both the SGA and PGA.

A system privelege is introduced in 11g called SYSASM, and this is granted to users who need to perform ASM related tasks.

Oracle Database 12c New Features:

Moving and Renaming datafile is now ONLINE, no need to put datafile in offline.
SQL> alter database move datafile 'path' to 'new_path';

No need to shutdown database for changing archive log mode.

Like sysdba, sysoper & sysasm, we have new privileges, in Oracle 12.1.0.
sysbackup for backup operations
sysdg for Data Guard operations
syskm for key management

Patching:
Centralised patching.
We can retrieve OPatch information using sqlplus query, using DBMS_QOPATCH package

SQL> select dbms_qopatch.get_opatch_lsinventory() from dual;

We can test patches on database copies, rolling patches out centrally once testing is complete.

New Commands
create pluggable database ...
alter pluggable database ...
drop pluggable database ...


New background processes - LREG (Listener Registration), SA (SGA Allocator), RM.

Oracle Database 12c Data Pump will allow turning off redo for the import operation (only).
$ impdp ... transform=disable_archive_logging:y

There are lots of differences! 

Some of the big ones are: 

- Multitenant/pluggable databases 
- In Memory (12.1.0.2 
- JSON support (12.1.0.2) 
- Adaptive queries 
- New histogram types 
- SQL enhancements (match_recognize, PL/SQL in the with clause, ...) 

Oracle 12c New Features

Overview

Oracle Forms Builder and Oracle Forms Services have been upgraded to simplify the development and deployment of Forms applications on the Web. A number of features have been added. In restructuring the Oracle Forms product, some legacy features have been dropped or scaled back. The future of Forms includes improving the Java-based Web user interface and extending product "openness" by allowing Java integration on all three tiers.

About Upgrading Your Forms Applications to 12c Release (12.2.1)

To upgrade your Oracle Forms applications, open your Forms 6i source files (FMB, MMB, PLL, and so on) in the Oracle Forms 12c (12.2.1) Builder, save them, then compile them. You can also use the Oracle Forms Compiler to upgrade your Forms 6i applications.

Forms 10g Features Removed from Oracle Forms

The following features have been dropped from Oracle Forms 10g and later:

·         Graphics Integration

·         Chart Items

Forms 6i Features Removed from Oracle Forms

The following features have been dropped from Oracle Forms 9.0.2 and later:

• Client-server Runtime
• Character mode Runtime
• Various runform command line options
• Character mode properties and logical attributes
• Item types that are specific to operating systems
• Various Built-ins
• Various properties
• Various menu features including:

o    Character mode menu properties

o    Obsolete types from the Menu-Items command type property

o    Menu parameters

o    Menu Built-ins

o    Full screen menu style

o    Bar (Lotus) menu style

• Forms version 2 style triggers and list of values (LOVs)
• Graphics Chart Wizard

Components of 6i Developer Product Suite Removed

The following components have been removed.

Table 1-1 Components Removed from the Developer Suite

Obsolete Component	UPGRADE NOTES
Oracle Graphics	If your applications use the Graphics Web Cartridge or Oracle Graphics Runtime, you should rewrite your applications and redevelop the graphics using other means such as Java, Bi Beans.
Oracle Forms Listener and Load Balancing Components	Use the Forms Listener Servlet to manage Forms sessions on the Web. The Forms Listener Servlet provides: Improved security because all traffic is directed through standard Web server HTTP or HTTPS ports, with no extra ports open through the firewall. Compliance with standards that can be used for load balancing techniques. Broader firewall and proxy support. Less administration because the listener and load balancing processes do not need to be managed. Simplified HTTPS support because a separate Web server SSL certificate for the Forms listener is not required
Oracle Forms Server Cartridge and CGI	Use the Forms Servlet. The functionality available with the Oracle Forms Server cartridge and CGI was incorporated into the Forms Servlet, which was first available in Oracle Forms Release 6i patches 2.
Oracle Procedure Builder	Use the facilities for editing and debugging local and server-side PL/SQL code in Forms Developer, which has been considerably improved for this release.
Oracle Translation Builder	Use Translation Hub to translate resource strings in Forms modules to deploy the modules in multiple languages.
Oracle Terminal.	The resource files used by Web-deployed forms are text based and can be edited using a conventional text editor. As a result, Oracle Terminal is no longer required for the product.
Open Client Adapters (OCA)	The resource files used by Web-deployed forms are text based and can be edited using a conventional text editor. As a result, Oracle Terminal is no longer required for the product.

New/Changed Features in WebLogic 12c R2 (12.1.2)

·         WebLogic Server is now available in two formats only i.e. zip and jar version. (JDK is mandatory and must be installed prior to WebLogic installation).

·         JDK version 7 or higher (1.7) is recommended to install WebLogic 12.1.2 (though WebLogic 12.1.2 works JDK 1.6 as well)

·         Tool to apply patches in WebLogic has changed from BSU (BEA Smart Update) to opatch.

·         Option to install WebLogic in silent mode is now -silent -responseFile [path_to_response_file] (Earlier option was -mode=silent -silent_xml=[path_to_silent.xml])

·         In previous versions of WebLogic upgrade of WebLogic Domain used to be done using Domain Upgrade Wizard but now (12.1.2 onwards) uses Reconfiguration Wizard. 

·         In earlier version of WebLogic, Node Manager is installed  at WebLogic Home($WLS_HOME) level but now Java Node Manager by default is installed at $DOMAIN level i.e. $DOMAIN_HOME/nodemanager (with an option to configure Node Manager at Server Level or Custom Location)

·         From 12.1.2 there is an option to configure Node Manager at Domain Level or Custom Location (as shown in above screenshot)

·         Offline Cloning of Managed Server is now possible using configuration wizard(config.sh) or WLST (clone) – In previous releases it was possible to clone a Managed Server from WebLogic Console only (Online Cloning)

·         Cluster in pre 12.1.2 version is now also called as Configured Cluster in WebLogic 12.1.2 

·         Dynamic Cluster introduced in WebLogic 12c is a cluster with one or more Dynamic Servers (More on Dynamic Cluster and Dynamic Server in WebLogic later)

·         WebLogic 12c supports Database 12c including Application Continuity (AC) , Database Resistence Connection Pooling (DRCP), Global Data Services (GDS) 

·         Diagnostics : Built-in Diagnostics Modules added that provides simple and easy mechanism for basic health check and performance monitoring of WebLogic Server

Comparison between Oracle Database 9i, 10g,11g and 12c

With Oracle Database 9i and 10g now both out of support, you should be thinking about an Oracle Database Upgrade to Oracle 11g or 12c?

With each release there is is always improvements and new features.

Here are some key features of Oracle Database 9i, 10g and 11g;

Oracle 9i	Oracle10g	Oracle11g
RAC Introduced         Providing High avaliability	RAC Improvements         improved clusterware         Introduction of VIP’s for RAC	Further RAC Improvements           Faster failover of services          Grid Plug&Play allowing seamless additions/removal of nodes
DataGuard enhancements         Detection of gasps and automatic resolution	DataGuard improvements          Realtime apply and log compressions         Fast start failover added	Active DataGuard added –       Standby Database can now be queried whilst redo apply is active
Backup and Recovery            Block level recovery           Improved reporting and automation	Data Pump added         Extract and import data faster than ever	Improved Manageability          ASM Cluster FileSystem (ACFS) Introduced       Virtual Columns added

Oracle Database Comparison

dsp have extensive experience across all Oracle database versions, Oracle Database upgrades and Oracle Database consultancy.

Oracle Database 12c – what is new?

There are a host of new features that are now available with Oracle database 12c, including multitenant architecture which enables you to run pluggable databases in a multitenant container database. There are also many improvements in areas such as Big Data, Data security and Storage optimisation, which are key areas which will help drive future business growth.

Connect 12c Database with 6i Developer

Connect 12c Database with 6i Developer

Subject: Connectivity between Oracle 12c Database and Oracle 6i Developer 2000

Step 1:

Install Oracle 12c Database with default Character set and default schemas

Step 2:

Configure SQLNET.ORA Database file by adding this line.

·         “SQLNET.ALLOWED_LOGON_VERSION=8”

·         “SQLNET.ALLOWED_LOGON_VERSION_SERVER=8”

·         “SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8”

Step 3:

Setting up some parameter in Oracle Database.

·         Setting the system parameters, JOB_QUEUE_PROCESSES and AQ_TM_PROCESSES, to 0

·         Setting the parameter “SEC_CASE_SENSITIVE_LOGIN” to FALSE

·         Changing the database character set to WE8MSWIN1252 using “ALTER DATABASE CHARACTER SET INTERNAL_USE WE8MSWIN1252; or changing the character set to a UTF8 character set such as AL32UTF8

Startup Oracle database

SQL> startup mount;

SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;

SQL> ALTER DATABASE OPEN;

If you not set your database with default schemas while installing then follow the next command.

SQL> update sys.props$ set VALUE$='WE8MSWIN1252' where NAME='NLS_CHARACTERSET';

SQL> commit;

SQL> shutdown immediate;

SQL> startup;

Know entry on tnsnames.ora file of Oracle form 6i which is located like this.

“C:/orant/NET80/ADMIN/tnsnames.ora”

Your entry should be like this.

ORCL =

   (DESCRIPTION =

      (ADDRESS_LIST =

            (ADDRESS =

              (PROTOCOL = TCP)

              (HOST = 127.0.0.1)

              (PORT = 1521)

             )

        )

      (CONNECT_DATA = (SID = orcl )

      )

   )