Feed aggregator

[Blog] [Solved] RC-20200: Fatal: Could not find Unzip When Installing EBS R12.1

Online Apps DBA - Thu, 2019-02-14 05:54

While installing EBS R12.1 on Linux x86-64, the following error appears RW-50004. This error is caused due to an error RC-20200… Stucked with this Error and want to know the Solution? Visit: https://k21academy.com/appsdba46 and find our new blog covering: ✔ Root Cause for the Error RC-20200. ✔ Solution for the error. While installing EBS R12.1 […]

The post [Blog] [Solved] RC-20200: Fatal: Could not find Unzip When Installing EBS R12.1 appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

[BLOG] Oracle GoldenGate 12c : Troubleshooting using LogDump Utility

Online Apps DBA - Thu, 2019-02-14 05:46

Are you facing an issue in Oracle GoldenGate in Using LogDump Utility? If yes, then visit: https://k21academy.com/goldengate13 and learn about: ✔ What are Trail Files ✔ LogDump Utility In Troubleshooting GoldenGate Issues and much more… Are you facing an issue in Oracle GoldenGate in Using LogDump Utility? If yes, then visit: https://k21academy.com/goldengate13 and learn about: […]

The post [BLOG] Oracle GoldenGate 12c : Troubleshooting using LogDump Utility appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Oracle 19c and my favorite list

Syed Jaffar - Thu, 2019-02-14 05:37
Today (14-Feb-2019) Oracle officially released the 19c docs and Oracle Database 19c for Exadata through edelivery channel. Since the news is out, Oracle community is busy talking about 19c availability and sharing articles about 19c etc.

I spent a little amount of time to scan through some of really useful features of 19c for DBAs, and here is my list:
  • Availability
    • Simplified DB parameter management in Broker Configuration
    • Flashback Standby DB when Primary DB is flashed back
    • Active Data Guard DML Redirection
    • New parameter for tuning automatic outage resolution with DG
  • Data Warehousing
    • SQL Diagnostic and Repair Enhancements
    • Automatic Indexing 
    • Performance Enhancement for in-memory external tables
    • Real-Time Statistics
    • High Frequency Automatic Optimizer Statistics Collection
  • Automated install, config and patch
  • Automated upgrade, migration and utilities
  • Performance
    • SQL Quarantine 
    • Real-time monitoring for Developers
    • Workload capture and Replay in a PDB
  • RAC and Grid
    • Automated Transaction Draining for Oracle Grid Infrastructure Upgrades
    • Zero-downtime Oracle Grid Infrastructure Patching

I will start writing series of articles about my favorite Oracle 19c features. Stay tune.



References:
https://www.oracle.com/a/tech/docs/database19c-wp.pdf
https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-06A15128-1172-48E5-8493-CD670B9E57DC
https://medium.com/oracledevs/oracle-database-19c-now-available-on-oracle-exadata-9b57963e2c89

[Video 1 of 5 Part Series] Networking in Oracle’s Gen2 Cloud: Who should learn & Why?

Online Apps DBA - Thu, 2019-02-14 05:34

[Video 1 of 5 Part Series] Networking in Oracle’s Gen2 Cloud: Who should learn & Why? Whether you are deploying Database or Application on Cloud, the very first thing you will do is create a Network (VCN & Subnet). You then will decide which part of Application/Database is in what Subnet, What Ports to open […]

The post [Video 1 of 5 Part Series] Networking in Oracle’s Gen2 Cloud: Who should learn & Why? appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Update production database from ETL Process

Tom Kyte - Wed, 2019-02-13 21:46
Hello, Ask Tom Team. I am using a Microsoft SSIS ETL Package to insert data to Oracle (source and destination). I want to do an incremental load every day but I have to flag the rows that are already loaded in the destination. It is not just s...
Categories: DBA Blogs

DB Link between Oracle 12c (Linux) and Oracle 11.2 R2 (Windows)

Tom Kyte - Wed, 2019-02-13 21:46
Hi everyone, I have a problem with DB Link. I'm trying to create a dblink from and Oracle 12c (installed on Linux Server) and Oracle 11.2 R2 (installed on Windows Server). I've correctly created the dblink, but when i try to query the result is: "<b...
Categories: DBA Blogs

Merge using collections

Tom Kyte - Wed, 2019-02-13 21:46
Hi Tom, I am just trying to understand if the table function will work with collections. Please find my below code. Script: <code>create table setm_students (id number, name varchar2(10)); create table setm_students_target as select * fro...
Categories: DBA Blogs

getting rows N through M of a result set

Tom Kyte - Wed, 2019-02-13 21:46
I would like to fetch data after joining 3 tables and sorting based on some field. As this query results into approx 100 records, I would like to cut the result set into 4, each of 25 record. and I would like to give sequence number to each r...
Categories: DBA Blogs

Permission issues when loading text file to external table

Tom Kyte - Wed, 2019-02-13 21:46
Hey Tom, First of all, I'm sorry if this has been asked already, I simply couldn't find an answer after days of googling. Here it goes: I've created a SP to load a text file into an external table on 10g as per instructed here and many more places...
Categories: DBA Blogs

Integrating Cloud Foundry with Spinnaker

Pas Apicella - Wed, 2019-02-13 19:36
I previously blogged about "Installing Spinnaker on Pivotal Container Service (PKS) with NSX-T running on vSphere" and then how to invoke UI using a "kubectl port-forward".

http://theblasfrompas.blogspot.com/2019/02/installing-spinnaker-on-pivotal.html
http://theblasfrompas.blogspot.com/2019/02/exposing-spinnaker-ui-endpoint-from.html

Steps

1. Exec into hal pod using a command as follows:

$ kubectl exec --namespace default -it myspinnaker-spinnaker-halyard-0 bash

Note: You can get the POD name as follows

papicella@papicella:~$ kubectl get pods | grep halyard
myspinnaker-spinnaker-halyard-0       1/1       Running     0          6d

2. Create a file settings-local.js in the directory ~/.hal/default/profiles/

window.spinnakerSettings.providers.cloudfoundry = {
  defaults: {account: 'my-cloudfoundry-account'}
};

3. Create a file clouddriver-local.yml with contents as follows. You can add multiple accounts but in this example I am just adding one

cloudfoundry:
  enabled: true
  accounts:
    - name: PWS
      user: papicella-pas@pivotal.io
      password: yyyyyyy
      api: api.run.pivotal.io

4. If you are working with an existing installation of Spinnaker, apply your changes:

spinnaker@myspinnaker-spinnaker-halyard-0:~/.hal/default/profiles$ hal deploy apply
+ Get current deployment
  Success
+ Prep deployment
  Success
Problems in halconfig:
- WARNING There is a newer version of Halyard available (1.15.0),
  please update when possible
? Run 'sudo apt-get update && sudo apt-get install
  spinnaker-halyard -y' to upgrade

+ Preparation complete... deploying Spinnaker
+ Get current deployment
  Success
+ Apply deployment
  Success
+ Run `hal deploy connect` to connect to Spinnaker.

5. Once this is done in the UI you will see any applications in your Organisations appear in this example it's a single application called "Spring" as shown below



6. In the example below when "Creating an Application" we can select the ORGS/Spaces we wish to use as shown below



More Information

Cloud Foundry Integration
https://www.spinnaker.io/setup/install/providers/cf/

Cloud Foundry Resource Mapping
https://www.spinnaker.io/reference/providers/cf/



Categories: Fusion Middleware

Microsoft Azure: Creating a Linux machine and a first login via ssh

Dietrich Schroff - Wed, 2019-02-13 13:08
After having logged in to azure.microsoft.com i navigated to "Virtual machines":
There i hit the "create virtual machine" button and a wizard was opened, where the following steps have to be completed:


So here are the basic settings:


Inside the basic settings you have to choose the name and a resource group (in my case i had to create a resource group, because its my first vm).


Then i had to select an image:
Below this drop down is a link "browse all images and disks". If you choose that, you get many more options:

At "Administrator account" i chose "SSH public key" i added one (this field has a built-in check function, so if there is an copy/paste error, you get an immediate response):
Then i added the following for the disks:
And i left "networking" to the defaults up to the "select inbound ports":



For "Management" i had to create a storage account. This account has to unique  (mystorage  was already taken by some other azure users).


I left "Guest config" unchanged:
"Tags":
And then i had to wait some seconds at "Review + create" until the "validation passed" messaged appeared.
After that i had to wait for three minutes until my vm was ready to use:

And then i got the following dashboard for my vm:
 
A login to this machine was successful:

 ssh 40.112.94.136
The authenticity of host '40.112.94.136 (40.112.94.136)' can't be established.
ECDSA key fingerprint is SHA256:PxIwA6+b0lfcrV//yXpFUPjY3jiD2GgxME57EYQlx9Y.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '40.112.94.136' (ECDSA) to the list of known hosts.
Welcome to Ubuntu 18.04.1 LTS (GNU/Linux 4.15.0-1036-azure x86_64)

 * Documentation:  https://help.ubuntu.com
 * Management:     https://landscape.canonical.com
 * Support:        https://ubuntu.com/advantage

  System information as of Sat Jan 26 19:06:21 UTC 2019

  System load:  0.0               Processes:           113
  Usage of /:   4.1% of 28.90GB   Users logged in:     0
  Memory usage: 3%                IP address for eth0: 10.0.0.4
  Swap usage:   0%

  Get cloud support with Ubuntu Advantage Cloud Guest:
    http://www.ubuntu.com/business/services/cloud

0 packages can be updated.
0 updates are security updates.



The programs included with the Ubuntu system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.

Ubuntu comes with ABSOLUTELY NO WARRANTY, to the extent permitted by
applicable law.

To run a command as administrator (user "root"), use "sudo ".
See "man sudo_root" for details.



February 2019 Updates to EBS Technology Codelevel Checker (ETCC)

Steven Chan - Wed, 2019-02-13 09:51

The E-Business Suite Technology Codelevel Checker (ETCC) tool helps you identify application or database tier overlay patches that need to be applied to your Oracle E-Business Suite Release 12.2 system. ETCC maps any missing overlay patches to the default corresponding Database Patch Set Update (PSU) patches, and displays them in a patch recommendation summary.

The ETCC tool was designed to be self-documenting, but you can find an introduction to it in Section 3 of Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (MOS Note 1594274.1).

What’s New

ETCC has been updated to include bug fixes and patching combinations for the following recommended versions of the following updates:

  • Oracle Database Proactive BP 12.1.0.2.190115
  • Oracle Database PSU 12.1.0.2.190115
  • Oracle JavaVM Component Database PSU 12.1.0.2.190115
  • Oracle Database Patch for Exadata BP 11.2.0.4.190115
  • Oracle Database PSU 11.2.0.4.190115
  • Oracle JavaVM Component Database PSU 11.2.0.4.190115
  • Microsoft Windows Database PSU 11.2.0.4.190115
  • Oracle JavaVM Component 2.1.0.2.180417 on Windows
  • Microsoft Windows Database BP 11.2.0.4.180417
  • Oracle JavaVM Component 11.2.0.4.180417 on Windows

Obtaining ETCC

We recommend always using the latest version of ETCC, as new bugfixes will not be checked by older versions of the utility. The latest version of the ETCC tool can always be downloaded via Patch 17537119 from My Oracle Support.

References

Related Articles

Categories: APPS Blogs

[Blog] Oracle GoldenGate: Supplemental Logging & Its Importance

Online Apps DBA - Wed, 2019-02-13 06:05

Do you want to learn about Supplemental Logging and its Importance in GoldenGate?   If yes, then visit: https://k21academy.com/goldengate18 and learn about: ✔ Supplemental Logging Levels ✔Why is Supplemental Logging Required & much more… Do you want to learn about Supplemental Logging and its Importance in GoldenGate?   If yes, then visit: https://k21academy.com/goldengate18 and learn […]

The post [Blog] Oracle GoldenGate: Supplemental Logging & Its Importance appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Best practices for keeping passwords hidden

Tom Kyte - Wed, 2019-02-13 03:26
Can you recommend best practices for keeping passwords hidden in command lines for impdp/expdp, shell scripts etc.?
Categories: DBA Blogs

Object View To Manipulate Data In Tables

Tom Kyte - Wed, 2019-02-13 03:26
Hi, I have been using Object View, User Defined Types in Oracle for sometime. I tried to follow the approach here. <code>https://docs.oracle.com/cd/A64702_01/doc/server.805/a58241/ch_ov.htm</code> I am wondering if we put all the data manipul...
Categories: DBA Blogs

Lob: Basic - Secure

Tom Kyte - Wed, 2019-02-13 03:26
We observed frequent wait event 'enq HW - contention' in performance reports with SQL includes LOB Objects. Lob object Details ? Object - WF_WORKFLOW Owner - IBMUCD What changes we can face if we convert LOB from basic to secure?...
Categories: DBA Blogs

Distinct count across multiple tables

Tom Kyte - Wed, 2019-02-13 03:26
I have three possible places where accounts data can be requested. On the MONTHLY USAGE, HISTORY USAGE or ENROLLMENT tables. The same account(s) could be on all three tables, or on the table(S) multiple times, but some accounts could be on one or ...
Categories: DBA Blogs

lost update

Tom Kyte - Wed, 2019-02-13 03:26
Tom, I was reading your book expert one-on-one and in Chapter 3: Locking and Concurrency, you have mentioned a scenario of lost update. I was trying to simulate that and I did not succeed in doing the test. I tried to update emp table in session...
Categories: DBA Blogs

Update a column after multiple criteria

Tom Kyte - Wed, 2019-02-13 03:26
Hello, I have the following data: Id AMAOUNT NO_PRATITION ID_STRATEGY 1 100 99 XXX 2 200 99 XXX 3 0 99 YYY 4 100 99 YYY 5 200 99 YYY 6 0 99 ZZZ 7 100 99 ZZZ 8 200 99 ...
Categories: DBA Blogs

How Oracle Database gets the data from multiple left joins

Tom Kyte - Wed, 2019-02-13 03:26
Hi Tom, I came across a scenario today. table1 id integer name varchar table2 id integer name varchar designation varchar table3 id integer name varchar relation_status varchar I have the query as below which is working fine ...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator