Feed aggregator

AWS: Accessing S3 buckets from the internet and from ec2 instances (2)

Dietrich Schroff - Wed, 2019-04-10 12:42
After accessing a S3 bucket from an ec2 instance by adding an IAM role to my EC2 instance, i tried to get the access from an ec2 instance by using a AWS endpoint.

First step: Launch an ec2 instance within your VPC and try to access your S3 bucket:

[ec2-user@ip-172-31-30-93 ~]$ wget https://s3-eu-west-1.amazonaws.com/my.webtest/website.json
--2019-02-02 18:29:28--  https://s3-eu-west-1.amazonaws.com/my.webtest/website.json
Auflösen des Hostnamen »s3-eu-west-1.amazonaws.com (s3-eu-west-1.amazonaws.com)«... 52.218.16.244
Verbindungsaufbau zu s3-eu-west-1.amazonaws.com (s3-eu-west-1.amazonaws.com)|52.218.16.244|:443... verbunden.
HTTP-Anforderung gesendet, warte auf Antwort... 403 Forbidden
2019-02-02 18:29:28 FEHLER 403: Forbidden.

Second step: change the bucket policy to this:

{
    "Version": "2012-10-17",
    "Id": "Policy1119991119999",
    "Statement": [
        {
            "Sid": "Access-to-specific-VPC-only",
            "Effect": "Allow",
            "Principal": "*",
            "Action": "*",
            "Resource": [
                "arn:aws:s3:::my.webtest",
                "arn:aws:s3:::my.webtest/*"
            ],
            "Condition": {
                "StringEquals": {
                    "aws:sourceVpc": "vpc-12e0cc74"
                }
            }
        }
    ]
}
The access to the bucket is still forbidden. So next step is to add the endpoint:
Goto VPC -> endpoint:
And then choose the following:



(Here you have to select your route table ID!!!)

After that everything works like expected:
[ec2-user@ip-172-31-30-93 ~]$ wget https://s3-eu-west-1.amazonaws.com/my.webtest/website.json
--2019-02-02 18:29:51--  https://s3-eu-west-1.amazonaws.com/my.webtest/website.json
Auflösen des Hostnamen »s3-eu-west-1.amazonaws.com (s3-eu-west-1.amazonaws.com)«... 52.218.53.66
Verbindungsaufbau zu s3-eu-west-1.amazonaws.com (s3-eu-west-1.amazonaws.com)|52.218.53.66|:443... verbunden.
HTTP-Anforderung gesendet, warte auf Antwort... 200 OK
Länge: 130 [application/json]
In »»website.json.1«« speichern.

100%[===============================================================================================================>] 130         --.-K/s   in 0s     

2019-02-02 18:29:51 (5,28 MB/s) - »»website.json.1«« gespeichert [130/130]

Cruise Lines Serve Up Better Dining Experiences with Oracle

Oracle Press Releases - Wed, 2019-04-10 07:00
Press Release
Cruise Lines Serve Up Better Dining Experiences with Oracle With Oracle point-of-sale system passengers can order food and drinks anytime from stem to stern

SEATRADE CONFERENCE, Miami Beach, Fla.—Apr 10, 2019

Food and drinks are a central part of any cruise experience with travelers expecting a wide variety of unique menus around the clock. For cruise ships, the stakes are high to deliver seamless experiences with unmatched service. With Oracle Hospitality solutions, cruise ships have the agility and tools to offer passengers their favorite foods and beverages from anywhere on the ship, at any time during their shipboard holiday.

“One of the reasons consumers love cruises is for the food and beverage options. From ‘all-you-can-eat’ buffets to the specialty restaurants, the onboard dining experience is becoming more diverse and sophisticated. Making sure guests have the ultimate food experience is critical, making it imperative that cruise lines use technology that is purpose built for their needs – and this is exactly what Oracle delivers,” said Ingo Soerensen, AVP, global cruise sales, Oracle Hospitality.

Oracle Hospitality Simphony shipboard point-of-sale is fully integrated with Oracle Hospitality Shipboard Property Management System for a cash-free environment, real-time tracking of meal orders, table reservations, and special packages. Delivered on fixed and mobile devices, Simphony enables guests to order everywhere on the ship from room service and specialty restaurants to bars and coffee stations that can be charged directly to a guest’s cruise account.

Simphony runs on Oracle MICROS Compact Workstations and Oracle MICROS Tablet hardware, enabling cruise staff to move freely about the ship taking orders and better serving customers. The devices are portable, compact, spill and water resistant, and offer a daylight viewable screen - perfect for poolside order taking. A mobile belt printer also produces immediate receipts and offers fingerprint biometrics to ensure fast, easy and secure login. Oracle MICROS Workstation 310 can also run on batteries for ultimate flexibility.

Oracle Hospitality, with 9 of the 10 top cruise brands as customers, is exhibiting at the Seatrade Conference in Miami, Florida April 9-11, 2019 in booth #1901. Come visit us to see our flagship cruise solutions including Shipboard Property Management System, Fleet Management System and a live demo of Simphony on Oracle MICROS hardware allowing attendees to see how an order for an espresso, latte or iced coffee is taken, sent to the kitchen and delivered right to the booth.

Contact Info
Valerie Beaudett
Oracle
+1 650.400.7833
valerie.beaudett@oracle.com
About Oracle Hospitality

Oracle Hospitality offers a range of software, hardware and related services—including a leading portfolio of cruise solutions 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.

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

Valerie Beaudett

  • +1 650.400.7833

CoreDial Calls on Oracle to Bolster IP Network Quality and Reliability

Oracle Press Releases - Wed, 2019-04-10 07:00
Press Release
CoreDial Calls on Oracle to Bolster IP Network Quality and Reliability Oracle Empowers Cloud Communication Leader to Seamlessly Migrate Between Platforms and Improve Network Troubleshooting

Redwood Shores, Calif.—Apr 10, 2019

CoreDial, LLC, a leading provider of cloud communications and UCaaS services, has selected Oracle Communications to help the company deliver high-quality, reliable services. Today, more than 800 channel partners rely on CoreDial to deliver services to 26,000 businesses in the United States.

“At CoreDial our number one priority is serving our partners and providing them unparalleled services that, combined with our channel optimized platform, business model, and exceptional people, enable them to deliver the best communications networks to their customers,” said Alan Rihm, chief executive officer, CoreDial. “Oracle plays a key role in helping us meet this objective and these new solutions have already greatly improved the quality, flexibility, reliability and uptime of services on our network, resulting in more consistent uptime for our partners and their customers.”

Leveraging Oracle Communications Session Border Controller (SBC), Subscriber-Aware Load Balancer and Operations Monitor, CoreDial will be able to improve real-time communications services across Internet Protocol (IP) network borders and provide interoperability between multiple private branch exchanges as they migrate across platforms.

“In an increasingly competitive market, networks that will power future generation IP services must deliver superior performance, flexibility and security,” said Doug Suriano, senior vice president and general manager, Oracle Communications. “Our technology empowers CoreDial for future growth, easily scaling to meet their business needs.”

Enhancing Services with a Modern, Responsive Communications Network

CoreDial selected Oracle SBC to leverage the offering’s inherent abilities to protect and defend CoreDial’s network and services against a wide breadth of security threats. For example, the ability to deny access to requests that reach abusive levels allows CoreDial to prevent its customers’ services from being interrupted by bad actors.  Oracle SBC has also already improved critical service provider requirements for CoreDial, including interoperability, reliability and quality, regulatory compliance, and cost optimization.

Augmenting Oracle SBC with Oracle’s Subscriber-Aware Load Balancer, CoreDial gains linear, non-disruptive scaling of up to 10 million subscribers from a single address. The solution creates a truly geo-redundant VoIP network as well. For example, in the case of a catastrophic event, CoreDial’s Philadelphia or Phoenix data centers can assume responsibilities for the network.

In addition, Oracle Communications Operations Monitor has helped CoreDial to increase visibility into their network traffic (including non-Oracle SIP devices) and to accelerate troubleshooting. Oracle’s unique, end-to-end session correlation and real-time analysis capabilities enable the CoreDial IT team to rapidly detect, isolate, and resolve problems anywhere in multivendor VoIP and UC networks.

Contact Info
Katie Barron
Oracle
+1.202.904.1138
katie.barron@oracle.com
Brent Curry
Hill+Knowlton Strategies
+1.312.255.3086
brent.curry@hkstrategies.com
About Oracle Communications

Oracle Communications provides integrated communications and cloud solutions for Service Providers and Enterprises to accelerate their digital transformation journey in a communications-driven world from network evolution to digital business to customer experience. www.oracle.com/communications

To learn more about Oracle Communications industry solutions, visit: Oracle Communications LinkedIn, or join the conversation at Twitter @OracleComms.

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.

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

Brent Curry

  • +1.312.255.3086

Butler Students Tap Oracle Cloud to Make Responsible Financial Aid Choices

Oracle Press Releases - Wed, 2019-04-10 07:00
Press Release
Butler Students Tap Oracle Cloud to Make Responsible Financial Aid Choices University to Integrate Oracle Student Financial Planning to Match Students with their Best Financial Aid Options

Redwood Shores, Calif.—Apr 10, 2019

Student debt continues to be a massive issue for American students who collectively owe an estimated $1.5T in loans. Navigating cost and financial aid is a crucial step in a complex process toward student attainment of higher education. Butler University wants to increase student success through a more efficient process and sound fiscal decisions. Deploying Oracle Student Financial Planning, part of Oracle  Student Cloud, the university will be able to guide students towards more responsible borrowing and course-planning that will keep them on track towards their graduation goals.

Butler, a private university in Indianapolis, integrates the liberal arts with a professional education to provide the highest quality education. It fosters a stimulating intellectual community built upon interactive dialogue and inquiry among students, faculty and staff.

With cloud technology providing real-time synchronization with government systems and automated, student-centric processes, Oracle Student Financial Planning will let Butler financial aid officers and administrators spend more time advising students on financial aid choices and less time packaging their aid. Direct integration with Oracle PeopleSoft Campus Solutions will also enable the university to cut the costs of ongoing financial aid compliance. To date, Oracle Student Financial Planning has processed $2.9 billion in financial aid, representing 15 million automated packages.

“Cost should not be the gating factor in individuals getting the education they desire,” said Pete Williams, CIO at Butler University. “With Oracle Student Cloud, we will have the tools we need to improve student success by delivering a more transparent and effective financial aid experience.”

Oracle Student Financial Planning supports traditional and non-traditional academic models and drives institutional transparency, regulatory compliance, superior student visibility, and control of education financing options. With it, institutions can leverage advanced automated technologies to manage comprehensive fund management, calculate and repackage student financial aid based on pre-set triggers, optimize both private and public funding sources based on student financing requirements, reduce time and resources spent on supporting manual processes, and reduce the complexity of annual audits and compliance risk.

“Financial aid has been a frustrating and confusing process for many students, making it difficult to find options that best meets their qualifications and needs,” said Vivian Wong, GVP higher education development, Oracle. “With Oracle Financial Planning, we are enabling progressive universities such as Butler to match students with their best financial options, giving them the resources they need to focus on reaching their academic goals.”

Contact Info
Katie Barron
Oracle
+1.202.904.1138
katie.barron@oracle.com
Kristin Reeves
Oracle
+1.925.787.6744
kris.reeves@oracle.com
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.

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

Creating dummy data for chart

Tom Kyte - Tue, 2019-04-09 22:06
Hi, I am generating a bar chart in Apex and my data has few gaps as a result there are gaps between bars.If I fill data in query with zero value then my bar chart will be correctly displayed. Below is data and required output <code>create table...
Categories: DBA Blogs

Like Operator with IN clause

Tom Kyte - Tue, 2019-04-09 22:06
I have to compare more than one Patter using LIKE operator Say I want to prepare query SELECT name FROM employee WHERE name <b>LIKE IN</b> ('sasho','shashi%','rags')
Categories: DBA Blogs

Goldengate TDE Extract support for SQL Server

VitalSoftTech - Tue, 2019-04-09 13:41
Does GoldenGate support extraction for Transparent Data Encrytion on SQL Server Database?
Categories: DBA Blogs

10 Tips for Marketing IT Services

VitalSoftTech - Tue, 2019-04-09 12:46
Based on my experience in marketing IT services, the competition is really high and very challenging. I’m sure you will agree to that! A lot of online entrepreneurs, especially those that are dealing with IT services like you are always on the search for the best marketing tips. You always needed new information so that […]
Categories: DBA Blogs

Latest ACE Technical Articles: March 2019

OTN TechBlog - Tue, 2019-04-09 11:05

What does is take to spend countless hours hunched over a keyboard pounding out code, only to hunch yet again to write a technical article? Beyond the necessary technical skill and expertise, my guess is that it also takes massive quantities of coffee. I have no hard evidence to support that theory other than the long lines at any Starbucks within range of any developer conference. I didn't ask these ACEs how much coffee they consumed as they wrote these articles. They may not drink coffee at all. But the articles listed below are clear evidence that these fine people had the energy and the inclination to transfer their expertise and experience onto the page were you can absorb it.

So pour yourself a cup of whatever keeps you going and soak up some of what these ACEs are serving,

Oracle ACE Director Nassayam BashaNassyam Basha
Database Expert, eProseed
Oracle ACE Director Syed Jaffar HussainSyed Jaffar Hussain
Author, Speaker, Oracle Evangelist, Award winning DBA
Oracle ACE David FitzjarrellDavid Fitzjarrell
Oracle Database Administrator, Pinnacol Assurance
Oracle ACE Michael GanglerMichael Gangler
Database Expert, eProseed
Oracle ACE Asscociate Jian JiangJian Jiang
Yunqu Tech
  Oracle ACE Associate Bin HongBin Hong
Senior MySQL DBA, Shanghai Action Information Technology Co., Ltd.
Additional Resources

New Bookmark for the Journey

Steven Chan - Tue, 2019-04-09 09:01

Contributing Author: Robert Farrington

Greetings, EBS Technology Blog readers!

As some of you may have noticed, on Friday, April 5, 2019, the URL of this blog changed to https://blogs.oracle.com/ebstech. The change was made to better reflect its reason for existing: to provide unmatched insider coverage of the wide range of technology used by Oracle E-Business Suite.

This update is the latest stage in the evolution of the EBS Technology Blog that Steven Chan started in 2006. Since Steven updated you at the end of January 2019 about his extended leave, we've continued to provide a comprehensive range of technology updates from our ever-growing team of contributors.

You will be pleased to hear that our blog infrastructure support team has made the change seamlessly, with a custom configuration that transparently redirects to our new URL. We do recommend, however, that you update your bookmarks with the new URL.

RSS Feed

If you are a subscriber to our RSS feed, this too will continue to function in the same way, with no action needed by you. And if you have not subscribed, you are invited to do so by clicking on the orange RSS icon below and towards the right of the blog title banner. The feed is a great way for you to get automated notifications of the articles published on this blog, conveniently and at no cost.

Get in Touch

Please don't hesitate to let us know how we are doing on any aspect of this blog - what you'd like to see more of, or any other suggestions. You can comment directly on this article, or drop us an email.

References Related Articles
Categories: APPS Blogs

Oracle Enables Utilities to Embrace a Customer-Centric Future

Oracle Press Releases - Tue, 2019-04-09 06:00
Press Release
Oracle Enables Utilities to Embrace a Customer-Centric Future New enhancements to CIS offerings empower utilities to improve operations while providing personalized insights to better engage customers

CS WEEK, Phoenix, Arizona—Apr 9, 2019

The utility industry is undergoing a massive evolution as utility customers are becoming more active consumers and producers. The explosion of data from a multitude of devices, including meters, IoT sensors, and smart home appliances, require utilities to rethink old business and billing models to meet the demands of this new utility economy.

As such, Oracle continues to enhance its leading customer solutions platform to deliver the tools water, gas, and energy utilities need to address this changing market dynamic. With a modern user interface, deep analytics, and built-in integrations with operational device data management and customer self-service capabilities, utilities can better engage customers at scale. For example, they will be able to tap user interface innovations to target customers for new programs based on personalized information on their utility usage. The new features are now available across Oracle’s customer solutions, including Customer to Meter and Customer Cloud Service (CCS).

“In this new utility economy, the customer is transitioning from a billable account to a participant in the utility business model. With changes in rates, regulations, and production, customers are looking for more information regarding their usage and bill and how they can lessen the impact of both,” said Hillary Martin, senior director, Oracle Utilities. “Antiquated customer systems simply don’t allow utilities the flexibility and intelligence they need in this changing market paradigm. With our continued updates, Oracle is bringing utilities to the leading edge of innovation.”

Driving Customer Innovation at Scale

Customer Cloud Service brings together Oracle Utilities’ market-leading customer information system (CIS) and advanced meter data management capabilities into a single meter-to-cash-to-customer solution on a shared database and technology stack. By bringing metering, customer account and revenue data into a common view, enriched by deep analytics and data visualization tools, utilities can drive greater business value from the increasing amounts of data and convert it into actionable business insights.

Built on the Oracle Cloud and delivered as the industry’s first fully supported Software as a Service (SaaS) solution, CCS features automated patching, upgrades, security, and standard SaaS services—freeing up valuable utility resources. With CCS, utilities gain a complete view of their customers and significant cost reductions compared to managing two separate systems. 

With these new innovations, CCS and Customer to Meter utility customers can benefit from:

  • User Experience Enhancements: Guided by dozens of years working closely with customers on their CIS initiatives, a decade of Opower behavioral science research and design best practices, Oracle customer solutions feature a new, clean and modern interface and improvements to the ways end users interact with data, insights, content and context. With guided workflows and intuitive design, even brand new customer service representatives can deliver the same level of service as long-term call center experts.
  • Advanced Analytics: With the exponential growth in volumes and sources of data, utilities have an ever-expanding opportunity to derive value from that information to support better decisions across the business. With pre-built analytics embedded in both Oracle Utilities customer solutions, users can drive insight throughout the customer lifecycle. This allows utilities to visualize data clearly across systems and slice and dice to discover fresh insights that support customer engagement, revenue management, and more. With Oracle, utilities have the power of data science and machine learning at their fingertips, in pre-packaged solutions designed specifically for utility needs.
  • Operational Device Management: enables utilities to track meter and device inventory and monitor performance from within the same system capturing meter reads and customer accounts. This customer-device-data integration in a single solution not only reduces technology costs for utilities but also provides a more complete, “single source of truth” picture across an increasingly distributed network. This helps utilities move beyond the meter to leverage data across all relevant devices so they can explore and scale to new connected home services and more.
  • Digital Self Service: delivers a crucial component in providing modern customer experiences. By integrating Oracle Utilities Digital Self Service (DSS) and Oracle customer solutions, utilities can deliver superior service across channels and devices while driving down operating costs. In addition, based on a decade of user insights and design experience from Opower, Oracle DSS provides a strong web foundation to launch additional customer engagement programs. 
 

“Utility distribution is no longer a linear equation where a customer uses a resource and then is billed for it. With the industry’s most connected, end-to-end customer platforms, Oracle is enabling utilities to become trusted advisors in this new journey while modernizing operations for an evolving customer-centric utility future,” added Martin.

Contact Info
Kristin Reeves
Oracle
+1.925.787.6744
kris.reeves@oracle.com
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.

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

Kristin Reeves

  • +1.925.787.6744

How To Create Compute (Linux or Windows) in Oracle Cloud (OCI)

Online Apps DBA - Tue, 2019-04-09 05:41

How To Create Compute (Linux or Windows) in Oracle Cloud (OCI) Compute, Instance or Machine are used interchangeably and represents a VM or BM shapes in Oracle’s Gen2 Cloud (OCI)! Thinking, ✔ How To Create a Linux or Windows Machine in OCI? ✔ What are various options like AD, Image Source, Shape, of FD mean? […]

The post How To Create Compute (Linux or Windows) in Oracle Cloud (OCI) appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

PostgreSQL 12: Copying replication slots

Yann Neuhaus - Tue, 2019-04-09 04:44

The concept of replication slots was introduced in PostgreSQL 9.4 and was created to prevent a primary instance to delete WAL that a replica still needs to apply. That could happen when you have a network interruption or the replica was down for another reason. With replication slots you can prevent that at the downside that your master could fill up your disk if the interruption is too long. This concept of a “physical replication slot” was then advanced so you can also create “logical replication slots” which are used in logical replication which made in into PostgreSQL 10. Now with PostgreSQL 12 being in active development another great feature made it into PostgreSQL core: Copying replication slots.

What might that be good for? Lets assume the following scenario:

  • You want to attach two replicas to your master instance
  • You want both replicas to use a physical replication slot
  • You want to build both replicas from the same basebackup and to start at the same position

What you can do in PostgreSQL is to create base backup that will create a physical replication slot:

postgres@pgbox:/home/postgres/ [PGDEV] psql -X -c "select * from pg_replication_slots" postgres
 slot_name | plugin | slot_type | datoid | database | temporary | active | active_pid | xmin | catalog_xmin | restart_lsn | confirmed_flush_lsn 
-----------+--------+-----------+--------+----------+-----------+--------+------------+------+--------------+-------------+---------------------
(0 rows)

postgres@pgbox:/home/postgres/ [PGDEV] mkdir -p /var/tmp/basebackup
postgres@pgbox:/home/postgres/ [PGDEV] pg_basebackup --create-slot --slot myslot --write-recovery-conf -D /var/tmp/basebackup/
postgres@pgbox:/home/postgres/ [PGDEV] psql -X -c "select * from pg_replication_slots" postgres
 slot_name | plugin | slot_type | datoid | database | temporary | active | active_pid | xmin | catalog_xmin | restart_lsn | confirmed_flush_lsn 
-----------+--------+-----------+--------+----------+-----------+--------+------------+------+--------------+-------------+---------------------
 myslot    |        | physical  |        |          | f         | f      |            |      |              | 0/2000000   | 
(1 row)

(Please note that there is no more recovery.conf in PostgreSQL 12 so the recovery parameters have been added to postgresql.auto.conf)

The replication slot will not be dropped after pg_basebackup finished and you can use it to attach a new replica. But before doing that: As of PostgreSQL 12 you can copy the slot and then attach a second replica to the copied slot, so both replicas will start at the same position:

postgres@pgbox:/home/postgres/ [PGDEV] psql -X -c "select pg_copy_physical_replication_slot('myslot','myslot2')" postgres
 pg_copy_physical_replication_slot 
-----------------------------------
 (myslot2,)
(1 row)

postgres@pgbox:/home/postgres/ [PGDEV] psql -X -c "select * from pg_replication_slots" postgres
 slot_name | plugin | slot_type | datoid | database | temporary | active | active_pid | xmin | catalog_xmin | restart_lsn | confirmed_flush_lsn 
-----------+--------+-----------+--------+----------+-----------+--------+------------+------+--------------+-------------+---------------------
 myslot    |        | physical  |        |          | f         | f      |            |      |              | 0/8000000   | 
 myslot2   |        | physical  |        |          | f         | f      |            |      |              | 0/8000000   | 
(2 rows)

As you can see both replication slots have the same value for “restart_lsn”. This will make it very easy to use the basebackup for the two replicas and start them from the same position:

postgres@pgbox:/home/postgres/ [PGDEV] mkdir -p /var/tmp/replica1
postgres@pgbox:/home/postgres/ [PGDEV] mkdir -p /var/tmp/replica2
postgres@pgbox:/home/postgres/ [PGDEV] cp -pr /var/tmp/basebackup/* /var/tmp/replica1/
postgres@pgbox:/home/postgres/ [PGDEV] cp -pr /var/tmp/basebackup/* /var/tmp/replica2/
postgres@pgbox:/home/postgres/ [PGDEV] sed -i 's/myslot/myslot2/g' /var/tmp/replica2/postgresql.auto.conf 
postgres@pgbox:/home/postgres/ [PGDEV] echo "port=8888" >> /var/tmp/replica1/postgresql.auto.conf 
postgres@pgbox:/home/postgres/ [PGDEV] echo "port=8889" >> /var/tmp/replica2/postgresql.auto.conf 
postgres@pgbox:/home/postgres/ [PGDEV] chmod o-rwx /var/tmp/replica1
postgres@pgbox:/home/postgres/ [PGDEV] chmod o-rwx /var/tmp/replica2

What happened here:

  • Restore the same basebackup to the new replica locations
  • Change the slot to use for the second replica to our copied slot name
  • Change the ports of both replicas because we are running on the same host
  • Fix the permissions so pg_ctl will not complain

That’s it. We can startup both replicas:

postgres@pgbox:/home/postgres/ [PGDEV] pg_ctl -D /var/tmp/replica1/ start
postgres@pgbox:/home/postgres/ [PGDEV] pg_ctl -D /var/tmp/replica2/ start
postgres@pgbox:/home/postgres/ [PGDEV] psql -X -p 8888 -c "select pg_is_in_recovery()" postgres
 pg_is_in_recovery 
-------------------
 t
(1 row)

postgres@pgbox:/home/postgres/ [PGDEV] psql -X -p 8889 -c "select pg_is_in_recovery()" postgres
 pg_is_in_recovery 
-------------------
 t
(1 row)

Quite easy and we can confirm that both replicas are at the same location as previously:

postgres@pgbox:/home/postgres/ [PGDEV] psql -X -c "select * from pg_replication_slots" postgres
 slot_name | plugin | slot_type | datoid | database | temporary | active | active_pid | xmin | catalog_xmin | restart_lsn | confirmed_flush_lsn 
-----------+--------+-----------+--------+----------+-----------+--------+------------+------+--------------+-------------+---------------------
 myslot    |        | physical  |        |          | f         | t      |      15622 |      |              | 0/9000148   | 
 myslot2   |        | physical  |        |          | f         | t      |      15632 |      |              | 0/9000148   | 
(2 rows)

You can also copy logical replication slots, of course. Nice, thanks all involved.

Cet article PostgreSQL 12: Copying replication slots est apparu en premier sur Blog dbi services.

JSON path expression syntax error

Tom Kyte - Tue, 2019-04-09 03:46
Hi TOM, I am trying to use json_value function infor loop as below. then getting error as 'PL/SQL: ORA-40442: JSON path expression syntax error'. Could you please help me with solution. Thanks set serveroutput on; DECLARE p_dn_list CLO...
Categories: DBA Blogs

Parallel recursive WITH Enhancements

Tom Kyte - Tue, 2019-04-09 03:46
Team, was reading about this feature Parallel recursive WITH clause enhancements in 12.2 database from the below link: <u>https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqlrf/SELECT.html#GUID-CFA006CA-6FF1-4972-821E-6996142A51C...
Categories: DBA Blogs

Attempting primary / standby's using same scan listener name and configuration on both clusters.

Tom Kyte - Tue, 2019-04-09 03:46
Hi Tom, I've never gotten through to you in 20 years, so hopefully you'll be available as I could use some sound advice (you're so in demand, I gave up about 10 years ago :-) Here are the particulars: * We're planning a migration from data cen...
Categories: DBA Blogs

Check db_link from several databases, from one server via dv_links to these servers

Tom Kyte - Tue, 2019-04-09 03:46
Hello, I need to check db_links from all of my servers and I want to check it from procedure or view on statistic db server. Statistic db server have db_links to all of my db's. It is possible? If it is possible how I can do this?
Categories: DBA Blogs

Why the same query performs much slower in PL/SQL procedure/package than directly querying

Tom Kyte - Tue, 2019-04-09 03:46
Dear Tom, I have a complex query joining multiple tables which takes about 10 to 15 seconds to return results. There are 3 layers (2 sub queries) of the "FROM" to get the final results. However, if I create a procedure to run the same codes, whic...
Categories: DBA Blogs

To create multiple instances and databases on same unix machine

Tom Kyte - Tue, 2019-04-09 03:46
I have a requirement to create 2 instances and 2 databases on same unix machine. Do I need multiple homes, I think not because it is same version (11g). I already created one instance/database using OUI. Are these steps right for creating second one?...
Categories: DBA Blogs

Cube Viewer - A new way of analyzing operational data in OUAF

Anthony Shorten - Mon, 2019-04-08 19:23

In past releases of Oracle Utilities Application Framework, Query Zones have been a flexible way of display lists of information with flexible filters and dynamic interaction including creating and saving views of the lists for reuse. In Oracle Utilities Application Framework V4.3.0.6.0 and above, we introduced the Cube Viewer, which extends the query model to support pivot style analytical analysis and visualization of operational data. The capability extends the ConfigTools (aka Task Optimization) capability to allow implementations to define cubes and provide interactivity for end users on operational data.

The Cube Viewer brings together a number of ConfigTools objects to build an interactive visualization with the following capabilities:

  • Toolbar. An interactive toolbar to decide the view of the cube to be shown by the user. This includes saving a view including the criteria for reuse.
  • Settings. The view and criteria/filters to use on the data set to help optimize the analysis. For example you might want to see the raw data, a pivot grid, a line chart or bar chart. You can modify the dimensions shown and even add rules for how certain values are highlighted using formats.
  • Filters. You can decide the filters and values shown in the grid within the selection criteria.
  • View. The above configuration results in a number of views of the data.

An example of the Cube Viewer is shown below:

Example Cube ViewerThe Cube Viewer has many features that allow configuration to optimize and highlight critical data whilst allowing users to interact with the information presented. In summary the key features are:

  • Flexible View Configuration. It is possible to use the configuration at runtime to determine the subset the data to analyze and display format as a saved view. As with query portals, views can be saved and reused. These views can be Private, Shared (within an Access Group) or Public.
  • Formatting Support. To emphasize particular data values, it is possible at runtime to alter their display using simple rules. For example:

Example formatting

  • Visual and Analytical Views. The data to be shown can be expressed in a number of view formats including a variety of graph styles, in grid format and/or raw format. This allows users to interpret the data according to their preferences.
  • Configurable using ConfigTools. The Cube View uses and extends existing ConfigTools objects to allow greater flexibility and configuration control. This allows existing resources who have skills in ConfigTools.
  • Comparison Feature. Allows different selection criteria  sets to be used for comparison purposes.  This allows for difference comparison between two sets of data.
  • Save View as "Snapshot". It is possible to isolate data using the interactive elements of the Cube Viewer to find the data you want to analyze. Once found, you can save the configuration and filters etc for recall later, very similar to the concept of a "Snapshot". For example, if you find some data that needs attention, you can save the view and then reuse it to show others later if necessary.
  • Function Support. In the details additional functions such as Average Value, Count, Maximum Value, Median Value, Minimum Value, Standard Deviation and Sum are supported at the row and column levels.  For example:

Example Functions

Cube Views may be available with each product (refer to documentation shipped with the product) and Cubes Views can be configured by implementers and reused across users as necessary. Over the next few weeks a step by step guide will be published here and other locations to show the basic process and some best practices of building a Cube Viewer.

Pages

Subscribe to Oracle FAQ aggregator