Feed aggregator

Unilab Turns to NetSuite OneWorld for a Modern, Cloud-based System to Transform B2B Operations

Oracle Press Releases - Wed, 2017-11-01 19:00
Press Release
Unilab Turns to NetSuite OneWorld for a Modern, Cloud-based System to Transform B2B Operations Philippines' largest pharmaceutical company improves efficiency, transparency in B2B healthcare distribution channel

San Mateo, Calif., and Makati Citry, Philippines—Nov 2, 2017

Oracle NetSuite, one of the world’s leading providers of cloud-based financials / ERPHRProfessional Services Automation (PSA) and omnichannel commerce software suites, announced today that Unilab, the largest pharmaceutical company in the Philippines, has implemented NetSuite OneWorld to help power its 21 distributors by setting them up as individual business partners. Unilab upgraded from a 15-year-old locally developed application to a unified cloud ERP system, enabling its distributors to easily manage inventory and billing processes of around 10,000 trade accounts such as drug stores, clinics, and groceries. Unilab is also using OneWorld for sales and data consolidation and multi-subsidiary management. Since completing the NetSuite OneWorld implementation in January 2017, Unilab has streamlined operations for its distributors and has gained greater visibility into the channel, which accounts for a significant percentage of its US $1 billion annual revenue. Unilab is the first in the industry to leverage cloud ERP to standardize and stabilize its distributor management program through its project called iSERV 2.0.

Founded in 1945, Unilab manufactures over 350 brands of over-the-counter and prescription medications and personal health care products. The 4,000-person company, based in Mandaluyong in greater Manila, has maintained more than 20-percent market share in the Philippines for more than three decades. To help support continued growth and keep up with the changing times, Unilab needed to modernize from an on-premise system used by distributors to a flexible and scalable cloud-based system. Previously, Unilab’s business leaders had to manually consolidate and track data from distributors. Unilab realized it would need a new modern system that did not need to rely on servers scattered across the corporate landscape.

As part of its business continuity plan, Unilab also wanted to transition to the cloud as a disaster-protection measure that would stabilize the entire system during unexpected events like typhoons.

After evaluating several software options, Unilab selected NetSuite OneWorld as an agile, scalable cloud platform ideal to improve efficiency, visibility and standardization in the distribution channel.  NetSuite Solution Provider CloudTech played a key role, successfully and seamlessly implementing NetSuite at Unilab’s distributors.

With NetSuite OneWorld, Unilab has been able to realize its goals of real-time data visibility, streamlined distribution process, simplified data consolidation, and strengthened compliance while providing disaster protection through its cloud-based architecture.

NetSuite OneWorld supports 190 currencies, 20 languages, automated tax calculation and reporting in more than 100 countries, and transactions in more than 200 countries.

With NetSuite OneWorld, Unilab has also realized the following benefits:

Channel efficiency and visibility. Today, distributors use NetSuite for transactions with its trade accounts such as managing the inventory and billing process. Distributors are also able to monitor accounts receivable, inventory status, order status, and credit limits in NetSuite, while Unilab can better track vital data in real time.

Improved compliance. NetSuite gives Unilab better inventory management with lot-tracking capabilities to support compliance of distributors with the FEFO (first expiration, first out) distribution.

Multi-subsidiary management. With OneWorld, Unilab is able to centrally manage each of its 21 distributors.  

Contact Info
Mary Joy Katrina R. Contreras
NetSuite
+63 920 926 3024
PR@netsuite.com
About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world's first company dedicated to delivering business applications over the internet. Today, it 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 NetSuite's Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

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.

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

Mary Joy Katrina R. Contreras

  • +63 920 926 3024

PASS SUMMIT 2017 – SQL Server Security

Yann Neuhaus - Wed, 2017-11-01 18:05

Today is the first day of the PASS SUMMIT 2017 in Seattle (WA). The weather is cloudy and we have only 11°C… but where is the problem? Everything happens inside! (at the Convention Center).

IMG_9474[1]

In this blog, I will make a summary of main attack vectors against MSSQL environments, based on Argenis FERANDEZ’s session called “Modern Security Attack Vectors Against SQL Server Environments”.

METASPLOIT

Metasploit is a penetration testing framework to exploit known security vulnerabilities. This tool is able to scan a server by providing an IP address, and to list all security vulnerabilities you can find on TechNet.

After your environment has been scanned, you can exploit these vulnerabilities on every non-patched server. This kind of tool remind us how it is important to keep environments up-to-date with security updates!

Metasploit can also be used to hack SQL Server login password with a Brute-Force method. Time to remain Windows Logins are recommended over SQL Logins.

 

PowerSploit

PowerSploit is a collection of PowerShell modules (CodeExecution, ScriptModification, Exfiltration…) which can be used to exploit information / data from a compromised machine. This module includes the famous Mimikatz cmdlet which can be used to extract plaintext passwords, hash, PIN code and Kerberos tickets from memory.

 

SQLMAP

sqlmap is a penetration testing tool. It can detect and exploit different SQL injection types, like Boolean-based blind or Time-based blind.

 

RDP Hijacking

Imagine a Domain Admin (or a SQL Admin) connects to a remote Windows server. When his work is done, he disconnects from his session (so the session is still available). It happens to many administrators, doesn’t it? And now imagine this Windows server has been compromised and the hacker has local administrator privileges. He is able to hijack the domain admin session, and so retrieve all his privileges…

But how is it possible? You can either use PSEXEC Sysinternals tool (but it needs to be there), or either create a service which will hijack user’s session. You can find the demonstration made by Alexander Korznikov.

As a consequence, it highly recommended to completely logoff from your rdp sessions!

 

CONCLUSION

This session was pretty interesting because it provided various approaches which can be used to attack your MSSQL environment. It also provided different best practices to take care about, and I know I will always log off from my sessions ;-)

 

Cet article PASS SUMMIT 2017 – SQL Server Security est apparu en premier sur Blog dbi services.

November/December Online Class Offerings Posted

Jim Marion - Wed, 2017-11-01 16:40

We posted our online class offerings for November and December, 2017. You can find details on our website. Our Fluid classes have been extremely popular, so we will continue offering those at least once per month. Our Fluid 1 class is designed to get a developer up and running with Fluid as fast as possible. Through hands-on activities, you will use familiar tools and existsing skills to build Fluid components. No web development experience necessary. If you are a PeopleSoft developer, then Fluid 1 will teach you what you need to know to build Fluid pages. But there is more to Fluid than just dragging and dropping fields on a page. Fluid 2 takes your Fluid game to the next level by teaching you Fluid design patterns and Fluid techniques to build Fluid pages the way Oracle builds Fluid pages.

November, 2017 Course Title Date Start Time End Time Duration   AWE Nov. 7, 2017 9:00 AM PDT 4:00 PM PDT 2 days Register Fluid 1 Nov. 27, 2017 9:00 AM PDT 4:00 PM PDT 2 days Register Fluid 2 Nov. 29, 2017 9:00 AM PDT 4:00 PM PDT 2 days Register


December, 2017 Course Title Date Start Time End Time Duration   Fluid 1 December 11, 2017 9:00 AM PDT 4:00 PM PDT 2 days Register Fluid 2 December 13, 2017 9:00 AM PDT 4:00 PM PDT 2 days Register PeopleTools
8.55/8.56 Delta December 19, 2017 9:00 AM PDT 4:00 PM PDT 2 days Register

AVM Fritz: WLAN Mesh with Powerline Repeater does not work - Part 2

Dietrich Schroff - Wed, 2017-11-01 10:55
A month ago i tried to get the new WLAN mesh running with my Fritz!Box 7490 and Fritz!Powerline 546E.

Some days ago AVM release a new firmware for the 546E:

But even with the new firmware the powerline adapter does show up with the "mesh symbol" inside the home network overview:


I am wondering, if the WLAN mesh only works by using the powerline connectivity. AVM support pages show up the following advisory:
As you can see: Only the secondary powerline adapter shows the "mesh symbol".

Inside the networking overview my 546E is registered in this way:
Which is definitly wrong, because it is connected as WLAN bridge to the Fritz!Box without any powerline technololgy...

Hopefully the next update may fix this.

Contao: How to create a virtual system from your live website

Dietrich Schroff - Wed, 2017-11-01 09:07
Since a couple of year my sport club runs its website with contao.
Because our webhoster changed the support for php, i have to find a way to do an upgrade without damaging the running website.

The plan:
  1. create a linux host as a vm
  2. install mysql, apache2, php
  3. import the backups
The first step was easy. Inside virtualbox i created an ubuntu 17.10 system.
The second step was not that simple:
add-apt-repository ppa:ondrej/php
apt install mysql-server apache2 php5.6 php5.6-mysqlImporting the data into the database was easy (Before i did a backup via the contao frontend: system -> backup database).
mysql -u root -pYOURPASS -e "create database mydb"
mysql -u root -pYOURPASS mydb < database.backup.sqlFrom the live system i copied everything into /var/www/html and changed the user to www-data:
cd /var/www/html
chown -R www-data *Last step is the customizing of /var/www/html/system/config/localconfig.php
$GLOBALS['TL_CONFIG']['dbHost'] = 'localhost';
$GLOBALS['TL_CONFIG']['dbUser'] = 'root';
$GLOBALS['TL_CONFIG']['dbPass'] = 'YOURPASS';
$GLOBALS['TL_CONFIG']['dbDatabase'] = 'mydb';And after a last command
systemctl restart apache2i was able to open the website via a local firefox with http://localhost/index.php.
Now a snapshot a damaged installation after an upgrade can be rolled back without any problem ;-)

Enable Trusted Content Services (TCS) license in Documentum Content Server

Yann Neuhaus - Wed, 2017-11-01 08:12

The Trusted Content Services is a pack of features that you can enable/purchase to gain more security for your Content Server. The main key features are listed in this documentation:

https://www.emc.com/collateral/software/data-sheet/h3138-security-ds.pdf

In our case, we wanted to benefit from the Repository Encryption feature:

Repository Encryption: Documentum TCS prevents intruders from accessing information even if they obtain unauthorized access to repository files at the file-system or storage level. This capability protects content against an operating system level security breach and enables you to securely store back-up media containing information assets in encrypted form.

To enable the TCS first you must get a license key from OpenText then they will send you a key String. Put that key only in a file located here: $DOCUMENTUM/dba/tcs_license

Then login to the docbase with IAPI and enable TCS for this repo with:

retrieve,c,dm_server_config
set,c,l,r_trusted_mode
1
save,c,l
reinit,c

No need to restart, the TCS license is only checked dynamically when a TCS feature is called.
To see if the license has been properly integrated, login to Documentum Administrator and on the Admin page you should see:
Trusted Mode: Enabled

 

Cet article Enable Trusted Content Services (TCS) license in Documentum Content Server est apparu en premier sur Blog dbi services.

Oracle to Launch Four New Professional Tennis Events in Early 2018

Oracle Press Releases - Wed, 2017-11-01 08:00
Press Release
Oracle to Launch Four New Professional Tennis Events in Early 2018 Oracle Challenger Series Aims to Support American Players

Redwood Shores, Calif.—Nov 1, 2017

In another sign of its continued support of American tennis, Oracle Corp. announced today that it is launching four new professional tennis tournaments—two men’s events and two women’s events—in the United States next year in conjunction with the Association of Tennis Professionals (ATP) and the Women’s Tennis Association (WTA).

The Oracle Challenger Series—two ATP Challenger Tour events and two WTA 125K Series events—will take place as combined events Jan. 20-28, 2018 at the Newport Beach Tennis Club and February 24-March 4, 2018 at the Indian Wells Tennis Garden. Each event will pay equal prize money for a total of $150,000 per tournament.

The top two male and female Americans with the highest accumulated points at the events will be awarded wild cards in their respective singles main draws at the 2018 BNP Paribas Open, held March 5-18 at the Indian Wells Tennis Garden, which is widely considered the top combined ATP/WTA professional tennis tournament in the world. Player participation in the Oracle Challenger Series will be determined by ATP and WTA rankings and procedures used for similar tournaments.

“Tennis players in the United States need more chances to compete at home and more chances to earn a living from the sport,” said Oracle CEO Mark Hurd. “Oracle is committed to American tennis and these events are designed to provide opportunities for players to make meaningful gains in both prize money and ranking points on their home soil. We hope to continue to grow the number of events annually in the years ahead.”

“Our players in the United States are eager for more opportunities like this,” said Chris Kermode, ATP World Tour Executive Chairman and President. “We’re so pleased to partner with a company like Oracle to further promote and develop tennis in the United States.”

“We are thrilled that Oracle is making this commitment to grow the pathway for young emerging national and regional talent here in the USA to reach their goal of competing on the WTA Tour. This will lead to great things for tennis in America,” said Steve Simon, Chairman and Chief Executive Officer of the WTA.

The Series builds on Oracle’s commitment to help support U.S. tennis at both the professional and collegiate level. Earlier this year, Oracle unveiled the Oracle US Tennis Awards, two $100,000 grants awarded annually to assist young players as they transition from college into the professional ranks. Oracle also is working with the Intercollegiate Tennis Association (ITA) to host the Oracle ITA National Fall Championships, which begins today at the Indian Wells Tennis Garden and another resort-area location. The Oracle-sponsored event is the culmination of the fall collegiate tennis season and features the nation’s top 64 men’s and women’s singles players and top 32 men’s and women’s doubles teams. It replaces the ITA National Indoor Intercollegiate Championships. 

Contact Info
Deborah Hellinger
Oracle Corporate Communications
+1.212.508.7935
deborah.hellinger@oracle.com
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.

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

Deborah Hellinger

  • +1.212.508.7935

Oracle Cloud Application Development Platform 17.4.2 Anncounced

We are excited to announce the new enhancements to Oracle Application Container Cloud and Oracle Java Cloud Service that were rolled out as part of the 17.4.2 release. New Language runtime Support...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Oracle Leads the Pack in Independent Analyst Report on Digital Experience Platforms

Oracle Press Releases - Wed, 2017-11-01 07:00
Press Release
Oracle Leads the Pack in Independent Analyst Report on Digital Experience Platforms Oracle named sole leader in evolving digital experience platform market with a balance of product and platform

Redwood Shores, Calif.—Nov 1, 2017

Oracle today announced that Forrester Research has named the company the sole leader in digital experience platforms in its recent The Forrester Wave™: Digital Experience Platforms, Q3 2017 report. Oracle was recognized for having one of the broadest portfolios—including content, commerce, marketing, data, analytics and customer care.

Organizations today are under pressure to meet skyrocketing customer expectations. To meet these needs, organizations must be able to provide unique digital experiences across every step of a customer’s journey—requiring software that spans marketing, commerce, service, analytics and more. The Oracle CX Cloud Suite offers an integrated set of applications that blend innovative technologies, such as artificial intelligence (AI), Internet of Things (IoT) and data that span the entire customer lifecycle. By enabling a smarter approach to customer experience, Oracle empowers organizations to not only save time and money, but also improve the bottom line and exceed customer expectations.

“I believe that our performance as sole leader in Forrester’s digital experience report reflects the large investments and progress we’ve made in building the Oracle CX Cloud Suite,” said Des Cahill, vice president and head CX evangelist, Oracle. “Our mantra is simple: we want our customers to have connected data that spans their organization; to apply connected intelligence to that data; and to deliver connected experiences to their customers across any channel. Only the Oracle CX Cloud Suite is able to deliver on this promise.”

Of the 14 vendors Forrester evaluated for digital experience, the Oracle CX Cloud Suite was named sole leader based on evaluation across 28 criteria, including current offering, strategy and market presence. Oracle was cited for its balance of product and platform. As one Oracle reference noted: “No one else has the length and breadth of integration and future development dollars. I think Oracle is in this for the long haul.”

Oracle CX Cloud Suite empowers organizations to take a smarter approach to customer experience management and business transformation initiatives. By providing a trusted business platform that connects data, experiences and outcomes, Oracle CX Cloud Suite helps customers reduce IT complexity, deliver innovative customer experiences and achieve predictable and tangible business results. The Oracle CX Cloud Suite includes Oracle Commerce Cloud, Oracle Marketing Cloud, Oracle Sales Cloud and Oracle Service Cloud.

Download The Forrester Wave™: Digital Experience Platforms, Q3 2017

Contact Info
Simon Jones
PR for Oracle
+1.415.856.5155
sjones@blancandotus.com
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.

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

Simon Jones

  • +1.415.856.5155

Oracle Transforms the Student Experience with Oracle Student Cloud

Oracle Press Releases - Wed, 2017-11-01 07:00
Press Release
Oracle Transforms the Student Experience with Oracle Student Cloud Integrates Artificial Intelligence and Machine Learning to Modernize and Personalize the Student Journey, Improving Experience and Outcomes

EDUCAUSE, Philadelphia, PA.—Nov 1, 2017

Empowering higher education institutions with the data-driven intelligence and tools they need to deliver a personalized, modern student experience, Oracle today announced Oracle Student Management as the newest entry in the Oracle Student Cloud suite. Enhancing the traditional capabilities of student information systems (SIS), the offering transforms the student experience with new capabilities for student recruiting, engagement, support and management. With powerful built-in Artificial Intelligence (AI), machine-learning and predictive analytics, Oracle Student Management can proactively anticipate student needs, monitor progress and make suggestions when students appear to be at-risk or going off course.

“With the introduction of adaptive intelligence in the new Oracle Student Management module in Oracle Student Cloud, Oracle is bringing higher education out of the shadows and into the main stage,” said Nicole Engelbert, director of research and analysis, Ovum.  “For institutions looking to upgrade their student information systems, Oracle Student Cloud provides a comprehensive student experience throughout the student lifecycle, from recruiting through graduation. This solution will enable the institution to promote student success, as they improve retention and graduation rates. “

Two decades ago, most schools built the SIS infrastructure around transactions, such as registration and enrollment. Today, there is a pressing need to collect and use data to understand students and create more productive, meaningful and lasting relationships with them. Modern student cloud solutions must re-imagine the student journey to meet current expectations across the entire student lifecycle. Using the right tools, institutions will be able to anticipate the needs of their students and illuminate the right path to empower them to succeed.

“The higher education experience is transforming overall – from what students expect, to how they are pursuing their learning goals,” said Vivian Wong, Oracle’s group vice president of Higher Education Development. “As such, colleges and universities need to be more flexible, agile and responsive in their approach – meeting student expectations across new channels and modes of communication. This will require new intelligence and tools to help students carve their own unique path and find success. Oracle Student Cloud was built around this modern mentality and geared to help schools and their students succeed together.”

Architected from the ground up as a student-centric offering, Oracle Student Management will initially support a Continuing Education business model with subsequent updates providing the full spectrum of support for traditional models.This first release allows students to use any mobile device or personal computer to easily:

  • Self-create an account: no waiting on paperwork or administrator data entry, students can create an account, find learning and enroll all in one sitting.
  • Find learning opportunities (e.g., courses) using modern search paradigms: from intelligent type-ahead searching to curated postings like trending and highlighted courses to the use of configurable facets and filters to narrow results, students can quickly and easily find their way to just the right class.
  • Enroll and Pay-as-They-Go: with a streamlined business process and point and click interface, students can quickly progress through finding their class (including the number of open seats), adding it to their cart, and paying for it. Students get quick access to the learning they need, and institutions instantly see the status of enrollments and the financial viability of offerings.
  • View Courses: with one click access, students can view their current courses, either in a filterable List View or with Course Cards that provide additional details like meeting times, credits, location (with embedded mapping) and a more at-a-glance format.
  • Manage Finances: students can monitor their financial situation with on-demand access to view and manage their individual account.

With the addition of Oracle Student Management, Oracle Student Cloud enables higher education institutions to interact with students at all stages of the student lifecycle, including optimizing:

  • Student Engagement: personalize the student journey by delivering relevant, targeted, cross-channel outreach and engagement, deepen social interactions, deliver content in context to targeted audience segments, and demonstrate marketing’s impact on the institution’s goals.
  • Student Recruiting: meet enrollment goals by boosting pipeline and improving forecasting, managing recruiters and their territories, driving recruiting results with complete mobility, and optimizing recruiting performance with powerful analytics.
  • Student Support: deliver the best, fastest resolution by guiding the student’s personal journey based on their needs, empowering students with mobile-friendly web self-service, knowledge, and social tools, adapting support processes to meet student’s rising expectations and changing behaviors, and reduce support costs through improved productivity.

New solutions for Student Financial Aid, Student Success, and Advancement are planned for Oracle Student Cloud in the near future. Enabling institutions to reduce cost and complexity with a truly end-to-end system, Oracle Student Cloud also integrates seamlessly with other Oracle Cloud solutions, including Oracle HCM Cloud and Oracle Financials Cloud. From managing employees and assigning instructors to classes, to managing students’ accounts and providing easy payment processing during the enrollment process, these solutions work together to provide users all the tools they need to better serve the needs of students and administrators.  

Contact Info
Katie Barron
Oracle
+1.202.904.1138
katie.barron@oracle.com
Kristin Reeves
Blanc & Otus
+1.415.856.5145
kristin.reeves@blancandotus.com
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.

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

Katie Barron

  • +1.202.904.1138

Kristin Reeves

  • +1.415.856.5145

Retrieve fields from clob field with envelope and HTML chacaters

Tom Kyte - Wed, 2017-11-01 01:26
Dear I have tried to parse a clob field located in a Oracle table that contains a envelope and also some HTML characters (&quot, &lt, &gt), as shown below: <?xml version="1.0" encoding="utf-8"?><soapenv:Envelope xmlns:soapenv="http://schemas.xm...
Categories: DBA Blogs

Bulk Inserts with CLOB column Slower in Oracle 12c than Oracle 11g

Tom Kyte - Wed, 2017-11-01 01:26
We are noticing that large table inserts with CLOB is taking more time on 12c than 11g. The inserts are during an online transaction processing where we copy data from one business unit to another. There is one table in particular that is taking cons...
Categories: DBA Blogs

Get "LPX-00242: invalid use of ampersand" from xmltype() even though ampersand is already escaped

Tom Kyte - Wed, 2017-11-01 01:26
Any idea why I get the error message "LPX-00242: invalid use of ampersand ('&') character (use &amp;)" even though the ampersand in the below test case is already escaped? Tested with same result both in 11g XE, 11.2.0.4 SE, and on apex.oracle.com (w...
Categories: DBA Blogs

Dbvisit replicate – SQL Developer chart

Yann Neuhaus - Tue, 2017-10-31 14:27

Here is a quick SQL Developer report which display a chart about the Dbvisit replicate lag over the last hours

The idea is to have the following chart showing the lag in MINE and APPLY processes. Here is an example where I stopped the replication to show some lag.
CaptureDbvrepsqldev

The query is on the DBVREP.DBRSCOMMON_LAG_STATS on the APPLY side, which display the wallclock time with timestamp from the MINE and from the APPLY.

Here is the SQL Developer report .xml:

<?xml version="1.0" encoding="UTF-8" ?>
<displays>
<display id="72f37b59-015f-1000-8002-0af7a3b47766" type="" style="Chart" enable="true">
	<name><![CDATA[Dbvisit replicate gap]]></name>
	<description><![CDATA[]]></description>
	<tooltip><![CDATA[]]></tooltip>
	<drillclass><![CDATA[]]></drillclass>
	<CustomValues>
		<Y1AXIS_TITLE_TEXT><![CDATA[min]]></Y1AXIS_TITLE_TEXT>
		<PLOT_DATATIPS_TEXT><![CDATA[true]]></PLOT_DATATIPS_TEXT>
		<Y2AXIS_SCALE_MAXIMUM><![CDATA[80.0]]></Y2AXIS_SCALE_MAXIMUM>
		<XAXIS_TICK_LABEL_FONT.COLOR><![CDATA[-12565927]]></XAXIS_TICK_LABEL_FONT.COLOR>
		<LEGEND_LOCATION><![CDATA[AUTOMATIC]]></LEGEND_LOCATION>
		<PLOT_SERIES_OPTIONS_COLOR><![CDATA[\,-1344256,-16756836,-10066279,-16751002,-26368]]></PLOT_SERIES_OPTIONS_COLOR>
		<DATA_MAP_COLUMNS><![CDATA[\,"WALLCLOCK","WALLCLOCK"]]></DATA_MAP_COLUMNS>
		<Y1AXIS_SCALE_MAXIMUM><![CDATA[60.0]]></Y1AXIS_SCALE_MAXIMUM>
		<Y1AXIS_SCALE_INCREMENT_AUTOMATIC><![CDATA[false]]></Y1AXIS_SCALE_INCREMENT_AUTOMATIC>
		<XAXIS_TICK_LABEL_ROTATE><![CDATA[HORIZONTAL]]></XAXIS_TICK_LABEL_ROTATE>
		<TYPE><![CDATA[BAR_VERT_CLUST]]></TYPE>
		<DATA_MAP_COUNT><![CDATA[2]]></DATA_MAP_COUNT>
		<STYLE><![CDATA[Default]]></STYLE>
		<TITLE_ALIGNMENT><![CDATA[LEFT]]></TITLE_ALIGNMENT>
		<XAXIS_TICK_LABEL_FONT.NAME><![CDATA[Courier New]]></XAXIS_TICK_LABEL_FONT.NAME>
		<TITLE_TEXT><![CDATA[Dbvisit replicate gap (in minutes)]]></TITLE_TEXT>
		<Y2AXIS_TICK_LABEL_ROTATE><![CDATA[HORIZONTAL]]></Y2AXIS_TICK_LABEL_ROTATE>
		<PLOT_HGRID><![CDATA[true]]></PLOT_HGRID>
		<PLOT_DATATIPS_VALUE><![CDATA[true]]></PLOT_DATATIPS_VALUE>
		<Y2AXIS_LINE_WIDTH><![CDATA[THINNEST]]></Y2AXIS_LINE_WIDTH>
		<Y1AXIS_TICK_LABEL_ROTATE><![CDATA[HORIZONTAL]]></Y1AXIS_TICK_LABEL_ROTATE>
		<PLOT_HGRID_WIDTH><![CDATA[THINNER]]></PLOT_HGRID_WIDTH>
		<XAXIS_TICK_LABEL_AUTO_ROTATE><![CDATA[true]]></XAXIS_TICK_LABEL_AUTO_ROTATE>
		<Y1AXIS_SCALE_INCREMENT><![CDATA[60.0]]></Y1AXIS_SCALE_INCREMENT>
		<Y1AXIS_LINE_WIDTH><![CDATA[THINNEST]]></Y1AXIS_LINE_WIDTH>
		<Y1AXIS_TITLE_ALIGNMENT><![CDATA[CENTER]]></Y1AXIS_TITLE_ALIGNMENT>
		<LEGEND_ALIGNMENT><![CDATA[LEFT]]></LEGEND_ALIGNMENT>
		<XAXIS_LINE_WIDTH><![CDATA[THINNEST]]></XAXIS_LINE_WIDTH>
		<XAXIS_TICK_LABEL_FONT.SIZE><![CDATA[14]]></XAXIS_TICK_LABEL_FONT.SIZE>
		<XAXIS_TITLE_ALIGNMENT><![CDATA[CENTER]]></XAXIS_TITLE_ALIGNMENT>
		<PLOT_DATALABELS><![CDATA[false]]></PLOT_DATALABELS>
		<Y1AXIS_LOGARITHMIC_BASE><![CDATA[BASE_10]]></Y1AXIS_LOGARITHMIC_BASE>
		<GRID_WIDTH><![CDATA[THINNER]]></GRID_WIDTH>
		<PLOT_DATALABELS_BAR_POSITION><![CDATA[ABOVE]]></PLOT_DATALABELS_BAR_POSITION>
		<FOOTNOTE_ALIGNMENT><![CDATA[LEFT]]></FOOTNOTE_ALIGNMENT>
		<XAXIS_TICK_LABEL_SKIP_MODE><![CDATA[MANUAL]]></XAXIS_TICK_LABEL_SKIP_MODE>
		<XAXIS_TICK_LABEL_FONT.UNDERLINE><![CDATA[false]]></XAXIS_TICK_LABEL_FONT.UNDERLINE>
		<DATA_MAP_COLNAMES><![CDATA[\,"APPLY lag seconds","APPLY_PROCESS_NAME","DDC_ID","MINE lag seconds","MINE_PROCESS_NAME","WALLCLOCK"]]></DATA_MAP_COLNAMES>
		<DATA_MAP_SERIES><![CDATA[\,"MINE_PROCESS_NAME","APPLY_PROCESS_NAME"]]></DATA_MAP_SERIES>
		<Y2AXIS_LOGARITHMIC_BASE><![CDATA[BASE_10]]></Y2AXIS_LOGARITHMIC_BASE>
		<Y2AXIS_SCALE_MINIMUM><![CDATA[10.0]]></Y2AXIS_SCALE_MINIMUM>
		<XAXIS_TICK_LABEL_FONT.POSTURE><![CDATA[false]]></XAXIS_TICK_LABEL_FONT.POSTURE>
		<DATA_MAP_VALUES><![CDATA[\,"MINE lag seconds","MINE lag seconds"]]></DATA_MAP_VALUES>
		<PLOT_VGRID><![CDATA[true]]></PLOT_VGRID>
		<TITLE><![CDATA[true]]></TITLE>
		<Y1AXIS_TITLE><![CDATA[false]]></Y1AXIS_TITLE>
		<Y2AXIS_SCALE_INCREMENT><![CDATA[20.0]]></Y2AXIS_SCALE_INCREMENT>
		<PLOT_VGRID_WIDTH><![CDATA[THINNER]]></PLOT_VGRID_WIDTH>
		<Y2AXIS_TITLE_ALIGNMENT><![CDATA[CENTER]]></Y2AXIS_TITLE_ALIGNMENT>
		<SUBTITLE_ALIGNMENT><![CDATA[LEFT]]></SUBTITLE_ALIGNMENT>
		<XAXIS_TICK_LABEL_FONT.WEIGHT><![CDATA[false]]></XAXIS_TICK_LABEL_FONT.WEIGHT>
	</CustomValues>
	<query>
		<sql><![CDATA[SELECT  ddc_id,mine_process_name,apply_process_name,"WALLCLOCK", "APPLY lag seconds", "MINE lag seconds" FROM(
select ddc_id,mine_process_name,apply_process_name,
to_char(trunc(wallclock_date,'hh24'),'dd-mon hh24:mi') wallclock,
max(round((wallclock_date-apply_date)*24*60*60)) "APPLY lag seconds", max(round((wallclock_date-mine_date)*24*60*60)) "MINE lag seconds"
from DBVREP.DBRSCOMMON_LAG_STATS 
where wallclock_date>sysdate-3
group by ddc_id,mine_process_name,apply_process_name,to_char(trunc(wallclock_date,'hh24'),'dd-mon hh24:mi')
order by wallclock
)]]></sql>
	</query>
		<pdf version="VERSION_1_7" compression="CONTENT">
			<docproperty title="null" author="null" subject="null" keywords="null" />
			<cell toppadding="2" bottompadding="2" leftpadding="2" rightpadding="2" horizontalalign="LEFT" verticalalign="TOP" wrap="true" />
			<column>
				<heading font="null" size="10" style="NORMAL" color="-16777216" rowshading="-1" labeling="FIRST_PAGE" />
				<footing font="null" size="10" style="NORMAL" color="-16777216" rowshading="-1" labeling="NONE" />
				<blob blob="NONE" zip="false" />
			</column>
			<table font="null" size="10" style="NORMAL" color="-16777216" userowshading="false" oddrowshading="-1" evenrowshading="-1" showborders="true" spacingbefore="12" spacingafter="12" horizontalalign="LEFT" />
			<header enable="false" generatedate="false">
				<data>
				null				</data>
			</header>
			<footer enable="false" generatedate="false">
				<data value="null" />
			</footer>
			<pagesetup papersize="LETTER" orientation="1" measurement="in" margintop="1.0" marginbottom="1.0" marginleft="1.0" marginright="1.0" />
		</pdf>
</display>
</displays>
 

Cet article Dbvisit replicate – SQL Developer chart est apparu en premier sur Blog dbi services.

CVE-2017-10151 Oracle Identity Manager Vulnerability

Oracle has released an out-of-cycle security advisory (CVE-2017-10151) for a vulnerability affecting Oracle Identity Manager.  This vulnerability has a CVSS 3.0 base score of 10 out of 10.  Oracle Identity Manager is the identity governance component within the Oracle Identity Management solution.  All supported versions of Identity Manager are impacted from 11.1.1.7 to 12.2.1.3.0.  Most likely 11.1.1.1 through 11.1.1.6 are also vulnerable.  Previous Identity Manager versions (10g and 9.x) that are not based on Oracle WebLogic are probably not vulnerable.

The vulnerability is that the Oracle Identity Manager system user account (OIMINTERNAL) can be accessed using the default password through the Oracle WebLogic server.  As this is a highly privileged user, the entire Identity Manager environment can be completely compromised via an unauthenticated network attack.

The work-around is to change the OIMINTERNAL user password to a random string in the WebLogic administration console under Domain -> Security Realms.  A patch will be available in the future to automatically change the password.  See My Oracle Support Note "Oracle Security Alert CVE-2017-10151 Patch Availability Document for Oracle Identity Manager (Doc ID 2322316.1)" for more information.

As Oracle released an out-of-cycle security advisory, either detailed information regarding the vulnerability has been released or will soon be released, or Oracle has been informed the vulnerability is being actively exploited.

Oracle Fusion Middleware, Oracle Critical Patch Updates
Categories: APPS Blogs, Security Blogs

Quarterly EBS Upgrade Recommendations: Oct 2017 Edition

Steven Chan - Tue, 2017-10-31 11:24

We've previously provided advice on the general priorities for applying EBS updates and creating a comprehensive maintenance strategy.   

Here are our latest upgrade recommendations for E-Business Suite updates and technology stack components.  These quarterly recommendations are based upon the latest updates to Oracle's product strategies, latest support timelines, and newly-certified releases

You can research these yourself using this Note:

Upgrade Recommendations for October 2017

  EBS 12.2  EBS 12.1  EBS 12.0  EBS 11.5.10 Check your EBS support status and patching baseline

Apply the minimum 12.2 patching baseline
(EBS 12.2.3 + latest technology stack updates listed below)

In Premier Support to September 30, 2023

Apply the minimum 12.1 patching baseline
(12.1.3 Family Packs for products in use + latest technology stack updates listed below)

In Premier Support to December 31, 2021

In Sustaining Support. No new patches available.

Upgrade to 12.1.3 or 12.2

Before upgrading, 12.0 users should be on the minimum 12.0 patching baseline

In Sustaining Support. No new patches available.

Upgrade to 12.1.3 or 12.2

Before upgrading, 11i users should be on the minimum 11i patching baseline

Apply the latest EBS suite-wide RPC or RUP

12.2.7
Sept. 2017

12.1.3 RPC5
Aug. 2016

12.0.6

11.5.10.2
Use the latest Rapid Install

StartCD 51
Feb. 2016

StartCD 13
Aug. 2011

12.0.6


11.5.10.2

Apply the latest EBS technology stack, tools, and libraries

AD/TXK Delta 10
Sept. 2017

FND
Apr. 2017

EBS 12.2.6 OAF Update 7
Oct. 2017

EBS 12.2.5 OAF Update 16
Oct. 2017

EBS 12.2.4 OAF Update 17
Oct. 2017

ETCC
Sept. 2017

Web Tier Utilities 11.1.1.9

Daylight Savings Time DSTv28
Nov. 2016

FND
Apr. 2017

OAF Bundle 5
Jun. 2016

JTT Update 4
Oct. 2016

Daylight Savings Time DSTv28
Nov. 2016

 

 

Apply the latest security updates

Oct. 2017 Critical Patch Update

SHA-2 PKI Certificates

SHA-2 Update for Web ADI & Report Manager

Migrate from SSL or TLS 1.0 to TLS 1.2

Sign JAR files

Jul. 2017 Critical Patch Update

SHA-2 PKI Certificates

SHA-2 Update for Web ADI & Report Manager

Migrate from SSL or TLS 1.0 to TLS 1.2

Sign JAR files

Oct. 2015 Critical Patch Update April 2016 Critical Patch Update Use the latest certified desktop components

Use the latest JRE 1.8, 1.7, or 1.6 release that meets your requirements.

Switch to Java Web Start

Upgrade to IE 11

Upgrade to Firefox ESR 52

Upgrade Office 2003 and Office 2007 to later Office versions (e.g. Office 2016)

Upgrade Windows XP and Vista and Win 10v1507 to later versions (e.g. Windows 10v1607)

Use the latest JRE 1.8, 1.7, or 1.6 release that meets your requirements

Switch to Java Web Start

Upgrade to IE 11

Upgrade to Firefox ESR 52

Upgrade Office 2003 and Office 2007 to later Office versions (e.g. Office 2016)

Upgrade Windows XP and Vista and Win 10v1507 to later versions (e.g. Windows 10v1607)

    Upgrade to the latest database Database 11.2.0.4 or 12.1.0.2 Database 11.2.0.4 or 12.1.0.2 Database 11.2.0.4 or 12.1.0.2 Database 11.2.0.4 or 12.1.0.2 If you're using Oracle Identity Management

Upgrade to Oracle Access Manager 11.1.2.3

Upgrade to Oracle Internet Directory 11.1.1.9

Migrate from Oracle SSO to OAM 11.1.2.3

Upgrade to Oracle Internet Directory 11.1.1.9

    If you're using Oracle Discoverer

Migrate to Oracle
Business Intelligence Enterprise Edition (OBIEE), Oracle Business
Intelligence Applications (OBIA).

Discoverer 11.1.1.7 is in Sustaining Support as of June 2017

Migrate to Oracle
Business Intelligence Enterprise Edition (OBIEE), Oracle Business
Intelligence Applications (OBIA).

Discoverer 11.1.1.7 is in Sustaining Support as of June 2017

    If you're using Oracle Portal Migrate to Oracle WebCenter  11.1.1.9 Migrate to Oracle WebCenter 11.1.1.9 or upgrade to Portal 11.1.1.6 (End of Life Jun. 2017).

 

 
Categories: APPS Blogs

Oracle Brings Agile Pricing to Italian Hypermarket Bennet

Oracle Press Releases - Tue, 2017-10-31 08:00
Press Release
Oracle Brings Agile Pricing to Italian Hypermarket Bennet Pricing Efficiencies Gained with Oracle Retail Merchandising Planning and Optimization

Redwood Shores, Calif.—Oct 31, 2017

Today, Oracle announced that Italian hypermarket chain Bennet has deployed Oracle Retail Planning and Optimization solutions to increase efficiencies. Bennet operates 63 hypermarkets throughout northern Italy. Bennet focuses on price, service, and selection. With a centralized view of inventory, Bennet can leverage Oracle Retail Regular Price Optimization to maximize assortments to anticipate and meet customer needs.

Bennet understands that to stay competitive, it must adapt the price of its goods to react to changes in the market, including competitor pricing, seasonality and market trends. Its legacy system was time consuming and Bennet sought to improve the speed and the accuracy of the process to better serve its customers.

“We are committed to providing our customers with the very best quality and value, so it’s important that our prices match those of our competitors,” says Alessandro Volpato, Chief Information Officer, Bennet. “Our legacy system simply didn’t provide the ability to adapt our prices in real-time and we decided to replace our legacy technology with a proven, industry-leading platform.”

In 2015, Bennet turned to Oracle to transform its ability to manage pricing and improve its competitiveness while balancing profitability. The Italian hypermarket chain has dramatically cut the time it takes to adapt its prices following the implementation of Oracle Retail Merchandising Planning & Optimization—from days to hours. Bennet is now empowered to make real-time pricing decisions.

“Bennet has seen instant return on investment, as this activity can be completed in a few hours, and because the process of data entry is automated, it eliminates the possibility of errors associated with manual entry,” said Alessandro Volpato, Chief Information Officer, Bennet.

The first phase of the project was rolled out in July 2015 across Bennet’s full range of grocery items. Bennet focused on introducing rule-based pricing capabilities, including price proposal and competitor price comparison. The grocer is now extending the use of the Oracle platform with the optimization algorithms support. Using the Oracle platform, Bennet can dynamically manage pricing data without coding, and change pricing thresholds and rules without ever needing to involve the development team. Bennet can now predict the impact of pricing to both individual items and to categories of products, enabling it to balance and execute price effectiveness against competitors.

“Today, it’s never been easier to check and compare prices between different retailers, so it’s vital that they can adapt the price of items to react to their competitors, or to other factors,” said Ray Carlin, Senior Vice President and General Manager, Oracle Retail. “Customer loyalty is all about trust, and a big factor in maintaining this trust is making consumers feel that they are getting the best possible value. We look forward to working with Bennet to unlock even more of the value of our Merchandising platform, and help strengthen its brand and relationship with customers.”

The next phase of the implementation sees Bennet incorporating more sophisticated KPI within its operations and corporate strategy to simplify and drive the pricing decisions.

Contact Info
Judi Palmer
Oracle PR
+1.650.784.7901
judi.palmer@oracle.com
Matt Torres
Oracle PR
+1.415.595.1584
matt.torres@oracle.com
Patty Oien
Blanc & Otus
+1.510.303.7289
patty.oien@blancandotus.com
About Oracle Retail

Oracle provides retailers with a complete, open, and integrated suite of best-of-breed business applications, cloud services, and hardware that are engineered to work together and empower commerce. Leading fashion, grocery, and specialty retailers use Oracle solutions to anticipate market changes, simplify operations and inspire authentic brand interactions. For more information, visit our website at www.oracle.com/retail.

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

Judi Palmer

  • +1.650.784.7901

Matt Torres

  • +1.415.595.1584

Patty Oien

  • +1.510.303.7289

Implementing Old style SQL outer join along with condition query to the new style

Tom Kyte - Tue, 2017-10-31 07:06
Hi, I have SQL outer join query which is written in old format with (+) notation and I am working on its migration to the new presentation and without the (+) notation. I am unable to convert the last line of the query with the outer join condition....
Categories: DBA Blogs

Need to print latin ä charater through Dbms out into apex sql developer ?

Tom Kyte - Tue, 2017-10-31 07:06
Hi gurus, I am trying to print this character a through apex sql developer but it return me ? instead of this a , any one know how can I achieve this. begin dbms_output.put_line ('http://fam.co/') ; end; if my question is not clear please...
Categories: DBA Blogs

two stage RMAN backups

Tom Kyte - Tue, 2017-10-31 07:06
Hi team. We have an Oracle instance, which I think is using ASM on SAN LUNs. The SAN is multi-path, multi-fabric with the LUNs are provisioned from a high quality H/A storage array. At the moment the DBAs use RMAN to push backups via MML directly ...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator