Docker Version Manager (DVM) to easily Move between Docker Client Version

Another break-time post from the continuous tutorial about cloud native applications ūüôā

Sometimes when we are working in container environment, we found server’s version is not the same as client’s version. So we can not connect to the server. To easily solve this issue, we should install dvm (docker version manager) so we can easily move from one environment in our client to another.

These are the steps:

$ curl -sL https://download.getcarina.com/dvm/latest/install.sh | sh

$ source /Users/doddipriyambodo/.dvm/dvm.sh
#Usages of the commands:

$ dvm ls --> see the version in your client
$ dvm ls-remote --> see what version available to install
$ dmv install 1.12.3 --> install the client
$ dvm use 1.12.3 --> use the specified client
$ dvm deactivate --> uninstall the client

 

Kind Regards,
Doddi Priyambodo

Why Smaller vCPU is better than Bigger vCPU in a fully probable contention environment

In VMware vSphere environment, why Smaller vCPU is better than Bigger vCPU (if the workloads only require few vCPU) in a fully probable contention environment?

To explain this further let’s take an example of a four pCPU host that has four VMs, three with 1 vCPU and one with 4 vCPUs. At best only the three single vCPU VMs can be scheduled concurrently. In such an instance the 4 vCPU VM would have to wait for all four pCPUs to be idle. In this example the excess vCPUs actually impose scheduling constraints and consequently degrade the VM’s overall performance, typically indicated by low CPU utilization but a high CPU Ready figure.

So, always start with smaller vCPU and then add extra vCPU later on if needed based on your observation about the workload.

This reference post also share a very good description why too many vCPU will give poor performance to your Virtual Machine: http://www.gabesvirtualworld.com/how-too-many-vcpus-can-negatively-affect-your-performance/

Conclusion: “Right Size Your VMs!”

 

Kind Regards,
Doddi Priyambodo

Summary How To Upgrade VMware vCAC 6.1 to VMware vRA 6.2

Berikut ini saya lampirkan mekanisme untuk Upgrade VCAC 6.1 ke VRA 6.2. (*notes:  saat ini versi terbaru adalah VRA 7, dengan enhancement yang jauuuhhhh lebih banyak dibanding versi sebelumnya).

Anyway, berikut ini adalah Summary cara upgrade-nya:

  1. Backup Identity Appliance, vRA Appliance(s), IaaS database, and IaaS server(s). Lebih amannya: Lakukan Cloning terhadap beberapa VMs ini (sebagai backup)
  • vCenter
  • DB vCenter (jika terpisah)
  • Identity Appliance
  • VRA Appliance
  • IaaS Server
  • IaaS Database
  1. Stop vRA Appliance(s) Services.
  2. Stop IaaS Server(s) services.
  3. Identity Appliance Upgrade.
  4. vRA Appliance Upgrade.
  5. IaaS Database Upgrade.
  6. IaaS Upgrade

Terlampir dokumen resmi How to Upgrade. (Better dibaca dulu dokumennya, baru dicoba mengikuti tutorial dari beberapa blog dibawah ini) :

http://pubs.vmware.com/vra-62/topic/com.vmware.ICbase/PDF/vrealize-automation-62-upgrading.pdf

  • http://emadyounis.com/vrealize-automation/upgrading-vrealize-automation-6-1-formally-vcac-to-6-2/
  • http://www.vmdaemon.com/2014/12/upgrading-vcac-6-1-vra-6-2/
  • http://vdm-001.blogspot.co.id/2015/01/upgrade-vcac-61-to-vrealize-automation.html
  • http://theithollow.com/2014/12/16/vrealize-automation-6-2-upgrade/

Untuk instalasi/deploy baru VRA 7, bisa mengikuti blog ini: (lebih simple daripada install 6.1)

 

 

Kind Regards,
Doddi Priyambodo

7 Habits, 8th Habit, and 3rd Alternative – by Stephen Covey

I am not talking about IT in this post. Just want to summarize¬†of one of the book that changed my life (“a little bit better than before”) ūüôā

After reading this book, please continue with The 8th Habit and the 3rd Alternative.

Habits –> Objectives

  • Paradigms and Principles of Effectiveness –> Assess paradigms and align to principles of effectiveness
  • Habit 1: Be Proactive –> Assume responsibility, focus, and act on what can be controlled and influenced, instead of what can‚Äôt
  • Habit 2: Begin With The End in Mind –> Define clear measures of success and create a plan to achieve them for both life and work
  • Habit 3: Put First Things First –> Prioritize and achieve the most important goals instead of constantly reacting to urgencies
  • Habit 4: Think Win-Win –> Collaborate more effectively with others by building high-trust relationships of mutual benefits
  • Habit 5: Seek First to Understand, then to be Understood –> Influence others by developing a deep understanding of their needs and perspectives
  • Habit 6: Synergize –> Develop innovative solutions that leverage diversity and satisfy all key stakeholders
  • Habit 7: Sharpen the Saw –> Increase motivation, energy, and work/life balance by making time for renewal activities
  • Habit 8:¬†Find your voice and inspire others to find theirs!

Kind Regards,
Doddi Priyambodo

Saint of My Life – #SID

Good night good night my little angel
Good night good night my little one
Spread your wings and fly away to your dreams

When you’re sleep I’m on your side
When you’re awake I’ll be there still
Close your eyes, put a smile on your face

 

Lyric by #SupermanIsDead

Oracle¬ģ Database Licensing Information 11g Release

In this Article I would like to Copy and Paste about the Licensing Mechanism of Oracle Options and Pack beside The Enterprise Edition License. So, there are a lot of License to be bought right? ūüôā

Hmmm… Oracle is very Expensive solution dude ;p

 

Options and Packs

This chapter describes the separately licensed Oracle Database options, management packs, and other products you can purchase to enhance the capabilities of Oracle Database in specific application environments. This chapter contains the following sections:

You may not use the options, packs, or products described below without separately purchased licenses. The fact that these options, packs, or products may be included in product CDs or downloads or described in documentation that you receive does not authorize you to use them without purchasing appropriate licenses.

Oracle Database Options

All the Oracle Database options can be purchased with Oracle Database Enterprise Edition. Oracle Real Application Clusters (Oracle RAC) is included with Oracle Database Standard Edition. You cannot purchase any options with Oracle Database Standard Edition One or Oracle Express Edition. The Personal Edition includes all options except Oracle RAC at no additional cost.

Oracle Active Data Guard

Oracle Active Data Guard enhances the Quality of Service (QoS) for production databases by off-loading resource-intensive operations to one or more standby databases, which are synchronized copies of the production database. With Oracle Active Data Guard, a physical standby database can be used for real-time reporting, with minimal latency between reporting and production data. Compared with traditional replication methods, Active Data Guard is very simple to use, transparently supports all data types, and offers very high performance. Oracle Active Data Guard also allows backup operations to be off-loaded to the standby database, and be done very fast using intelligent incremental backups. Oracle Active Data Guard thus is a very effective way to insulate interactive users and critical business tasks on the production system from the impact of such long-running operations. Oracle Active Data Guard provides the additional benefit of high availability and disaster protection by quickly failing over to the standby database in the event of a planned or an unplanned outage at the production site.

The Active Data Guard option contains the following features:

  • Physical Standby with Real-time Query
  • Fast Incremental Backup on Physical Standby

If a physical standby database in a Data Guard configuration has any of the above features enabled, then the Active Data Guard option must be licensed for every such physical standby, and also for the primary database.

Oracle Advanced Compression

Oracle Advanced Compression provides comprehensive data compression capabilities to compress all types of data, backups, and network traffic in an application transparent manner. With Advanced Compression, Oracle includes table compression targeted at OLTP workloads, resulting in reduced storage consumption and improved query performance while incurring minimal write performance overhead. Advanced Compression can be used to compress any unstructured content using SecureFile Compression. Deduplication provides the ability to automatically eliminate redundant copies of SecureFile data. A new faster compression algorithm is included in the Advanced Compression to speed up RMAN backups. With Advanced Compression, Data Pump exports can now be compressed to reduce disk space requirements. Finally, Data Guard can compress redo data resulting in reduced network traffic and faster gap resolution.

The Oracle Advanced Compression option contains the following features:

  • Data Guard Network Compression
  • Data Pump Compression
  • Fast RMAN Compression
  • OLTP Table Compression
  • SecureFile Compression and Deduplication

Oracle Advanced Security

Oracle Advanced Security provides transparent data encryption of data stored in the database, the encryption of disk-based backups of the database, and also network encryption for data traveling across the network between the database and client or mid-tier applications. In addition it provides a complete suite of strong authentication services to Oracle Database. Network encryption is implemented using industry-standard data encryption and data integrity algorithms. This feature provides a choice of algorithms and cipher strengths for deployment. Strong authentication services support a comprehensive suite of industry-standard third-party authentication options. The authentication options include single sign-on services to the Oracle Database by interoperating with existing authentication frameworks and two-factor authentication choices such as smart cards and token cards.

If you wish to use Enterprise User Security in Oracle Database Enterprise Edition, you no longer need to license the Oracle Advanced Security Option for password-based authentication. However, you must license Oracle Internet Directory (OID). If you wish to use stronger authentication alternatives (such as Kerberos or PKI) for Enterprise User Security, you must license Oracle Advanced Security and the Oracle Internet Directory (OID). Any Oracle Advanced Security licenses purchased on or before January 31, 2004, have restricted use of the Oracle Internet Directory (OID) to support enterprise user security. Please contact your Oracle sales representative for additional information.

Oracle Advanced Security includes the following features:

  • Transparent Data Encryption (TDE) for columns
  • Transparent Data Encryption (TDE) for tablespace
  • Transparent Data Encryption (TDE) for securefiles
  • DataPump Export File encryption
  • RMAN backup encryption
  • Hardware Security Module (HSM) TDE Master Key Protection
  • Database strong authentication support (PKI, Kerberos, Radius)
  • Smartcard support (PKCS#11)
  • Transport Layer Security (TLS) Support
  • Native network encryption
  • SSL/TLS network encryption
  • SSL acceleration
  • Certificate Revocation List (CRL) support

Oracle Data Mining

Oracle Data Mining enables you to build advanced business intelligence applications that mine corporate databases, reveal new patterns and relationships, and integrate that information into business applications. This option embeds data mining functionality into Oracle Database for making classifications, predictions, and associations. All model-building, scoring, and metadata management operations are accessible by way of either a Java or PL/SQL API.

The Oracle Data Mining option includes the following features:

APIs and GUIs Supported to Access Algorithms:

  • PL/SQL API‚ÄĒfor model build, model apply, and data transformations
  • Java API‚ÄĒfor model build, model apply & data transformations
  • Oracle Data Miner (GUI)
  • Spreadsheet Add-in for Predictive Analytics

Algorithm Category and Supported Algorithms:

  • Classification
    • Naive Bayes
    • Decision Trees
    • Support Vector Machines
    • Logistic Regression
  • Regression
    • Multivariate Linear Regression
    • Support Vector Machines
  • Anomaly Detection
    • One Class Support Vector Machines
  • Attribute Importance
    • Minimum Description Length
  • Association Rules
    • A Priori
  • Clustering
    • Hierarchical K-Means Clustering
    • Hierarchical O-Clustering
  • Predictive Analytics (PL/SQL Packages)
    • Predict
    • Explain
    • Profile
  • Feature Extraction
    • Nonnegative Matrix Factorization

Oracle Database Vault

Oracle Database Vault lets you control who, when, and where data and applications can be accessed‚ÄĒprotecting your business against the most common security threat: malicious internal users. Enforcing separation of duties, even among administrators, Oracle Database Vault additionally serves as a powerful preventive control to help comply with today’s stringent compliance and privacy requirements.

  • It improves your ability to meet compliance requirements like Sarbanes-Oxley and other regulations that mandate control of access to, and release of, sensitive information
  • It controls access to application and database data, even by super-users and other highly privileged users
  • It enforces multi factor authorization via flexible business rules
  • It shows who is accessing what and when via over three dozen out-of-the-box security reports

Oracle Database Vault is an option for Oracle Database 10g or later. However, it has also been provided for earlier releases as well, including Oracle9iDatabase Release 2 (9.2.0.8) on a limited number of platforms. Please contact your Oracle Sales Representative if you are interested in Oracle Database Vault as an option on Oracle9i Database.

The Oracle Database Vault option includes the following features:

  • Realms
  • Separation of Duty
  • Factors
  • Command Rules
  • Rule Sets

Oracle In-Memory Database Cache

Oracle In-Memory Database Cache enables you to improve application transaction response time by caching a performance-critical subset of tables and table fragments from an Oracle database to the application tier. The table fragments are described through an extended SQL syntax and are cached into Oracle In-Memory Database Cache tables. Cache tables can be specified as read-only or updatable. Applications read and update the cache tables using standard SQL. Cache table hierarchy for related tables with foreign key constraints is maintained for data consistency. Automatic data synchronization between the cache and the Oracle database is provided.

Cache tables are managed like regular relational database tables within the TimesTen In-Memory Database. Thus, Oracle In-Memory Database Cache offers applications the full generality and functionality of a relational database, the transparent maintenance of cache consistency with the Oracle Database, and the real-time performance of an in-memory database. This Database option is ideal for caching performance-critical subsets of an Oracle database for improved response time in the application tier.

Oracle In-Memory Database Cache includes the following features:

  • Static and dynamic caching of Oracle database tables
  • Automatic data refresh from Oracle database to the in-memory cache
  • Automatic transaction write-through from the in-memory cache to the Oracle database
  • Automatic data aging with user-defined policies
  • Standard SQL functionality and database transaction semantics
  • Transactional replication with Active-Standby Pair topology
  • Real-time change notification using Transaction Log API (XLA)

Oracle Label Security

Oracle Label Security provides sophisticated and flexible security based on row labels for fine-grained access control. This option employs labeling concepts used by government, defense, and commercial organizations to protect sensitive information and provide data separation. It includes a powerful tool to manage policies, labels, and user label authorizations.

By default, Oracle Label Security is configured to use Oracle Database for all policy management. Users interested in centralized policy management using the Oracle identity management infrastructure must additionally license Oracle Identity and Access Management Suite. Please contact your Oracle sales representative for additional information.

The Oracle Label Security option includes the following features:

  • Label based access control (LBAC)
  • Multi-level security (MLS)
  • Label factors for Database Vault (Confidential, Sensitive)
  • User label authorizations (Confidential, Sensitive: PII)
  • Data labels (Sensitive: PII)

Oracle On-Line Analytical Processing (OLAP)

The OLAP option to Oracle Database is a full-featured OLAP server embedded in Oracle Database Enterprise Edition. Oracle OLAP cube data types improve business intelligence tools and applications by providing excellent query performance, rich analysis, and fast incremental updates of data sets. OLAP cubes are easily queried by SQL-based business intelligence tools through cube-organized materialized views and OLAP cube views. Cube-organized materialized views provide an alternative summary management solution to table-based materialized views. As with a table-based materialized view, an OLAP cube is accessed by SQL-based tools transparently using the automatic SQL query rewrite feature of the materialized views. SQL-based tools can access both summary data and rich analytic content directly through OLAP cube views. Multidimensional OLAP tools can provides a full-dimensional OLAP experience using the Oracle OLAP multidimensional API to cubes. A single OLAP cube can service each of these types of applications.

The Oracle OLAP option includes the following features:

  • OLAP Cube Definition, Storage, and Querying
  • OLAP API and Metadata
  • OLAP Cube Materialized Views
  • Analytic Workspaces
  • SQL Access to OLAP Cubes

Oracle Partitioning

Oracle Partitioning enhances the data management environment for OLTP, data mart, data warehouse, and content management applications by adding significant manageability, availability, and performance capabilities to large underlying database tables and indexes. Oracle Partitioning lets you store large tables as individually managed smaller pieces, while retaining a single application-level view of the data.

The Oracle Partitioning option includes the following features:

  • Table Partitions and Subpartitions
  • Local Index Partitions and Subpartitions
  • Global Index Partitions and Subpartitions
  • Range Partitioning
  • Hash Partitioning
  • List Partitioning
  • Interval Partitioning
  • Reference Partitioning
  • System Partitioning
  • Virtual Column-based Partitioning
  • Composite Partitioning
  • Subpartition Template
  • Fast Partition Split
  • Partition Exchange

Oracle Real Application Clusters (Oracle RAC)

Oracle Real Application Clusters (Oracle RAC) is a database computing environment that harnesses the processing power of multiple interconnected computers using clustering technology. Oracle RAC provides unlimited scalability and high availability for all applications. Oracle RAC makes the database highly available in the presence of computer hardware or software failure: in the event any computer in the cluster fails, the database continues to provide service on the surviving computers in the cluster. Oracle RAC provides scalable performance: as demand for database throughput grows, additional computers can be added to the database cluster with no downtime. Oracle RAC supports a single-system image for ease of management. Oracle RAC also provides a complete and integrated stack of clustering software on all platforms; third-party clusterware software is not required. Finally, Oracle RAC provides cluster file system capability on the Windows and Linux platforms.

Oracle Real Application Clusters includes the following features:

  • Real Application Clusters
  • Cluster Verification Utility
  • Automatic Workload Management
  • Connection Load Balancing
  • Fast Connection Failover
  • Hot Cluster Failover
  • Oracle Advanced Security SSL/TLS

Oracle Real Application Testing

The Oracle Real Application Testing option comprises a suite of features that help protect database applications from undesirable impact of routine changes such as hardware/software upgrades, configuration changes, platform migrations, and so forth. These features enable comprehensive testing of real-world applications so that any issues resulting from system changes are fully identified and addressed during testing, and unexpected problems encountered when a change is finally made in the production systems are minimized.

The Oracle Real Application Testing option includes the following features:

  • Database Replay
  • SQL Performance Analyzer (SPA)
  • SQL Tuning Sets (STS)

In order to use the features listed above, you must purchase licenses for the Oracle Real Application Testing option, with one exception: SQL Tuning Sets (STS) can be used if you have licensed either the Tuning Pack or Oracle Real Application Testing. Oracle Real Application Testing functionality can be accessed by Enterprise Manager as well as through the database server command-line APIs. The use of either interface requires an Oracle Real Application Testing option license.

Command-Line APIs

The Database Replay feature can also be accessed by way of database server APIs and command-line interfaces:

  • DBMS_WORKLOAD_CAPTURE¬†package is part of the Oracle Real Application Testing option
  • DBMS_WORKLOAD_REPLAY¬†package is part of the Oracle Real Application Testing option

The SQL Performance Analyzer feature can also be accessed by way of database server APIs and command-line interfaces:

  • DBMS_SQLPA¬†package is part of Oracle Real Application Testing option

SQL Tuning Sets can also be accessed by way of database server APIs and command-line interfaces. The following subprograms, part of the DBMS_SQLTUNEpackage, provide an interface to manage SQL tuning sets and are part of the Oracle Real Application Testing option:

  • ADD_SQLSET_REFERENCE
  • CAPTURE_CURSOR_CACHE_SQLSET
  • CREATE_SQLSET
  • CREATE_STGTAB_SQLSET
  • DELETE_SQLSET
  • DROP_SQLSET
  • LOAD_SQLSET
  • PACK_STGTAB_SQLSET
  • REMOVE_SQLSET_REFERENCE
  • SELECT_CURSOR_CACHE
  • SELECT_SQLSET
  • SELECT_WORKLOAD_REPOSITORY
  • UNPACK_STGTAB_SQLSET
  • UPDATE_SQLSET

The Oracle Real Application Testing license is required on both capture and replay systems for Database Replay and is charged by the total number of CPUs on those systems.

Oracle Spatial

Oracle Spatial provides advanced spatial analysis features for complex geographic information systems (GIS) applications, enterprise applications, and location-based services applications. It augments the Oracle Locator feature, which provides storage, analysis, and indexing of location data accessible through SQL and standard programming languages, supporting seamless integration of location data into enterprise applications, and use of any leading third-party GIS tool to access location data. Oracle Spatial advanced features include GeoRaster for storage, indexing, and analysis of image and gridded raster data, such as satellite imagery and remotely sensed data; a network data model that allows users to model and analyze link-node networks (graphs) for applications; a topology data model and schema to persistently manage topology; a fully functional geocoding engine and routing engine; and location-based analysis functions for business intelligence applications, including location-based classification, binning, association, and correlation. Oracle Spatial also supports spatial data manipulation and analysis such as buffer generation, area/distance calculations, linear referencing, and more.

Note:

Oracle Locator, a feature of Oracle Database 11g¬†(XE, SE1, SE, and EE), includes the spatial vector geometry type, spatial indexing and operators, and a limited set of spatial functions.For detailed lists of functions included in Locator and those included only in Oracle Spatial option, please refer to Appendix B of¬†Oracle Spatial Developer’s Guide.

Oracle Spatial also includes Semantic database features including support for W3C Resource Description Framework (RDF) triple storage, indexing and querying, Web Ontology Language (OWL), ontology management, and semantic inferencing.

Note:

The Semantic database features in Oracle Spatial require the Oracle Partitioning option.

The Oracle Spatial option includes the following features:

  • Selected Spatial Functions
  • Linear Referencing System
  • GeoRaster Storage, Indexing and Querying
  • Network Data Model
  • Topology Data Model
  • Spatial Analysis and Mining Functions
  • Spatial Routing Engine
  • Geocoding Engine
  • Spatial Web Services (new with 11g)
  • 3-D Geometry, Surface, and Point Cloud Storage, Indexing and Querying (new with 11g)
  • Semantic Content Storage, Indexing and Querying (RDF/OWL Support)

Oracle Total Recall

Oracle Total Recall provides the ability to transparently track and archive historical changes to all data stored in an Oracle database. History data is stored in a secure and highly optimized storage and can be accessed in a seamless manner using Flashback Queries. With Total Recall, you can enable history tracking on tables instantaneously and retain the history data any length of time. In addition, Total Recall provides for easier manageability by automating purge of historical data based on specified retention policy. History tracking is non-intrusive and completely transparent to applications.

The Oracle Total Recall option includes the following feature:

  • Flashback Data Archive

Oracle Management Packs

The sections that follow describe the Oracle management packs. The management packs can be purchased only with Enterprise Edition. The features in these packs are accessible through Oracle Enterprise Manager Database Control, Oracle Enterprise Manager Grid Control, and APIs provided with Oracle Database software.

This section describes the following management packs:

Oracle Change Management Pack

The Oracle Change Management Pack enables administrators to evaluate, plan, and implement database schema changes. Using the Change Management Pack, administrators can investigate and track changes, compare and synchronize objects and schemas, modify schema objects, evaluate the change impact, and if required undo changes that have been made previously. The Change Management Pack makes change management simple and efficient and minimizes chances for error, thereby reducing the opportunity for data loss and system down-time.

The Change Management Pack includes the following features:

  • Reverse engineer database and schema definitions
  • Capture and version baselines
  • Compare databases and schemas, or baselines
  • Copy database objects with data, with a subset of the data, or without data
  • Update database object definitions (ALTER¬†TABLE)
  • Synchronize objects and schemas
  • Evaluate the impact of changes
  • Clone or propagate application schemas

Oracle Configuration Management Pack

The Oracle Configuration Management Pack automates the time-consuming and often error prone process of software configuration, software and hardware inventory tracking, patching, cloning and policy management. The Configuration Management Pack includes the following features:

  • Database and Host Configuration
  • Deployments
  • Search configuration
  • Compare configuration
  • Policies, including Security checks and scoring

In order to use the features listed above, you must purchase licenses for the Configuration Management Pack. The Configuration Management Pack functionality can be accessed by the Enterprise Manager and through the Enterprise Manager repository views. The use of either interface requires licensing of the Configuration Management Pack.

In earlier releases, three additional features were part of this pack: Patch Deployment (Patch Database and View Patch Cache, Patch staging), Clone Oracle Home, and Clone Database. These features are no longer part of the Configuration Management Pack. They are now part of the Oracle Provisioning and Patch Automation Pack, which is licensed with Enterprise Manager. However, if you have previously licensed the Configuration Management Pack for Oracle Database, you are entitled to use these features without licensing the Oracle Provisioning and Patch Automation Pack.

Enterprise Manager

To determine which links in Enterprise Manager Grid Control and Database Control are part of the Configuration Management Pack, click the Setup link on the top right-hand part of the Enterprise Manager Home page.

  • When you click the¬†Setup¬†link, the navigation bar contains the¬†Management Pack Access¬†link. Click this link.
  • This will take you to the¬†Management Pack Access¬†page, which allows you to grant and remove access from all the management packs.
    • For Enterprise Manager Database Control, click the¬†Remove Access¬†radio button for the Configuration Management Pack and click¬†Apply.
    • For Enterprise Manager Grid Control, click the appropriate check box for the Configuration Management Pack and click¬†Apply.

This will disable all the links and tabs associated with the Configuration Management Pack in Enterprise Manager. All the disabled links and tabs are part of the Configuration Management Pack and therefore require pack license.

Configuration Management Pack Database Reports

The following reports found are part of this pack:

  • On the¬†Deployment and Configuration¬†page: all reports
  • From the¬†Monitoring¬†page, the¬†Alerts and Policy Violations¬†link: all reports.
  • From the¬†Monitoring¬†page, the¬†Disabled Policies¬†link: all reports.
  • From the¬†Security¬†page, the¬†Security Policy Overview¬†link: all reports.

Configuration Management Pack Enterprise Manager Repository Views

  • Policy Definition Views
    • MGMT$POLICIES
    • MGMT$POLICY_PARAMETERS
    • MGMT$POLICY_VIOLATION_CTXT
    • MGMT$POLICY_VIOL_ANNOTATIONS
    • MGMT$POLICY_VIOL_NOTIF_LOG
  • Policy Association Views
    • MGMT$TARGET_POLICIES
    • MGMT$TARGET_POLICY_SETTINGS
    • MGMT$TARGET_POLICY_EVAL_SUM
    • MGMT$TARGET_COMPLIANCE_SCORE
  • Policy Violation Views
    • MGMT$POLICY_VIOLATION_CURRENT
    • MGMT$POLICY_VIOLATION_HISTORY
    • MGMT$POLICY_VIOLATION_CONTEXT
  • Configuration Views
    • MGMT$DB_TABLESPACES
    • MGMT$DB_DATAFILES
    • MGMT$DB_CONTROLFILES
  • Oracle Home Patching
    • MGMT$CPF_ADVISORY_INFO
    • MGMT$CPF_HOMES_INFO
    • MGMT$CPF_PATCH_INFO
    • MGMT$EM_HOMES_PLATFORM
    • MGMT$HOMES_AFFECTED
    • MGMT$PATCH_ADVISORIES
    • MGMT$APPL_PATCH_AND_PATCHSET
    • MGMT$APPLIED_PATCHES
    • MGMT$APPLIED_PATCHSETS
  • Linux Patching
    • MGMT$HOSTPATCH_HOSTS
    • MGMT$HOSTPATCH_GROUPS
    • MGMT$HOSTPATCH_GRP_COMPL_HIST
    • MGMT$HOSTPATCH_HOST_COMPL
  • Security Views
    • MGMT$ESA_ALL_PRIVS_REPORT
    • MGMT$ESA_ANY_DICT_REPORT
    • MGMT$ESA_ANY_PRIV_REPORT
    • MGMT$ESA_AUDIT_SYSTEM_REPORT
    • MGMT$ESA_BECOME_USER_REPORT
    • MGMT$ESA_CATALOG_REPORT
    • MGMT$ESA_CONN_PRIV_REPORT
    • MGMT$ESA_CREATE_PRIV_REPORT
    • MGMT$ESA_DBA_GROUP_REPORT
    • MGMT$ESA_DBA_ROLE_REPORT
    • MGMT$ESA_DIRECT_PRIV_REPORT
    • MGMT$ESA_EXMPT_ACCESS_REPORT
    • MGMT$ESA_KEY_OBJECTS_REPORT
    • MGMT$ESA_OH_OWNERSHIP_REPORT
    • MGMT$ESA_OH_PERMISSION_REPORT
    • MGMT$ESA_POWER_PRIV_REPORT
    • MGMT$ESA_PUB_PRIV_REPORT
    • MGMT$ESA_SYS_PUB_PKG_REPORT
    • MGMT$ESA_TABSP_OWNERS_REPORT
    • MGMT$ESA_TRC_AUD_PERM_REPORT
    • MGMT$ESA_WITH_ADMIN_REPORT
    • MGMT$ESA_WITH_GRANT_REPORT
  • Client Configuration Views
    • MGMT$CSA_COLLECTIONS
    • MGMT$CSA_FAILED
    • MGMT$CSA_HOST_OS_COMPONENTS
    • MGMT$CSA_HOST_SW
    • MGMT$CSA_HOST_COOKIES
    • MGMT$CSA_HOST_CUSTOM
    • MGMT$CSA_HOST_RULES
    • MGMT$CSA_HOST_CPUS
    • MGMT$CSA_HOST_IOCARDS
    • MGMT$CSA_HOST_NICS
    • MGMT$CSA_HOST_OS_PROPERTIES
    • MGMT$CSA_HOST_OS_FILESYSEMS
    • MGMT$ECM_CONFIG_HISTORY
    • MGMT$ECM_CONFIG_HISTORY_KEY1
    • MGMT$ECM_CONFIG_HISTORY_KEY2
    • MGMT$ECM_CONFIG_HISTORY_KEY3
    • MGMT$ECM_CONFIG_HISTORY_KEY4
    • MGMT$ECM_CONFIG_HISTORY_KEY5
    • MGMT$ECM_CONFIG_HISTORY_KEY6
    • MGMT$HW_NIC
    • MGMT$OS_COMPONENTS
    • MGMT$OS_FS_MOUNT
    • MGMT$OS_HW_SUMMARY
    • MGMT$OS_HW_SUMMARY
    • MGMT$OS_PATCHES
    • MGMT$OS_SUMMARY
    • MGMT$SOFTWARE_COMP_PATCHSET
    • MGMT$SOFTWARE_COMPONENT_ONEOFF
    • MGMT$SOFTWARE_COMPONENTS
    • MGMT$SOFTWARE_DEPENDENCIES
    • MGMT$SOFTWARE_HOMES
    • MGMT$SOFTWARE_ONEOFF_PATCHES
    • MGMT$SOFTWARE_OTHERS
    • MGMT$SOFTWARE_PATCHES_IN_HOMES
    • MGMT$SOFTWARE_PATCHSETS

Oracle Data Masking Pack

Oracle Data Masking Pack offers the ability to mask regulated or confidential data on test or development systems.

Oracle Data Masking Pack includes the following features:

  • Mask format libraries
  • Mask definitions
  • Masking techniques
    • Condition-based masking
    • Compound masking
    • Deterministic masking
  • Application masking templates import or export
  • Mask format library import or export
  • Masking script generation
  • Clone and Mask workflow

Enterprise Manager

The following licensed pages and links in Enterprise Manager apply to Oracle Data Masking Pack.

From the Enterprise Manager Home page, select the Schema sub-tab. In the Data Masking section, the following links and associated pages are licensed as part of the pack:

  • Definitions: All links, buttons, and drilldowns on this page are licensed features of this pack.
  • Format Library: All links, buttons, and drilldowns on this page are licensed features of this pack.

Oracle Diagnostic Pack

The Oracle Diagnostic Pack provides automatic performance diagnostic and advanced system monitoring functionality. The Diagnostic Pack includes the following features:

  • Automatic Workload Repository
  • Automatic Database Diagnostic Monitor (ADDM)
  • Active Session History (ASH)
  • Performance monitoring (database and host)
  • Event notifications: notification methods, rules, and schedules
  • Event history and metric history (database and host)
  • Blackouts
  • Dynamic metric baselines
  • Monitoring templates
  • Memory-access based performance monitoring
  • Supporting functionality to perform per stream bottleneck detection and per component top wait event analysis

In order to use the features listed above, you must purchase licenses for the Diagnostic Pack. A new initialization parameter,CONTROL_MANAGEMENT_PACK_ACCESS, controls access to the Diagnostic Pack and Tuning Pack. This parameter can be set to one of three values:

  • DIAGNOSTIC+TUNING: Diagnostic Pack and Tuning Pack functionally is enabled in the database server.
  • DIAGNOSTIC: Only Diagnostic Pack functionality is enabled in the server.
  • NONE: Diagnostic Pack and Tuning pack functionally is disabled in the database server.

The Diagnostic Pack functionality can be accessed by Enterprise Manager links as well as through the database server command-line APIs. The use of either interface requires a Diagnostic Pack license.

Enterprise Manager

To determine which links in Enterprise Manager Grid Control and Database Control are part of the Diagnostics Packs, click the Setup link on the top right-hand part of the Enterprise Manager Home page.

  • When you click the¬†Setup¬†link, the navigation bar contains the¬†Management Pack Access¬†link. Click this link.
  • This will take you to the¬†Management Pack Access¬†page, which allows you to grant and remove access from all the management packs.
    • For Enterprise Manager Database Control, click the¬†Remove Access¬†radio button for the Diagnostic Pack and click¬†Apply.
    • For Enterprise Manager Grid Control, click the appropriate check box for the Diagnostic Pack and click¬†Apply.

This procedure disables all the links and tabs associated with the Diagnostic Pack in Enterprise Manager. All the disabled links and tabs are part of the Diagnostic Pack and therefore require pack license.

Command-Line APIs

Diagnostic Pack features can also be accessed by way of database server APIs and command-line interfaces:

  • The¬†DBMS_WORKLOAD_REPOSITORY¬†package is part of this pack.
  • The¬†DBMS_ADDM¬†package is part of this pack.
  • The¬†DBMS_ADVISOR¬†package is part of this pack if you specify ADDM as the value of the¬†advisor_name¬†parameter, or if you specify for the value of thetask_name¬†parameter any value starting with the ADDM prefix.
  • The¬†V$ACTIVE_SESSION_HISTORY¬†dynamic performance view and its underlying table,¬†X$ASH, are part of this pack.
  • The¬†DBA_STREAMS_TP_PATH_BOTTLENECK¬†view is part of this pack.
  • All views beginning with¬†DBA_ADDM_¬†are part of this pack.
  • Some data in¬†DBA_STREAMS_TP_COMPONENT_STAT¬†requires the Diagnostic Pack. The following filter clause to any query onDBA_STREAMS_TP_COMPONENT_STAT¬†shows Diagnostic-Pack-dependent data:
    where STATISTIC_UNIT  = 'PERCENT'

    For example, the following query shows Diagnostic-Pack-dependent data only:

    SELECT * FROM DBA_STREAMS_TP_COMPONENT_STAT
       where STATISTIC_UNIT = 'PERCENT';
  • All data dictionary views beginning with the prefix¬†DBA_HIST_¬†are part of this pack, along with their underlying tables.The only exception are the views:DBA_HIST_SNAPSHOT, DBA_HIST_DATABASE_INSTANCE, DBA_HIST_SNAP_ERROR, DBA_HIST_SEG_STAT, DBA_HIST_SEG_STAT_OBJ,¬†andDBA_HIST_UNDOSTAT. They can be used without the Diagnostic Pack license.
  • All data dictionary views with the prefix¬†DBA_ADVISOR_¬†are part of this pack if queries to these views return rows with the value¬†ADDM¬†in theADVISOR_NAME¬†column or a value of¬†ADDM*¬†in the¬†TASK_NAME¬†column or the corresponding¬†TASK_ID.
  • The following reports found in the /rdbms/admin/ directory of the Oracle home directory are part of this pack: awrrpt.sql, awrrpti.sql, addmrtp.sql, addmrpti.sql, ashrpt.sql, ashrpti.sql, awrddrpt.sql, awrddrpi.sql, awrsqrpi.sql, awrsqrpt.sql, awrextr.sql, and awrload.sql, awrextr.sql, awrload.sql, awrinfo.sql, spawrrac.sql.

Oracle Diagnostics Pack Enterprise Manager Repository Views

  • Monitoring Views
    • MGMT$BLACKOUT_HISTORY
    • MGMT$BLACKOUTS
    • MGMT$ALERT_ANNOTATIONS
    • MGMT$ALERT_NOTIF_LOG
    • MGMT$TARGET_METRIC_COLLECTIONS
    • MGMT$METRIC_COLLECTIONS
    • MGMT$TARGET_METRIC_SETTINGS
    • MGMT$AVAILABILITY_CURRENT
    • MGMT$AVAILABILITY_HISTORY
    • MGMT$ALERT_CURRENT
    • MGMT$ALERT_HISTORY
    • MGMT$METRIC_DETAILS
    • MGMT$METRIC_CURRENT
    • MGMT$METRIC_HOURLY
    • MGMT$METRIC_DAILY
  • Template Views
    • MGMT$TEMPLATES
    • MGMT$TEMPLATE_POLICY_SETTINGS
    • MGMT$TEMPLATE_METRIC_COLLECTION
    • MGMT$TEMPLATE_METRIC_SETTINGS

Oracle Provisioning and Patch Automation Pack

The Oracle Provisioning and Patch Automation Pack automates the deployment of software, applications, and patches for the database and underlying operating system. It makes critical data center operations easy, efficient and scalable resulting in lower operational risk and cost of ownership. The ability to provision the entire software stack that includes the operating system and the database, supplemented by comprehensive reporting tools make Oracle Provisioning and Patch Automation Pack an extremely significant entity in overall System Management space.

The Oracle Provisioning and Patch Automation Pack contains the following features:

  • Automated patching for Oracle database products and the operating system
  • Critical Patch Facility
  • Software Image Library
  • Bare metal OS provisioning
  • Single instance and RAC provisioning
  • Single click cluster scale up and scale down
  • Single instance-to-RAC conversion
  • CLI driven runtime
  • Enterprise Security Advisor
  • Provisioning and deployment reports

Oracle Tuning Pack

The Oracle Tuning Pack provides database administrators with expert performance management for the Oracle environment, including SQL tuning and storage optimizations. The Oracle Diagnostic Pack is a prerequisite product to the Oracle Tuning Pack. Therefore, to use the Tuning Pack, you must also have a Diagnostic Pack.

The Tuning Pack includes the following features:

  • SQL Access Advisor
  • SQL Tuning Advisor
  • Automatic SQL Tuning
  • SQL Tuning Sets
  • Automatic Plan Evolution of SQL Plan Management
  • SQL Monitoring
  • Reorganize objects

In order to use the features listed above, you must purchase licenses for the Tuning Pack, with one exception: SQL Tuning Sets can be used if you have licensed either the Tuning Pack or Oracle Real Application Testing. A new initialization parameter, CONTROL_MANAGEMENT_PACK_ACCESS, is introduced to control access to the Diagnostic Pack and Tuning Pack in the database server. This parameter can be set to one of three values:

  • DIAGNOSTIC+TUNING: Diagnostic Pack and Tuning Pack functionally is enabled in the database server.
  • DIAGNOSTIC: Only Diagnostic Pack functionality is enabled in the server.
  • NONE: Diagnostic Pack and Tuning pack functionally is disabled in the database server.

The Tuning Pack functionality can be accessed by the Enterprise Manager links as well as through the database server command-line APIs. The use of either interface requires licensing of the Tuning Pack

Enterprise Manager

To determine which links in Enterprise Manager Grid Control and Database Control are part of the Diagnostics Packs, click the Setup link on the top right-hand part of the Enterprise Manager Home page.

  • When you click the¬†Setup¬†link, the navigation bar contains the¬†Management Pack Access¬†link. Click this link.
  • This will take you to the Management Pack Access page, which allows you to grant and remove access from all the management packs.
    • For Enterprise Manager Database Control, click the¬†Remove Access¬†radio button for the Tuning Pack and click¬†Apply.
    • For Enterprise Manager Grid Control, click the appropriate check box for the Tuning Pack and click¬†Apply.

This procedure disables all the links and tabs associated with the Tuning Pack in Enterprise Manager. All the disabled links and tabs are part of the Tuning Pack and therefore require pack license.

Command-Line APIs

Tuning Pack features can also be accessed by way of database server APIs and command-line interfaces:

  • DBMS_SQLTUNE
  • DBMS_ADVISOR, when the value of the¬†advisor_name¬†parameter is either SQL Tuning Advisor or SQL Access Advisor.
  • V$SQL_MONITOR
  • V$SQL_PLAN_MONITOR
  • The following report found in the /rdbms/admin/ directory of the Oracle home directory is part of this pack: sqltrpt.sql.

Other Oracle Products

In addition to the options and packs described in this chapter, Oracle provides the following additional products for specific customer environments:

Oracle Database Lite

Oracle Database Lite Client Oracle Database Lite Client is a small general-purpose relational database used for mobile and embedded applications. Oracle Database Lite client can be used as a standalone database in embedded hardware and software applications or may be used as the data store for disconnected mobile applications when used with the Oracle Database Lite Mobile Server.

Each user must purchase a Named User Plus license.

Oracle Database Lite Mobile Server Oracle Database Lite Mobile Server is middle-tier infrastructure for mobile and disconnected applications that performs data synchronization and provides management for applications, users, and devices. Oracle Database Lite Mobile Server can use the Oracle Database Lite client as a data store for mobile and disconnected applications, providing efficient, reliable, and secure data management running locally on mobile and small-footprint devices (handhelds, notebooks, communicators, and so forth). The Lite Mobile Server supports scalable synchronization of data between devices and an Oracle Database.

Oracle Database Lite Mobile Server is licensed by CPU.

Note:

When Lite Mobile Server is used with Lite Client, customers must purchase at least one CPU license for Lite Mobile Server and a Named User Plus license for each client user.

Oracle Programmer

Oracle Programmer is a separate Oracle product that provides a programmatic interface to any edition of Oracle Database for application programmers. Programmer provides a rich set of interfaces for developers who build enterprise applications that access and manipulate Oracle Database. This product is licensed separately from the Oracle Database products. Oracle Programmer is a family of the following products:

  • Three embedded SQL-style interfaces: precompilers, SQL*Module, and SQLJ
  • Two utilities to generate host-language bindings from database schemas: Object Type Translator and JPub

Oracle Secure Backup

Oracle Secure Backup provides tape backup management for the entire Oracle environment. You can use Oracle Secure Backup to back up Oracle databases and host file systems to tape through direct-attached or network-attached tape drives. Oracle Secure Backup provides centralized management and control over backup and restore operations.

Oracle Secure Backup is available in the following forms, each suitable for different development and deployment scenarios:

Oracle Secure Backup  For environments that consist of many servers, Oracle Secure Backup offers high performance data protection from server to tape. This protection is crucial for local and offsite storage of business-critical data.

Oracle Secure Backup Express  For environments that consist of a single server, Oracle Secure Backup Express offers the same tape backup functionality as Oracle Secure Backup, but is limited to a single host with one direct-attached tape drive.

 

 

Leadership and Managerial Tweets and Quotes

These are several of My Tweets about Leadership, taken from several resources and some are created by me.

  • managing people has more to do with letting go, and with establishing an environment in which others can achieve peak performance
  • good management goes beyond systems ‚Äď it involves people
  • It is the art of creating and maintaining an atmosphere to work together and accomplish a mission using minimal time, money, and materials
  • as a Leader: ur job is to ‚Äúprepare the soil‚ÄĚ, create environment for the team effectively and efficiently where they can do their best work
  • as a Leader: Your primary focus must be on encouraging commitment, capability and confidence among employees or team members

How to Start Database Oracle, Listener, and Enterprise Manager via Console

Mohon maaf jika ini adalah materi yang mendasar. Tetapi karena banyak yang masih menanyakan kepada saya perihal ini. Mending saya tulis saja deh. Berikut ini adalah cara manual via console bagaimana caranya untuk menaikkan database server dan juga enterprise manager-nya berikut juga listener-nya. Untuk lebih detail dapat merujuk ke dokumentasi Oracle-nya juga.

Terima Kasih.

 

Doddi-Priyambodos-MacBook-Pro:~ doddi$ ssh root@10.14.152.137 (sebaiknya langsung login menggunakan user oracle)
root@10.14.152.137’s password:
Last login: Tue May 22 14:08:27 2012 from 172.16.96.5
[root@db2 ~]# su – oracle
[oracle@db2 ~]$ ps -ax | grep oracle
Warning: bad syntax, perhaps a bogus ‘-‘? See /usr/share/doc/procps-3.2.7/FAQ
13437 ? Rl 8923:38 /oracle/oracle10g/jdk/bin/servertool
13446 ? Rl 8863:10 /oracle/oracle10g/jdk/bin/servertool
13455 ? Rl 8869:12 /oracle/oracle10g/jdk/bin/servertool
13464 ? Rl 8885:57 /oracle/oracle10g/jdk/bin/servertool
14565 pts/1 S 0:00 su – oracle
14595 pts/1 S+ 0:00 grep oracle
[oracle@db2 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 – Production on Thu May 31 12:17:35 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 8589934592 bytes
Fixed Size 2034520 bytes
Variable Size 2986345640 bytes
Database Buffers 5553258496 bytes
Redo Buffers 48295936 bytes
Database mounted.
Database opened.
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@db2 ~]$ emctl start dbconsole
TZ set to Asia/Jakarta
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://db2.batubara.icon:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control …………………….. started.
——————————————————————
Logs are generated in directory /oracle/oracle10g/db2.batubara.icon_phonix/sysman/log
[oracle@db2 ~]$

[oracle@db2 ~]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 – Production on 31-MAY-2012 13:01:35

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /oracle/oracle10g/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 10.2.0.1.0 – Production
System parameter file is /oracle/oracle10g/network/admin/listener.ora
Log messages written to /oracle/oracle10g/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db2.batubara.icon)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db2.batubara.icon)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 – Production
Start Date 31-MAY-2012 13:01:37
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/oracle10g/network/admin/listener.ora
Listener Log File /oracle/oracle10g/network/log/listener.log
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db2.batubara.icon)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary…
Service “PLSExtProc” has 1 instance(s).
Instance “PLSExtProc”, status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully
[oracle@db2 ~]$

You’re DONE!

Silahkan Download Oracle Virtual Box Templates

Jika anda tidak mau repot untuk melakukan Instalasi produk-produk dari ORACLE, maka anda dapat langsung mengambil VirtualBox Template-nya saja. Secara otomatis sudah ter-install produk2 yang anda inginkan. Sangat cocok untuk environment Development, saya belum tau apakah cocok untuk Production (belum mencoba).

Bisa langsung di download disini =  http://www.oracle.com/technetwork/community/developer-vm/index.html

Nama VM = Database App Development VM 
Oracle Linux 5
Oracle Database 11g Release 2 Enterprise Edition
Oracle TimesTen In-Memory Database Cache
Oracle XML DB
Oracle SQL Developer
Oracle SQL Developer Data Modeler
Oracle Application Express 4.1
Oracle JDeveloper
Video chats with engineers and experts
Downloads and Instructions

Nama VM = Enterprise Java Development VM 
Oracle Linux 5, JDK 1.6 +
Oracle WebLogic Server 12.1.1
Oracle Coherence 3.7
Oracle TopLink 12.1.1
Hudson 2.2
Subversion 1.4.2
Maven 3.0.1
NetBeans IDE 7.1 RC2
Oracle Enterprise Pack for Eclipse 12.1.1 / Eclipse 3.7
Easter Egg: Bonus introductory labs for Coherence 3.7
Downloads and Instructions

Nama VM = Oracle VM Manager 3.0 VM 
Oracle Linux 5 update 7 with the Unbreakable Enterprise Kernel (2.6.32)
Oracle VM Manager 3.0.3 demo installation
Oracle WebLogic Server 10.3
Oracle Database 11g Express Edition
Download and Instructions

Nama VM = Solaris 11 Admin VM 
Oracle Solaris 11 11/11
Downloads and Instructions
Oracle WebCenter Portal Framework 11g Hands-on VM
Oracle Linux 5
Oracle XE Universal Database 10.2.0.1
Oracle WebLogic Server 10.3.4.0
Oracle WebCenter Portal Framework 11gR1 PS3 (11.1.1.4.0)
Oracle JDeveloper 11.1.1.4
Oracle WebCenter Extension for JDeveloper (11.1.1.4.0)
Downloads and Instructions

Nama VM = Oracle Tuxedo Web Application Server Demo V 
Oracle Linux 5.6
Oracle Tuxedo 11gR1 PS1 1 1(1.1.1.2.0)
Oracle SALT 11gR1 (11.1.1.2.2)
Oracle TSAM 11gR1 (11.1.1.2.0)
Oracle Database XE 10.2
PHP 5.3.6, xDebug extension
Apache HTTP Server 2.2.17
NetBeans PHP IDE 7.0 Beta
JDK 1.6 +
Downloads and Instructions

Nama VM = Oracle Business Intelligence Enterprise Edition Plus VM 
Oracle Database 11g Release 2
Oracle TimesTen
Essbase Server
Access Provisioning Services
OBIEE 11.1.1.5 with BI Composer configured SampleApp 10722
Oracle JDev
Oracle SQL Developer
Oracle Internet Directory
Downloads and Instructions

Nama VM = SOA & BPM Development VM 
Oracle Linux 5
Oracle Database XE 10.2
Oracle WebLogic Server 10.3.3.0
Oracle SOA Suite 11g R1 PS2
Oracle BPM Suite 11g R1 PS2 (with bundle patch #1)
Oracle BAM 11g R1 PS2
Oracle B2B 11g R1 PS2
Oracle JDeveloper 11.1.1.3
Downloads and Instructions

Nama VM = Enterprise PHP Development VM
(Provided and supported by Zend)
Oracle Linux 5.7
Zend Server 5.5
Oracle Database XE 11.2
Downloads and Instructions

Nama VM = Oracle Developer Days VB template for workshops
http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html

Oracle Linux 5
Oracle Database 11g Release 2 Enterprise Edition
Oracle TimesTen In-Memory Database Cache
Oracle XML DB
Oracle SQL Developer
Oracle SQL Developer Data Modeler
Oracle Application Express
Oracle JDeveloper
Hands-On-Labs (accessed via the Toolbar Menu in Firefox)