Feed aggregator

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..

Migration of a very large warehouse database

Tom Kyte - Fri, 2019-03-22 13:46
This question is more of a solicitation for advice than an actual question. I've been tasked with migrating a large warehouse database from one set of hardware in one datacenter to a new set of hardware in a different datacenter. Excluding temp, ...
Categories: DBA Blogs

How to show special/unseen characters from a column in a plsql ?

Tom Kyte - Fri, 2019-03-22 13:46
Hi Tom, I have a table with special characters in a column. The column values are like this with the plsql below. <code>set serveroutput on; declare c varchar2 (100); a number; begin for i in ( select ekd0756_cur...
Categories: DBA Blogs

how to copy chrome bookmarks from one computer to another

Matt Penny - Fri, 2019-03-22 12:20

copy "C:\Users\matty\AppData\Local\Google\Chrome\User Data\Default\Bookmarks"
"\sh00001\c$\Users\matty\AppData\Local\Google\Chrome\User Data\Default" -verbose

Categories: DBA Blogs

Stats advisor

Jonathan Lewis - Fri, 2019-03-22 08:10

This is just a little shout-out about the Stats Advisor – if you decide to give it a go, what sort of things is it likely to tell you. The answer is in a dynamic performance view called v$stats_advisor_rules – which I’ve list below from an instance running

SQL> set linesize 180
SQL> set trimspool on
SQL> set pagesize 40
SQL> column description format a75
SQL> column name format a32
SQL> break on rule_type duplicate skip 1
SQL> select * from v$stats_advisor_rules;

  RULE_ID NAME                             RULE_TYPE DESCRIPTION                                                                     CON_ID
---------- -------------------------------- --------- --------------------------------------------------------------------------- ----------
         0                                  SYSTEM                                                                                         0
         1 UseAutoJob                       SYSTEM    Use Auto Job for Statistics Collection                                               0
         2 CompleteAutoJob                  SYSTEM    Auto Statistics Gather Job should complete successfully                              0
         3 MaintainStatsHistory             SYSTEM    Maintain Statistics History                                                          0
         4 UseConcurrent                    SYSTEM    Use Concurrent preference for Statistics Collection                                  0
         5 UseDefaultPreference             SYSTEM    Use Default Preference for Stats Collection                                          0
         6 TurnOnSQLPlanDirective           SYSTEM    SQL Plan Directives should not be disabled                                           0

         7 AvoidSetProcedures               OPERATION Avoid Set Statistics Procedures                                                      0
         8 UseDefaultParams                 OPERATION Use Default Parameters in Statistics Collection Procedures                           0
         9 UseGatherSchemaStats             OPERATION Use gather_schema_stats procedure                                                    0
        10 AvoidInefficientStatsOprSeq      OPERATION Avoid inefficient statistics operation sequences                                     0

        11 AvoidUnnecessaryStatsCollection  OBJECT    Avoid unnecessary statistics collection                                              0
        12 AvoidStaleStats                  OBJECT    Avoid objects with stale or no statistics                                            0
        13 GatherStatsAfterBulkDML          OBJECT    Do not gather statistics right before bulk DML                                       0
        14 LockVolatileTable                OBJECT    Statistics for objects with volatile data should be locked                           0
        15 UnlockNonVolatileTable           OBJECT    Statistics for objects with non-volatile should not be locked                        0
        16 MaintainStatsConsistency         OBJECT    Statistics of dependent objects should be consistent                                 0
        17 AvoidDropRecreate                OBJECT    Avoid drop and recreate object seqauences                                            0
        18 UseIncremental                   OBJECT    Statistics should be maintained incrementally when it is beneficial                  0
        19 NotUseIncremental                OBJECT    Statistics should not be maintained incrementally when it is not beneficial          0
        20 AvoidOutOfRange                  OBJECT    Avoid Out of Range Histogram endpoints                                               0
        21 UseAutoDegree                    OBJECT    Use Auto Degree for statistics collection                                            0
        22 UseDefaultObjectPreference       OBJECT    Use Default Object Preference for statistics collection                              0
        23 AvoidAnalyzeTable                OBJECT    Avoid using analyze table commands for statistics collection                         0

24 rows selected.

As you can see the rules fall into three groups: system, operation, and object – and you can’t help noticing at all three levels how commonly the theme is: “just stick with the defaults!”.

As so often happens when I start writing a catch-up or “remind myself” not I found that Tim Hall has already written all about it.

When AWS SCT Unable to Connect to MySQL in RDS or EC2

Pakistan's First Oracle Blog - Fri, 2019-03-22 05:27
AWS Schema Conversion Tool (SCT) is one of the must tool for a successful migration of databases to AWS RDS.

If you are trying to connect to MySQL hosted on EC2 instance or RDS and unable to make the connection despite of setting the security groups correctly and making sure that port, hostname, username and password are right, then first check the log of SCT.

2019-03-22 19:40:16.866 [   1]     GENERAL INFO    global_settings:
    app_folder=AWS Schema Conversion Tool
    console_log_folder=C:\Users\mirza\AWS Schema Conversion Tool\Log
    facade_log_folder=C:\Users\mirza\AWS Schema Conversion Tool\Log
    log_folder=C:\Users\mirza\AWS Schema Conversion Tool\Log
    log_folder_extractors=C:\Users\mirza\AWS Schema Conversion Tool\Extractor Log
    log_folder_extractors_cassandra=C:\Users\mirza\AWS Schema Conversion Tool\Extractor Log\Cassandra
Caused by: com.amazon.sct.dbloader.DbLoaderHandledException: Connection wasn't established. Check connection properties.
at com.amazon.sct.dbloader.DbLoader.checkConnection(DbLoader.java:512)
at com.amazon.sct.dbloader.DbLoader.connect(DbLoader.java:349)
at com.amazon.sct.dbloader.DbLoaderContainer.checkAccessibility(DbLoaderContainer.java:25)
at com.amazon.sct.task.TestConnectionTask.call(TestConnectionTask.java:26)
at com.amazon.sct.task.TestConnectionTask.call(TestConnectionTask.java:12)
at javafx.concurrent.Task$TaskCallable.call(Task.java:1423)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
... 1 more

In this case, there are no errors about time out which commonly refers to security group configuration or any about the credential issue. Here the issue is not with SCT or any of AWS component, rather its about the user which you are using to connect to MySQL.

Create user MySQL as follows and try and it should work:

CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass';
CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';

GRANT ALL ON *.* TO 'myuser'@'localhost';
GRANT ALL ON *.* TO 'myuser'@'%';

Then first test connection using MySQL workbench and then try with SCT.

Hope it helps.

Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator