Oracle 19c Released (Linux Platform)

Oracle has officially released version 19c (premise release) 19.3 for Linux platform. The rest of systems like Windows and Unix (and its different portings) will have to wait for some days now.

You can download it from OTN (now renamed Technical Resources);

Download Oracle Database 19c (From OTN/Technical Resources)

And also from edelivery;

Download Oracle Database 19c (From Edelivey)

If you have not had occasion to use a version 19 until now, I hope you enjoy it.

HTH – Antonio NAVARRO

Advertisements

Node 1 Does Not Support Connections (RAC)

This morning I have been reported a problem in a test environment. Some connections were hung when trying to enter. After connecting and taking a look, the environment, it is a cluster of two nodes version 12c, note that node one is the one that does not support connections and the connections were left is waiting for a change of log. It’s funny but it did not give any error, it’s usually this situations shows a ora-00257, but this is not the case, maybe because of the engine version.

Checking the situation at the instance level;

 
SQL> select inst_id, version, status, thread#, archiver, log_switch_wait, logins from gv$instance

   INST_ID VERSION           STATUS          THREAD# ARCHIVE LOG_SWITCH_WAIT LOGINS
---------- ----------------- ------------ ---------- ------- --------------- ----------
         2 12.1.0.2.0        OPEN                  2 STARTED                 ALLOWED
         1 12.1.0.2.0        OPEN                  1 STARTED ARCHIVE LOG     ALLOWED

 
Sessions are waiting on event “log file switch (archiving needed)” like show below, first column is node (in this case the problem is in node 1);

 
N     SID TIME    SQL_ID            EXECS EVENT                              Marker
- ------- ------- -------------- -------- ---------------------------------- --------
1      22 0       6vm7g6qj4mqhd        0  PX Deq: Execution Msg
2     327 0       6vm7g6qj4mqhd        4  PX Deq: Execution Msg
2     649 0       6vm7g6qj4mqhd        4  PX Deq: Execute Reply
1     361 1471    6228pzdt28kzd     1008  log file switch (archiving needed)      <<<
2     121 106     61tssjb6hj8x7      329  gc buffer busy acquire
1      88 1645    9zg9qd9bm4spu     7787  log file switch (archiving needed)      <<<
1     804 1704    3mptsg6h27zg9        1  log file switch (archiving needed)      <<<
1      89 1705    0bfdn75zn75pw        2  log file switch (archiving needed)      <<<
2      20 1699    6nauzjpthp1w7        3  db file sequential read
1       3 +1H     1aa2fpqtx557g     3877  log file switch (archiving needed)      <<<
1     328 1705    g8bkp70myp46t        2  log file switch (archiving needed)      <<<
1     257 +1H     dr6d1upgkc1g3        1  log file switch (archiving needed)      <<<
2     615 505     aq8yqxyyb40nn     1255  gc current request
1     800 817     aq8yqxyyb40nn     1282  buffer busy waits
1     480 817     aq8yqxyyb40nn     1282  buffer busy waits
2     342 +1H     5ms6rbzdnq16t    15644  gc buffer busy acquire
1     377 817     aq8yqxyyb40nn     1282  buffer busy waits
1     345 817     aq8yqxyyb40nn     1282  log file switch (archiving needed)      <<<
1      21 817     aq8yqxyyb40nn     1282  buffer busy waits

 
After perform archive backup (with delete option);

 
SQL> select inst_id, version, status, thread#, archiver, log_switch_wait, logins from gv$instance

   INST_ID VERSION           STATUS          THREAD# ARCHIVE LOG_SWITCH_WAIT LOGINS
---------- ----------------- ------------ ---------- ------- --------------- ----------
         2 12.1.0.2.0        OPEN                  2 STARTED                 ALLOWED
         1 12.1.0.2.0        OPEN                  1 STARTED                 ALLOWED

 
HTH – Antonio NAVARRO

 

ORA-00245 Error

Today when I was executing a archive backup after of full refresh (by OGG) I get the next error;

 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 04/10/2019 09:26:58
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 04/10/2019 09:26:58
ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage

The same is generated in the first sentence of the RMAN script (resyn catalog). The problem is that snap CF backup is in a DG, which is not permited. It must be out of DG. In this case ACFS or local disk (ZFS) is possible.

Like first action I performed a specified backup like show below;

 

SQL> alter database backup controlfile to ‘/prod/backup/CONTROLFILE/snapcf_nube.f’ reuse;

 
The second action is make this change permanent. From RMAN you can use;

 

CONFIGURE CONTROLFILE AUTOBACKUP OFF;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK CLEAR;

CONFIGURE SNAPSHOT CONTROLFILE NAME clear;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘/prod/backup/CONTROLFILE/snapcf_nube.f’;

 
HTH – Antonio NAVARRO

Error ORA-01924

Recently I have been migrating a database from version 10g to 12c. In the functionality testing phase the error ORA-01924 arose. This occurs (in version 12.1) when the 600 roles assigned to a user are exceeded, Oracle has a specific oneoff collected in bug 18934948. But after applying this oneoff, the problem. After doing several tests we saw that it was a problem of lack of privileges. The user who made the mistake He lacked the ability to interact with roles.

In version 10g I did not have any problem with the level of privileges assigned, but in version 12c I needed to add two new permits. It may seem strange the difference of operation between versions, but it really makes sense if you look at the model of continuity. Oracle in the last has accelerated this part of the databases, in general it has been a leader in many aspects, but here has always been one step behind other  rdbms such as SQL Server.

In this case giving these two privileges to the user solved the problem;

  • drop role
  • grant any role

HTH – Antonio NAVARRO.