Feed aggregator

12cR2 PDB archive

Yann Neuhaus - Wed, 2018-02-07 13:50

In 12.1 we had the possibility to unplug a PDB by closing it and generating a .xml file that describes the PDB metadata required to plug the datafiles into another CDB.
In 12.2 we got an additional possibility to have this .xml file zipped together with the datafiles, for an easy transport. But that was not working for ASM files.
The latest Release Update, Oct 17 includes the patch that fixes this issue and is the occasion to show PDB archive.

Here is Oracle with Oct 2017 (https://updates.oracle.com/download/26737266.html) applied (needs latest OPatch https://updates.oracle.com/download/6880880.html)
With a PDB1 pluggable database:

[oracle@VM106 ~]$ rman target /
Recovery Manager: Release - Production on Wed Oct 18 16:16:41 2017
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB1 (DBID=920040307)
RMAN> report schema;
using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name CDB1
List of Permanent Datafiles
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 810 SYSTEM YES /acfs/oradata/CDB1/datafile/o1_mf_system_dmrbv534_.dbf
3 540 SYSAUX NO /acfs/oradata/CDB1/datafile/o1_mf_sysaux_dmrbxvds_.dbf
4 70 UNDOTBS1 YES /acfs/oradata/CDB1/datafile/o1_mf_undotbs1_dmrbz8mm_.dbf
5 250 PDB$SEED:SYSTEM NO /acfs/oradata/CDB1/datafile/o1_mf_system_dmrc52tm_.dbf
6 330 PDB$SEED:SYSAUX NO /acfs/oradata/CDB1/datafile/o1_mf_sysaux_dmrc52t9_.dbf
7 5 USERS NO /acfs/oradata/CDB1/datafile/o1_mf_users_dygrpz79_.dbf
8 100 PDB$SEED:UNDOTBS1 NO /acfs/oradata/CDB1/datafile/o1_mf_undotbs1_dmrc52x0_.dbf
21 250 PDB1:SYSTEM YES /acfs/oradata/CDB1/5BD3ED9D73B079D2E0536A4EA8C0967B/datafile/o1_mf_system_dygrqqq2_.dbf
22 350 PDB1:SYSAUX NO /acfs/oradata/CDB1/5BD3ED9D73B079D2E0536A4EA8C0967B/datafile/o1_mf_sysaux_dygrqqs8_.dbf
23 100 PDB1:UNDOTBS1 YES +ASM1/CDB1/5BD3ED9D73B079D2E0536A4EA8C0967B/DATAFILE/undotbs1.257.957719779
List of Temporary Files
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 33 TEMP 32767 /acfs/oradata/CDB1/datafile/o1_mf_temp_dmrc4wlh_.tmp
2 64 PDB$SEED:TEMP 32767 /acfs/oradata/CDB1/pdbseed/temp012017-06-10_19-17-38-745-PM.dbf
3 64 PDB1:TEMP 32767 /acfs/oradata/CDB1/5BD3ED9D73B079D2E0536A4EA8C0967B/datafile/o1_mf_temp_dygrqqsh_.dbf

I have moved one file to ASM to show that it is now handled correctly.

The pluggable database is closed, we can unplug it. Nothing changes with the unplug syntax except the extension of the file. If the file mentioned is a .pdb instead of a .xml then it is a PDB archive:

RMAN> alter pluggable database PDB1 unplug into '/var/tmp/PDB1.pdb';
RMAN> alter pluggable database PDB1 close;
Statement processed
RMAN> alter pluggable database PDB1 unplug into '/var/tmp/PDB1.pdb'
2> ;
Statement processed
RMAN> exit

Actually it is just a zip file with the datafiles, without the full path:

[oracle@VM106 ~]$ unzip -t /var/tmp/PDB1.pdb
Archive: /var/tmp/PDB1.pdb
testing: o1_mf_system_dygrqqq2_.dbf OK
testing: o1_mf_sysaux_dygrqqs8_.dbf OK
testing: undotbs1.257.957719779 OK
testing: /var/tmp/PDB1.xml OK
No errors detected in compressed data of /var/tmp/PDB1.pdb.

You can see that the ASM file is not different from the others.

I drop the pluggable database

RMAN> drop pluggable database PDB1 including datafiles;
using target database control file instead of recovery catalog
Statement processed

And plug back the PDB1, as PDB2, using the zip file:

RMAN> create pluggable database PDB2 using '/var/tmp/PDB1.pdb';
Statement processed
RMAN> report schema;
Report of database schema for database with db_unique_name CDB1
List of Permanent Datafiles
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 810 SYSTEM YES /acfs/oradata/CDB1/datafile/o1_mf_system_dmrbv534_.dbf
3 540 SYSAUX NO /acfs/oradata/CDB1/datafile/o1_mf_sysaux_dmrbxvds_.dbf
4 70 UNDOTBS1 YES /acfs/oradata/CDB1/datafile/o1_mf_undotbs1_dmrbz8mm_.dbf
5 250 PDB$SEED:SYSTEM NO /acfs/oradata/CDB1/datafile/o1_mf_system_dmrc52tm_.dbf
6 330 PDB$SEED:SYSAUX NO /acfs/oradata/CDB1/datafile/o1_mf_sysaux_dmrc52t9_.dbf
7 5 USERS NO /acfs/oradata/CDB1/datafile/o1_mf_users_dygrpz79_.dbf
8 100 PDB$SEED:UNDOTBS1 NO /acfs/oradata/CDB1/datafile/o1_mf_undotbs1_dmrc52x0_.dbf
24 250 PDB2:SYSTEM NO /acfs/oradata/CDB1/5BD3ED9D73B079D2E0536A4EA8C0967B/datafile/o1_mf_system_dygwt1lh_.dbf
25 350 PDB2:SYSAUX NO /acfs/oradata/CDB1/5BD3ED9D73B079D2E0536A4EA8C0967B/datafile/o1_mf_sysaux_dygwt1lm_.dbf
26 100 PDB2:UNDOTBS1 NO /acfs/oradata/CDB1/5BD3ED9D73B079D2E0536A4EA8C0967B/datafile/o1_mf_undotbs1_dygwt1lo_.dbf
List of Temporary Files
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 33 TEMP 32767 /acfs/oradata/CDB1/datafile/o1_mf_temp_dmrc4wlh_.tmp
2 64 PDB$SEED:TEMP 32767 /acfs/oradata/CDB1/pdbseed/temp012017-06-10_19-17-38-745-PM.dbf
4 64 PDB2:TEMP 32767 /acfs/oradata/CDB1/5BD3ED9D73B079D2E0536A4EA8C0967B/datafile/o1_mf_temp_dygwt1lp_.dbf

Here all files are there, created in the db_create_file_dest.

File name convert

When you create a pluggable database and you are not in OMF you need to add a FILE_NAME_CONVERT to convert from the source file names to destination file names. When the files are referenced by a .xml file, the .xml file references the path to the files as they were in the source database. If you move then, you can update the .xml file, or you can use SOURCE_FILE_NAME_CONVERT to mention the new place. With a .pdb archive, the .xml inside contains the original path, but this is not what will be used. The path of the .pdb itself is used, as if the files were unzipped at that place.

If you use Oracle-Managed-Files, don’t care about the file names and then you don’t need all those file name converts.


Cet article 12cR2 PDB archive est apparu en premier sur Blog dbi services.

Using a BareMetal GPU shape in Oracle Cloud Infrastructure with Oracle Linux 7 and TensorFlow

Wim Coekaerts - Wed, 2018-02-07 13:32

A lot of developers are using TensorFlow for Machine Learning these days. In Oracle Cloud Infrastructure we provide some great GPU options. One of them is the BM.GPU2.2 shape which is an X7-based GPU system (contains 2 P100 Nvidia GPUs).

When you create an OCI instance using this shape with Oracle Linux 7, it comes pre-installed with the kernel modules to enable the GPUs. Ready to use.

Getting TensorFlow installed is very easy:

Install some prerequisite RPMs, some come from the EPEL yum repo which we provide as part of Oracle Linux and is enabled by default in your yum.repos file.

# sudo yum -y install python-pip python-devel atlas atlas-devel gcc-gfortran openssl-devel libffi-devel

# sudo pip install --upgrade virtualenv

# virtualenv --system-site-packages ~/venvs/tensorflow

# source ~/venvs/tensorflow/bin/activate

Now you can install TensorFlow using pip. use tensorflow-gpu if you want the GPU enabled version otherwise just use tensorflow.

(tensorflow) # pip install --upgrade tensorflow-gpu


(tensorflow) # pip install --upgrade tensorflow

To use tensorflow-gpu you have to install the Nvidia CUDA packages. This version of tensorflow depends on version 9.0

(tensorflow) # sudo yum -y install cuda-9-0

Run a TF example:

(tensorflow) #  pip install pandas

(tensorflow) # sudo yum -y install git

(tensorflow) # mkdir git

(tensorflow) # cd git

(tensorflow) # git clone https://github.com/tensorflow/models

(tensorflow) # cd models/samples/core/get_started/

(tensorflow) # python premade_estimator.py

and that's it. Super easy without any manual downloads.

this is a test

Talking about Microservices: A journey to Docker / Snap / CoreOS / Unbuntu Core / Docker-Swarm

Dietrich Schroff - Wed, 2018-02-07 13:11
A few months ago (13th august 2017) i started my personal journey into this new hype called microservices:

I thought the best way for me to get in touch was to begin with CoreOS. Within 2 weeks i got some first impressions:

But after these steps i realized, that next step on this road is kubernetes. It is clear that cluster scheduler like kubernetes can not be run on a single machine - so i tried to get another access to microservices: Snap and UbuntuCore:
In november 2017 it was clear, that both UbuntuCore and CoreOS are some building blocks for microservices, but i was not really on the right track.
Back to kubernetes? Kubernetes relies on containers. So i started with docker:
Nearly 3 months later i still did not get in touch with kubernetes - but i think docker swarm is a cluster scheduler, too. And it is really easy to run.

What will i do next? Some tests to failure/failover/failback scenarios. 

    6 Ways Automated Security Becomes A Developer’s Ally

    OTN TechBlog - Wed, 2018-02-07 09:46

    In a recent InfoWorld article, Siddhartha Agarwal, VP of Product Management at Oracle, outlined his top 10 predictions impacting application developers in 2018. In this blog, we’ll take a closer look at one of those predictions and how a cloud access security broker (CASB) service can help with it.

    #10. Highly automated security and compliance efforts become a new ally of developers

    Companies are increasingly adopting DevOps methodologies to accelerate their app development lifecycles in the cloud. Unfortunately, the common perception is that accelerating application lifecycles comes at the expense of security. That’s because, traditionally, security used to be a discrete step in application development lifecycles, taking weeks or months to certify an application for production use. There is no way such a delay can be incorporated into an agile CI/CD methodology. Security needs to be a continuous process linked to every step of DevOps.

    Fortunately, artificial intelligence and machine learning have matured to the point that they can be used to automate much of application security. Developers can ensure that their applications and data are continuously monitored using a CASB service, and any threats, compliance violations, or security incidents are automatically detected and remediated. This lets app developers maintain their development velocity, while conforming to security and compliance standards. Let’s look at some key areas that can be protected with continuous visibility and monitoring with Oracle CASB. 

    1. Enforcing Strong Application Configuration and Micro Segmentation

    CASB can monitor application configurations to detect any changes and revert those automatically to the “golden” configuration, as well as alert relevant administrators. This enforcement may include configurations for network segmentation, DNS resolution, usage of secure or insecure network ports, and encryption settings for folders containing application data.

    2. Enforcing Strong Access Control for Administrators

    CASB can continuously monitor and enforce strong access control policies for administrators, including multi-factor authentication, strong password policies, and SSH key rotation. Any changes to these can be reverted automatically and alerted to relevant administrators.

    3. Monitoring Admin Activity for Out-of-the-Ordinary Patterns

    CASB uses machine learning to automatically learn “normal” or regular patterns of administrative activity, such as the login/logout times of administrators, locations/IP addresses where they typically login from, and types of changes they usually perform to the application. It can then send an alert on any deviations from these normal patterns, such as an admin logging in from a location, IP address, or device type that they’ve never used before. In addition, customers can also configure CASB to look for admin changes to specific areas, such as lists of authorized users or groups, starting or stopping of app instances, or changes to encryption settings of folders. For example, if an infiltrator attempts to use valuable compute or storage resources for malicious usage, CASB will immediately raise an alert.

    4. Enforcing Data Security and Compliance
    CASB can continuously scan application data to detect any files that violate the company’s compliance policy. For example, it can be configured to look for sensitive or confidential information, such as credit card or Social Security numbers. If found, CASB can automatically alert administrators and take remedial action that prevent unauthorized access of the data.

    5. Monitoring User Activity for Out-of-the-Ordinary Patterns

    CASB uses machine learning to automatically detect unauthorized or malicious insider usage of the application. Similar to monitoring administrator activity, CASB uses machine learning to automatically learn normal patterns of regular user activity. Any deviations from these, such as users logging in from a location that they’ve never logged in from before, can automatically be alerted as being suspicious. On detecting suspicious activity, application access for the user can automatically be downgraded to prevent downloads, as an example, until the user has been able to prove their identity with further authentication.

    6. Monitoring for Misuse of Escalated Privileges

    Often times, developers gain access to production resources for troubleshooting purposes such as debugging, bug fixing, or other maintenance purposes. In many cases, those privileges are never revoked, thereby leaving those resources fully accessible by those developers even after those issues are resolved. CASB can help monitor resources in production so that any access or modifications is alerted to respective administrators, who can then respond accordingly. CASB can also help prevent or revert changes to the original state, thereby preventing unauthorized changes to production resources by such users.

    Oracle CASB offers all of the capabilities listed above, and it can also be integrated with other enterprise systems, such as SIEM, Identity-as-a-Service (IDaaS), or IT Service Management applications. This ensures that companies can tightly integrate CASB into their existing Security Operations Center (SOC) workflows and enable CASB to raise tickets automatically for remediation.

    Platform choice matters

    Oracle has spent the last several years building and assembling the set of security and management services in the Oracle Cloud that together enable customers to build the Identity-centric Security Operations Center (Identity SOC). The Identity SOC platform leverages purpose-built machine learning against the full breadth of operational and security telemetry — including activity and configuration information as well as identity and asset context — to provide real-time threat detection across heterogeneous, hybrid cloud environments.  When potential or active threats are detected, automated remediation can be invoked to eliminate those threats.


    Oracle Hospitality Sponsored Research Explores the State of the Central Reservation System Globally

    Oracle Press Releases - Wed, 2018-02-07 08:00
    Press Release
    Oracle Hospitality Sponsored Research Explores the State of the Central Reservation System Globally h2c Report “The Next Generation Central Reservation System” Audits 90 Chains Across Europe, The Middle East and Africa, the Americas and Asia Pacific

    Redwood Shores, Calif.—Feb 7, 2018

    Oracle Hospitality announced today the findings of a global research study – conducted by analyst firm h2c ­­– surveying more than 90 hotel chains to assess the state of central reservation systems (CRS) and the improvements needed to prioritize IT development and, ultimately, enhance guest service.

    Commissioned by Oracle Hospitality, h2c’s research scope focused on an online survey and expert interviews with hotel chains in Europe, the Middle East and Africa, the Americas and Asia Pacific – representing more than 11,000 properties and 1.7 million rooms worldwide. The primary objectives: determine chains’ satisfaction level with their current CRS solution, identify missing features and functionalities, and seek recommendations to achieve improvements.

    “Today’s guests increasingly demand a hassle-free journey. The findings of the h2c report clearly indicate that the hotel industry is challenged to meet such expectations,” said Laura Calin, vice president strategy and solutions management, Oracle Hospitality. “At Oracle, we’re working diligently with our customers to simplify and integrate solutions, making it easier to leverage technology to attract new guests and win the loyalty of existing ones.”

    Among the most significant findings: dissatisfaction with CRS is common among hotel operators, with one third of respondents reporting they are missing more than 30% of required functionality. Furthermore, half of all chains reported missing at least one key CRS functionality.

    Although respondents readily cited their CRS deficiencies, many struggled to identify means to remedy shortcomings. Such issues underscore the need for technology providers/CRS vendors to collaborate with clients to truly understand problems before driving innovation with new features.

    Based on the findings, h2c forecasts that PMS and CRS solutions will continue to merge in the future, either in the form of hybrid solutions or as entirely new hotel management platforms.

    The following are some of the key highlights from The Next Generation Central Reservation System – Implications for Future CRS Developments:

    • Customer Relationship Management (CRM) poses the largest demand for CRS integration. Small and medium-sized hotel groups, with or without full-fledged loyalty programs, are under intense pressure to improve their guest experience to better compete with the personalization capabilities of global chains. CRS integration is minimal and even non-existent in some regions, making it a critical priority for CRS vendors to address – either with a proprietary product or a third-party integration.

    • Internet booking engine (IBE) reservations are the greatest value driver, but underperforming. Though hotel chains are changing their online sales policy (including price disparity and/or offering free benefits) to compete against OTAs, the IBE needs to facilitate more sophisticated business rules. Such trends are mandating a reinvention of the IBE, which would enable more e-commerce functionality such as discounting packages.

    • Future distribution management tasks will shift to non-CRS systems. From the hoteliers’ perspective, some key CRS tasks such as availability and rates (ARI) management, will likely migrate to other systems in their IT portfolio or become part of a still-to-be-developed platform solution.

    A full copy of the report can be found here.

    Oracle will convene a global community of hospitality leadership at Oracle Industry Connect April 10-11, 2018 in New York, NY. Oracle Industry Connect provides attendees with intimate peer networking opportunities in addition to over 30 customer-led presentations with themes including how to move to the cloud to accelerate innovation and reduce IT complexity, mine data to gain insights and competitive advantages and capitalize on mobility to empower staff and serve guests. To learn more about Oracle Industry Connect 2018 and register to attend visit: www.oracle.com/oracleindustryconnect/

    Contact Info
    Matt Torres
    About Oracle

    The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.


    Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

    About Oracle Hospitality

    Oracle Hospitality brings 35 years of experience in providing technology solutions to food and beverage operators. We provide hardware, software, and services that allow our customers to deliver exceptional guest experiences while maximizing profitability. Our solutions include integrated point-of-sale, loyalty, reporting and analytics, inventory and labor management, all delivered from the cloud to lower IT cost and maximize business agility.

    For more information about Oracle Hospitality, please visit www.Oracle.com/Hospitality

    About h2c

    h2c’s services to the hospitality industry are unbiased and customer-focused. H2c’s clients benefit from B2B research, Content Marketing services, hospitality technology RFPs and CONTtest, a channel manager for static hotel content.

    Our Mission: H2c inspires success in hospitality commerce. Our passion to translate marketplace complexities into actionable strategies shapes our relationships. The goal: clients are confidently in control.” For more information, please visit our website.

    Talk to a Press Contact

    Matt Torres

    • 4155951584

    Oracle JET Composite Components - Manual for JET Coder

    Andrejus Baranovski - Wed, 2018-02-07 07:20
    JET Composite Components - are useful not only to build UI widgets, but also to group and simplify JET code. In this post, I will show how to wrap JET table into composite component and use all essential features, such as properties, methods, events and slots.

    Sample app code is available on GitHub. JET table is wrapped into composite component, it comes with slot for toolbar buttons:

    What is the benefit to wrap such components as JET table into your own composite? To name a few:

    1. Code encapsulation. Complex functionality, which requires multiple lines of HTML and JS code resides in the composite component
    2. Maintenance and migration. It is easier to fix JET specific changes in single place
    3. Faster development. There is less steps to repeat and less code to write for developer, when using shorter definition of the wrapper composite component

    Sample application implements table-redsam component, for the table UI you can see above. Here is component usage example, very short and clean:

    All the properties specific to given table are initialised in the module. Developer should provide REST endpoint, key values, pagination size and column structure. The rest is happening in the composite component and is hidden from the developer, who wants to implement a table:


    We should take a look into array type property. Such property allows to pass array into component. This can be useful either to pass array of data to be displayed or array of metadata to help with component rendering. In our case we pass array of metadata, which helps to render table columns. Array type property is based on two attributes - Header Text and Field. Properties are defined in composite component JSON file:

    Properties are retrieved from variable inside component and are assigned to local variables:

    This is table implementation inside component, columns are initialised from component property:


    Slot defines a placeholder, where developer who is using composite component can add additional elements. Slot is defined in component JSON definition file:

    To define slot, JET slot component should be defined inside composite. You can control layout and location where slot will be rendered:

    In our case, we use slot for table toolbar buttons. These buttons are added later, when developer is using composite. To place button into slot, put button inside composite component tag and assign defined slot name for the button. This will allow to render button in the slot:


    Method defined in composite component, can be called from outside. In example below, I call JS function from toolbar slot button:

    Function gets composite by ID and calls exposed method:

    Method should be defined in composite JSON definition:

    Method is implemented inside composite JS module:


    Events allows to implement external listeners. Basically this allows to override composite logic in external functions. Event is declared in composite JSON definition:

    Composite tag contains event property mapped with external JS function, which will be called when event happens inside composite:

    Function code in the module, it prints current row selection key:

    Table is defined with listener property inside composite:

    Listener inside composite initiates event, which will be distributed outside and handled by method defined in composite tag on-handle-selection property:

    Let's see how it works. Call Method button invokes method inside composite:

    Table row selection first triggers listener inside composite, then it initiates event and external listener is invoked too:

    I think this lists pretty much all of the essential functionality given by JET composite components. I hope you will find it useful in your development.

    discovering when plans change

    Tom Kyte - Wed, 2018-02-07 03:26
    hi , in my environment i found some of query plans often gets changed, i used 10053 to figure out for plan change , but which part to check and how to conclude what is causing plan change that i am not able to figure out can you please help h...
    Categories: DBA Blogs

    difference between Cardinality feedback and dynamic sampling

    Tom Kyte - Wed, 2018-02-07 03:26
    hi Team, i want to know difference between Cardinality feedback and dynamic sampling . additionally cardinality feedback is provides more near by accurate estimation of cardinality on basis of new plan is generated and used in next execution...
    Categories: DBA Blogs

    Debugging a PLSQL application

    Tom Kyte - Wed, 2018-02-07 03:26
    Help me bro..plaes...i didnt understand this requirement an exactly.... This code is located in the Account_Servicing_Fact_Load SSIS package. The final container contains the code components needed to run both aggregation data. You will have...
    Categories: DBA Blogs

    Range Partition on Virtual column - CTAS.. syntax is not working

    Tom Kyte - Wed, 2018-02-07 03:26
    Hi Tom, I have a requirement to create a range partition for an existing table. Lets say the table name is Orders. The table has Order_Date column of timestamp datatype and the data is in UTC timezone. [We get the data in UTC format in a ...
    Categories: DBA Blogs

    how can alter table

    Tom Kyte - Wed, 2018-02-07 03:26
    Can we add a new column between two columns.If yes,please tell me command
    Categories: DBA Blogs

    SELECT with WITH Clause(subfactoring) and ORA-4031 errors.

    Tom Kyte - Wed, 2018-02-07 03:26
    Tom, I want to validate following reasons to keep away from using "WITH CLAUSE" in the select statement: a) Each time the WITH query clause is run, a global temporary table is created and used in the query. Even if the SQL is using bind variabl...
    Categories: DBA Blogs

    PHP and Oracle DB: RPMs for Easy Install on Linux

    Christopher Jones - Tue, 2018-02-06 22:05

    The Oracle Linux team is now making updated PHP RPMs available on yum.oracle.com.  The good news: an RPM for the PHP OCI8 extension is included.  Yay!  My colleague, Sergio, has a blog post Connect PHP 7.2 to Oracle Database 12c using Oracle Linux Yum Server with the details.

    JAN18: Database 11gR2 PSU, 12cR1 ProactiveBP, 12cR2 RU

    Yann Neuhaus - Tue, 2018-02-06 15:32

    If you want to apply the latest patches (and you should), you can go to the My Oracle Support Recommended Patch Advisor. But sometimes it is not up-todate. For example, for only the PSU is displayed and not the Proactive Bundle Patch, which is highly recommended. And across releases, the names have changed and can be misleading: PSU for (no Proactive Bundle Patch except for Engineered Systems). can have SPU, PSU, or Proactive BP but the latest is highly recommended, especially now that it includes the adaptive statistics patches. introduce the new RUR and RU, the latest one being the one recommended.

    To get things clear, there’s also the Master Note for Database Proactive Patch Program, with reference to one note per release. This blog post is my master note to link directly to the recommended updates for Oracle Database.

    Master Note for Database Proactive Patch Program (Doc ID 756671.1)
    https://support.oracle.com/epmos/faces/DocContentDisplay?id=756671.1 – PSU

    Database Proactive Patch Information (Doc ID 2285559.1)
    Paragraph -> Database Patch Set Update

    Latest as of Q1 2018 -> 16-Jan-2018 (Jan 2018) Database Patch Set Update (DB PSU) 26925576 (Windows: 26925576)  – ProactiveBP

    Database Proactive Patch Information (Doc ID 2285558.1)
    Paragraph -> Database Proactive Bundle Patches (DBBP)

    Latest as of Q1 2018 -> 16-Jan-2018 Database Proactive Bundle Patch (Jan 2018) 27010930 – RU

    Database Proactive Patch Information (Doc ID 2285557.1)
    Paragraph -> Database Release Update (Update)

    Latest as of Q1 2018 -> 16-Jan-2018 (Jan 2018) Database Release Update 27105253 (Windows: WIN DB BP 27162931)

    Don’t forget SQL Developer

    In the 12c Oracle Home SQL Developer is installed, but you should update it to the latest version.
    Download the following from http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
    – The SQL Developer zip for ‘Other Platforms’, currently 17.4
    – The SQLcl zip for ‘All Platforms’, currently 17.4

    On the server, remove, or rename the original directory:
    mv $ORACLE_HOME/sqldeveloper $ORACLE_HOME/sqldeveloper.orig

    Unzip what you have downloaded:
    unzip -d $ORACLE_HOME/ sqldeveloper-*-no-jre.zip
    unzip -d $ORACLE_HOME/sqldeveloper sqlcl-*-no-jre.zip

    I suggest to have a login.sql which sets the beautiful ansiconsole for SQLcl:

    echo "set sqlformat ansiconsole" > $ORACLE_HOME/sqldeveloper/sqlcl/login.sql

    On 12.2 you can run SQLcl just with ‘sql’ (and same arguments as sqlplus: / as sysdba or /nolog,…) because this is what is defined in $ORACLE_HOME/bin.
    However, it sets the current working directory and i prefer to keep the current one as it is probably were I want to run scripts from.

    Then I add the following aliases in .bashrc

    alias sqlcl='JAVA_HOME=$ORACLE_HOME/jdk SQLPATH=$ORACLE_HOME/sqldeveloper/sqlcl bash $ORACLE_HOME/sqldeveloper/sqlcl/bin/sql'
    alias sqldev='$ORACLE_HOME/sqldeveloper/sqldeveloper.sh'

    When running SQL Developer for the first time you can create automatically a ‘/ as sysdba’ connection (but remember this is not a good practice to connect like this) and a connection for each user declared in the database: Right click on Connections and Create Local Connections


    Cet article JAN18: Database 11gR2 PSU, 12cR1 ProactiveBP, 12cR2 RU est apparu en premier sur Blog dbi services.

    New OA Framework 12.2.5 Update 19 Now Available

    Steven Chan - Tue, 2018-02-06 11:46

    Web-based content in Oracle E-Business Suite Release 12 runs on the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and infrastructure. Since the initial release of Oracle E-Business Suite Release 12.2 in 2013, we have released a number of cumulative updates to Oracle Application Framework to fix performance, security, and stability issues.

    These updates are provided in cumulative Release Update Packs, and cumulative Bundle Patches that can be applied on top of the Release Update Packs. In this context, cumulative means that the latest RUP or Bundle Patch contains everything released earlier.

    The latest OAF update for Oracle E-Business Suite Release 12.2.5 is now available:

    Where is this update documented?

    Instructions for installing this OAF Release Update Pack are in the following My Oracle Support knowledge document:

    Who should apply this patch?

    All Oracle E-Business Suite Release 12.2.5 users should apply this patch.  Future OAF patches for EBS Release 12.2.5 will require this patch as a prerequisite. 

    What's new in this update?

    This bundle patch is cumulative: it includes (TBS) fixes in total, including all fixes released in previous EBS Release 12.2.5 bundle patches.

    This latest bundle patch includes fixes for following bugs/issues:

    • Tip type is not displayed in advanced search region in 'Screen Reader Optimized' accessibility mode.

    Related Articles

    Categories: APPS Blogs

    Podcast: Women in Technology: Motivation and Momentum

    OTN TechBlog - Tue, 2018-02-06 10:39

    According to the National Center for Women and Information Technology (NCWIT), while 57% of professional occupations in the US were held by women in 2016, women held only 26% of professional computing occupations. Correcting that imbalance is the right thing to do, of course. But there’s another dimension to the issue that raises the stakes for getting more women into IT jobs.

    “We have 80,000 graduates every year coming out of college with computer science degrees,” says Kellyn Pot’Vin-Gorman, technical intelligence manager for the office of CTO at Delphix. But US colleges and universities can’t crank out computer science grads fast enough to meet demand. “Over a million technical jobs will be here by 2020, and we’ve got nobody to fill them,” Kellyn says.

    Attracting more women into software development and other technical fields will help to fill the IT jobs that will otherwise go wanting. But, perhaps due to lingering gender bias, or simple oversight, effective communication of the opportunities doesn’t always happen. “No one told me that I could do this as a career,” says Michelle Malcher, a security architect at Extreme Scale Solutions in Chicago. “No one said, ‘you can have fun with code.’”

    Now that Michelle is having fun with code, she, like Kellyn, puts significant time and effort into getting the word out about the opportunities and career potential for young women. But men also have a role in that mission. “Men need to be part of the conversation. It can’t just be women talking about women's issues,” says Natalie Delemar, a senior consultant with Ernst and Young and an active supporter of women in technology. “We need to have men at the table so that they understand the importance of these issues.”

    Women and men can engage in mentoring and sponsorship activities that are important in getting more women into IT roles. Heli Helskyaho, CEO of Miracle Finland and a PhD student at the University of Helsinki, is one of two mentors recently elected by computer science students at that institution. “The faculty just decided that it's time to have mentorship in the university the first time after all these years.”

    But while mentoring and sponsorship are important, there are key differences. And, as Natalie observes, “women in the workplace are actually over mentored and under sponsored.”

    Natalie explains that while mentoring typically focuses on career guidance and advice on educational matters, “sponsorship is when somebody actually uses their political capital to put you into positions of power to give you experiences to get ahead.”

    Getting ahead is what the latest Oracle Developer Community podcast is all about, as Kellyn Pot'Vin-Gorman, Michelle Malcher, Natalie Delemar, and Heli Helskyaho, along with panel organizer and moderator Laura Ramsey, share insight on what motivated them in their IT careers, and how they lend their expertise and energy to driving momentum in the effort to draw more women into technology.

    This panel discussion took place at Oracle Openworld in San Francisco on September 18, 2016.

    The Panelists

    (Listed alphabetically)

    Natalie Delemar
    Senior Consultant, Ernst and Young
    President, ODTUG Board of Directors
    Twitter LinkedIn Facebook Heli Helskyaho Heli Helskyaho
    CEO, Miracle Finland
    Oracle ACE Director
    Ambassador, EMEA Oracle Usergroups Community
    Twitter LinkedIn Facebook Michelle Malcher
    Security Architect, Extreme Scale Solutions
    Oracle ACE Director
    Twitter LinkedIn Facebook Kellyn Pot'Vin-Gorman
    Technical Intelligence Manager, Office of CTO, Delphix
    President, Board Of Directors, Denver SQL Server User Group
    Twitter LinkedIn Facebook Laura Ramsey
    Manager, Database Technology and Developer Communities
    Oracle America
    Twitter LinkedIn Facebook   Additional Resources Coming Soon
    • DevOps: Can This Marriage be Saved? (Feb 21)
      What is the biggest threat to successful DevOps? What’s the most common DevOps mistake? Experts Nicole Forsgen, Leonid Igolnik, Alaina Prokharchyk, Baruch Sadogursky, Shay Shmeltzer, and Kelly Shortridge discuss what it takes to make DevOps work.
    • Combating Complexity
      An article in the September 2017 edition of the Atlantic warned of The Coming Software Apocalypse. Oracle's Chris Newcombe was interviewed for that article. In this podcast Chris joins Chris Richardson, Adam Bien, and Lucas Jellema to discuss heading off catastophic software failures.

    Never miss an episode! The Oracle Developer Community Podcast is available via:


    Materialized views and Synonyms

    Tom Kyte - Tue, 2018-02-06 09:06
    Good day. I need help with refresh materialized view. I created synonym MySynonym: <code>CREATE OR REPLACE SYNONYM "MyScheme"."MySynonym" FOR "MyScheme2"."SomeTable";</code> I created materialized view: <code>CREATE MATERIALIZED VIEW MyMView T...
    Categories: DBA Blogs

    Cast to varchar2 with utl_raw

    Tom Kyte - Tue, 2018-02-06 09:06
    Hi Below query converts the string into lower case. i would want to keep the case as it is .. Can you please suggest a solution for this. <code>select utl_raw.cast_to_varchar2(nlssort('PRAshantE', 'nls_sort=binary_ai')) from dual; </code> ...
    Categories: DBA Blogs

    Function based unique index is not used in select

    Tom Kyte - Tue, 2018-02-06 09:06
    Hi guys, I'm curious why the function based index is not used in the following SELECT statement. <code> SELECT USERNAME FROM USERS WHERE USERNAME = 'MyUser' AND IS_DELETED = 0; </code> Or <code> SELECT USERNAME FROM USERS WHERE USERNAME = 'M...
    Categories: DBA Blogs

    Accessing dynamically generated pivot columns through a cursor

    Tom Kyte - Tue, 2018-02-06 09:06
    Hi Tom, I have a PL/SQL report wherein the columns change dynamically (refer sample SQL: https://livesql.oracle.com/apex/livesql/s/f8gbm32e2acju7jzvuzjjh3a1) based on the parameter. Suppose if the report is run for the Q1 2018, then it will have...
    Categories: DBA Blogs


    Subscribe to Oracle FAQ aggregator