Database Tutorials

Auditing Oracle Roles with Unified Auditing

Posted on January 21, 2020January 21, 2020 by dbtut

In Oracle 12c and later versions, auditing is possible with Unified audit as well as standard auditing. This feature allows

How To Export Data From SQL Plus to CSV

Posted on January 20, 2020January 20, 2020 by dbtut

With Oracle 12.2.0.1, SQL * Plus is capable of displaying the result of a query as CSV. Its use is

Oracle User Operations

Posted on January 15, 2020January 15, 2020 by Yusuf SEZER

This article contains information about Oracle User Operations like creating a new Oracle user, authorizing, changing password and dropping Oracle

ORA-28041: Authentication protocol internal error

Posted on January 15, 2020January 15, 2020 by dbtut

if your Oracle client version is 11.1.0.7 and you use Oracle 12.2 databases with a patch applied after April 2018

How To Check Whether ARCHIVE Logs are transferred to Standby Database

Posted on January 14, 2020January 21, 2020 by Onur ARDAHANLI

Whether the ARCHIVE Logs are transferred to Standby can be seen from the ALERT LOGs as follows.

Thu Oct 03 16:18:27 2019
Thread 1 advanced to log sequence 105672 (LGWR switch)-->Log Switch operation performed. Current Redo Log Sequence number reported.
Current log# 1 seq# 105672 mem# 0: +DATA/mhrs/onlinelog/group_1.261.922153509
Thu Oct 03 16:18:33 2019
Archived Log entry 291716 added for thread 1 sequence 105671 ID 0x59914531 dest 1:--><strong>Archived Redo Log information reported.</strong>
Thu Oct 03 16:18:33 2019
ARC7: Standby redo logfile selected for thread 1 sequence 105671 for destination LOG_ARCHIVE_DEST_2 -->This line means that it has started writing to Standby Redo Log Files.

Thu Oct 03 16:18:27 2019

Thread 1 advanced to log sequence 105672 (LGWR switch)-->Log Switch operation performed. Current Redo Log Sequence number reported.

Current log# 1 seq# 105672 mem# 0: +DATA/mhrs/onlinelog/group_1.261.922153509

Thu Oct 03 16:18:33 2019

Archived Log entry 291716 added for thread 1 sequence 105671 ID 0x59914531 dest 1:--><strong>Archived Redo Log information reported.</strong>

Thu Oct 03 16:18:33 2019

ARC7: Standby redo logfile selected for thread 1 sequence 105671 for destination LOG_ARCHIVE_DEST_2 -->This line means that it has started writing to Standby Redo Log Files.

After the