Feed aggregator

New workshop "Exadata For Developers"

Randolf Geist - Wed, 2017-05-31 15:00
Just a short note that I've developed a new two day course that covers all relevant features that a database application developer should know when dealing with the Oracle Exadata Database Machine platform.

It covers in detail Smart Scans, the Exadata Flash Cache, Hybrid Columnar Compression and all surrounding features like Storage Indexes, (serial) direct path reads etc. etc.. Of course it also includes features that were added in 12c, like Attribute Clustering and Zone Maps.

All features are presented with live demo scripts, and there will be enough time to discuss your specific questions and analyse existing applications if desired.

For more information and details, check the corresponding pages:

German: Exadata für Anwendungsentwickler

English: Exadata For Developers

OHUG 2017 - What Looks Good To Me

Floyd Teter - Wed, 2017-05-31 14:01
So I’m headed to the OHUG 2017 conference next week.  As it is one of the few conferences I attend anymore, I’m pretty excited about going.  I’m particularly interested in information related to the implementation of Oracle HCM Cloud.  So, in  preparation for the conference, I thought I’d share some events and sessions that look good to me.

First, a few caveats about the following list.   I’m presenting twice myself, so I’m breaking my sessions out as a blatant plug rather than including them on the list:
  • Oracle Human Capital Management Cloud User Experience Extensibility: From Mystery To Magic, Wednesday, 1:45 pm, Salon 1
  • An Update: The Oracle HCM Cloud Solution Library, Friday, 10:15 am, Salon 8
It's worth stating here that, although I'm an Oracle employee, the opinions here and mine and mine alone - this should not be interpreted in any way as official Oracle information or direction.  Nor am I speaking for OHUG in any way.  In addition, keep in mind that I’m focused on Oracle HCM Cloud Applications.  OHUG tracks cover HCM Cloud, PeopleSoft, and E-Business.  As I make my living these days by working on HCM Cloud Applications, I can’t render any opinions on PeopleSoft or EBS sessions…so you will only see HCM Cloud entries on my list.  Also keep in mind that I won’t list SIG sessions:  you know better than I the SIGs you should attend.  But I will say that the SIG sessions are often the best part of a user conference…be sure you don’t miss out.  And finally, some of the sessions I list will have schedule conflicts with other sessions I list.  But that’s an indicator of a great conference…making difficult choices about where to burn your calories. 
 
So, with all that said, let’s get to the list.  Sessions are listed in no particular order.  And, for the presenters that did not make this list…it’s not that your presentation did not look interesting (almost all of the sessions have something that I’d love to check out), it’s just that I’m digging into other subject areas this year and my own focus had definitely driven this list.

Digital HR Transformation  First and Foremost Managing The Challenge of Change
Tuesday
4:45 pm
Salon 12
Product Vision and Roadmap:  Oracle HCM Cloud
Tuesday
3:30 pm
Ballroom
The Current State of Human Capital Management
Tuesday
1:30 pm
Executive Ballroom
User Experience: Best Practices to Ensure a Positive Experience for Candidates and Users
Wednesday
9:00 am
Salon 15

Oracle HCM Cloud Leading Practice - Cloud Rapid Start Implementation with Tools
Wednesday
10:30 am
Salon 12
Meet The Experts:  HCM Cloud Center of Excellence
Wednesday
3:15 pm
Salon 19
How To Get The Best Out of OTBI
Thursday
9:00 am
Salon 12
Cloud Global Deployments - Leading Practices and Things That Make You Go Hmmm
Thursday
11:00 am
Salon 3
Cloud Payroll:  What You Don’t Know Could Hurt You or At Least Your Project
Thursday
2:30 pm
Salon 3
Adopting A Testing Strategy Fit For The Latest Oracle HCM Cloud
Friday
11:30 am
Salon 3
HCM Cloud Extracts Made Easy!
Wednesday
3:15 pm
Salon 9
Decision Is Made:  Going To HCM Cloud. Now, What’s The Best Strategy For Data Conversion?
Friday
10:15 am
Salon 13
Patching - Where’s The Beef?
Thursday
9:00 am
Salon 4

Best Practices in Attracting Top Talent Through Oracle Taleo Cloud Suite
Thursday
9:00 am
Salon 2
Cloud Portal:  Self-Service Management For The HCM Cloud
Wednesday
9:00 am
Salon 3

Note that this information is current as of May 31st.  Dates, times and locations could change at anytime leading up to or during the conference.  Your best bet for staying current is the OHUG application for your phone.

In addition to the sessions, there are a few conference events you may want to consider:
  • Meet The Experts:  a place to meet and chat with the people who build and deliver Oracle HCM products.  Watch the schedule for the times and locations of those you’d care to meet.  I have listed one Meet The Experts session in the above list - the session for the HCM Cloud Center of Excellence.  Oracle’s John Cafolla will be the expert at this particular session.  John has his fingers on the pulse of HCM Cloud implementations around the globe.  If you want to talk implementation, John is your guy.  You can find the full schedule for Meet The Experts here.
  • Report Jam:  Oracle’s Julian Challenger conducts a series of pretty cool workshops focused on building reports using OTBI.  If you have reports you’d like to build or report-related questions, you’ll get a hands-on opportunity to collaborate with Oracle’s best OTBI gurus here.  Sign up for a time slot in advance at the Empire foyer.
  • Usability Lab: you’ll have the opportunity to see and provide feedback on HCM-related features and applications still in development.  Great for getting a sneak peek and influencing future direction of Oracle products.  The Lab only happens on Wednesday and requires signing up in advance by sending an email to jeannette.chadwick@oracle.com.
  • Oracle Support Central:  Bring your toughest HCM-related questions here. Whether it’s HR, Payroll, Benefits, Compensation, Taleo or whatever, this is the place to get answers.

Let’s wrap this up with an invitation from me to you:  if you’d like to get together with me at the conference to talk or ask questions about anything related to HCM Cloud (or if you’d just like to hang out), hit me up on Twitter @fteter.  I'm happy to talk to customers, partners, old friends and potential new friends.  Hope to see you there! 

DevOps and the Agile DBA

Gerger Consulting - Wed, 2017-05-31 13:38
The esteemed ACE Director alumna Kellyn Pot'Vin Gorman is hosting our next webinar!

Attend the free webinar by Kellyn on June 13th and learn how agile best practices and virtualization can help you become better at DevOps.


About the Webinar:
This session discusses common database challenges and how they can be solved with newer DevOps practices without impacting the DBAs “safe zone”.

Development, testing, provisioning, patching, upgrading and managing will become easier with agile tools, virtualization and collaboration.

The take-aways from this session are to embrace DevOps basics with a “DBA twist” such as:
  • Develop, Rinse, Repeat
  • Test Until Your Five Year Old Can Do It
  • Human Intervention Creates Human Error- Automate EVERYTHING.
  • How the shorter development cycle build business success.
  • How the DBA can do more with less.
Discover the power of virtualization and agile development practices providing more value to even the most senior database expert.

We’ll demo different scenarios surrounding DevOps, virtualization and how to make the DBA pivotal to DevOps success.

Sign up for the free webinar.

About the Presenter:



Kellyn Pot’Vin-Gorman is a member of the Oak Table Network and an Oracle ACE Director alumna. She is the Technical Intelligence Manager for the Office of CTO at Delphix, a company recognized for it's impressive virtualization and data masking environment capabilities. Kellyn is known for her extensive work with multi-database platforms, cloud migrations, virtualization, the command line interface, environment optimization tuning, automation and architecture design. Her blog, http://dbakevlar.com and social media activity under her handle, DBAKevlar is well respected for her insight and content.

Registration is free but space is limited.
Sign up now.
Categories: Development

Packages, roles, compilation and invoker rights and package privileges.

Tom Kyte - Wed, 2017-05-31 13:26
Hi I have need to select from tables in another schema (B). I am connected to schema (A) by using proxy account. Privileges have been given to me through roles and I can select tables from schema B with sqlplus. There is package in schema...
Categories: DBA Blogs

PL/SQL update set row command and virtual columns

Tom Kyte - Wed, 2017-05-31 13:26
Hi I have found PL/SQL 'update tablex set row' command very useful in some cases. (And special thanks to asktom.com to teaching me it !). However I now would like to add virtual columns to table to be updated. My trial caused error of 'trying...
Categories: DBA Blogs

Find number and date which break the rule

Tom Kyte - Wed, 2017-05-31 13:26
Dear Chris, I have table like this <code>Account_number Opening_date 1234 16/05/2017 1235 16/05/2017 1236 23/04/2017 1237 25/04/2017 1238 25/04/2...
Categories: DBA Blogs

Need to load the data into pl/sql tables from excel file

Tom Kyte - Wed, 2017-05-31 13:26
Hello Experts, I have a below code from where I want to convert .xls file to .csv file and load the data into pl/sql tables but I am not able to perform it. Could you please help to get this done? Code: CREATE OR REPLACE FUNCTION LOAD_CSV...
Categories: DBA Blogs

DB Link: ALTER SESSION ENABLE PARALLEL DML

Tom Kyte - Wed, 2017-05-31 13:26
Hi Chris/Connonr, We have two databases namely Primary & Secondary. On Primary, There is scheduled Job which select data from Primary and Insert it into Secondary then inserted records gets delete from Primary. here are the steps written in ...
Categories: DBA Blogs

Session Maximum Time Exceeded

Tom Kyte - Wed, 2017-05-31 13:26
Hello I have problem with Session Maximum Time Exceeded. Users are usually 13 hours strait in the app. But sessions are cleared in 12 hours. How can i increase or disable it at all? Best requires Kristjan
Categories: DBA Blogs

Enabling an EBS Global Diagnostics Trace

Steven Chan - Wed, 2017-05-31 12:23

Oracle E-Business Suite provides several types of logs.  One of the tools you can use is the Logging Framework, which allows you to collect and view log messages in Oracle Applications Manager.  The Logging Framework collects debug messages, errors, and alerts.

A Global Diagnostics Trace can help you diagnose issues if errors occur when users click a button or select an option. It's a targeted trace that can be run per user, thereby minimizing the impact on the overall performance of your environment. This kind of trace is also known as an FND Diagnostics Trace or Oracle Applications Logging.

You can find a quick summary of steps to enable a Global Diagnostics trace here:

There's lots more information about more-powerful logging options in the following manuals

Related Articles

Categories: APPS Blogs

DIY Home Center Sets Foundation for Growth and Customer Experience Innovation with NetSuite Unified Cloud Commerce Platform

Oracle Press Releases - Wed, 2017-05-31 10:55
Press Release
DIY Home Center Sets Foundation for Growth and Customer Experience Innovation with NetSuite Unified Cloud Commerce Platform Online home improvement distributor sees 16% increase in conversion rate and 6% increase in average order value with new commerce platform

SAN MATEO, Calif.—May 31, 2017

Oracle NetSuite Global Business Unit, one of the world’s leading providers of cloud-based financials / ERP, HR, Professional Services Automation (PSA) and omnichannel commerce software suites, today announced that DIY Home Center, an online distributor of decking products and outdoor furniture, has implemented NetSuite’s unified cloud commerce platform to power its B2C and B2B ecommerce, inventory and order management, CRM and ERP.

Servicing homeowners and professional builders, DIY Home Center has experienced double-digit year over year growth since it launched online in 2004. However, its siloed, legacy systems and applications, including Dynacomp’s MOM, QuickBooks and home-grown product information management (PIM) system and ecommerce website, could no longer support its growth. The company was wasting resources making the technology work together, instead of focusing innovating the customer experience and growing the business.

“We had a lightbulb moment when we realized we could have everything on one unified suite without the hairball of disconnected systems to manage,” said Michael Anderson, President at DIY Home Center. “Now, with a modern ecommerce platform natively part of the solution, we can provide a more visual, intuitive shopping experience.”

DIY Home Center first focused on getting its technology foundation in place. It went live on NetSuite in June 2016 to power its back-end applications, including order and inventory management, CRM and ERP. By consolidating fragmented data into a single source of customer, order and product information, the company was able to make informed, timely business decisions and provide more engaging, relevant customer experiences. The launch of its new ecommerce site powered by SuiteCommerce Advanced followed in November and quickly led to the following results:

  • 6 percent increase in average order value.
  • 16 percent increase in conversion rates.
  • 15 percent increase in average time spent on site.

The new webstore, designed by NetSuite Commerce Agency Partner, Intente, provides a modern and engaging experience. Prior to the new site, only a desktop experience was supported. Now, with a responsive design website, 50 percent of the company’s site visitors are using mobile devices.  

To further enrich the online experience and drive engagement, DIY Home Center showcases a wealth of educational product content and improvement tips on its product pages, ranging from videos, blogs and tutorials.

To support its B2B buyers, DIY Home Center developed a Preferred Builder Program. Builders get the same rich online experience that individual shoppers get, but in addition, receive product discounts and enhanced account management capabilities to view invoices, make payments, review past orders and easily reorder products. With these account management activities now online, the company sales reps can focus on offering value-add services to their accounts and building brand loyalty.

DIY Home Center has also gained these other benefits with NetSuite’s unified cloud commerce platform:

  • Single source of product information. As an omnichannel retailer selling on marketplaces including Amazon, eBay and Walmart.com, DIY Home Center uses its product data from NetSuite to publish to these marketplaces, delivering consistent, high quality data.
  • Real-time inventory management. DIY Home Center is benefiting from just-in-time ordering. NetSuite SuiteCloud Developer Network partner PaceJet has helped streamline the pick, pack and ship process.
  • Optimized order management. With centralized order management for orders from all channels, DIY Home Center is able to quickly and efficiently process orders. What used to take sales reps four hours to process, now takes less than 30 minutes.
  • Unified cloud platform. Moving to the cloud has saved on IT costs and removed the hassles of having to manage systems and software. DIY Home Center also benefits from a platform that allows for easy customizations and integrations. The cloud platform provides the scalability and adaptability needed to keep pace with business, especially during the peak summer months.

“NetSuite is the heartbeat of our company,” said Anderson. “Everything starts and ends with it. If we’re looking to add another system our first requirement is that it must connect with NetSuite.”

Experience NetSuite at IRCE 2017

NetSuite is empowering DIY Home Center to transform its business. Merchants attending IRCE 2017 from June 6-9 at McCormick Place in Chicago will have the opportunity to see firsthand how NetSuite’s unified cloud commerce platform is enabling B2C and B2B businesses to provide customers with a seamless shopping experience as well as optimize business operations. To learn more and schedule a personal demo at NetSuite’s booth #701 please visit www.netsuite-irce.com.

About Oracle NetSuite Global Business Unit

Oracle NetSuite Global Business Unit pioneered the Cloud Computing revolution in 1998, establishing the world's first company dedicated to delivering business applications over the internet. Today, Oracle NetSuite Global Business Unit provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit http://www.netsuite.com.

Follow Oracle NetSuite Global Business Unit’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

Contact Info
Christine Allen
Public Relations, Oracle NetSuite Global Business Unit
603-743-4534
PR@netsuite.com
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

Trademarks

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

Christine Allen

  • 603-743-4534

Soccer Express Scales Omnichannel Business with NetSuite Unified Cloud Commerce Platform

Oracle Press Releases - Wed, 2017-05-31 10:55
Press Release
Soccer Express Scales Omnichannel Business with NetSuite Unified Cloud Commerce Platform Canada’s largest soccer store delivers personalized, digital-first shopping experiences

SAN MATEO, Calif.—May 31, 2017

Oracle NetSuite Global Business Unit, one of the world’s leading providers of cloud-based financials / ERP, HR, Professional Services Automation (PSA) and omnichannel commerce software suites, today announced that Soccer Express, Canada’s largest distributor and retailer of soccer equipment and apparel, has implemented NetSuite’s unified cloud commerce platform to run its omnichannel sales spanning ecommerce and in- store point of sale (POS) across four stores, inventory management, order management and ERP. As a result of the implementation, Soccer Express has increased revenue by 25 percent.

Founded in Coquitlam, British Columbia in 1998, Soccer Express offers merchandise from global brands including Nike, Adidas and Puma. As the company experienced 30 percent year over year growth rates, Soccer Express realized its siloed, legacy Sage and Adobe systems could no longer support its business. The company required a scalable, flexible solution to manage the business and support its ecommerce expansion.

“Adopting a single solution that seamlessly unifies ecommerce with back-end business systems has given us the ability to scale and improve processes,” said Andrew Veer, Chief Operating Officer of Soccer Express. “By removing the burden of manual tasks, we’ve been able to take two employees previously dedicated to order entry and invoicing and move them to roles focused on better supporting our customers.”

Since going live with NetSuite in May, 2016, the customer experience has dramatically evolved.  All customer information is captured in a single repository, providing a 360-degree view of all customer activity, including purchases, returns, exchanges, store visits and marketing campaigns. This allows customer service representatives to provide better service and information to customers. Similarly, when shoppers are in a Soccer Express retail store, sales associates can access the same information with NetSuite POS, which provides shoppers with a seamless experience across all sales channels.

The new website, running on SuiteCommerce Advanced, provides a fresh and engaging shopping experience, including the ability to customize merchandise with names and numbers as well as display tier quantity pricing based on volume. With its target audience of 13- to 24-year-olds, it was also critical for Soccer Express to support and optimize the mobile experience. Now, with a responsive design website, the company has seen a 24 percent growth in mobile users and 30 percent increase in sales.

The website caters to individual soccer enthusiasts as well as soccer clubs by offering customized, private club stores. Each club store has its own unique merchandise, pricing, and real-time inventory availability. Because club purchasing happens at the start of the season, it was critical for Soccer Express to have a platform that could scale to meet the traffic and order management spikes.

“We support more than 150 soccer clubs across Canada and we wanted our customers to feel like they were shopping on a local online store,” said Veer. “We now have a platform that can meet the demands of our business.”

With NetSuite’s unified cloud commerce platform, Soccer Express has gained the following benefits:

  • Optimized inventory management. With two distribution centers and four retail stores, Soccer Express has real-time insight into inventory across its entire enterprise. It can utilize inventory from across its stores to fulfill ecommerce orders as well as ship direct from suppliers.
  • Efficient order management. With a centralized order management system for orders from all channels, Soccer Express can process orders faster, satisfy customers and lower operational costs. Orders that used to take six days to ship now go out in 24 hours or less.
  • Improved communication. Customers receive updates on every stage of their order from processing to shipping and delivery. Customer service is now standardized and employees across the company have access to all order information to help improve the customer experience.
  • Unified cloud platform. Replacing Sage for its ERP and Adobe for ecommerce with a single cloud solution, Soccer Express has removed the hassles of having to manage upgrades, servers and dealing with version lock issues. The company gets automatic product updates and a platform that allows for easy customizations and integrations.

Experience NetSuite at IRCE 2017

NetSuite is empowering Soccer Express to transform its business. Merchants attending IRCE 2017 from June 6-9 at McCormick Place in Chicago will have the opportunity to see firsthand how NetSuite’s unified cloud commerce platform is enabling B2C and B2B businesses to provide customers with a seamless shopping experience as well as optimize business operations. To learn more and schedule a personal demo at NetSuite’s booth #701 please visit www.netsuite-irce.com.

About Oracle NetSuite Global Business Unit

Oracle NetSuite Global Business Unit pioneered the Cloud Computing revolution in 1998, establishing the world's first company dedicated to delivering business applications over the internet. Today, Oracle NetSuite Global Business Unit provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit http://www.netsuite.com.

Follow Oracle NetSuite Global Business Unit’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

Contact Info
Christine Allen
Public Relations, Oracle NetSuite Global Business Unit
603-743-4534
PR@netsuite.com
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

Trademarks

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

Christine Allen

  • 603-743-4534

ORA-12154 in Data Guard environment

Amardeep Sidhu - Wed, 2017-05-31 10:54

Hit this silly issue in one of the data guard environments today. Primary is a 2 node RAC running 11.2.0.4 and standby is also a 2 node RAC. Archive logs from node2 aren’t shipping and the error being reported is

ORA-12154: TNS:could not resolve the connect identifier specified

We tried usual things like going to $TNS_ADMIN, checking the entry in tnsnames.ora and then also trying to connect using sqlplus sys@target as sysdba. Everything seemed to be good but logs were not shipping and the same problem was being reported repeatedly. As everything on node1 was working fine so it looked even more weird.

From the error it is clear that the issue is with tnsnames entry. Finally found the issue after some 30 mins. It was an Oracle EBS environment so the TNS_ADMIN was set to the standard $ORACLE_HOME/network/admin/*hostname* path (on both the nodes). On node1 there was no tnsnames.ora file in $ORACLE_HOME/network/admin so it was connecting to the standby using the Apps tnsnames.ora which was having the correct entry for standby. On node2 there was a file called tnsnames.ora in $ORACLE_HOME/network/admin but it was not having any entry for standby. It was trying to connect using that file (the default tns path) and failing with ORA-12154. Once we removed that file, it started using the Apps tnsnames.ora and logs started shipping.

Categories: BI & Warehousing

Look Who's Talking: Creating a Great Chatbot User Experience

OTN TechBlog - Wed, 2017-05-31 10:16

Chatbots represent an enormous opportunity for developers. But while aspects of chatbot development will be quite familiar, there are key differences that will require a shift in thinking, according to Joe Huang, product manager for Oracle's Mobile and Bot platforms.

"Traditionally, when we talk about application development, you're thinking about how to design the user interface, how to make the application easier to use," Joe says. "With chatbots, it's both different and also the same. It's the same in that you want to give the best conversational experiences for the end-user to be able to very quickly complete their operation, to find what they need to do through a chat interface. But it's also very different in that thinking about building a good experience changes from building a beautiful user interface to designing a conversation."

Want more of Joe's insight into chatbot development? Watch this interview recorded at Oracle Code Washington DC. And for a deeper dive, you can watch the video recordings of Joe's Oracle Code sessions:

Additional Resources

 

How to get Difference between AVG of two groups with windowing function(current group Avg - Previous group Avg)

Tom Kyte - Tue, 2017-05-30 19:06
Hello Tom, I am using following code to get average of group data partition by group id. I am getting correct values for current group with following code. I am using Oracle 12.1.0.2.0 I want difference in average of current group(partitio...
Categories: DBA Blogs

Remove History from Flash Back Archive

Tom Kyte - Tue, 2017-05-30 19:06
Hi Tom, I have a requirement to update/Delete(permanent) the archived(Data deleted. But present in flashback archive) data. Can we update/delete(permanently) a record/set of records present in flashback archive?
Categories: DBA Blogs

Automating Processes With Application Builder and Process Cloud Services

Shay Shmeltzer - Tue, 2017-05-30 18:33

Oracle Application Builder Cloud Service (ABCS) gives you a great way to build apps that track data, but what if your data is also involved in processes? What if you need to automate not just the data collection but also the human workflow interactions? The new integration between Oracle ABCS and Oracle Process Cloud Service (PCS) enables you to achieve this easily.

You can now create processes that are associated with ABCS business objects and interact with them directly from your Oracle ABCS user interfaces. This is a two way interaction patterns, where PCS processes can access information from Oracle ABCS business objects, and ABCS user interfaces can be created on top of these PCS processes to initiate and progress processes.

PCS integration in ABCS

In the video example below I'm developing a basic approval flow for travel requests. The video will show you how the integration works covering:

  • Associating a process with a business object
  • Accessing the business object values from your process
  • Setting security and connection between PCS and ABCS
  • Initiating PCS processes from an ABCS page
  • Creating custom to-do list pages in ABCS to show you your tasks
  • Creating custom task details pages in ABCS to progress tasks

As you'll see, all of these are quite simple and completely declarative to achieve with the visual development approach.

The combination of the products provide great value to the users of each one of those. PCS customers will love the ability to persist the data they use in their processes, and the ability to design even richer interfaces and reports. ABCS users will love the ability to automate and manage long running complex processes. 

 

 

 

Categories: Development

Webcast: "E-Business Suite 12.2 Upgrade Best Practices to Minimize Downtime"

Steven Chan - Tue, 2017-05-30 12:56

Oracle University has a large selection of free recorded webcasts for Oracle E-Business Suite.  If you're planning to upgrade to EBS 12.2, the following webcast is worth your time:

This session is ideal for organizations thinking about upgrading to Oracle E-Business Suite 12.2. Samer Barakat, Director Application Performance, covers best practices and performance optimizations to minimize 12.2 upgrade downtime. This material was presented at Oracle OpenWorld 2015.

Related Articles

Categories: APPS Blogs

Upgrade Existing TDE to Use New Unified Key Management in 12c Upgraded Database (non-cdb)

Pythian Group - Tue, 2017-05-30 10:04

I’m really excited to be writing this post and I’m hoping it serves as helpful content. When reviewing the new unified key management in RDMS 12c, I came across old commands like ‘ALTER SYSTEM’ to manage the TDE keys that are still supported.  As a proof, I didn’t see any pre-reqs that exists on TDE part in the following upgrade related MOS note.

Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1) (Doc ID 1503653.1)

I had a test database which was running on RDBMS 11.2.0.4 version along with TDE configured (segments located in dedicated tablespace created with encryption clause). I upgraded this database into version 12.1.0.2  without any issues using the above note. No issues were found while accessing the encrypted segments using the old keys with autologin option existing on the “/etc/oracle/WALLETS/Test/” location on the server.

I wanted to use the new unified key management on this upgraded database. I checked MOS and surprisingly, no direct notes to fulfill this purpose. After doing multiple tests, I was able to get this method working.

1. First, I copied my existing keys into “/home/oracle/keys” location as a backup. I confirmed my existing TDE keys work fine.

SQL> select count(1) from test.tstbl;

COUNT(1)
———-
261440

2. I brought down my database and removed the keys from “/etc/oracle/WALLETS/Test/” location. I then started the database instance and created the dummy keystore using the new syntax.

SQL> startup
ORACLE instance started.

Total System Global Area 524288000 bytes
Fixed Size 2926320 bytes
Variable Size 197134608 bytes
Database Buffers 318767104 bytes
Redo Buffers 5459968 bytes
Database mounted.
Database opened.
SQL> select * from v$encryption_wallet;

WRL_TYPE
——————–
WRL_PARAMETER
——————————————————————————–
STATUS WALLET_TYPE WALLET_OR FULLY_BAC
—————————— ——————– ——— ———
CON_ID
———-
FILE
/etc/oracle/WALLETS/Test/
NOT_AVAILABLE UNKNOWN SINGLE UNDEFINED
0
SQL> select key_id,activation_time from v$encryption_keys;

no rows selected

SQL> ADMINISTER KEY MANAGEMENT CREATE KEYSTORE ‘/etc/oracle/WALLETS/Test’ IDENTIFIED BY “<keystore_password>”;

keystore altered.

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY “<keystore_password>”;

keystore altered.

SQL> select key_id,activation_time from v$encryption_keys;

no rows selected

SQL> select * from v$encryption_wallet;

WRL_TYPE
——————–
WRL_PARAMETER
——————————————————————————–
STATUS WALLET_TYPE WALLET_OR FULLY_BAC
—————————— ——————– ——— ———
CON_ID
———-
FILE
/etc/oracle/WALLETS/Test/
OPEN_NO_MASTER_KEY PASSWORD SINGLE UNDEFINED
0

3. Next, I imported the keys from the files copied as per MOS note 2254960.1, but still I saw the same “OPEN_NO_MASTER_KEY” status on the data dictionary.

How to Merge a TDE Wallet From 11gR2 Into a New 12c Database Keystore? (Doc ID 2254960.1)

SQL> ADMINISTER KEY MANAGEMENT MERGE KEYSTORE ‘/home/oracle/keys’ IDENTIFIED BY “<11g_wallet_password>” INTO EXISTING KEYSTORE ‘/etc/oracle/WALLETS/Test’ IDENTIFIED BY “<keystore_password>” WITH BACKUP;

keystore altered.

SQL> !ls -ltr /etc/oracle/WALLETS/Test
total 16
-rw-r–r– 1 oracle oinstall 3112 May 4 23:16 ewallet.p12
-rw-r–r– 1 oracle oinstall 2408 May 4 23:16 ewallet_2017050503161274.p12

SQL> select * from v$encryption_wallet;

WRL_TYPE
——————–
WRL_PARAMETER
——————————————————————————–
STATUS WALLET_TYPE WALLET_OR FULLY_BAC
—————————— ——————– ——— ———
CON_ID
———-
FILE
/etc/oracle/WALLETS/Test/
OPEN_NO_MASTER_KEY PASSWORD SINGLE UNDEFINED
0
SQL> select key_id,activation_time from v$encryption_keys;

no rows selected

4. I restarted my database instance and saw CLOSED status, which is expected as autologin was not enabled yet.

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 524288000 bytes
Fixed Size 2926320 bytes
Variable Size 197134608 bytes
Database Buffers 318767104 bytes
Redo Buffers 5459968 bytes
Database mounted.
Database opened.
SQL> select key_id,activation_time from v$encryption_keys;

no rows selected

SQL> select * from v$encryption_wallet;

WRL_TYPE
——————–
WRL_PARAMETER
——————————————————————————–
STATUS WALLET_TYPE WALLET_OR FULLY_BAC
—————————— ——————– ——— ———
CON_ID
———-
FILE
/etc/oracle/WALLETS/Test/
CLOSED UNKNOWN SINGLE UNDEFINED
0
SQL> !ls -ltr /etc/oracle/WALLETS/Test/
total 16
-rw-r–r– 1 oracle oinstall 3112 May 4 23:16 ewallet.p12
-rw-r–r– 1 oracle oinstall 2408 May 4 23:16 ewallet_2017050503161274.p12

SQL> select count(1) from test.tstbl;
select count(1) from test.tstbl
*
ERROR at line 1:
ORA-28365: wallet is not open

5. The only option available was to open the wallet is using the old syntax.

SQL> ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY “<11g_wallet_password>”;

System altered.

SQL> select * from v$encryption_wallet;

WRL_TYPE
——————–
WRL_PARAMETER
——————————————————————————–
STATUS WALLET_TYPE WALLET_OR FULLY_BAC
—————————— ——————– ——— ———
CON_ID
———-
FILE
/etc/oracle/WALLETS/Test/
OPEN PASSWORD SINGLE NO
0
SQL> select count(1) from test.tstbl;

COUNT(1)
———-
261440

6. I configured the AUTOLOGIN feature using the new syntax and restarted the instance many times, no further issues reported with the keys availability.

SQL> ADMINISTER KEY MANAGEMENT CREATE AUTO_LOGIN KEYSTORE FROM KEYSTORE ‘/etc/oracle/WALLETS/Test’ IDENTIFIED BY “<keystore_password>”;

keystore altered.

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 524288000 bytes
Fixed Size 2926320 bytes
Variable Size 197134608 bytes
Database Buffers 318767104 bytes
Redo Buffers 5459968 bytes
Database mounted.
Database opened.
SQL> select * from v$encryption_wallet;

WRL_TYPE
——————–
WRL_PARAMETER
——————————————————————————–
STATUS WALLET_TYPE WALLET_OR FULLY_BAC
—————————— ——————– ——— ———
CON_ID
———-
FILE
/etc/oracle/WALLETS/Test/
OPEN AUTOLOGIN SINGLE NO
0
SQL> select count(1) from test.tstbl;

COUNT(1)
———-
261440

SQL> !ls -ltr /etc/oracle/WALLETS/Test
total 24
-rw-r–r– 1 oracle oinstall 3112 May 4 23:16 ewallet.p12
-rw-r–r– 1 oracle oinstall 2408 May 4 23:16 ewallet_2017050503161274.p12
-rw-r–r– 1 oracle oinstall 3157 May 4 23:21 cwallet.sso

Verification:
——————
SQL> select key_id,activation_time from v$encryption_keys;

KEY_ID
——————————————————————————
ACTIVATION_TIME
—————————————————————————
AQ**************************************AA

SQL> select name,utl_raw.cast_to_varchar2( utl_encode.base64_encode(’01’||substr(mkeyid,1,4))) || utl_raw.cast_to_varchar2( utl_encode.base64_encode(substr(mkeyid,5,length(mkeyid)))) masterkeyid_base64 FROM (select t.name, RAWTOHEX(x.mkid) mkeyid from v$tablespace t, x$kcbtek x where t.ts#=x.ts#);

NAME MASTERKEYID_BASE64
—————————— ————————————————————
TDE_TBS AQ*********************

The keys generated during older version of Oracle RDMS can be made active using the new TDE unified key management interface on RDMS 12c.

Categories: DBA Blogs

Prochaine édition des 24 HOP 2017 francophone

Yann Neuhaus - Tue, 2017-05-30 06:28

La prochaine édition du 24 Hours of PASS 2017 edition francophone se déroulera les 29-30 juin prochain.

Pour rappel le format est simple: 24 webinars gratuits répartis sur 2 jours de 07:00 à 18h00 GMT et en Français. La seule obligation: s’inscrire aux sessions auxquelles vous assisterez. Cela vous permettra également de récupérer l’enregistrement vidéo si vous voulez la visionner à nouveau par la suite.

Cette année il y en aura encore pour tous les goûts. Du monitoring, de la performance, de l’Azure, de la BI, du BigData et machine learning, de la modélisation, de la haute disponibilité, de l’open source et des nouveautés concernant la prochaine version de SQL Server!

Pour ma part j’aurai le privilège de présenter une session concernant les nouvelles possibilités en terme de haute disponibilité avec SQL Server dans un monde mixte (Windows et Linux) et un monde “full Linux”.

 

24HOP%20Website%20Banner%20French

Au plaisir de vous y retrouver!

 

 

Cet article Prochaine édition des 24 HOP 2017 francophone est apparu en premier sur Blog dbi services.

Pages

Subscribe to Oracle FAQ aggregator