Feed aggregator

Using a custom bootloader for my smartphone: TWRP on Samsung Galaxy A3

Dietrich Schroff - Fri, 2020-04-03 15:09
I read about /e/ some days ago and i decided to install this on my old smartphone (a samsung A3).

So first: What is /e/?
So i started at

where i learned, that i have to install a custom bootloader on my smartphone. This is very good explained at /e/:

(You will find there the description how to install "heimdall" and "adb")

schroff@zerberus:~/bin$ sudo ./heimdall flash --verbose --RECOVERY ~/Downloads/twrp-3.3.0-0-a3xelte.img --no-reboot
Heimdall v1.4.2

Copyright (c) 2010-2017 Benjamin Dobell, Glass Echidna

This software is provided free of charge. Copying and redistribution is

If you appreciate this software and you would like to support future
development please consider donating:

Initialising connection...
Detecting device...
Manufacturer: "SAMSUNG"
Product: "Gadget Serial"

length: 18
device class: 2
S/N: 0
VID:PID: 04E8:685D
bcdDevice: 021B
iMan:iProd:iSer: 1:2:0
nb confs: 1

interface[0].altsetting[0]: num endpoints = 1
Class.SubClass.Protocol: 02.02.01
endpoint[0].address: 83
max packet size: 0010
polling interval: 09

interface[1].altsetting[0]: num endpoints = 2
Class.SubClass.Protocol: 0A.00.00
endpoint[0].address: 81
max packet size: 0200
polling interval: 00
endpoint[1].address: 02
max packet size: 0200
polling interval: 00
Claiming interface...
Setting up interface...

Initialising protocol...
Protocol initialisation successful.

Beginning session...

Some devices may take up to 2 minutes to respond.
Please be patient!

Session begun.

Downloading device's PIT file...
WARNING: Empty bulk transfer after receiving packet failed. Continuing anyway...
PIT file download successful.

Uploading RECOVERY
0%ERROR: Failed to unpack received packet.

ERROR: Failed to receive file part response!
RECOVERY upload successful

Ending session...
Releasing device interface...
and then:
For more information take a look at https://twrp.me/

SQL * Plus connectivity to Autonomous Database (ADB) procedure

Syed Jaffar - Fri, 2020-04-03 13:10
Keeping myself occupied learning all about Autonomous Database (ADB) concepts. Thanks to Oracle for the free offer to course and a certification chance. So planned to write a few important topics along the way while learning. This post will focus on autonomous database (ADB) connectivity options, downloading connection credentials and procedure to connect a ADB database using the SQL * Plus tool.

Autonomous Database (ADB) can be connected through SQL * Net, JDBC thick/thin or ODBC. All connections to the database must use SSL for encryption and under any circumstances, unsecured connection are not allowed. 

To start with, every ADB database connection must be made over a public internet and application should use a secure connection (SSL).  Before using any connectivity method, database connect credentials must be downloaded from the OCI page for the respective database (instance) or region. Below procedure summarizes how to download connect credentials and use SQL * Plus to connect to a ADB.

Downloading connection credentials

As discussed earlier, ADB only accepts secure connections to the database. Therefore, Oracle client credential (wallet) files which contains your connection credentials should be downloaded first. The wallet can be downloaded either from ADB service console, or from the DB Connection button on instance page or through API calls. Use the following method to download the connection credentials from OCI console:

  • Navigate to ADB details page  and click on DB Connection button
  • Based on the connectivity requirement, choose either Instance or Regional wallet type and click on the Download button 
  • The credentials file is protected with a password. So, you will have to input a password before downloading the file. The password must be 8 characters long, with at least 1 letter and either 1 numeric character or 1 special character
  • Once the password is entered and confirmed, download button will be activated to download the connectivity zip file
  • Default name for the file is Wallet_databaename.zip, and the zip files contains following files:
    • tnsnames.ora & sqlnet.ora
    • cwallet.sso & ewallet.p12
    • keystore.jks & tuststore.jks
    • ojdbc.properties & 
Predefined DB Service Names

The tns entries comes with the following predefined values:
  • high A high priority app connection for reporting and batch operations which runs in parallel, subject to queuing.
  • medium A typical connection service for reporting and batch operations with limited (4) parallel degree.
  • low A low priority connection service for reporting and batch operations with no parallelism options.
  • tp (for ATP only), typical application connection service for transaction processing operations with no parallelism.
  • tpurgent (ATP only) the highest priority application connection for time critical transaction processing operations. Can specify manual parallelism. 
SQL * Plus connection to ADB

Unlike other Oracle cloud options, ADB doesn't provide connectivity to the compute node. So, you have to install Oracle client software or higher version on your system. Once the client software is installed, download connection credentials using the procedure described above.

Unzip/uncompress the zip file downloaded into a secure folder on your computer.

Edit the sqlnet.ora file and replace ?/network/admin text with name of the folder containing the credentials, as shown in the below example on a unix/linux client:

WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="/home/adw_credentials")))

 It is highly recommended to set TNS_ADMIN environmental variable and set the location of the credentials files.

Update the sqlnet.ora and tnsnames.ora files as per below example if you have a firewall connection and requires HTTP proxy to connect internet (this scenario only support clients with or higher version):

  • sqlnet.ora should have this entry: SQLNET.USE_HTTPS_PROXY=on
  • And the tnsnames.ora entry should contains the following:
ADWC1_high =
            (security=(ssl_server_cert_dn="adwc.example.oraclecloud.com,OU=Oracle BMCS US,O=Oracle Corporation,L=Redwood City,ST=California,C=US")
Once you have the client software and connect credentials ready, now you can use the sql * plus tool to connect to a ADB. Refer below syntax:

sqlplus sales_dwh@adwc1_low  

SQL*Plus: Release - Production on Wed Apr 3 15:09:53 2019

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

Enter password:
Last Successful login time: Wed Apr 03 2019 14:50:39 -07:00

Connected to:
Oracle Database 18c Enterprise Edition Release - Production

 You can also see the last successful login time.


How to Register For [AZ-900] Microsoft Azure Fundamentals Certification Exam

Online Apps DBA - Fri, 2020-04-03 10:03

AZ-900 Certification Exam is the first step to learn and demonstrate foundational-level knowledge of Cloud services and how those services are provided with Microsoft Azure. Check out K21 Academy’s blog post at https://k21academy.com/az90013 that covers: ▪ What Is AZ-900 Certification? ▪ Azure Certification Path ▪ AZ-900 Exam Registration Steps Begin your journey towards Azure, Getting […]

The post How to Register For [AZ-900] Microsoft Azure Fundamentals Certification Exam appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

[AZ-400] Microsoft Azure DevOps Certification Exam: Everything You Need To Know

Online Apps DBA - Fri, 2020-04-03 08:59

The AZ-400 Certification Exam is geared towards professionals who can design a DevOps strategy & implement DevOps development processes; dependency management; application infrastructure; and continuous integration, delivery, and feedback. Check out K21Academy’s blog post at https://k21academy.com/az40011 which covers: ▪ Who This AZ-400 Certification Is For? ▪ Exam Details & Prerequisites ▪ Types Of Questions ▪ […]

The post [AZ-400] Microsoft Azure DevOps Certification Exam: Everything You Need To Know appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs


Bar Solutions - Fri, 2020-04-03 06:18

The other day a friend called me with a question on constraints. “I have a table where the combination of two columns must be unique”. My response was: “Use a Unique Constraint on these two columns”.
That should work, however…

“There is one value for the first column, where the second column doesn’t have to be unique.”
Let’s start with a simple script to play with this issue:

prompt create a simple table
create table t
( v1 number
, v2 number
prompt add a unique constraint on columns v1 and v2
alter table t add constraint uk_2cols unique (v1, v2)
prompt add some data
  insert into t(v1, v2) values (1,1);
  insert into t(v1, v2) values (1,2);
  insert into t(v1, v2) values (2,1);
  insert into t(v1, v2) values (2,2);
  insert into t(v1, v2) values (3,1);

If we add a duplicate record, this will fail:

prompt try to add a duplicate, this will fail
insert into t(v1, v2) values (3,1)

So using a Unique Constraint like this doesn’t work. There is a solution to this using a package and some triggers to work around a mutating table problem, but there should be a solution just using SQL and the features of the Oracle Database.

So we drop the constraint, it doesn’t do what we want.

prompt drop the constraint
alter table t drop constraint uk_2cols

Remember, two (or more) NULL values are considered to be Unique, so I create a virtual column in the table with the following statement:

prompt add a virtual column
alter table T add v3 as (case when v1 = 3 then null else v1 || v2 end)

Then we can add a unique constraint on the virtual column, which now contains NULL values for the values that don’t have to be unique

prompt add a unique constraint on this virtual column
alter table t add constraint uk_2cols unique (v3)

If we now try the insert again, this works.

prompt now the insert works
insert into t(v1, v2) values (3,1)

But the insert where the combination should be unique still failes.

prompt but this one still failes
insert into t(v1, v2) values (1,1)

As you can see, you can solve this issue by just using the features provided by the Oracle Database.

Adjust connections/sessions Oracle database

Tom Kyte - Fri, 2020-04-03 05:26
Hello, Ask Tom Team. I have a production database running for several months. These are my connection parameters in the client to connect to the database (RAC 18c). I am using a .NET app. Min Pool Size=1;Max Pool Size=60;Connection Lifetime=18...
Categories: DBA Blogs

Regarding Oracle Error ORA-26002 table has index defined upon it

Tom Kyte - Fri, 2020-04-03 05:26
Hi There, This is regarding the error ora-26002 which we are facing since few days. We have one table T1 which is having an index on one of the column. This table T1 is being loaded through informatica using bulk mode option. (Without droppi...
Categories: DBA Blogs

Oracle 18c SQL Query Pagination

Tom Kyte - Fri, 2020-04-03 05:26
Hello, Ask Tom Team. I am building a report using Microsoft SQL Server Reporting Services connecting to an Oracle 18c database. This report will show lots of data. I need to paginate the results, showing 50 rows per page. 1. How can I do i...
Categories: DBA Blogs

Online Table move to different table space.

Tom Kyte - Fri, 2020-04-03 05:26
Team, we are on 18c and trying to move a table to a different table space, using the online move it got failed like this. <code>c##rajesh@PDB1> alter session set ddl_lock_timeout =300; Session altered. c##rajesh@PDB1> show parameter ddl_l...
Categories: DBA Blogs

VMware enterprise PKS 1.7 has just been released

Pas Apicella - Thu, 2020-04-02 22:51
VMware enterprise PKS 1.7 was just released. For details please review the release notes using the link below.


More Information


Categories: Fusion Middleware

Oracle Database + Git = Gitora 4

Gerger Consulting - Thu, 2020-04-02 15:17

We are happy to announce the new version of Gitora, the version control tool for the Oracle Database.

Gitora 4 enables you to manage your entire Oracle code base with Git. New features in Gitora 4 include:
  • Push to and pull from repositories in GitHub, GitLab, Bitbucket etc...
  • Simplified workflow and vastly improved working directory structure
  • SQL Developer Extension (Coming soon.)

Categories: Development

PL/SQL Machine Code Trace - event 10928

Pete Finnigan - Thu, 2020-04-02 11:06
I have had an interest in PL/SQL for more around 25 years. I have always liked this great language as its powerful and simple and a great tool for writing code in the database. I wrote my very first PL/SQL....[Read More]

Posted by Pete On 02/04/20 At 01:33 PM

Categories: Security Blogs

Database Link Issues: Adding schema name raises ORA-02002: error while writing to audit trail ORA-00942

Tom Kyte - Thu, 2020-04-02 11:06
I have a database link that connects to a databases that is running 11g ( The database it is created in was recently upgraded to 19c. After the upgrade, I can no longer access remote tables using fully qualified table names. Prior ...
Categories: DBA Blogs

VM username and password

Tom Kyte - Thu, 2020-04-02 11:06
I require password and username for oracle db developer virtual machine for training purpose
Categories: DBA Blogs

Generate version number

Tom Kyte - Thu, 2020-04-02 11:06
How to Generate version Number using oracle SQL like rownum?? Need Result Like this <b>0.7,0.8,0.9,1.0,1.1,1.2</b> upto 4.5
Categories: DBA Blogs

Second run of calling webservice using UTL_HTTP fails with ORA-12535: TNS:operation timed out

Tom Kyte - Thu, 2020-04-02 11:06
Hi Tom, Please help me in addressing this issue. I am using the below procedure to call HTTPS wsdl, this works fine for the first time when calling this procedure on SQL prompt logging into DB server(AIX) via Putty. But fails when I try to ex...
Categories: DBA Blogs

Timestamp validation against current timestamp

Tom Kyte - Thu, 2020-04-02 11:06
Hello, I am a newbie developing an app on APEX 19.2. I have a table with a field <b>START_DATE</b> of data type <i>TIMESTAMP WITH LOCAL TIME ZONE</i>. I also have a form with this field, for which I have specified <b>Identification Type</b> as Da...
Categories: DBA Blogs

How "ONLINE" is an "alter table move ONLINE" in 12.2 and beyond?

Tom Kyte - Thu, 2020-04-02 11:06
Good Morning, It seems like Oracle has made some significant improvements to the "alter table move ONLINE" command in 12.2. For a basic heap table that is made up of varchar, char and number data types with a few b-tree indexes, it seems like we ...
Categories: DBA Blogs

Oracle 11g select query with Json field

Tom Kyte - Thu, 2020-04-02 11:06
I want to fetch data from below table. Table Name: Insight <code>Id | Name | JSON_DATA ----+------------+------------------------------------------------------------- 1 | Sitansu. | {"country_codes": ["IND"], "regions": ["ASIA"]...
Categories: DBA Blogs

Log errors

Bar Solutions - Wed, 2020-04-01 23:48

Just a quick note of something I ran into at my current assignment. I have to import data from external tables into persistent tables. This proces normally is just inserting data into the table, but sometimes a file can be sent in more than once.

Originally I thought I would add the /*+ APPEND */ hint to the statement to speed things up. This works flawlessly as long as you are just inserting new records. As soon as you try to insert a record which already exists you can hit a unique constraint (or some other constraint) (if defined). So my next idea was to use the LOG ERRORS construction. As soon as you hit an error for a specific record, it will record it in a separate table and continue with the next record.

But…This doesn’t work when combined. As soon as you add the /*+ APPEND */ hint, the LOG ERRORS line seems to be ignored.


Subscribe to Oracle FAQ aggregator