Feed aggregator

Quickly build self-signed certificates for Oracle GoldenGate 18c

DBASolved - Wed, 2019-03-27 13:30

With Oracle GoldenGate Microservices 12c and 18c, the architecture can be configured to use SSL certificates for securing and replicating between sites. This is a huge improvement for securing the replication framework and makes it a lot simpler to replicate data over standard HTTPS ports.

In order to configure Oracle GoldenGate 12c/18c Microserivces with SSL certificates, you either have to generate a self-signed certificate or bring your own certificate (BYOC) to use. This also requires you to build an Oracle Wallet to store the certificates in. Additionally, to secure both sides of the replication environment within a Microservices environment; the wallet is required to be copied to any other environment where you will be replicating to or from.

In this post, I’m providing you with a simple python script that will build the Self-Signed Certificates needed for testing purposes. By using this overly-simplified, script you assume responsibility of using the generated certificates.

For more details on configuring Oracle GoldenGate Microservices 12c/18c using Self-Signed Certificates, refer to the Oracle documentation for Securing Oracle GoldenGate Microservices (here).

My overly-simple python script is located here.

Happy Securing and Enjoy!!!

Categories: DBA Blogs

Accessing Visual Builder Business Objects through REST Services

Shay Shmeltzer - Wed, 2019-03-27 13:22

One nice thing about Visual Builder is that it helps you not only with the creation of the front end, but also with the creation of the backend for your app - through the use of the business objects feature. When you develop the UI in VB it is accessing the business objects through REST endpoints, and these REST endpoints can also be exposed so other UIs or systems can access the same data.

In the video below, I'm showing you how to access the business objects and perform the full set of CRUD operations against them.

There are many more capabilities to these REST APIs including advanced query options that help you optimize the amount of data you are getting back from them. Read about it in our documentation.

One more note - in the demo I use the Bearer Token security, but you can also switch to use basic authentication to access your services. To do this in your application settings, under the business object tab, you can check the check box for enabling this.

Security setting for business objects



Categories: Development

TWINSET Curates a Sophisticated Customer Experience with Oracle Retail

Oracle Press Releases - Wed, 2019-03-27 11:00
Press Release
TWINSET Curates a Sophisticated Customer Experience with Oracle Retail Italian Clothing Brand Modernizes Point of Service to Increase Storefronts and Better Engage Customers

REDWOOD SHORES, Calif. and MILAN, Italy—Mar 27, 2019

TWINSET curates a unique assortment of women’s ready-to-wear fashion, shoes and accessories sold online and across renowned Italian, European and Russian cities. As the company continued to grow, they knew maintaining harmony between delivering high-quality clothing and excellent customer service was essential. With Oracle Retail’s modern point of service (POS) technology, TWINSET can open more boutiques and corner stores that meet international requirements, while delighting sophisticated shoppers with associates that are informed and ready to help.

“We want our consumers, the brand and our associates to be in harmony when they enter the store. By putting intuitive and modern technology at our associates’ fingertips, they can focus on the customer and delivering a seamless omnichannel experience,” said Federico Tamburini, IT and logistic director, TWINSET. “Oracle also enables us to quickly roll out new boutiques by leveraging the international and localization capabilities inherent in the solution.”  

In the recent Topography of Retail Report, nearly 6,400 European consumers surveyed prioritized knowledgeable in-store staff (73 percent) as one of the most compelling attributes of a shopping experience. Oracle Retail Xstore Point-of-Service will empower TWINSET associates to deliver on the brand commitment in store with inventory visibility, customer intelligence, and seamless transactions.

For example, from a tablet, an associate will be able to easily pull up a customer’s recent transactions to get a sense of their style and make suggestions on new merchandise or easily order an out-of-stock item from the website and have it shipped directly to the customer with no hassle.

“The in-store experience must go beyond transactions alone. Retailers, particularly fashion retailers, must dazzle their customers at the point of interest. By modernizing in-store POS technology, brands such as TWINSET are putting consumer intelligence in the associates’ hands, allowing them to personalize the interaction and build trust between the brand and the individual,” said Mike Webster, senior vice president and general manager, Oracle Retail.

Contact Info
Kris Reeves
Oracle PR
About Oracle Retail

Oracle is the modern platform for retail. Oracle provides retailers with a complete, open, and integrated platform for best-of-breed business applications, cloud services, and hardware that are engineered to work together. Leading fashion, grocery, and specialty retailers use Oracle solutions to accelerate from best practice to next practice, drive operational agility and refine the customer experience. For more information, visit our website www.oracle.com/retail.

About Oracle

The Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly-Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database. 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.

Talk to a Press Contact

Kris Reeves

  • +1.925.787.6744

ORA-00984 column not allowed here

VitalSoftTech - Wed, 2019-03-27 09:45
What is the cause of the "ORA-00984 column not allowed here" error? How do I resolve this?
Categories: DBA Blogs

Documented JSON Classes

Jim Marion - Tue, 2019-03-26 19:18

Looking through the PeopleTools 8.57 Feature Overview document, you may have noticed that 8.57 now includes support for several JSON classes as well as PeopleBooks documentation. As Chris Malek showed us a couple of years ago, the classes listed in the Feature Overview document are not new. What is new is the keyword Support and PeopleBooks documentation. Using the documentation, I was able to generate a sample on PeopleTools 8.57:

Local JsonBuilder &jbldr = CreateJsonBuilder();
Local string &json;

If &jbldr.StartArrayReturnsTrue("Employees") Then
REM Empl 1;
If &jbldr.StartObjectReturnsTrue("Employee") Then
If &jbldr.StartObjectReturnsTrue("Name") Then
&jbldr.AddProperty("First", "Jim");
&jbldr.AddProperty("Last", "Marion");
&jbldr.AddProperty("Middle", "J");
&jbldr.AddProperty("ID", 123456);

REM Empl 2;
If &jbldr.StartObjectReturnsTrue("Employee") Then
If &jbldr.StartObjectReturnsTrue("Name") Then
&jbldr.AddProperty("First", "Lucy");
&jbldr.AddProperty("Last", "McGillicuddy");
&jbldr.AddProperty("Middle", "");
&jbldr.AddProperty("ID", 789123);

&json = &jbldr.ToString();

MessageBox(0, "", 0, 0, &json);

Alternatively, we can build JSON structures using JsonObject and JsonArray directly, but I like the way the JsonBuilder structures code so that child items appear indented, etc. Notice the code above begins the JSON structure with an array? Here is the output. Notice the root node is an object, not an Array:

Even though my very first call to JsonBuilder was to start an Array, it started an Object. What if you just want an array as the outer node? We can extract the array from the JsonBuilder RootNode using the following:

What if we want to format the code? First, I don't recommend formatting code you will transmit to external systems as white-space compressed JSON is preferred for data transmission. But formatting for debugging purposes is perfect. We can format JsonBuilder output using the JsonGenerator class. Here is a fragment that will format the JsonBuilder result:
Local JsonGenerator &jgen = CreateJsonGenerator();
&json = &jgen.ToString();

One thing to note is that JsonBuilder will let you generate invalid JSON. The parameter to StartXxxReturnsTrue is the name of the node to create. If we start the first node with a zero-length string: &jbldr.StartArrayReturnsTrue(""), then the generated JSON will include curly brace object notation, but no property name before the Array start.

As I look through the documentation for 8.57, I see every Json class method and property documented, but what about the CreateJsonXxx functions? Anyone find documentation for these functions? Did I miss something?

As Chris pointed out, these JSON Classes have been in PeopleTools since 8.55.11. Assuming that just the documentation is new and not the classes, I ran all of this code on 8.56 and it works without modification.

At jsmpros, we teach JSON strategies through our Integration Broker and PeopleTools Delta courses. Are you interested in learning more? Contact us to schedule your next PeopleTools training session.

Non-Deterministic Functions and Scalar Subquery Caching

Tom Kyte - Tue, 2019-03-26 09:26
Hi, i got one question regarding scalar subquery: Why does Oracle not restrict scalar-subquery-caching to functions which are declared to be deterministic? With the deterministic keyword the developer states that a function is deterministic...
Categories: DBA Blogs

dbms_assert package

Tom Kyte - Tue, 2019-03-26 09:26
Hi, Oracle provides dbms_assert package with functions which can be used to safeguard SQL injections. Shall I use this package like below in my java application. select DBMS_ASSERT.sql_object_name ('test') from dual; I didn't see people usi...
Categories: DBA Blogs

How to move to a new tablespace a column LOB of the dataype ANYDATA ?

Tom Kyte - Tue, 2019-03-26 09:26
Hello Masters, I have a table with a PUBLIC.ANYDATA column. <code>SQL> desc XL_EURO_AXAIA.EXT_TCV_TCH_VALEUR Nom NULL ? Type ----------------------------------------------- TCH_ID NOT NULL NUMBER ID NO...
Categories: DBA Blogs

Oracle Blockchain Platform Now Available as Part of Everledger’s Provenance Tracking Solution

Oracle Press Releases - Tue, 2019-03-26 07:15
Press Release
Oracle Blockchain Platform Now Available as Part of Everledger’s Provenance Tracking Solution New capabilities deemed critical by Everledger for customers to get the most out of blockchain and their existing business and IT systems

Oracle OpenWorld Singapore, Singapore—Mar 26, 2019

Oracle’s enterprise-grade blockchain platform is now available as part of Everledger’s blockchain-based solution following a rigorous development and scale evaluation process. As part of this, Everledger, a global emerging technology enterprise leading the way in real-world applications of blockchain, assessed Oracle’s blockchain offering for its ability to provide extended product capabilities to support enhanced customer solutions.

In particular, the alignment will give Everledger users the ability to shadow blockchain transactions into a relational database, making it easier to run analytics on them. This will enable improved decision making, for example, being better able to determine how long it takes to transport gemstones from mine to the wholesaler and the retailer.

A pioneer in digital provenance tracking, Everledger’s blockchain-based platform is trusted by many industries including diamonds, coloured gemstones, fine wine and art. The ability to transparently track the provenance and lifetime journey of assets as they move across global supply chains, is especially critical for high value goods. These industries are susceptible to increased potential for theft, fraud and counterfeit—in the diamond industry alone, fraud events cost the insurance industry millions of dollars a year.

Leanne Kemp, Founder & CEO Everledger says, “With an increasing consumer consciousness and a vocal demand for transparency, our work is focused on engaging entire business ecosystems to provide consumers the ability to make fully informed purchasing decisions. It is thus key for us to enable the ease of systems interaction and provide value add to our customers.

“The inclusion of Oracle Blockchain Platform in our offering enables us to deploy more innovative products and solutions for our customers globally, in particular with improved time to market for business intelligence reporting solutions. Oracle’s comprehensive enterprise-grade offering will open our customers to realising more from our blockchain-based platform and crystalise value from the data in their own systems.”

Key Elements

Some of the new capabilities of Oracle Blockchain Platform are deemed critical by Everledger in the integration of its blockchain-based platform with customers’ existing business and IT systems. As blockchain becomes an important data store in the enterprise, the Oracle Blockchain Platform enables users to capture blockchain transaction history and current state data for analytics as well as integrate it with other data sources.

“Our longstanding goal has been to help customers to manage, protect, analyze and use the world’s data for the benefit of all. Being able to work with innovative companies like Everledger is an amazing opportunity. We look forward to helping both the company itself further its innovations in tracking and tracing the authenticity of some of the world’s most precious items, but also helping those in the ecosystem link key data sources for wider benefit,” said Frank Xiong, group vice president, Blockchain Product Development, Oracle.

The key elements of note include:

  • Database access – Data is an integral part of blockchain. With much of the world’s data resident in Oracle systems, the use of Oracle Blockchain Platform to seamlessly link to those repositories will enable these same customers to leverage both their existing data stores and data on the Everledger blockchain.
  • Analytics – Oracle Blockchain Platform’s ability to connect to the rich histories stored in an organisation’s existing database means that Everledger can seamlessly enable analytics integration for highly visual interactive dashboards and reports.
  • Monitoring of network health, transaction rates, and other statistics, and other elements of blockchain administration/configuration, are made easier by enhanced REST APIs, which also simplify integration with existing enterprise IT tools.
  • Out of the box plug and play capabilities from the Oracle Blockchain Platform makes it not only easy for Everledger to get off the ground, but will also easier for deployment.
  • Developer tools – Additionally, the query tools for Oracle Blockchain Platform link into things like smart contract support standard SQL-based ledger queries, enabling organisations to leverage the skill sets their developers already have, thereby reducing the complexity of developing chaincode and boosting performance.
Contact Info
Rebecca English
+61 414 314 836
About Oracle Blockchain

Only Oracle provides a comprehensive blockchain offering, including business-ready Oracle Blockchain Applications Cloud and Oracle Blockchain Platform for developers who need to build or integrate their applications. Oracle’s blockchain applications are built with Oracle Blockchain Platform and seamlessly connect with Oracle Supply Chain Management (SCM) Cloud, Oracle Enterprise Resource Planning (ERP) Cloud and other Oracle Cloud Applications. Oracle Blockchain Platform is production ready with enterprise-grade capabilities, easy to adopt, and quick to develop upon, accelerating customer’s blockchain journeys and saving their costs.

About Oracle

The Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database. For more information about Oracle (NYSE: ORCL), please visit us at www.oracle.com.

Talk to a Press Contact

Rebecca English

  • +61 414 314 836

Hoteliers Deliver Stellar Guest Experiences with Oracle Innovations

Oracle Press Releases - Tue, 2019-03-26 07:00
Press Release
Hoteliers Deliver Stellar Guest Experiences with Oracle Innovations Oracle Hospitality Arms Hotels with Intelligence and Capabilities to Create Memorable Guest Stays

ORACLE HOSPITALITY CONNECT, Lisbon, Portugal—Mar 26, 2019

Updates to Oracle Hospitality OPERA Cloud Service continue to redefine how hoteliers engage and serve guests, from the time they make their reservations through to check-out. With a plethora of new innovations, including a completely redesigned user interface and deeper customer insights, OPERA Cloud Service enables hotel personnel to focus on better connecting with guests and delivering personalized experiences to keep them coming back. 

“In a world where guest experience is ‘make or break’, today’s hoteliers need critical insights into their operations and into each guest’s needs, desires and behaviors,” said Greg Webb, senior vice president and general manager, Oracle Hospitality. “With this release, our hotel customers can truly hear the “voice of the guest.” enabling employees to raise their game and deliver on guest experience like never before.”

OPERA has long been the preferred hotel management platform for thousands of hotels from the world’s most recognizable brands to independent properties. OPERA Cloud brings the same comprehensive features to a cloud-based, mobile-enabled platform. In addition, OPERA Cloud Service now offers open APIs enabling faster and easier integration with third party providers that hotels can leverage to deliver unparalleled guest stays. By moving the property management system to the cloud, hotels can reduce dramatically their IT complexity.

OPERA Cloud’s innovations enable the following:

  • Enhance the guest experience:
    • Streamline Reservations: a new “look to book” feature provides room type and rate inventory for single- and multi-property reservations via a shopping cart view for faster booking. Existing reservations are easily located via several search options, and one-click access to guest details helps staff understand which guests are VIPs, repeat customers, loyalty members as well as their preferences. Group bookings have also been streamlined.
    • Ease Arrivals & Check In: new features allow hotel operators to make the check-in process seamless and consistent with a set of customizable steps. OPERA Cloud is mobile-enabled, allowing staff to check-in guests on tablets, eliminating long lines and guest frustration while delivering a more personalized check-in experience.
    • Simplify Check-Out: enhanced check out capabilities make it easy to settle bills, including preparing and routing bills with multiple folios. Drag and drop functionality makes it easy to transfer a posting to another folio or room. Integration with EMV credit card settlement eases payment processing from the desk or a mobile tablet makes it easier to serve the customer in the most convenient locations.
  • Empower Staff: available in 20 languages, the enhanced OPERA Cloud Service offers additional capabilities that make the guest journey even more rewarding while empowering managers and personnel with detailed reports and insights.
    • Improve Corporate and Property Reporting: with three out-of-the-box standard dashboards and sample reports, hotel personnel from operations managers to revenue teams can swiftly view and deliver insights such as average daily rates, room revenue by property, guest profiles, reservation blocks and sales and catering information.
    • Enhance Staff Productivity: OPERA Cloud’s “I want to” panel enables personnel to easily find tasks they need to perform such as assigning a room, canceling a reservation, checking in a guest, or creating an invoice. With OPERA Cloud, all departments from concierge and valet to housekeeping and maintenance, can leverage mobile devices for tasks that will make the guest journey superior.
Contact Info
Valerie Beaudett
+1 650.400.7833
About Oracle Hospitality

Oracle Hospitality offers a range of software, hardware and related services—including a leading portfolio of cloud solutions for hotel and food and beverage operations—designed for the hospitality industry. Oracle Hospitality brings more than 40 years of experience in best-in-class technology solutions that help our customers elevate the guest experience, streamline operations and enhance profitability—all while reducing the cost and complexity of IT. For more information about Oracle Hospitality, visit oracle.com/hospitality.

About Oracle

The Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly-Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database. 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.

Talk to a Press Contact

Valerie Beaudett

  • +1 650.400.7833

Troubleshoot: Database Connectivity On Oracle Cloud (OCI)

Online Apps DBA - Tue, 2019-03-26 02:48

Facing any issues while Connecting to Database on Oracle Cloud? In this Video, with Oracle ACE & Cloud Expert Atul Kumar You’ll learn How To Troubleshoot Connectivity Issues while connecting to Database on Oracle Cloud. Check the Episode 11 of Weekly Video Series at https://k21academy.com/12 & know all about: ✔ How the connectivity to Oracle […]

The post Troubleshoot: Database Connectivity On Oracle Cloud (OCI) appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Getting Started With Git On Oracle Cloud

OTN TechBlog - Mon, 2019-03-25 12:47

The new and improved Oracle Marketplace is now available from within the Oracle Cloud Infrastructure console.  The marketplace contains several applications that developers commonly use in their projects; things like source control, bug tracking and CI/CD applications - with more being added all the time.  The best part about the marketplace is that it gives you the ability to launch instances running these tools with one click.  Let's take a look at how to launch one of these instances using something that nearly every software project uses - source control.  More specifically, the current most popular source control system: Git.

To get started with git, head to your Oracle Cloud console and select Marketplace from the left sidebar menu:

From the Marketplace, select 'GitLab CE Certified by Bitnami':

On the following page, click 'Launch Instance':

Choose the image and compartment, review and accept the terms, then click 'Launch Instance':

The next page should look familiar to you if you have previously launched an instance on Oracle Cloud.  Enter your instance name, choose your options related to the instance shape and make necessary networking selections.  Be sure to upload an SSH key, we'll need it later on.  When you're satisfied, click 'Create':

You'll be taken next to the instance details page while the instance is provisioned.  

While the instance provisions, double check that the subnet you have chosen has the proper security and route table rules to allow the instance to be web accessible.  From the sidebar, select 'Networking' then 'Virtual Cloud Networks':

From the Virtual Cloud Networks landing page, select the VCN you chose when creating the network, then from the following page locate the subnet that you chose.  Here you'll be able to navigate directly to the proper rules that you will need to verify or create:

First verify (or create) a route table rule that targets your internet gateway for all incoming traffic:

Then make sure the security list allows ports 80 and 443 for all incoming traffic (please ensure that this subnet is not associated with any instances that you do not want to expose to the web):

By now your GitLab instance should be fully provisioned.  Head to the instance details page (Compute -> Instances in the left sidebar) and view the details for your GitLab instance.  Take note of the public IP address:

Click on 'Console Connections' in the left menu, then 'Create Console Connection' and populate the dialog with the SSH key you used when creating the instance and click 'Create Console Connection':

Now you should be able to hit your running GitLab administrator via your browser at http://<public ip>:

The default username is 'root'.  To find your initial password, SSH into the instance using the following command:

ssh bitnami@<public ip> -i /path/to/ssh_key

The initial password is stored in a file called 'bitnami_credentials'. To view it:

cat ./bitnami_credentials

Which will look similar to:

Log in and get started working with GitLab on Oracle Cloud!

ACE Program Members Deliver Sessions at Collaborate 2019 in San Antonio

OTN TechBlog - Mon, 2019-03-25 12:46

A small army of experts will present more than 1000 sessions at Collaborate 2019, April 7-11, 2019 in San Antonio, TX, (the home of the historic Alamo). As the list below shows, members of the Oracle ACE Program are well represented among those delivering sessions. Each of the listed session titles links to specific time, date, and location information. That should help as you're putting together your agenda for the event.

Collaborate 2019
April 7-11, 2019
Henry B. González Convention Center
San Antonio, TX USA

Presenter Session Date

Oracle ACE Ahmed Aboulnaga
Ahmed Aboulnaga

Extract Partial Data from ASO Cube of Oracle Planning and Budgeting Cloud in a Readable Format 4/10/2019

Oracle ACE Ahmed Alomari
Ahmed Alomari

Taming the OACore JVM 4/10/2019 Applications Database Tuning Panel 4/8/2019

Oracle ACE Director Biju Thomas
Biju Thomas

Let's talk AI, ML, and DL 4/8/2019 Practical Usage of ORAchk and DBSAT for E-Business Suite Applications 4/9/2019 Eighteen (18) Database New Features you must See (c) 4/11/2019

Oracle ACE Bill Dunham
Bill Dunham

Workshop: EBS Upgrades StreetSmarts: A Guide to Executing Oracle EBS 12.2.x Upgrades 4/7/2019 To Cloud or Not to Cloud: That is the Question! 4/8/2019 OAUG Customizations & Alternatives Special Interest Group 4/9/2019 R12.2 Happy Hour - San Antonio Style! 4/9/2019 Flying Right Through the Clouds: Lifting and Shifting Oracle EBS On-Premise to MS Azure Cloud 4/10/2019 Let the Excitement Continue: Meet the New & Modern 12.2 EBS! 4/11/2019

Oracle ACE Chris Couture
Chris Couture

Developing a Cohesive User Experience 4/9/2019 What's Possible with PeopleSoft Chatbots 4/10/2019

Oracle ACE Director Dan Vlamis
Dan Vlamis

Getting from Answers/Dashboards to Data Visualization 4/9/2019 Smart Targeting Consumers: DX Marketing's Autonomous Data Warehousing Future 4/9/2019 Modern Machine Learning with Oracle Analytics Cloud and Autonomous Data Warehouse Cloud 4/10/2019

Oracle ACE Associate Dayalan Punniyamoorthy
Dayalan Punniyamoorthy

Extract “Partial Data” from ASO Cube of Oracle Planning and Budgeting Cloud in a Readable Format 4/7/2019

Oracle ACE Director Francis Mignault
Francis Mignault

What Every DBA Needs to Know About Oracle Application Express 4/8/2019 Oracle Forms and Oracle Application Express: The Odd Couple 4/10/2019 Worlds Collide! APEX and Digital Assistants Revolutionize Your ERP Applications 4/11/2019

Oracle ACE Associate Fred Denis
Fred Denis

Lessons Learned in Exadata Patching (Including 18c and in the Cloud) 4/8/2019 Must-Have Free Scripts When Working With Exadata / GI / ASM / opatch 4/9/2019

Oracle ACE Ilmar Kerm
Ilmar Kerm

Oracle Database Infrastructure as Code with Ansible 4/8/2019 Implementing Incremental Forever Strategy for Oracle Database Backups 4/9/2019

Oracle ACE Director Martin Klier
Martin Klier

YOUR Machine and MY Database - A Performing Relationship!? (2019 edition 4/10/2019 Oracle Core: Database I/O 4/10/2019

Oracle ACE Michael Barone
Michael Barone

OAUG: E-Business Suite Security SIG -- On-Premise and Cloud Security 4/11/2019

Oracle ACE Michael Messina
Michael Messina

MySQL 8 New Features, Updates and Changes 4/9/2019 MySQL Database Security 4/10/2019 The Oracle Database Security Assessment Tool: Know Your Security Risks 4/10/2019 Oracle Database Sharding - Architecture and Concepts 4/10/2019

Oracle ACE Director Osama Mustafa
Osama Mustafa

Best Practices for Virtualizing Oracle RAC with VMware Cloud on AWS 4/8/2019 Using Python With Oracle Database 4/9/2019

Oracle ACE Roger Cornejo
Roger Cornejo

Scale-Up Your Use of the Advisor Framework 4/8/2019 Using the Dynamic Oracle Performance Analytics Framework 4/10/2019

Oracle ACE Director Susan Behn
Susan Behn

Data Security-Wizarding with EBS Security Wizards 4/7/2019 OAF Personalization’s 2019 - Quick Innovation Wins 4/8/2019 Enforcing Business Rules With Approvals Management (AME) in OM, GL, PO, AP and User Management 4/9/2019 Role Based Access Controls – Side by Side Comparison of EBS and Cloud 4/9/2019 RBAC Training - Automated processes for new users and roles with approval processes in AME 4/10/2019

Oracle ACE Tim Warnet
Tim Warner

Closing the Workforce Management Circle – Using PaaS to Extend SaaS 4/10/2019   Other Events Featuring Oracle ACEs


About the Oracle ACE Program Recognized for their technical expertise, Oracle ACEs contribute knowledge with articles, technical advice, blog posts, presentations, and tweets. Join the community and learn from their insights and experience. Learn more.

Partitioning -- 14 : Converting a non-Partitioned Table to a Partitioned Table

Hemant K Chitale - Mon, 2019-03-25 09:59
Pre-12cRelease2, there were only three methods to convert a non-Partitioned Table to a Partitioned Table

(a) Create a new, empty, Partitioned Table and copy (using INSERT .... AS SELECT ... ) all the data from the non-Partitioned Table to the new, Partitioned Table (and subsequently rename the new Partitioned Table after renaming or dropping the old non-Partitioned Table)

(b) Create a new, empty, Partitioned Table and use EXCHANGE PARTITION to switch the non-Partitioned Table into the Partitioned Table (and then run subsequent SPLIT PARTITION or ADD PARTITION commands as needed to create the additional Partitions)

(c) Create an interim Partitioned Table and use DBMS_REDEFINITION to do an online copy of the data to the interim Partitioned Table and automatically switch the name at the end

12.2 introduced the ability to use ALTER TABLE  ... MODIFY PARTITION ... to convert a non-Partitioned Table to a Partitioned Table

I start with a non-Partitioned Table :

SQL> select table_name, partitioned
2 from user_tables
3 where table_name = 'SALES_DATA_NONPARTITIONED'
4 /

------------------------------ ---

SQL> select index_name, uniqueness, partitioned
2 from user_indexes
3 where table_name = 'SALES_DATA_NONPARTITIONED'
4 /

------------------------------ --------- ---


I then convert it to a Range-Partitioned Table.

SQL> alter table sales_data_nonpartitioned
2 modify
3 partition by range (sale_date)
4 (
5 partition P_2015 values less than (to_date('01-JAN-2016','DD-MON-YYYY')),
6 partition P_2016 values less than (to_date('01-JAN-2017','DD-MON-YYYY')),
7 partition P_2017 values less than (to_date('01-JAN-2018','DD-MON-YYYY')),
8 partition P_2018 values less than (to_date('01-JAN-2019','DD-MON-YYYY')),
9 partition P_2019 values less than (to_date('01-JAN-2020','DD-MON-YYYY')),
10 partition p_MAXVALUE values less than (MAXVALUE)
11 )
12 online
13 update indexes
14 /

Table altered.

SQL> alter table sales_data_nonpartitioned rename to sales_data;

Table altered.

SQL> select partition_name, high_value
2 from user_tab_partitions
3 where table_name = 'SALES_DATA'
4 order by partition_position
5 /

---------------- --------------------------
P_2015 TO_DATE(' 2016-01-01 00:00
P_2016 TO_DATE(' 2017-01-01 00:00
P_2017 TO_DATE(' 2018-01-01 00:00
P_2018 TO_DATE(' 2019-01-01 00:00
P_2019 TO_DATE(' 2020-01-01 00:00

6 rows selected.

SQL> select index_name, partitioned, uniqueness, status
2 from user_indexes
3 where table_name = 'SALES_DATA'
4 /

------------------------------ --- --------- --------


The SALES_DATA_NONPARTITIONED was converted to a Range Partitioned Table.  If I didn't have to rename the table (e.g. if the table name was actually, properly SALES_DATA only), then there would be no need to lock the table as the RENAME command does.

Categories: DBA Blogs

Independant Review of What is Oracle GoldenGate

VitalSoftTech - Mon, 2019-03-25 09:12
Golden Gate in Oracle provides continuous and reliable access to real time routing, capturing, transforming and delivering of transactional data.
Categories: DBA Blogs

Your Invitation to Meet the EBS Applications Technology Product Management Team at Collaborate 2019

Steven Chan - Mon, 2019-03-25 08:20

You are cordially invited to join the Oracle E-Business Suite Applications Technology Product Management Team for informal discussions (and refreshments) at Collaborate 2019. This special meet and greet is not part of the regular conference routine, and offers you a chance to have a short break from the schedule to talk to us on a one-to-one basis.

EBS Applications Technology Product Management Team at Collaborate 2019

This meet and greet offers a unique opportunity for you to sit down and chat with Oracle Product Management experts about the latest EBS technology and features that you may be using or intend to use. We would love the opportunity to discuss with you your upcoming projects, or answer your questions regarding such topics as integration, cloning, online patching, performance, security, advanced architectures, upgrades, and migrations to Oracle Cloud infrastructure.

About the Conference

Collaborate 2019 offers an excellent opportunity for you to attend sessions and talk with various members of the Oracle team to get latest information about new features with Oracle E-Business Suite technology. This year's conference will be held at the Henry B. González Convention Center in San Antonio, Texas April 7 to 11, 2019.  For a complete listing of all educational sessions and other activities, please visit the OAUG Collaborate website.

Related Conference Material Related Articles
Categories: APPS Blogs

Adding an item to the Ubuntu Unity Launcher

The Anti-Kyte - Sun, 2019-03-24 17:20

I would begin this post by saying something pithy about the latest Brexit crisis gripping the nation. However, watching any news or current affairs program at the moment leaves me feeling rather like this :

Fortunately, I had a new version of SQLDeveloper to install on my Ubuntu 16.04 laptop to take my mind off things.
After installing the software, I forgot – as I almost always do – how to add a new item to the Unity Launcher, so I thought I’d write down the steps this time.

Unity is similar to Gnome, KDE and – as it turns out – XFCE in that it seems to follow the freedesktop.org Desktop Entry Specification.
So, all I need to do is :

  • create a .desktop file in a suitable location to tell Unity how to run SQLDeveloper
  • add it to the Unity Launcher
Creating the desktop file

The desktop files in this Ubuntu version are in /usr/share/applications so…

sudo nano /usr/share/applications/sqldeveloper184.desktop

The file itself, looks like this

[Desktop Entry]
Name=SQLDeveloper 18.4

It’s probably worth briefly covering some of the entries in the file…

In Unity, the Name is the string which appears in the tooltip on the Launcher.
Exec is the fully qualified path of the command to run for this menu item.
Type is mandatory and must be one of Application, Link, or Directory.
Categories are optional but may be relevant if you are using a desktop which offers access to applications via a menu.

Now we’ve created the file, we need to add it to the Launcher.

In Unity, the Name is the string which appears in the tooltip on the Launcher.
Exec is the fully qualified path of the command to run for this menu item.
Type is mandatory and must be one of Application, Link, or Directory.
Categories are optional but may be relevant if you are using a desktop which offers access to applications via a menu.

Now we’ve created the file, we need to add it to the Launcher.

Adding the application to the launcher

The easiest way to do this, is to simply open the directory where the file is located in the File Manager…

nautilus /usr/share/applications

Sorting the files by Modified date (latest first), I can easily find my new file :

Then, I just need to drag it over to the Launcher…

Useful Links

As is so often the case, this sort of thing is easy when you know how…or when someone is kind enough to tell you. So…

Playing with ACFS

Michael Dinh - Sun, 2019-03-24 11:50

Kernel version is 4.1.12-94.3.9.el7uek.x86_64 vs ACFS-9325: Driver OS kernel version = 4.1.12-32.el7uek.x86_64 because kernel was upgraded and ACFS has not been reconfigured after kernel upgrade.

[root@racnode-dc1-1 ~]# uname -r

[root@racnode-dc1-1 ~]# lsmod | grep oracle
oracleacfs           3719168  2
oracleadvm            606208  7
oracleoks             516096  2 oracleacfs,oracleadvm
oracleasm              57344  1

[root@racnode-dc1-1 ~]# modinfo oracleoks
filename:       /lib/modules/4.1.12-94.3.9.el7uek.x86_64/weak-updates/usm/oracleoks.ko
author:         Oracle Corporation
license:        Proprietary
srcversion:     3B8116031A3907D0FFFC8E1
vermagic:       4.1.12-32.el7uek.x86_64 SMP mod_unload modversions
signer:         Oracle Linux Kernel Module Signing Key
sig_key:        2B:B3:52:41:29:69:A3:65:3F:0E:B6:02:17:63:40:8E:BB:9B:B5:AB
sig_hashalgo:   sha512

[root@racnode-dc1-1 ~]# acfsdriverstate version
ACFS-9325:     Driver OS kernel version = 4.1.12-32.el7uek.x86_64(x86_64).
ACFS-9326:     Driver Oracle version = 181010.

[root@racnode-dc1-1 ~]# acfsdriverstate installed
ACFS-9203: true

[root@racnode-dc1-1 ~]# acfsdriverstate supported
ACFS-9200: Supported

[root@racnode-dc1-1 ~]# acfsroot version_check
ACFS-9316: Valid ADVM/ACFS distribution media detected at: '/u01/app/'

[root@racnode-dc1-1 ~]# crsctl query crs activeversion
Oracle Clusterware active version on the cluster is []

[root@racnode-dc1-1 ~]# acfsutil registry
Mount Object:
  Device: /dev/asm/acfs_vol-256
  Mount Point: /ggdata02
  Disk Group: DATA
  Volume: ACFS_VOL
  Options: none
  Nodes: all
[root@racnode-dc1-1 ~]#
Gather ACFS Volume Info:

[oracle@racnode-dc1-1 ~]$ asmcmd volinfo –all

Diskgroup Name: DATA

         Volume Name: ACFS_VOL
         Volume Device: /dev/asm/acfs_vol-256
         State: ENABLED
         Size (MB): 10240
         Resize Unit (MB): 512
         Redundancy: UNPROT
         Stripe Columns: 8
         Stripe Width (K): 1024
         Usage: ACFS
         Mountpath: /ggdata02
Gather ACFS info using resource name:

[oracle@racnode-dc1-1 ~]$ crsctl stat res ora.drivers.acfs -init

STATE=ONLINE on racnode-dc1-1

From (asmcmd volinfo –all): Diskgroup Name: DATA 

[oracle@racnode-dc1-1 ~]$ crsctl stat res ora.DATA.dg -t

Name           Target  State        Server                   State details
Local Resources
               ONLINE  ONLINE       racnode-dc1-1            STABLE
               ONLINE  ONLINE       racnode-dc1-2            STABLE

From (asmcmd volinfo –all): Diskgroup Name: DATA and Volume Name: ACFS_VOL

[oracle@racnode-dc1-1 ~]$ crsctl stat res ora.DATA.ACFS_VOL.advm -t

Name           Target  State        Server                   State details
Local Resources
               ONLINE  ONLINE       racnode-dc1-1            Volume device /dev/asm/acfs_vol-256 
                                                             is online,STABLE
               ONLINE  ONLINE       racnode-dc1-2            Volume device /dev/asm/acfs_vol-256 
                                                             is online,STABLE

[oracle@racnode-dc1-1 ~]$ crsctl stat res ora.DATA.ACFS_VOL.acfs -t

Name           Target  State        Server                   State details
Local Resources
               ONLINE  ONLINE       racnode-dc1-1            mounted on /ggdata02,STABLE
               ONLINE  ONLINE       racnode-dc1-2            mounted on /ggdata02,STABLE
Gather ACFS info using resource type:

[oracle@racnode-dc1-1 ~]$ crsctl stat res -t -w ‘TYPE = ora.volume.type’

Name           Target  State        Server                   State details
Local Resources
               ONLINE  ONLINE       racnode-dc1-1            Volume device /dev/asm/acfs_vol-256 
			                                                 is online,STABLE
               ONLINE  ONLINE       racnode-dc1-2            Volume device /dev/asm/acfs_vol-256 
			                                                 is online,STABLE

[oracle@racnode-dc1-1 ~]$ crsctl stat res -t -w ‘TYPE = ora.acfs.type’

Name           Target  State        Server                   State details
Local Resources
               ONLINE  ONLINE       racnode-dc1-1            mounted on /ggdata02,STABLE
               ONLINE  ONLINE       racnode-dc1-2            mounted on /ggdata02,STABLE

[oracle@racnode-dc1-1 ~]$ crsctl stat res -t -w ‘TYPE = ora.diskgroup.type’

Name Target State Server State details
Local Resources

Python Practice Produced Pretty Pictures

Bobby Durrett's DBA Blog - Sat, 2019-03-23 18:57

I wrote a Python program that made some fun pictures so I thought I would share them even though this is not really a database post.

I practice Python programming by doing Rosetta Code programming tasks that no one has implemented in Python. This is a fun way of keeping up my Python skills. My most recent contribution made pretty pictures so I thought I would show them here. The code takes a cube and breaks up the faces into smaller and smaller pieces that change the cube into a rounder shape.

Here is the input:

Input to the program, a cube

Here is the output after one subdivision:

After one subdivision. Chunky.

Here is the output after two subdivisions:

Two subdivisions. Pretty round.

Note that it is getting rounder. Lastly, after four subdivisions it is remarkably round considering that it started as a cube:

Four subdivisions. Quite round.

The main point of this post was to show the pretty pictures. But, to be more serious, if someone is reading this blog and looking for a programming task to do for practice you can do what I do and find a Rosetta Code task for the language you are learning and you can get some good practice.


Categories: DBA Blogs

Microsoft Azure: Adding user requires more work as expected

Dietrich Schroff - Sat, 2019-03-23 02:49
Just to try some things in Microsoft Azure i wanted to add an additional user to my test account. But this was not so easy:

Go to "Azure Active Directory" and "Users":


 But then:

I thought this is not really a problem, because openesb.eu is my domain, so let's try to verify this one:

The problem is, that i am not able to change this settings. So i tried, if i am lucky, but:
So only way to add users in such a minimal setup, is to add accounts from live.com etc..


Subscribe to Oracle FAQ aggregator