Check Data Guard Recovery Mode You can find database_mode, recovery mode and protection mode of your Data Guard as follows. [crayon-6627b558b6921364507446/] Data Guard Recovery Modes …
Read More »ORACLE
How To Check Standby Redo Logs
This article contains scripts about checking Standby redo logs. You can use the below queries to check standby redo logs in Oracle. [crayon-6627b558b7265269776568/] or [crayon-6627b558b726d753547220/]
Read More »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 database. Please test in the …
Read More »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 occurs. You see the error …
Read More »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 more detailed information about a …
Read More »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 session without terminating session. You …
Read More »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 role-based auditing. It is possible …
Read More »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 as follows. [crayon-6627b558b8356215234058/] Options DELIMI[TER] …
Read More »Oracle User Operations
This article contains information about Oracle User Operations like creating a new Oracle user, authorizing, changing password and dropping Oracle User. Create Oracle User CREATE …
Read More »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 PSU, you receive an error …
Read More »