Heterogeneous Connection From Oracle to SQL Server
You can read this document to access the tables in the MSSQL database using the DBLINK architecture from the Oracle
Category: ORACLE
ORA-00600: internal error code, arguments: [krbebad_1]
When you create backups with rman in Oracle 12.2 databases, an “RMAN-10038: database session for channel d1 terminated unexpectedly” error
How To Enable Debug in rman
You can run rman in debug mode to get more detailed information about Rman operations. In this way, we get
Oracle 18c new feature: ALTER SYSTEM CANCEL SQL
With the new feature that introduced with Oracle 18c, it is now possible to stop the running query in a
Auditing Oracle Roles with Unified Auditing
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
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
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
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
Whether the ARCHIVE Logs are transferred to Standby can be seen from the ALERT LOGs as follows.
|
1 2 3 4 5 6 7 |
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
What is Oracle SQL Plus and SQL Plus Usage
This article contains information about Oracle SQL Plus tool. What is Oracle SQL Plus? SQL Plus is a tool for