Feed aggregator

Certified Kubernetes Administrator | Day 1 & Day 2 Training Concepts

Online Apps DBA - 10 hours 12 min ago

K8s Architecture, Components, Installation, and Networking Kubernetes is an open-source conainer tool for orchestration. It can automate the processes such as deploying, and managing containerized applications. Kubernetes follows a very straightforward architecture with flexibility. It consists of master nodes and worker nodes. Master communicates with the worker node with the help of API servers. Kubernetes […]

The post Certified Kubernetes Administrator | Day 1 & Day 2 Training Concepts appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Surpriseeee : )

H.Tonguç Yılmaz - 15 hours 57 sec ago
Let’s make yet another fresh start here, sharing platform became Linkedin for me for the last years but I really missed writing my experiences in detail, let’s start with the recent changes for me: 1. We left İstanbul 4 years ago and moved to my home town Fethiye, started working remotely with my wife long…More

Introduction to Azure SQL Database For Beginners & Steps to Deploy

Online Apps DBA - Fri, 2021-09-17 05:45

There are very few relational database systems as established and widely used as Microsoft’s SQL Server. SQL Server on Microsoft Azure comes in 3 different types (commonly known as the Azure SQL family): 1. SQL Server on Azure VM (IaaS) 2. Azure SQL Database (PaaS) 3. Azure SQL Managed Instance (PaaS). The IaaS offering, SQL […]

The post Introduction to Azure SQL Database For Beginners & Steps to Deploy appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Schedule Tasks Using SQL Server Agent

Online Apps DBA - Fri, 2021-09-17 04:04

In this blog, we are going to cover Schedule Tasks Using SQL Server Agent In Database systems that need regular maintenance, which includes tasks like making backups and updating statistics. Maintenance may also include regularly scheduled jobs that execute against a database. What is Task Scheduling? Database systems need regular maintenance, which includes tasks like […]

The post Schedule Tasks Using SQL Server Agent appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Introduction to Azure SQL Database For Beginners & Steps to Deploy

Online Apps DBA - Fri, 2021-09-17 00:53

There are very few relational database systems as established and widely used as Microsoft’s SQL Server. SQL Server on Microsoft Azure comes in 3 different types (commonly known as the Azure SQL family): 1. SQL Server on Azure VM (IaaS) 2. Azure SQL Database (PaaS) 3. Azure SQL Managed Instance (PaaS). The IaaS offering, SQL […]

The post Introduction to Azure SQL Database For Beginners & Steps to Deploy appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Happy 17th Birthday to this Oracle Security Blog

Pete Finnigan - Thu, 2021-09-16 14:46
It is almost 17 years since I started this blog on the 20th of September 2004. I had actually already been sort of blogging without blog software before that since 10th February 2004 with my ramblings section of my website....[Read More]

Posted by Pete On 16/09/21 At 11:24 AM

Categories: Security Blogs

CLOB column over DB Link

Tom Kyte - Wed, 2021-09-15 22:26
Hi Tom, We have a query which has to get a set of rows over the db link which has a CONTAINS predicate on a column of CLOB. E.g. There is a DB A and DB B with table T1( c1 varchar2(10),c2 clob) . I want to run a query from DB A using dblink on DB B to query T1 which has a CONTAINS predicate on c2 and based on the query the rows have to return c1 from t1. Can you suggest anyway in which we can get this done. We have a couple of restrictions though: WE cant insert into DB A from DB B. Table T1 contains around a 100 thousand rows and has around 20 columns. Thanks Ramkumar
Categories: DBA Blogs

[Recap] Oracle Cloud Infrastructure Architect Associate | Training Day 2 | Networking Concepts and Overview

Online Apps DBA - Wed, 2021-09-15 06:09

 Oracle Cloud Infrastructure is a broad platform of public cloud services that allows customers to build and run wide range of applications.  Oracle Cloud Infrastructure Architect has a deep understanding of cloud and provides solutions on Oracle Infrastructure and services.  Responsibilities ➽ Advising stakeholders and translating business requirements into secure, scalable, and reliable cloud solutions.  Skills ➽ […]

The post [Recap] Oracle Cloud Infrastructure Architect Associate | Training Day 2 | Networking Concepts and Overview appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

[Recap] Oracle Cloud Infrastructure Architect Associate | Training Day 1 | Identity and Access Management

Online Apps DBA - Wed, 2021-09-15 05:53

 Oracle Cloud Infrastructure is a deep and broad platform of public cloud services enabling customers to build and run a wide range of applications.  Oracle Cloud Infrastructure Architect has a deep understanding of cloud and provides solutions on Oracle Infrastructure and services.  Responsibilities ➽ Advising stakeholders and translating business requirements into secure, scalable, and reliable cloud […]

The post [Recap] Oracle Cloud Infrastructure Architect Associate | Training Day 1 | Identity and Access Management appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Using Buildkite to perform Snyk Open Source and Snyk Code (SAST) tests

Pas Apicella - Tue, 2021-09-14 23:15

Buildkite is a platform for running fast, secure, and scalable continuous integration pipelines on your own infrastructure. In the example below I will run my Buildkite pipeline on my Macbook to perform two Snyk Tests, one for Open-Source dependancies and the other a SAST test of the code itself.

Snyk is an open source security platform designed to help software-driven businesses enhance developer security.

You will need an account on Snyk and Buildkite to follow the steps below.

Steps

1. First in Snyk let's create a Service Account which will be the Snyk token I will use to authenticate with. You can use the Snyk API Token but the service account is all you need to run "Snyk Tests" so makes sense to use that.


2. Next let's store that Service Account token somewhere where I can safely inject that into my pipeline at the appropriate step. In this example I am using "Google Secret Manager" but there are other choices of course.


Note: We will be using the secret NAME shortly "PAS_BUILDKITE_SA_SNYK_TOKEN"

3. You will need a Buildkite agent on your local Infrastructure in my case I using my Macbook so that's done as follows

https://buildkite.com/docs/agent/v3/macos 

pasapicella@192-168-1-113:~/demos/integrations/buildkite$ ./start-agent.sh

   _           _ _     _ _    _ _                                _
  | |         (_) |   | | |  (_) |                              | |
  | |__  _   _ _| | __| | | ___| |_ ___    __ _  __ _  ___ _ __ | |_
  | '_ \| | | | | |/ _` | |/ / | __/ _ \  / _` |/ _` |/ _ \ '_ \| __|
  | |_) | |_| | | | (_| |   <| | ||  __/ | (_| | (_| |  __/ | | | |_
  |_.__/ \__,_|_|_|\__,_|_|\_\_|\__\___|  \__,_|\__, |\___|_| |_|\__|
                                                 __/ |
 https://buildkite.com/agent                    |___/

2021-09-15 11:09:33 NOTICE Starting buildkite-agent v3.32.3 with PID: 50130
2021-09-15 11:09:33 NOTICE The agent source code can be found here: https://github.com/buildkite/agent
2021-09-15 11:09:33 NOTICE For questions and support, email us at: hello@buildkite.com
2021-09-15 11:09:33 INFO   Configuration loaded path=/usr/local/etc/buildkite-agent/buildkite-agent.cfg
2021-09-15 11:09:33 INFO   Registering agent with Buildkite...
2021-09-15 11:09:35 INFO   Successfully registered agent "y.y.y.y.tpgi.com.au-1" with tags []
2021-09-15 11:09:35 INFO   Starting 1 Agent(s)
2021-09-15 11:09:35 INFO   You can press Ctrl-C to stop the agents

4. You're now ready to create a pipeline. A pipeline is a template of the steps you want to run. There are many types of steps, some run scripts, some define conditional logic, and others wait for user input. When you run a pipeline, a build is created. Each of the steps in the pipeline end up as jobs in the build, which then get distributed to available agents.

In the example below our pipeline is created from a GitHub repo and then select the default branch. At that point incoming webhooks are sent to Buildkite by source control providers (GitHub, GitLab, Bitbucket, etc.) to trigger builds, in this scenario we using GitHub


5. Let's go ahead and actually just edit the build steps using YAML. My final YAML is as follows and I explain below why it looks this way but in short I just want to run two snyk tests rather then actually deploy anything for this demo.

steps:
  - commands:
      - "snyk config set api=$$SNYK_SA_TOKEN_VAR"
      - "snyk test --severity-threshold=$$SEVERITY_THRESHOLD"
      - "snyk code test --org=$$SNYK_ORG"
    plugins:
      - avaly/gcp-secret-manager#v1.0.0:
          credentials_file: /Users/pasapicella/snyk/clouds/gcp/buildkite-secrets-gcp.json
          env:
            SNYK_SA_TOKEN_VAR: PAS_BUILDKITE_SA_SNYK_TOKEN
    env:
      SEVERITY_THRESHOLD: "critical"
      SNYK_ORG: "pas.apicella-41p"
    label: "Employee API Snyk Test"

Few things to note here:

  • I am using a GCP secret manager plugin to retrieve my Snyk SA token with a name as follows "PAS_BUILDKITE_SA_SNYK_TOKEN"
  • I am using a Google Service Account JSON so I can authenticate with GCP and retrieve my secret "SNYK_SA_TOKEN_VAR", you will need to use a Service Account with privileges to at least READ from Google Secret Manager
  • I am using some local non sensitive ENV variables which get used at the appropriate time
  • I have three commands of which the first command sets my Snyk API token for the Snyk CLI
  • I have not installed the Snyk CLI because it already exists on my Macbook 
  • I am only looking for my Snyk tests to fail if it finds any CRITICAL issues only
  • I should be running a "mvn package" here but I can still execute a "snyk test" without it for demo purposes as we have a pom..xml
  • I could also build a container in the pipeline from the source code and then run a "snyk container test" as well, in fact I could even run "snyk iac test" against any IaC files in the repo as well
  • If a test fails we can easily run "snyk monitor" to load the results into the Snyk App but for this demo we don't do that

6. Now we can manually run a build or wait for triggering event on our repo, here is some screen shots of what it looks like including some failures where we find vulnerabilities in a separate node.js repo





 

It makes more sense to create a Buildkite plugin for Snyk rather than execute commands using a script and here is an example of one below. Having said that the commands you run to execute a "snyk test" are simple enough to include in the pipeline YML without the need for a plugin here especially if you have infrastructure already setup with the ability to run the "snyk cli". A plugin would be the right approach here though as per the example below.

https://github.com/seek-oss/snyk-buildkite-plugin


Hopefully you have seen how easy it is to continuously avoid known vulnerabilities in your dependencies and code, by integrating Snyk into your continuous integration pipeline with Buildkite.

More Information
Snyk
Categories: Fusion Middleware

Register for a Free Webinar with PFCLForensics for Breached Oracle Databases

Pete Finnigan - Tue, 2021-09-14 07:46
I will be giving a free webinar hosted with our reseller/distributer in Slovenia and the Balkans region - Palsit . The free webinar is at 09:00 UK time or 10:00 CET time on the 22nd September 2021. In this webinar....[Read More]

Posted by Pete On 14/09/21 At 01:28 PM

Categories: Security Blogs

How to Call Fusion REST api in PLSQL using apex web service

Tom Kyte - Mon, 2021-09-13 15:26
Hi, I'm trying to consume Oracle fusion rest web service's in PLSQL using apex_web_service. I'm getting the below error. could you please guide me on this. also Pls suggest how to enable the basic authentication in web service like how to set the basic auth. ORA-20987: APEX - One or more cookies set in apex_util.g_request_cookies contain an invalid value. - Contact your application administrator. Details about this incident are available via debug id "49001 <code> CREATE OR REPLACE FUNCTION ATP_REST RETURN CLOB AS l_clob CLOB; l_result VARCHAR2(32767); BEGIN APEX_WEB_SERVICE.g_request_cookies.delete(); APEX_WEB_SERVICE.g_request_cookies(1).name := '';---i'm passing the username (baisc auth) APEX_WEB_SERVICE.g_request_cookies(1).value := '';---pwd l_clob := APEX_WEB_SERVICE.make_rest_request( p_url => 'https://ehpv-dev8.fa.em2.oraclecloud.com/bpm/api/4.0/tasks', p_http_method => 'GET' -- p_parm_name => APEX_UTIL.string_to_table('p_int_1:p_int_2'), -- p_parm_value => APEX_UTIL.string_to_table(p_int_1 || ':' || p_int_2) ); DBMS_OUTPUT.put_line('l_clob=' || l_clob); RETURN l_clob; END; / </code> Regards, Praveen Paulraj
Categories: DBA Blogs

Oracle 12c EMON processing features

Tom Kyte - Mon, 2021-09-13 15:26
I read the article, titled: <b>Event Monitor Process: Architecture and Known Issues (Doc ID 105067.1)</b> ? Notification implements a high-watermark scheme where when the backlog of notification events hit an in-memory limit the messages are, in the case of 9.2, spilled onto disk into the SYS.AQ_EVENT_TABLE_Q queue if a watermark has been set. In 9.2 the default value for the watermark is 0 which means that the no messages will spill onto disk and the entire shared pool could be used for notification events. In 10.1 onwards the procedures DBMS_AQADM.GET_WATERMARK and DBMS_AQADM.SET_WATERMARK are available to set the amount of memory available for notification events but the messages are no longer spilled onto disk. Instead the enqueueing process are subject to flow control until the backlog has been cleared by the emon process. ? What does it mean for me as a developer? I?ve a 12.2 EE database under Linux(64 bit). I registered a notification callback procedure. How can I know , when enqueuing a message to the queue, that my message will be approved by EMON, or it will be placed to the backlog? And why should I know that? Does ?until the backlog has been cleared by the emon process? mean that entire backlog will be lost without any further processing by EMON? I noticed many times that there are messages in the queue and in the same time EMON?s job PLSQL_NTFN hangs in state ?Waiting for messages in the queue?. And these messages seems to be never processed. May be it is the case of clearing backlog? And where can I find an information (in server logs, in database objects) about clearing backlog and about MSGId?s of messages that had been cleared? TIA, Andrew.
Categories: DBA Blogs

INLIST ITERATOR

Tom Kyte - Mon, 2021-09-13 15:26
Hi Tom, Some questions about the SQL tuning. 1) I found that when using "IN" in the where clause , INLIST ITERATOR is shown on the explain plan in a cost-based database (and using the index correctly, the response is fast). However, no such INLIST ITERATOR in rule-based (and using the full table scan, the response is slow). Is INLIST ITERATOR only occur on cost-based? Is it possible to force the optimizer to use INLIST ITERATOR in a rule-based database (without any hints added to the SQL statement or using alter session set optimizer_mode = choose)? Or is it possible to rewrite the "IN" to other forms such that the index can be used in rule-based database? I have tried to rewrite "IN" to "OR" but the index still cannot be used. The only way the index can be used is using UNION ALL the values of "IN". 2) If the database is rule-based (optimizer_mode=rule), and the table has statistics, will Oracle use cost-based to answer the query? I rememeber that Oracle will use rule-based if the optimizer_mode is set to rule (from Oracle documentation), no matter whether the table has statistics. But I found that in some situation Oracle will use cost-based. Thanks, David
Categories: DBA Blogs

Defaulting Argument Values in a BASH script

The Anti-Kyte - Mon, 2021-09-13 13:49

I recently found out (again) how to default argument values in a shell script, so I thought I’d write it down this time.
The ABBA flavour in what follows is because we’re talking about BASH – the Bourne Again SHell and Bjorn Again are an ABBA tribute band. This is quite handy because the ABBA back catalogue is rather versatile having already lent itself to an explanation Oracle password complexity.

Welcome to the inside of my head. Sorry about the mess…

Let’s start with a simple script – abba.sh :

#!/bin/bash

if [ $# = 0 ];  then
    echo 'No argument values passed in'
else
    TRACK=$1
    echo $TRACK
fi;

…which we now make executable :

chmod u+x abba.sh

Run this – first with no arguments passed in and then with a single argument and we get :

If we want to default the value of $TRACK (and let’s face it, who doesn’t love a bit of Dancing Queen), we can do the following (saved as abba2.sh) …

#!/bin/bash

TRACK="${1:-Dancing Queen}"
if [ $# != 1 ];  then
    echo 'No argument values passed in'
fi;
echo $TRACK

Now, when we run this, we can see that it’ll accept an argument as before. However, if no argument is passed in the argument count is unaffected but the variable is initialized to it’s default value :

Migrate Your Relational Database To Azure

Online Apps DBA - Mon, 2021-09-13 03:48

In this blog, we are going to cover Migrate Your Relational Database To Azure. In Azure, you can migrate your database servers directly to IaaS VMs (pure lift and shift), or you can migrate to Azure SQL Database, for additional benefits. Azure SQL Database offers the managed instance and full database-as-a-service (DBaaS) options. What Is […]

The post Migrate Your Relational Database To Azure appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

FastAPI on Kubernetes with NGINX Ingress

Andrejus Baranovski - Mon, 2021-09-13 03:29
A simple tutorial about a complex thing - how to expose FastAPI app to the world on Kubernets with NGINX Ingress Controller. I explain the structure of Kubernetes Pod for FastAPI along with Kubernetes service. I show how FastAPI properties should be set to be accessible through Ingress path definition. You will learn how to check the log for NGINX Ingress Controller and FastAPI Pod.

 

How to Become a Successful AWS DevOps Engineer

Online Apps DBA - Mon, 2021-09-13 01:51

DevOps is becoming the trend in the cloud, and the need for DevOps professionals is also growing with time DevOps Engineer ➽ DevOps engineers are IT professionals who introduce processes, tools, and methodologies to complete the need of the software development life cycle, from coding or deployment to maintenance and updates.  Roles and Responsibilities ➽ DevOps Engineers […]

The post How to Become a Successful AWS DevOps Engineer appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Considering Reclaimed Wooden Flooring for Your Home

OraQA - Mon, 2021-09-13 01:33

Home is a place where you find real peace of mind. This is the main point why most of the contemporary individuals feel their home as a recreational place to live in. When it comes to adding additional charm to your home, you need to install wooden flooring. Obviously, wooden flooring is a great choice to go with when it comes to transforming the look and feel a home.

However, wooden flooring is a great flooring option for homeowners, but problem comes with its price. It means that many homeowners find wooden flooring an expensive option to go with.

Are you also among those homeowners?

If so, then reclaimed wood flooring can be the best solution for your flooring requirements.

What Is Reclaimed Wooden Flooring?

As the name suggests reclaimed wood flooring comes out used wooden. Whether it is about using damage wooden furniture or stuffs made out of wooden, you can reclaim the same wood for other requirements. In other words, you create wooden flooring out of used wooden.

Engineered flooring or reclaimed wooden flooring is surely a great choice for modern homeowners. Since it is an echo-friendly flooring option, most of the contemporary homeowners are choosing it as their flooring option.

Can I Make My Flooring Stylish and Attractive with Engineered Wood Flooring?

There are individuals who assume that they may not be able to avail the benefits of using wooden flooring manufactured out of fresh wooden. Of course, it’s a wrong perception to go with. If you are also dealing with this misconception, you need to eliminate it as soon as possible.

You need to remember that engineered wood flooring is surely a great choice. Moreover, you can easily make your reclaimed wooden flooring more stylish and amazing than ever before. Obviously, choosing used wood for manufacturing wood flooring doesn’t mean that you can’t make it a desired design. You can do whatever you want to do with reclaimed wood.

What Are My Flooring Budget and Requirements?

If you don’t want to repent on your own buying decision at later stage, you first need to know about your budget and flooring requirements. Obviously, you won’t choose a wooden flooring option that you actually don’t need. Similarly, you will never like to choose an expensive flooring option that may not fit well with your limited budget.

So, if you don’t want to cope with unwanted financial trouble, you first need to take your budget and flooring requirements into consideration. Taking these two significant factors into consideration can help you making your life better than ever before.

Where to Find Best Manufacturer of Reclaimed Wooden Flooring?

If you want to choose top-quality of wooden flooring, you first need to know about a right wood flooring manufacturer. Of course, a right manufacturer can manufacture amazing quality, style and design of reclaimed wood flooring for modern homes.

When it comes to searching for the best reclaimed wooden flooring manufacturer, you need to look at nowhere else but internet. By searching online, you can know about top manufacturers of engineered wood flooring online.

The post Considering Reclaimed Wooden Flooring for Your Home appeared first on ORA QA.

Slay Imposter Syndrome for AWS Certification Exams

Online Apps DBA - Mon, 2021-09-13 00:43

Have you ever doubt your capability or felt an internalized fear It is most common to students or learners before attending exams  Imposter Syndrome ➽ Imposter Syndrome is the psychological pattern in which individuals doubt their skills or accomplishments and have an internalized fear of being exposed as ‘fraud.’  How can it affect you? ➽ Imposter Syndrome is not […]

The post Slay Imposter Syndrome for AWS Certification Exams appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Pages

Subscribe to Oracle FAQ aggregator