Feed aggregator

Thoughts on RMAN Backup Strategy Part 3

Michael Dinh - Mon, 2017-09-18 18:42

Thoughts on RMAN Backup Strategy Part 2

Thoughts on RMAN Backup Strategy

Linux Locking using flock

From cron:

00 03 * * 0          rman_db_backup.sh 0     > /tmp/rman_l0.log 2>&1
00 03 * * 1,2,3,4,5  rman_db_backup.sh 1     > /tmp/rman_l1.log 2>&1
30 * * * *           rman_archive_backup.sh  > /tmp/rman_arch.log 2>1

Notice from cron, DB backup starts at 3am and achivelog backup starts at 30m after the hour.

What happens when DB performs backup database plus archivelog delete input?

What happens when failed backup does not exits from shell script and continue with delete noprompt obsolete;?

Just a few thoughts:

  1. Use flock to prevent 2 backups for running at the same time.
  2. User error trapping to exit from shell script vs continuing to next step.
  3. Don’t delete archivelog from DB backup.
  4. Delete archivelog from ARC backup or schedule MW tasks.

 


SRVCTL Status Doesn't Show RAC instances Running Unlike SQLPLUS

Pakistan's First Oracle Blog - Mon, 2017-09-18 18:34
Yesterday, I converted a single instance 12.1.0.2.0 physical standby database to a cluster database with 2 nodes.

After converting that to RAC database, I brought both instances up in mount state on both nodes and they came up fine and I started managed recovery on one node and it started working perfectly fine and got in sync with the primary.


Then I added them as a cluster resource by srvctl like this:

$ srvctl add database -d mystb -o /d01/app/oracle/product/12.1.0.2/db_1 -r PHYSICAL_STANDBY -s MOUNT
$ srvctl add instance -d mystb -i mystb1 -n node1
$ srvctl add instance -d mystb -i mystb2 -n node2

But srvctl status didnt show it running:

$ srvctl status database -d mystb -v
Instance mystb1 is not running on node node1
Instance mystb2 is not running on node node2

While from SQLPLUS, I could see both instances mounted:

SQL> select instance_name,status,host_name from gv$instance;

INSTANCE_NAME     STATUS       HOST_NAME
---------------- ------------ ----------------------------------------------------------------
mystb1             MOUNTED      node1
mystb2              MOUNTED      node2

So I needed to start database in srvctl (thought it was already started and mounted) just to please srvctl:

So I ran this:

$ srvctl start database -d mystb

The command didn't do anything but change the status of resource on the cluster. After running above, it worked:


$ srvctl status database -d mystb -v
 Instance mystb1 is running on node node1
 Instance mystb2 is running on node node2
Categories: DBA Blogs

Added save and restore data function to PythonDBAGraphs

Bobby Durrett's DBA Blog - Mon, 2017-09-18 18:30

I pushed out a quick change to PythonDBAGraphs to automatically save the data for any graph that you make so that you can redraw the graph later. This is better than saving an image file because the redrawn graph lets you see details about the points on the graph when you hover the mouse over the points.

Now when you generate a graph you get a line like this:

Saving data in C:\temp\ASH active session count for MYDB database.txt

When you want to see the graph again you run show_saved.py like this:

python show_saved.py
Enter name of data file to be restored: C:\temp\ASH active session count for MYDB database.txt

Bobby

Categories: DBA Blogs

“Oracle Indexing Internals & Best Practices” Seminar: Australia 2017 Tour (Stage)

Richard Foote - Mon, 2017-09-18 17:10
I’ll be running a fully revised and updated version of my acclaimed “Oracle Indexing Internals and Best Practices” seminar throughout Australia in Oct/Nov 2017. Previous versions of this seminar have been hugely popular and run in some 18 countries. This updated version will feature lots of new material including 12c related indexing capabilities and recommendations. […]
Categories: DBA Blogs

Business Intelligence for the Finance Industry

Nilesh Jethwa - Mon, 2017-09-18 15:20

The banking and finance industry is experiencing continuous changes brought about by advances in technology. The changes are welcome – however not without the accompanying challenges.

As a result, the kind of market we now have is dynamic and Wall Street is making the necessary adjustments, not to dampen vibrancy in the market, but to improve strategies in line with the changing technology. That requires developing new tools and implementing them correctly.

Business Intelligence (BI) Tools for Financial Institutions

There are a lot of tools that have been developed and ones that are worth discussing about are business intelligence tools that help managers identify better management practices and make smarter business decisions. A finance management dashboard is one of these tools.

Here’s a quick look on how this kind of instruments can help in those areas and in other areas such as profitability, reduction of risks and creating competitive advantage.

  • Operational Efficiencies

Improving efficiency is a key to winning in the competition. BI tools can analyze how efficient are the operational processes leading to maximization of resources and expertise and to reduction of operational cost.

How good are you at customer experience? A dashboard can help you improve this at the point where your employees and customers come face to face.

  • Products and Services

BI tools do not only allow managers to track which products and services are performing well but also give them insights on the needs and experience of their customers.

  • Marketing

Do you want to know the best market segment to target? A simple dashboard is all you need to have a good picture of it. The tool can also show you which customer profile gives you the highest revenue and the one that should be put lowest in the list of priorities.

  • Customer Retention

There are customers who are loyal to you. You need to know the reasons why they are staying with your business, but you also need to identify why others are leaving.

Business analytic tools can help you determine the reasons why and lead you to taking steps to improve your retention rates.

  • Risk Reduction

This is an ever-changing world where nothing is 100% certain. How would you keep track of your customers and internal organizations so that you can early detect possibilities of fraud?

You can use BI tools for this. There are also lots of benefits from knowing your clients’ financial capacities, which a dashboard can provide you 24/7.

  • Investment

At some points, managers run out of invest ideas and strategies. The good thing about BI tools is that they can bring in “new” results from real-time data.

New results mean new things that can be explored further for better decision making and development of new approaches to investing. That’s the kind of data and analysis only a dashboard can bring to your organization.

As an example, the number of cars on a shopping mall’s parking lot can be useful in triangulating consumer research. Recently, images from satellites are used to gather data of the global supply of fuel.

These and more examples clearly show how indispensable BI tools can be in the conduct of modern business.

Read more at http://www.infocaptor.com/dashboard/business-intelligence-for-the-finance-industry

Another Chance to Soar: Integrating 17 PaaS Services

OTN TechBlog - Mon, 2017-09-18 14:24

One of the highlights of the Oracle Fusion Middleware Partner Forum in Valencia, Spain in March 2016 was a live demo of a system developed by ACE Directors Wilfred van der Deijl, Mark Simpson, Lonneke Dikmans, Torsten Winterberg, and Lucas Jellema that integrated 10 different Oracle PaaS services.

The details of that project were described in the 8-part article series, Soaring Through the Clouds, written by members of the demo team. In March 2017 three members of that team also discussed details of the project in a subsequent podcast, 10 Services, 5 Developers, 1 Hour - A Cloud Integration Story.

Not content with a mere ten cloud services, Lucas Jellema and Lonneke Dikmans head up a new team at Oracle OpenWorld 2017 for a live demo that integrates 17 -- count 'em, 17! -- PaaS services.

Soaring Through the Clouds: Live Demo of 17 Oracle PaaS Services Working Together kicks off on Monday, Oct 02, 2:15 p.m. - 3:00 p.m. in Moscone West, Room 3009. The audience plays an active role in the demo, so be there on time.

Before or after the session, stop by the Developer Lounge in Moscone West to say hello and check out the live demos, labs, and other cool stuff.

Related Content

Another Chance to Soar: Integrating 17 PaaS Services

OTN TechBlog - Mon, 2017-09-18 14:24

One of the highlights of the Oracle Fusion Middleware Partner Forum in Valencia, Spain in March 2016 was a live demo of a system developed by ACE Directors Wilfred van der Deijl, Mark Simpson, Lonneke Dikmans, Torsten Winterberg, and Lucas Jellema that integrated 10 different Oracle PaaS services.

The details of that project were described in the 8-part article series, Soaring Through the Clouds, written by members of the demo team. In March 2017 three members of that team also discussed details of the project in a subsequent podcast, 10 Services, 5 Developers, 1 Hour - A Cloud Integration Story.

Not content with a mere ten cloud services, Lucas Jellema and Lonneke Dikmans head up a new team at Oracle OpenWorld 2017 for a live demo that integrates 17 -- count 'em, 17! -- PaaS services.

Soaring Through the Clouds: Live Demo of 17 Oracle PaaS Services Working Together kicks off on Monday, Oct 02, 2:15 p.m. - 3:00 p.m. in Moscone West, Room 3009. The audience plays an active role in the demo, so be there on time.

Before or after the session, stop by the Developer Lounge in Moscone West to say hello and check out the live demos, labs, and other cool stuff.

Related Content

Evolute from a Developer to DBA

Tom Kyte - Mon, 2017-09-18 12:26
Hi Tom, I found this website by accident one year ago and get addicted to it in just a couple of hours. Thank you for all the interesting and useful instructions/suggestions. I am a database developer who uses PL/SQL to code everyday. I always ho...
Categories: DBA Blogs

Delete a record at the at end when others stage

Tom Kyte - Mon, 2017-09-18 12:26
I have a procedure which writes a record each in two tables. Want to delete the record inserted into the first table if the second table insert fails. However, the delete does not happen. The problem is that the before insert trigger in the second t...
Categories: DBA Blogs

capture old and new values of the fields using Stored Procedure

Tom Kyte - Mon, 2017-09-18 12:26
Hi, We have a requirement to store old and new values of the fields and insert into another table. For example, If we have Table A and Table B and in both the tables columns are exactly same but we need to write a procedure like whenever an...
Categories: DBA Blogs

How to pass a list of values from one procedure to another

Tom Kyte - Mon, 2017-09-18 12:26
The first step is to fetch the data. Second is to pass the list of values fetched in step 1 to another procedure. This is the table <code>CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10), ...
Categories: DBA Blogs

Refreshing Materialized view in a remote database

Tom Kyte - Mon, 2017-09-18 12:26
Hi there. I have created in the database A the following MV: CREATE MATERIALIZED VIEW MRW_USER.MB_TRACK_REPORT3_FINAL_SS (SOUNDREC_CODE,ISRC,CAT_NUM,TITLE,MIX_NAME, ARTIST,RELEASE_DATE,LABEL,COMPANY,CORPORATE_GROUP, DISTRIBUTOR,DEALER_PRICE,GEN...
Categories: DBA Blogs

Splitting and storing Json string from file to table

Tom Kyte - Mon, 2017-09-18 12:26
Hi Team..Please help me on below scenario. I have data in a file as below. It has two records Id and JsonString DELIMITED By "| 1001"|{"id":"1234","code":"test1","Version":v1,"time":"2017-08-31","rank":2,"device":"TEST1234TEST","response":"appr...
Categories: DBA Blogs

Flashlogs not getting deleted

Tom Kyte - Mon, 2017-09-18 12:26
Hi Tom, I see FRA size is Filling up and when checked Flashback Logs are occupying most of it as seen below, SQL> select * from v$recovery_area_usage; FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES -------...
Categories: DBA Blogs

WebCenter Portal 12.2.1.3 Certified with E-Business Suite 12.x

Steven Chan - Mon, 2017-09-18 11:07

Oracle WebCenter Portal 12.2.1.3 is now certified with Oracle E-Business Suite Release 12.2 and 12.1.3.  WebCenter Portal 12.2.1.3 is part of Oracle Fusion Middleware 12c Version 12.2.1.3. 

Oracle WebCenter Portal is part of Oracle WebCenter.  Oracle WebCenter is an integrated suite of tools used to create web sites and portals.  Applications adapters are also available.  

WebCenter Development Framework

 

Certified Platforms

Oracle WebCenter Portal is certified to run on any operating system for which Oracle WebLogic Server 12c is certified. For information on operating systems supported by Oracle WebLogic Server 12c and Oracle WebCenter Portal, refer to the 'Oracle Fusion Middleware on WebLogic Server - System Certification' in the Oracle Fusion Middleware Supported System Configurations.

Integration with Oracle WebCenter Portal involves components spanning several different suites of Oracle products. There are no restrictions on which platform any particular component may be installed so long as the platform is supported for that component.

Migrating to Oracle WebCenter Portal

Oracle Portal entered Sustaining Support on July 1, 2017.  The terminal release of Oracle Portal was 11.1.1.6.  You can still download existing resources for Oracle Portal such as documentation and patches, but no new updates will be created.  You should consider migrating to Oracle WebCenter Portal for ongoing new features.

References

Related Articles

Categories: APPS Blogs

Getting started with Oracle JET: a CRUD service

Amis Blog - Mon, 2017-09-18 10:25
Introduction

AMIS has recently set up a brand new Enterprise Web Application team, of which I am proud to be a member. We will working in front-end development using a variety of Javascript based frameworks. As a first framework, we are currently investigating Oracle JET.  After working through the Oracle JET MOOC and a Knockout.js tutorial we have begun to build a meetings organisation app in order to get some more hands-on experience. This app is initially intended to have users and meetings, allowing for the users to create, show, update and delete meetings with their authorization dependent on authentication. This blog post is intended to show you some of the discoveries we made while working on this project.

Getting started

To keep things simple, we started of by setting up a FeathersJS REST API as a back-end with two models, one for meetings and one for users, as well as some seeds to provide initial data for these models. The next step was to make this data available in the JET app, across any of the components which might want to make use of it. This was done through use of the JET model and collection systems. In this system an model is a single data record, while a collection contains multiple records.  Since we want the CRUD functionality to be available to different JET components, we placed the code in a separate service as shown below. As you can see, this service defines the model and collection as well as providing an instance of the collection. The parseMeeting and parseSaveMeeting functions and attributes are optional and can be left out if you do not want to change the names of any attributes from back-end to front-end. The comparator attribute of the collection is used to order the different models.

.gist table { margin-bottom: 0; }
CRUD actions

After setting up the model and collection, we added  CRUD functionality. JET models and collections provide functions which take care of the communication with the back-end. For example, when using the create function a plain old javascript object can be passed, as well as success and error handlers. The collection which was instantiated earlier is used to call the create function on, adding the new model to collection for quick availability in the front-end as well as making a call to the back-end to create the object in the database. Specific headers can be used, for example in order to pass an authorization token.

For the fetch and delete methods, we instantiate a new model and set its ID to the ID of the object we want to affect. The relevant function is then called on this object. In the case of the fetch function, the data in the model is mapped to a plain old javascript object, which is returned. In the success handler of the delete function we remove the destroyed meeting from the collection, automatically updating all components in the front-end which rely on its data. The update function accepts both  plain javascript objects and JET models.

.gist table { margin-bottom: 0; }
Calling the service

Setting the service up like this gave us an easy to use way to interact with our back-end, as well as allowing us to clean up the code of our components and remove any duplication. Here is an example of how we call this service from our meetings.js. Other services can be set up in the same way, or multiple services could even inherit from the same base service.

.gist table { margin-bottom: 0; }

 

The post Getting started with Oracle JET: a CRUD service appeared first on AMIS Oracle and Java Blog.

Log Buffer #522: A Carnival of the Vanities for DBAs

Pythian Group - Mon, 2017-09-18 10:22

This edition of Log Buffer covers Cloud, Oracle, SQL Server and MySQL and much more.

Cloud:

Introducing managed SSL for Google App Engine

Using Cloud Foundry CUPS to inject Spring Security credentials into a Spring Boot Application

ClusterControl in the Cloud – All Our Resources

Monitoring Amazon Aurora Audit Events with Amazon CloudWatch

Integrating Teradata with Amazon Redshift Using the AWS Schema Conversion Tool

Oracle:

Demo App for REST enabled SQL

The Insurance of Oracle APEX – Can Your Low Code Framework Do This?

Oracle GoldenGate is now avaliable on Docker! All the details you need to get up and running on an image is included in Oracle’s public github.

Assign Pseudo Random Password for Oracle DB Users

Simple regexp to check that string contains word1 and word2 and doesn’t contain word3

SQL Server:

Automate MSBI deployments Using PowerShell

NEW – Machine Learning with SQL Server 2017 and R Tutorial

Optional Parameters and Missing Index Requests

Moving Dynamic Data Masked Data to New Locations

Indexing for Windowing Functions: WHERE vs. OVER

MySQL:

Lock, Stock and MySQL Backups: Data Guaranteed Webinar Follow Up Questions

gh-ost 1.0.42 released: JSON support, optimizations

Massive Parallel Log Processing with ClickHouse

cscope: Searching Code Efficiently

Updating InnoDB Table Statistics Manually

Categories: DBA Blogs

Oracle’s New SPARC Systems Deliver 2-7x Better Performance, Security Capabilities, and Efficiency than Intel-based Systems

Oracle Press Releases - Mon, 2017-09-18 07:00
Press Release
Oracle’s New SPARC Systems Deliver 2-7x Better Performance, Security Capabilities, and Efficiency than Intel-based Systems World’s most advanced processor adds breakthrough performance and security enhancements with Software in Silicon v2 for Oracle Cloud, Oracle Engineered Systems, and Servers

Redwood Shores, Calif.—Sep 18, 2017

Oracle today announced its eighth generation SPARC platform, delivering new levels of security capabilities, performance, and availability for critical customer workloads. Powered by the new SPARC M8 microprocessor, new Oracle systems and IaaS deliver a modern enterprise platform, including proven Software in Silicon with new v2 advancements, enabling customers to cost-effectively deploy their most critical business applications and scale-out application environments with extreme performance both on-premises and in Oracle Cloud.

SPARC M8 processor-based systems, including the Oracle SuperCluster M8 engineered systems and SPARC T8 and M8 servers, are designed to seamlessly integrate with existing infrastructures and include fully integrated virtualization and management for private cloud. All existing commercial and custom applications will run on SPARC M8 systems unchanged with new levels of performance, security capabilities, and availability. The SPARC M8 processor with Software in Silicon v2 extends the industry’s first Silicon Secured Memory, which provides always-on hardware-based memory protection for advanced intrusion protection and end-to-end encryption and Data Analytics Accelerators (DAX) with open API’s for breakthrough performance and efficiency running Database analytics and Java streams processing. Oracle Cloud SPARC Dedicated Compute service will also be updated with the SPARC M8 processor.

“Oracle has long been a pioneer in engineering software and hardware together to secure high-performance infrastructure for any workload of any size,” said Edward Screven, chief corporate architect, Oracle. “SPARC was already the fastest, most secure processor in the world for running Oracle Database and Java. SPARC M8 extends that lead even further.”

The SPARC M8 processor offers security enhancements delivering 2x faster encryption and 2x faster hashing than x86 and 2x faster than SPARC M7 microprocessors. The SPARC M8 processor’s unique design also provides always-on security by default and built-in protection of in-memory data structures from hacks and programming errors. SPARC M8’s silicon innovation provides new levels of performance and efficiency across all workloads, including:  

  • Database: Engineered to run Oracle Database faster than any other microprocessor, SPARC M8 delivers 2x faster OLTP performance per core than x86 and 1.4x faster than M7 microprocessors, as well as up to 7x faster database analytics than x86.
  • Java: SPARC M8 delivers 2x better Java performance than x86 and 1.3x better than M7 microprocessors.  DAX v2 produces 8x more efficient Java streams processing, improving overall application performance.
  • In Memory Analytics: Innovative new processor delivers 7x Queries per Minute (QPM)/core than x86 for database analytics.
 

Oracle is committed to delivering the latest in SPARC and Solaris technologies and servers to its global customers. Oracle’s long history of binary compatibility across processor generations continues with M8, providing an upgrade path for customers when they are ready. Oracle has also publicly committed to supporting Solaris until at least 2034.

Contact Info
Nicole Maloney
Oracle
+1.650.506.0806
nicole.maloney@oracle.com
Kristin Reeves
Blanc and Otus
+1.925.787.6744
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

Nicole Maloney

  • +1.650.506.0806

Kristin Reeves

  • +1.925.787.6744

And the idiocy continues...

Nuno Souto - Mon, 2017-09-18 05:32
Been a while since my last post.  Then again, Oracle administration has become such a small part of my work that I hardly find the motivation... But the latest idiocy from the Larry Ellison camp is just too much! Yeah sure: another iteration of the "let's get rid of all those DBAs" nonsense that has essentially killed the company here in NSW Australia, since the days of release9! This one is Noonshttp://www.blogger.com/profile/04285930853937157148noreply@blogger.com0

SQL Saturday Toulouse 2017: SQL Server on Linux – Slide deck

Yann Neuhaus - Mon, 2017-09-18 03:39

#SQLSatToulouse was definitely a great event. Firstly, a big thanks to the organization team (@Guss and @Fredg_31) as well as all the sponsors and attendees (without whom this kind of event would not be possible).

blog 124 - sqlonlinuxsqlsattoulouse

As promised, here the slide deck of my session “Introduction to SQL Server on Linux for DBAs“. It was for me a great moment of sharing.

Thanks to all!

 

 

Cet article SQL Saturday Toulouse 2017: SQL Server on Linux – Slide deck est apparu en premier sur Blog dbi services.

Pages

Subscribe to Oracle FAQ aggregator