Weekly Events #1

 

MARCH 16

 

Oracle Cloud SaaS Awareness Session

Oracle SD-WAN – ensuring application performance and reliability for real-time and other critical applications.

Oracle SD-WAN helps enterprises connect their branches, HQ, data centers, multiple clouds but also vehicles and ships with an autonomous WAN providing greater network reliability and superior application quality of experience while reducing the cost of WAN.

READ MORE

Oracle User Group Get-Together: JDE-DevOps(Blue-Green deployment) and Pluggable DB for Data refreshes

This is a webinar associated with Oracle Benelux User Group and French Oracle Users Group.

Come and join us to see our success in Oracle’s JDE internal development operations with Blue-Green deployment for the JDE Tools updates process and simplification of data refresh process using pluggable databases(PDB) of containerized database(CDB). This session showcases the benefits of Blue-Green deployment strategy, Pluggable Databases and how much Time/Effort we have saved in our internal operations by adopting the latest innovations of DevOps strategies and Pluggable Databases.

READ MORE

Cloud Applications Implementation Best Practices Webinar

ORACLE CS connectx: implementation best practices.

We invite you to attend a LIVE webinar to get started with implementation of your Oracle Cloud Applications. This is a perfect start to your Cloud journey where you will learn about:-

READ MORE

Oracle Maximize Value with Oracle Database 19c

“The Time is Now” for database modernization removing technology debt.

The new normal has accelerated digitalization of many customers across industries. Customers are facing new challenges and need to develop new business models to increase efficiency, be more agile and highly resilient.

Addressing “technology debt” enables customers to move much more rapidly in this direction.Technology debt is not only linked to hardware and software obsolescence, but leaves organisations “lagging” – unable to leverage automation and integration capabilities, lacking superior scalability and availability to be able to handle demand and offer near-zero business service disruption. To add to this, there is an inability to get insights from data in real-time, and increased vulnerability as cyber-attacks grow exponentially and data breaches are commonplace, particularly, as systems remain out-of-date.

READ MORE

DAY ONE – Hyperion on Oracle Cloud Infrastructure – Hands On Lab

See Oracle Cloud Infrastructure (OCI) in action with your Hyperion application in a live hands-on virtual lab.

In this workshop, Oracle cloud engineers will demonstrate the setting up of Oracle Hyperion Financial Management (HFM), Oracle Hyperion Foundation Services, and Oracle Hyperion Financial Data Quality Management Enterprise Edition (FDMEE) on OCI.

READ MORE

   MARCH 17

 

DAY TWO – Hyperion on Oracle Cloud Infrastructure – Hands On Lab

See Oracle Cloud Infrastructure (OCI) in action with your Hyperion application in a live hands-on virtual lab.

In this workshop, Oracle cloud engineers will demonstrate the setting up of Oracle Hyperion Financial Management (HFM), Oracle Hyperion Foundation Services, and Oracle Hyperion Financial Data Quality Management Enterprise Edition (FDMEE) on OCI.

READ MORE

DAY ONE – UTOUG – Training Days 2021

We are going VIRTUAL this year.

UTOUG Training Days brings the best speakers in the country to your doorstep! Network with people who are part of your local community – no hotel required! Explore the session schedule when it becomes available then go ahead and invest in yourself by registering today.

UTOUG is committed to ensuring that all Oracle technologists in our area can learn and grow. Our available scholarships help further that commitment by helping UTOUG members and students attend Training Days.

READ MORE

Oracle Live Event – MySQL Accelerate Live Session: GAMING

Mysql for modern & secure high availability gaming applications.

This Accelerate Live Session is designed to get you on track with the latest DBA trends and technology with real life use cases.

READ MORE

New Autonomous Data Warehouse Innovations

Featuring andrew mendelsohn, evp, oracle database server technologies.

On Wednesday, March 17, Andrew Mendelsohn will announce Oracle’s latest cloud data warehouse innovations that put the full power of your data within the reach of your entire organization. New intuitive, integrated capabilities enable analysts, data scientists, and line-of-business developers to deliver even faster results, accelerating insights and time-to-market. Together with the existing zero-admin capabilities of Oracle Autonomous Data Warehouse, organizations of all sizes can lower TCO and increase ROI while more rapidly gaining maximum value from their data.

READ MORE

Live Webinar: Simplify and Modernize Your On-Premises Cloud using Oracle Private Cloud Appliance

Cloud native technology are rapidly gaining acceptance and is simplifying the building of complex applications, while at the same time enabling organizations to build and deploy these applications faster.

Now, with Cloud native environments integrated with the latest PCA software release, organizations are further empowered to build and run scalable applications in modern, dynamic, highly available environments, which enable loosely coupled systems that are resilient, manageable, and observable.

READ MORE

ZDLRA and MAA integration to reach ZERO RPO everywhere

Zero Data Loss Recovery Appliance (ZDLRA) is an Oracle Engineering System that was it is part of the Oracle Maximum Availability Architecture (MAA) family. But it goes beyond just backup and recovery. In this webinar I will show how to integrate ZDLRA with all kinds of databases that you have, protecting from the simplest single instance to the huge multi-site DG+RAC database. Everything with ZERO Recovery Point Objective (RPO) and multi-site protection. Check in this webinar how you integrate ZDLRA features like Real-Time Redo transport, Multi ZDLRA Replication, and Tape backups with the Oracle MAA Reference Architecture. After the webinar, you will understand why you need to consider ZDLRA for your architecture design and how ZDLRA and MAA can work together to reach maximum protection for all kinds of databases.

READ MORE

   MARCH 18
DAY TWO – UTOUG – Training Days 2021

We are going VIRTUAL this year.

UTOUG Training Days brings the best speakers in the country to your doorstep! Network with people who are part of your local community – no hotel required! Explore the session schedule when it becomes available then go ahead and invest in yourself by registering today.

READ MORE

Cloud-Driven Transformation: Accelerating resiliency and business continuity with Oracle

Today’s organizations are undergoing massive transformation, ramping up digital initiatives across the enterprise. Further driven by the pandemic, according to IDC, at least 50% of organizations in Africa will launch new lines of business driven by DX investments in 2021.

READ MORE

Live Webcast: Optimizing value of your Oracle licenses – best practices for Software Asset Management

Optimizing value of your oracle licenses – best practices for software asset management.

Do you want to gain a better understanding of the various licensing and contract options that Oracle offers? Is the management of your Oracle licenses fixed in a solid and standardized Software Asset Management process? Are you wondering what methods and techniques you can use and what this means for your organization? Then join us for this upcoming webinar!

READ MORE

Meetup: Experiences with Oracle Database Migrations to the Cloud (Moved to April!)

Meetup: Experiences with Oracle Database Migrations to the cloud</strong>

Originally this Meetup was supposed to take place on March 18th. The Meetup will be postponed to a date yet to be determined in April. More information about this will follow as soon as possible.

READ MORE

APEX Office Hours
APEX + Server-side JavaScript = Awesome!
Welcome to the future! Starting with Oracle Database 21c, developers can now execute JavaScript within the database. This functionality is enabled by the Multilingual Engine (MLE), powered by GraalVM. And APEX 20.2 is the first (and only) low code framework on the planet which natively supports server-side JavaScript, out of the box!

READ MORE

   MARCH 19
A la découverte de la nouvelle machine virtuelle d’Oracle – GraalVM

Venez decouvrir graalvm lors de ce webinar.

Une toute nouvelle solution elaborée par “Oracle Lab” qui apporte une valeure ajoutee ultra rapide au Business que vous soyez une Multinational ou une PME.

READ MORE

AWS AQUA for Redshift

Hi all,

Quick one today. Did you see this new release? I’m a bit behind the schedule but trying to catch up with the news. It seems very interesting:

AQUA (Advanced Query Accelerator) for Amazon Redshift is available in preview. AQUA provides a new distributed and hardware-accelerated cache that brings compute to the storage layer for Amazon Redshift and delivers up to 10x faster query performance than other cloud data warehouses.

AQUA is a high-speed cache on top of Redshift Managed Storage that can scale out and process data in parallel across many AQUA nodes. AQUA uses AWS-designed analytics processors that dramatically accelerate data compression, encryption, and data processing on queries that scan, filter, and aggregate large data sets. With this new architecture, customers can run queries quicker than ever before, allowing them to query data directly, even at scale, and giving them more up-to-date dashboards, reducing development time, and making system maintenance easier.

It is available for preview in US East (Ohio), US East (N. Virginia), and US West (Oregon) regions at this point.

For more references:

  • There is a very tech detailed article about it HERE.
  • There is also a very nice TechTalk presenting it HERE.

Let’s keep up to date!

Microsoft Ignite 2021!

Hey Folks,
Better later than never… Yesterday was the first day of the Microsoft Ignite event, and again, like last year, you have a chance to earn a voucher to do a free certification exam.

Same as the last year, to receive the voucher all you have to do is complete at least one of the challenges.

Bellow, you have two links. One where you can see which Exams will be available and the other one will take you to the challenges page.

 

ORA-07445 [kxsPurgeCursor()]

Hi all,
We started getting lots of ORA-07445 errors that are being reported in the Exadata production database from a client.
Checking on the traces we can see that someone is running the below SQL and that is triggering these errors:
declare
i number := 0;
begin
for c1 in (
select address, hash_value, sql_id from v$sql where
last_active_time < sysdate - 1/24
and executions < 2 ) loop
begin
dbms_shared_pool.purge(c1.address || ' ' || to_char(c1.hash_value), 'C');
i := i + 1;
exception when others then
dbms_output.put_line(c1.sql_id);
end;
end loop;
dbms_output.put_line('Cursors purged = ' || to_char(i));
end;
/
I’m not even going to discuss the PL above, it’s purging all new SQLs executed less than 2 times in the last 24hours. I’m not really agreeing with this…
What matters is: in the end, it was being caused because hash value of non-cursor is being passed to dbms_shared_pool.purge().  This is a match to Bug 29281112 – ORA-7445: [kxspurgecursor()+517] [sigsegv] (Doc ID 29281112.8)
There is no actual workaround besides stop passing a non-cursor hash to dbms_shared_pool.purge, however we have a fix for a better addressing of those cases on:

Quick Reference: Oracle Exadata default passwords

It’s not needed to say how important this is to have all the password reset, even though on new Exa hardware the SSH is usually disabled. How ever, oftenly we need to have access in some of the consoles knowing the password was never changed but unaware on what it should be.

For those cases (until you change it, ASAP), here is a quick reference:

Database Server:

  • root/welcome1
  • oracle/welcome1
  • grid/welcome1
  • grub/sos1Exadata

Exadata Storage Servers:

  • root/welcome1
  • celladmin/welcome1
  • cellmonitor/welcome1

InfiniBand switches:

  • root/welcome1
  • nm2user/changeme

Ethernet switches:

  • admin/welcome1

Power distribution units (PDUs):

  • admin/welcome1
  • root/welcome1

Database server ILOMs:

  • root/welcome1

Exadata Storage Server ILOMs:

  • root/welcome1

InfiniBand ILOMs:

  • ilom-admin/ilom-admin
  • ilom-operator/ilom-operator

Keyboard, video, mouse (KVM):

  • admin/welcome1

Change them!

I hope this was useful for you.

Loading “Views” from One Database to Another

Hi all,

This seems to be a simple request, right?  Let’s go to the regular cases / simple answers:

  • Use DBMS_METDATA.ET_DDL to get the view code: DBMS_METADATA.get_ddl (‘VIEW’, <VIEW_NAME>, <OWNER>)
  • Use datapump with include=VIEW Or even specifying the list INCLUDE=VIEW:\”IN (\’VW_EXAMPLE1\’, \’VW_EXAMPLE2\’)\” Or part of the name: INCLUDE=VIEW:”LIKE ‘VW_%EXEMPLE%'”

However, when supporting a client with this need I see this may have some caveats. The options above load the view purely, not the “content” of the view from an application perspective.

And here let’s leave it clear, a view doesn’t have any data but instead stores a query to retrieve the data from regular tables. We could have underlying tables as support mechanisms in case of materialized views,  but in essence, they are transitory build from the actual database tables. Now how to load views to other databases without the source tables including the underlying data?

This question has 2 answers:

  • Exporting the views as tables.

In general lines I’d do it manually: Create tables from views and then export them. This can mean I would need to have space for creating those tables, which can be a lot, though.

But then I see we have VIEWS_AS_TABLES clause in Datapump which makes exactly that. As a reference: https://docs.oracle.com/database/121/SUTIL/GUID-E4E45E81-5391-43BE-B27D-B763EF79A885.htm#SUTIL3904

However, in this case, the import will bring the views as tables, not as views. Which will theoretically resolve the issue from a data perspective, but may not be what is required: What if I need the views as views on the destination database?

Well, in this case it’s needed to load all the underlying tables. How to extract them? The hard way is opening all the view codes and listing them. The smart way is the second option:

  • Listing the tables referenced by Views from dba_dependencies and exporting them.

select owner as schema_name,
name as view_name,
referenced_owner as referenced_schema_name,
referenced_name,
referenced_type
from sys.dba_dependencies
where type = 'VIEW'
-- excluding some Oracle maintained schemas
and owner not in ('ANONYMOUS','CTXSYS','DBSNMP','EXFSYS', 'LBACSYS',
'MDSYS', 'MGMT_VIEW','OLAPSYS','OWBSYS','ORDPLUGINS', 'ORDSYS','OUTLN',
'SI_INFORMTN_SCHEMA','SYS','SYSMAN','SYSTEM','TSMSYS','WK_TEST','WKSYS',
'WKPROXY','WMSYS','XDB','APEX_040000', 'APEX_PUBLIC_USER','DIP',
'FLOWS_30000','FLOWS_FILES','MDDATA', 'ORACLE_OCM', 'XS$NULL',
'SPATIAL_CSW_ADMIN_USR', 'SPATIAL_WFS_ADMIN_USR', 'PUBLIC')
order by owner, name, referenced_name, referenced_owner, referenced_type;

Aaaand, that’s what I actually needed. With the list in place, it’s a matter of exporting with datapump including the tables on the list and the views (as mentioned above).

I hope it helps!

ORA-12537: TNS:connection closed – When nothing else works!

Sounds desperate?

Well, when you are sure all the TNS, listener (SID_LIST_LISTENER on this case), services, db_domain are fine but still facing this issue when trying to access remotely an open database… what to do?

[oracle@greporasrv admin]$ sqlplus sys/******@MYDB as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Feb 3 17:45:29 2021

Copyright (c) 1982, 2013, Oracle. All rights reserved.

ERROR:
ORA-12537: TNS:connection closed

My friend here is a quick tip that, if you are an Oracle DBA for time enough you know that solves several issues, maybe affecting this case again:

[oracle@greporasrv admin]$ cd $ORACLE_HOME/bin
[oracle@greporasrv bin]$ ls -lrt oracle
-rwxr-x--x. 1 oracle oinstall 242993632 Dec 18 19:20 oracle
[oracle@greporasrv bin]$ chmod 6751 oracle
[oracle@greporasrv bin]$ ls -lrt oracle
-rwsr-s--x. 1 oracle oinstall 242993632 Dec 18 19:20 oracle

The CHMOD 6751 did it again!

It happened to me because, somehow, these permissions were wrong in my LOCAL host (the one I was trying to use the SQLPlus* from.

I hope it helps!

 

Removing user from SQL Server database

So, have you ever been in the need to drop a user from the SQL Server database, but you stuck with the following related error?

Error: 15138 The database principal owns a schema in the database, and cannot be dropped.

If you don’t have access to the SSMS to see which schema or objects the user owns, the following SQL should do the job.

USE [DATABASENAME]
GO
SELECT so.name OBJECT, su.name OWNER
FROM sys.schemas so
INNER JOIN sysusers su ON (so.principal_id = su.uid)
WHERE su.name = 'username'
GO
SELECT so.name OBJECT, su.name OWNER, so.xtype TP
FROM sys.sysobjects so
INNER JOIN sysusers su ON (so.uid = su.uid)
WHERE su.name = 'username'
GO

Once you have the owned objects/schemas, you can change them with the following SQL (schema example):

USE [DATABASENAME]
GO
ALTER AUTHORIZATION ON SCHEMA::[db_datareader] TO [newowner] /* new owner username */
ALTER AUTHORIZATION ON SCHEMA::[db_datawriter] TO [newowner]
GO

Then you’re ready to drop the user DROP USER [username].

Bonus SQL: The following will list the schemas and their owner.

SELECT schema_name(schema_id) as SCHEMANAME,
user_name(s.principal_id) as USERNAME
FROM sys.schemas AS s

AWS CloudFormation

Hello everyone,

We are going to start one series of posts where we are going to show the AWS CloudFormation usage.

The nexts post going to abord a creation one RDS, DMS using AWS cloudFormation stack. In this series we’re going to showcase AWS CloudFormation by creating one RDS and one DMS.

First one fast introduction about AWS cloudFormation.

Let start to explain AWS CloudFormation

” AWS CloudFormation provides a common language for you to model and provision AWS and third party application resources in your cloud environment.”

In practice it’s a json/yaml file, where we can describe instructions to create AWS services.

Let’s  code!.

First step that we need is connect to AWS Console. In the search field type CloudFormation like the picture below.

Click on CloudFormation to open the service console.

 

Click on Stacks.

 

 

After this, click on create a new stack and select “with new resources”

We are going to click on Create template in designer and you will be redirected to page like below.

 

Click on Template and the code editor is going to open.

The next step will be to create one script to deploy a service. In this example, we going to use a DMS script and a RDS Postgresql. The examples used in this article are available in the next article.

To execute the script the first step is to validate by clicking the highlighted button in the below image.

The return can be OK or error. If the return is OK you can create the stack. To do this clicking the highlighted button in the below image.

You can check execution events by clicking in the Events page. The return is similar to the image below.

In the next articles, we are going see the source code and to use the AWS DMS Service to replicate data from Oracle Database to RDS PostgreSQL.

 

Stop installing MySQL 5.6!

From time to time, I get a customer request to configure/optimize a MySQL server, and usually, when the customer has already installed the MySQL Server, usually, it’s an “old” version. It’s ok if your software uses features that only work on some specific version of a Database, but keep an eye open for its end of life support. And that EOF is coming to MySQL 5.6. Below you can see a table with the MySQL versions and their ending date.

So, next time you need to configure a new server, keep an eye on the version you’re using.

Version Ending date
5.6 02/05/2021
5.7 10/21/2023
8.0 04/xx/2026