TNS-01189

Uncategorized
| Sep 5, 2019
I saw a couple of messages like this in an Oracle listener log recently:

TNS-01189: The listener could not authenticate the user
 
I knew that somebody in another country was carrying out internal security scans and suspected this may have been the reason. To confirm, I tried to check the status of the listener from another server and was able to reproduce the error as follows:
 
UNIX: lsnrctl status 10.80.1. (more...)

How to Skip N Rows in an Oracle SELECT Statement

Uncategorized
| Aug 29, 2019
I saw this question on a SQL Server blog. Apparently it was asked at an interview. Here is the suggested answer:

SELECT *
FROM [AdventureWorks2014].[Person].[Address]
ORDER BY AddressID
OFFSET 100 ROWS;
 
I don’t have access to SQL Server right now so I wondered how I might do this in Oracle. This is what I came up with. I ran it in an Oracle 11.2.0.4 database:

SQL> l
  1   (more...)

Published: Using Red Hat Insights with SQL Server

Uncategorized
| May 9, 2019
I published Using Red Hat Insights with SQL Server on Medium.

ORA-02391

Uncategorized
| Jun 29, 2017
I tested this on an Oracle 11.1 database.
 
Oracle profiles control how certain database resources are allocated to a user session. They also define some security rules. When you create a user, it is assigned a profile and, if you do not specify it explicitly, the DEFAULT profile will be used:
 
SQL> grant create session to andrew
  2  identified by reid
  3  /
 
Grant succeeded.
 
SQL> select profile (more...)