Feed aggregator

Protect Your Home from Pests

OraQA - Tue, 2021-06-22 12:34

Amongst the most difficult jobs that homeowners will deal with entails the upkeep of their house as well as residential property. Upkeep entails anything from an occasional replacement of floor covering to painting wall surfaces. It may ask for a more comprehensive remodeling of the kitchen area or among the washrooms. Nevertheless, these jobs are not a returning task and enable pre-planning as well as choosing a convenience of year.

Nonetheless, there is at least one recurring task that includes the upkeep as well as treatment of your home. This is the requirement for several years round control as well as administration of house insects. Some parasites are just a hassle while others are destructive in addition to being an annoyance. Still, others can jeopardize the wellness of members of the family as well as pets. Each season of time throughout the year is noted for certain parasites to be rising. The correct monitoring of such bugs consists of precise identification as well as the proper technique of control.

The best company for pest control will recognize the stress as well as the obligation that supports bug administration. The professionals have made three different domestic insect control services from which homeowners can select to get rid of the tension of undesirable parasites. These professionals provide amongst the most innovative, eco-friendly pest control remedies developed to safeguard your household, furniture, as well as pets.

The right strategy gives year-round security against greater than thirty common household parasites. This exceptional security is scheduled six times each year and includes the pest-free pledge. In the not likely occasion that pests return in between sees, we will return for no added charge.

The care as well as plan, along with everything else in the treatment strategy, gives termite monitoring. Typically described as quiet destroyers, termite colonies can create serious damage without the property owner understanding their presence. This ongoing tracking of termites is crucial to the defense of the house.

The professionals are available to the property owner who wants the best protection. In addition to everything consisted of in the first two strategies, the professionals include termite treatment with the termite elimination system.

For emergency service pest control, please visit the link.

The post Protect Your Home from Pests appeared first on ORA QA.

EKS Login error: You must be logged in to the server (Unauthorized)

Pakistan's First Oracle Blog - Tue, 2021-06-22 09:00

 The reason why you would receive following error when you try to access an EKS cluster is that the user who created the EKS cluster is different what you are using to run kubectl commands:

error: You must be logged in to the server (Unauthorized)

In order to resolve this, either use aws-iam-authenticator or use the same user to run your kubectl commands with which you created the cluster. I  normally like to work with the kubeconfig file present so I use the same user for both creating EKS cluster and running kubectl commands. I also set my config and credentials in AWS as follows:

AWS .config file entry:

[profile eks-np]

region = ap-southeast-2

output = json

AWS credentials file entry:


aws_access_key_id = <key id>

aws_secret_access_key = <access key>

region = ap-southeast-2

and then run following command to update your .kube file with cluster and context info:

aws eks --region ap-southeast-2 update-kubeconfig --name ekscluster --profile eks-np

I hope that helps.

Categories: DBA Blogs

Conflict - The Subnet ocid1.subnet.oc1... references the VNIC ocid1.vnic.... You must remove the reference to proceed with this operation.

Virag Sharma - Tue, 2021-06-22 06:18

 Recently , i was cleaning Oracle OCI Account. I delete / terminated most of things 
But subnet was giving error 

Conflict - The Subnet ocid1.subnet.oc1.iad..xxxxxxxxxxxxx   references the VNIC ocid1.vnic.oc1.iad.xxxxxxxxxxxxxxxxxxxxxxxxxxx . You must remove the reference to proceed with this operation.

After searching came across following documenation 

  See the following for official Oracle directions covering the process to delete an Orphaned Mount Target – https://docs.cloud.oracle.com/iaas/Content/File/Troubleshooting/orphanedmounttarget.htm

But it not help , as i was not using File system. But it gave clue that i can query VNIC on OCI CLI  and see what attached to it 

when query VNIC , we saw one MYSQL instance not terminated yet 

root# oci network vnic get --vnic-id ocid1.vnic.oc1.iad.abuwcljsyovdlywqyd7tndgwfdfj2pbwo76gfdh6iocr4g552xmgqucy3hnq  


  "data": {

    "availability-domain": "QNKP:US-ASHBURN-AD-1",

    "compartment-id": "ocid1.tenancy.oc1..aaaaaaaajjkprkd7xdzwso4f6lki6mj7nz5xqnoo7rwurtvtxb56spycbtsq",

    "defined-tags": {

      "Oracle-Tags": {

        "CreatedBy": "mysql",

        "CreatedOn": "2021-06-10T06:34:44.152Z"



    "display-name": "vnic20210610063448",

    "freeform-tags": {},

    "hostname-label": null,

    "id": "ocid1.vnic.oc1.iad.abuwcljsyovdlywqyd7tndgwfdfj2pbwo76gfdh6iocr4g552xmgqucy3hnq",

    "is-primary": false,

    "lifecycle-state": "AVAILABLE",

    "mac-address": "02:00:17:0B:D9:98",

    "nsg-ids": [],

    "private-ip": "",

    "public-ip": null,

    "skip-source-dest-check": false,

    "subnet-id": "ocid1.subnet.oc1.iad.aaaaaaaafekmxhstcrmqttpfxeakojqtqvlor6ik6qmtqskxawecrhtiovgq",

    "time-created": "2021-06-10T06:34:48.386000+00:00"


  "etag": "3e6a18c3"


Categories: DBA Blogs

3 Tips For Mental Health as Cloud Engineer

Pakistan's First Oracle Blog - Mon, 2021-06-21 17:52

 It's simple. Our brain is our biggest asset when it comes to being a cloud or devops engineer. If you start loosing your mind or if its chaotic and unsound, then you won't be a cloud engineer for long for sure. Following are 3 tips to maintain your mental health as a cloud engineer.

1- You don't have to Learn it all 

You don't have to learn all hundreds of services offered by AWS, Azure, GCP, Ali baba, Oracle, etc. Don't stress about learning every devops CICD tool under the sun. You are not supposed to learn all there is in cloud w.r.t networking, compute, storage, databases, serverless, streams, ML, AI, integration, and other stuff. Stop falling into that bottomless chasm as you would never be able to get out of it. Just learn what's needed now. Just learn what your background is. Just learn what interests you. Just learn what gets the job done.

2- Don't take Cloud Job postings too seriously

One of the ways I was checking what's required by today's businesses in terms of skillset was to review cloud job postings. After going through the skills required, I was getting very depressed as the list was long. Then I started to realize that it was humanly impossible for anyone to possess all those skills in fullest. How can I be a full stack developer with rich networking background, having worked in true agile environment remaining abreast of CICD pipelines with a must docker and kubernetes 5 year experience, topped by some SQL and NoSQL database skills. Job posting just don't end there either. You have to know all those tools like DCOS, K8s, Maven, Ant, Gradle, TeamCity, Jenkins, Bash, Powershell, Python, Ruby, MongoDB, Kafka, Oracle, IAM, OKTA, AD, ELK, and plethora of other acronyms. Trust me, most of these job postings are unrealistic and they know it. If you foot even half of the bill in these job postings and are good at what you do, you should be fine. 

3- Keep Learning Enjoyably

Don't switch off and don't go to some remote monastery to meditate. We have made these careers after lots of hard work. We have to stay relevant in the industry. We have to pay mortgages and we have to provide for our family. What really stresses is the fear of lagging behind and going obsolete. We keep doing this cloud stuff because we enjoy doing it. What bothers is the endless list of things to learn. Just follow above 2 points and this stress should be very manageable, and then you can just focus on things which you really should be learning and what you enjoy learning. 

Happy learning and progressing.

Categories: DBA Blogs

Criteria that you can use when you are choosing a gambling agent

OraQA - Mon, 2021-06-21 10:00

Choosing a suitable online gambling agent has become very difficult these days. This is because many gambling agents are offering different games, enticing bonuses, and rewards that making a suitable choice becomes very difficult. With thousands of options available, you need to look for the best way, a method, or perfect criteria that you can use to choose the best gambling agent. Here are some of the tips to use

Check if the online gambling agent is available in your country

The first criterion is checking whether the online gambling agent is available in your country. This will help you avoid researching online gambling sites that don’t accept punters from your country or state. There are many agenjudi online terbesar that do not accept punters from other states and countries. The best way to figure out its boundary limits is through reading the terms and conditions. To be on the safe side, deal with online casinos within your country of residence.

Welcome bonuses and promotions

This may sound like a no-brainer but it is a very important factor when you are choosing a gambling agent. We all love free things and we also love promotions. That is the reason why gambling agents use promotions and bonuses to attract punters. With bonuses and promotions, you have an opportunity to win money without spending a dime from your pocket. Today, almost all gambling agents offer bonuses and promotions. Therefore, you should not settle for one that doesn’t offer bonuses and rewards.

Customer support

Another criterion is through checking the customer service of the gambling agent. How a gambling agent treats other punters is very important. Check whether an agent has customer support to help you and what other people are saying about different gambling agents.

The post Criteria that you can use when you are choosing a gambling agent appeared first on ORA QA.

Publishing Your Python Library on PyPI

Andrejus Baranovski - Mon, 2021-06-21 02:15
I explain how to publish Python library on PyPI with Poetry. I believe this video will be useful to all Python developers, who are looking at how to create Python library and publish it. I share my experience and explain why I spent the entire day debugging the issue with library dependencies.


which delete statement is better for deleting millions of rows

Tom Kyte - Fri, 2021-06-18 14:06
I have table which contains millions of rows. I want to delete all the data which is over a week old based on the value of column last_updated. so here are my two queries, Approach 1: <code> Delete from A where to_date(last_updated,''yyyy-mm-dd'')< sysdate-7; </code> Approach 2: <code> l_lastupdated varchar2(255) := to_char(sysdate-nvl(p_days,7),'YYYY-MM-DD'); insert into B(ID) select ID from A where LASTUPDATED < l_lastupdated; delete from A where id in (select id from B); </code> which one is better considering performance, safety and locking?
Categories: DBA Blogs

Exam AI-102: Designing And Implementing a Microsoft Azure AI Solution | AI Engineer

Online Apps DBA - Fri, 2021-06-18 00:35

This training will teach you how to design and implement an Azure AI solution. It is intended for software developers wanting to build AI-infused applications that leverage Azure Cognitive Services, Azure Cognitive Search, and Microsoft Bot Framework. This training includes 24 hands-on activities in which you will use C# or Python to develop AI applications. […]

The post Exam AI-102: Designing And Implementing a Microsoft Azure AI Solution | AI Engineer appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Exam DP-300: Microsoft Azure Database Administrator Associate

Online Apps DBA - Fri, 2021-06-18 00:15

✯ The Azure Database Administrator implements and manages the operational aspects of cloud-native and hybrid data platform solutions built on Microsoft Azure data services and Microsoft SQL Server. ✯ DP-300 Exam is initiated by Microsoft with a major aspect of administering Relational Databases on Microsoft Azure. This exam is an objective for Data Professionals, Data […]

The post Exam DP-300: Microsoft Azure Database Administrator Associate appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

How to Create and Publish Power BI App

Online Apps DBA - Thu, 2021-06-17 23:51

Did you ever struggle to share all of your Power BI content in one place? If so, then the Power BI App has got the perfect solution for you. ➤ Power BI App ↬ Power BI App is one of the features of Power BI that allows sharing of the content to a broad audience. […]

The post How to Create and Publish Power BI App appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Cloud Vanity: A Weekly Carnival of AWS, Azure, GCP, and More - Edition 6

Pakistan's First Oracle Blog - Thu, 2021-06-17 21:55

 Welcome to the next edition of weekly Cloud Vanity. There is so much razzmatazz about cloud that for a second we tend to think that every company is already on some sort of cloud. A recent study has found out that still only 35% of companies are in the cloud and rest of them are still thinking or planning to migrate. So still lot of opportunity there.


Announcing the AWS Security and Privacy Knowledge Hub for Australia and New Zealand

Few things have changed the world more than the internet, and at the heart of the internet is the open source LAMP stack. LAMP, short for Linux, Apache, MySQL, and PHP, enabled developers to build new, interactive web experiences

Australian Commonwealth Government agencies are subject to specific requirements set by the Protective Security Policy Framework (PSPF) for securing connectivity between systems that are running sensitive workloads, and for accessing less trusted environments, such as the internet.

Today, Dave Brown, VP of Amazon EC2 at AWS, announced the Graviton Challenge as part of his session on AWS silicon innovation at the Six Five Summit 2021.

AWS Step Functions allow you to build scalable, distributed applications using state machines. Until today, building workflows on Step Functions required you to learn and understand Amazon State Language (ASL).


Now’s the time to register for the free Azure Hybrid and Multicloud Digital Event on Tuesday, June 29, 2021, from 9:00 AM–11:00 AM Pacific Time, delivered in partnership with Intel.

For over three years, I have had the privilege of leading the SAP solutions on Azure business at Microsoft and of partnering with outstanding leaders at SAP and with many of our global partners to ensure that our joint customers run one of their most critical business assets safely and reliably in the cloud. 

There are many factors that can affect critical environment (CE) infrastructure availability—the reliability of the infrastructure building blocks, the controls during the datacenter construction stage, effective health monitoring and event detection schemes, a robust maintenance program, and operational excellence to ensure that every action is taken with careful consideration of related risk implications.

The power of 5G, IoT, and real-time AI will unlock new and innovative services for enterprises across the world to accelerate their transformation toward Industry 4.0 as they evolve and adopt diverse new business models. 

Cloud and edge computing are coming together as never before, leading to huge opportunities for developers and organizations around the world. Digital twins, mixed reality, and autonomous systems are at the core of a massive wave of innovation from which our customers already benefit.


As your organization evolves, the cloud can be a powerful tool to drive growth, improve efficiency, and reduce costs. In fact, the cloud is so powerful that most organizations find themselves running on multiple clouds

At its core, Data and Analytics allows us to make impactful decisions by deriving insights from our data. In the pursuit of making data meaningful, data scientists and engineers are often tasked with building end-to-end workflows to ingest, process and analyze data.

At Google Cloud, we believe moving to the cloud shouldn’t have to mean starting over from scratch. That’s why we’re on a mission to give you choices for how you run your enterprise workloads, including migrating and modernizing your Windows workloads. 

In times of significant disruption, organizations are faced with three choices: Retrench within legacy solutions, pause and do nothing while waiting for more data or different circumstances, or press ahead, potentially even accelerating to realize the desired outcome.

Our collective understanding of work—where it takes place and how it gets done—has been transformed over the last year.


The Clouds are Thickening: An Overview of The SaaS Ecosystem and Big Cloud Providers

The Move Toward Simplicity: Why a Single-Vendor Approach to AI-Powered Automation Matters

Crafting with XieSandi is an educational simulation video game that describes how to craft different things, such as handcrafting and DIY.

Imagine one hybrid cloud platform that provides the automation, observability and cloud-native capabilities necessary to keep business, technology and teams connected while delivering the best digital experiences now and in the future.

Cloud operating model refers to the operational model used by I&O organization when adopting cloud and trying to execute their cloud strategy. The model is used to transform the traditional IT management within an organization to be capable of managing the clouds that the business consumes.

Categories: DBA Blogs

Introduction to ARM Templates: Learn, Create and Deploy in Azure

Online Apps DBA - Thu, 2021-06-17 09:14

An ARM template is a block of code that defines the infrastructure and configuration for your project. It uses a declarative syntax to let you define your deployment in the form of JSON files. Template Format – In ARM Template, we need to define schema, content version, parameters, variables, functions, resources, and outputs. Azure Quickstart […]

The post Introduction to ARM Templates: Learn, Create and Deploy in Azure appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Azure Networking | A Brief Introduction for Beginners

Online Apps DBA - Thu, 2021-06-17 09:01

Azure Networking is a communication protocol for connecting multiple resources via the Internet. Azure provides various tools and services that make your network strong and easy to manage. Azure Virtual Network (VNet) is a private network with interconnected Azure Resources like Azure Virtual Machines, Infrastructure and Network. If you want to learn more on Azure […]

The post Azure Networking | A Brief Introduction for Beginners appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

How To Determine Host Is On OCI

Michael Dinh - Wed, 2021-06-16 14:35

Learned something new today.


Host is running OEM

[oracle@oemhost ~]$ oci-metadata
Instance details:
  Display Name: oemhost
  Region: phx - us-phoenix-1 (Phoenix, AZ, USA)
  Canonical Region Name: us-phoenix-1
  Availability Domain: jjZD:PHX-AD-2
  Fault domain: FAULT-DOMAIN-1
  OCID: ocid1.instance.oc1.phx.X
  Compartment OCID: ocid1.compartment.oc1..X
  Instance shape: VM.Standard2.16
  Image ID: ocid1.image.oc1.phx.X
  Created at: 1592424850729
  state: Running
    managementDisabled: False
    monitoringDisabled: False
  ociAdName: phx-ad-2
  hostname: oemhost
    regionKey: PHX
    realmDomainComponent: oraclecloud.com
    regionIdentifier: us-phoenix-1
    realmKey: oc1
  Instance Metadata:
    ssh_authorized_keys: ssh-rsa *
Networking details:
  VNIC OCID: ocid1.vnic.oc1.phx.X
  VLAN Tag: 293
  Private IP address:
  MAC address: 00:00:17:01:47:77
  Subnet CIDR block:
  Virtual router IP address:
[oracle@oemhost ~]$
__ATA.cmd.push(function() { __ATA.initDynamicSlot({ id: 'atatags-26942-60ca5383d3879', location: 120, formFactor: '001', label: { text: 'Advertisements', }, creative: { reportAd: { text: 'Report this ad', }, privacySettings: { text: 'Privacy', } } }); });


Tom Kyte - Wed, 2021-06-16 07:06
HI Tom, I am running one procedure using dbms_job.submit. but it is getting failed immediately. i wrote dbms_output command to output the error message. So how and where can I see that error message. Thanks in advance for your great support...
Categories: DBA Blogs

I cannot append data more than 32kb in CLOB

Tom Kyte - Wed, 2021-06-16 07:06
Hi, Am using CLOB data type in stored procedure. I am appending data from temporary table in CLOB I have a following plsql. DECLARE TYPE sturecord IS RECORD (stid NUMBER, Regid NUMBER); TYPE stutype IS TABLE OF sturecord; stutable stutype; stid CLOB := NULL; Regid CLOB := NULL; BEGIN SELECT DISTINCT (st.stu_id), rg.Reg_id BULK COLLECT INTO stutable FROM Student_details st, student_registration rg WHERE st.stu_id = rg.stu_id; FOR i IN stutable.FIRST .. stutable.LAST LOOP dbms_output.put_line(i) ; stid := stid || stutable (i).stid || ','; Regid := Regid || stutable (i).Regid || ','; END LOOP; END; In line 22 am getting error like "ORA-06502: PL/SQL: numeric or value error ORA-06512: at line 22" Temporary Table having more than 44000 record, approximate size is 3mb. CLOB Datatype has max length 4GB. Please help how to resolve this error. Thanks
Categories: DBA Blogs

Split Partition

Jonathan Lewis - Wed, 2021-06-16 06:33

This is a note I drafted a little over 5 years ago in response to a question on the Oracle developer forum about turning a simple heap table into a list partitioned table; but never got around to publishing it and now it’s not going to be of much benefit to most people because in 12c Oracle makes it very easy to handle the task of re-engineering partitioned tables online with a single “alter table” command.

But people do still run 11g, and the topic of changing, or repairing, a partitioning strategy has come up again very recently (more than once) in the context of 11g, so I thought I’d edit the draft and publish it.

There are, of course, many ways to start with a simple heap table and end up with a partitioned table, or start with a partitioned table in one state and end up with the table in a different state, and the method you choose may depend on various restrictions imposed from outside the database. One of the simpler strategies would be to “create table as select” to create a new partitioned table from the existing table and then rename the two tables – with possible variations such as exporting, creating an empty partitioned table, then re-importing ignoring creation errors.

Here’s a thought, though, that you might be able to take advantage if you need to enhance the partitioning of an existing partitioned table, but don’t have to re-partition all your data immediately. It’s an idea I came up with many years ago (long before the introduction of interval partitions) when a client had a daily partitioned table but had forgotten for a several months that they were supposed to do a regular “split partition” of the maxvalue partition in anticipation of future data arriving. They had a table with about 30 daily parititons, and one partition of about 500 days (18 months).

The first step, of course, was to split the big partiiton “above” the highest current value so that Oracle didn’t have to copy data into the resulting two partitions, so we could re-impose the regular splitting mechanism on the new, small, maxvalue partition. The follow-up step was to worry about splitting the one huge partition into daily chunks over the next few days or weeks.

The client’s initial thought was to write a simple pl/sql loop that generated and executed statements like:

alter table orders 
        split partition p20050907 
        at (to_date('02-Mar-2004','dd-Mon-yyyy')) 
        into (
                partition p20040302, 
                partition p20050907

This would split the first day off the very large partition, then the next pass through the loop would move on one day and split off the next daily partition, and so on. While the code was simple it was not an efficient strategy – just think about the arithmetic:

To keep things simple, imagine we have 512 days in the intial partition and each day’s data is exactly 1GB. On the first split we read and write 512GB; on the second split we read and write 511GB, on the fird split we read and write 510GB … on the 511th split we read and write 2GB and the job is done. In total the loop reads and writes 511 * (512 + 2) / 2 = 131,327 GB.  (Average of 1st and last, multiplied by number of terms).

Now think about coding a more complex algorithm:

  • First split the big partition into 2 partitions of 256 days each, reading and writing 512GB;
  • Then split the two resulting partitions into a total 4 partitions of 128 days each, reading and writing 512GB (in total);
  • Then split the 4 resulting partitions into a total of 8 partition of 64 days each, reading and writing 512GB (in total)
  • On the 9th cycle you will have to split 256 partitions of 2GB each to produce 512 partitions of 1GB each, reading and writing a total of 512GB.

In total the algorithm reads and writes 9 * 512 = 4,604 GB which is about 1/30th of the simpler algorithm.


This example of splitting partitions is just one specific case of a general principle.

It’s easy to code up an “obvious” strategy without considering whether there might be a slightly more complex but vastly more efficient strategy. In many cases, of course, the difference in resource costs between the simplest and the most efficient strategies may not be worth the extra development and testing time, but when you start dealing with large data volumes it is always worth asking three questions:

  1. Do I have a reasonable idea of the resources that will be taken up by the obvious strategy
  2. Is the obvious strategy the only possible strategy
  3. Is it worth spending more human resources designing and testing a better strategy to save machine resources at run-time.


AWS Solution Architect Training Day 10 & Day 11 FAQ’s

Online Apps DBA - Wed, 2021-06-16 00:50

AWS Solution Architecture Associate is the comprehensive Training for those who run enterprise architecture programs, as well as solutions architects or Beginners who want to learn AWS Solution Architecture Associate covering Cloud Concepts, AWS Services, Serverless Websites, Load Balancing, etc. The blog post – https://k21academy.com/awssa53 will cover the Q/A’s from Day 10 & 11 of […]

The post AWS Solution Architect Training Day 10 & Day 11 FAQ’s appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Google Identity and Access Management (IAM)

Online Apps DBA - Wed, 2021-06-16 00:38

Google Identity and Access Management is a service that gives cloud administrators the authority to decide who can take a particular action on a particular resource. It is important to have an IAM service associated with one’s cloud platform to prevent unauthorized access to sensitive data. Want to learn more about Google Identity and Access […]

The post Google Identity and Access Management (IAM) appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Amazon Inspector: Overview, Benefits and How to Get Started?

Online Apps DBA - Wed, 2021-06-16 00:24

➤ Security is crucial for everyone running applications on the cloud. Cloud security refers to the technologies, policies, and services that help to protect cloud-hosted data, applications, and infrastructure from various internet threats. Amazon Inspector is a security service that helps improve the security of deployed applications on AWS. ➤ Amazon Inspector is an AWS […]

The post Amazon Inspector: Overview, Benefits and How to Get Started? appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs


Subscribe to Oracle FAQ aggregator