If a user want to drop a DB link belonging to a schema in Oracle databases, it searches for that DB link under the schema …
Read More »ORACLE
Check When Password Was Last Changed in Oracle
The most recent password change date for users in the Oracle database is in the ptime field in the sys.user $ table. With a query …
Read More »How To Test Multicast Between Oracle Rac Database Servers
Any problem with multicast traffic between Oracle RAC database servers can cause network heartbit problems between servers. In this case you need to see the …
Read More »How To Disable System Triggers in Oracle
In the database, it may sometimes be necessary to disable system triggers during operations such as java installation, downgrade, or upgrade. An error in a …
Read More »ORA-00600: internal error code, arguments: [kgantc_1]
While current transaction waiting for a lock in a session, the following error will occur in the database when the corresponding session terminated unexpectedly with …
Read More »“ORA-01031: Insufficient Privileges” Error When Creating a Materialized View in a Different Schema
When a user tries to create a materialized view in a different schema, if the user of that schema does not have create table authority, …
Read More »Oracle Database Security Check With Database Security Assessment Tool (DBSAT)
The Oracle Database Security Assessment Tool (DBSAT) analyzes database configurations and security policies to help eliminate security risks and improve database security. Using the DBSAT …
Read More »ORA-19573: cannot obtain exclusive enqueue for datafile X
We use the incremental backup of the primary database to fix the gap that occurs in the standby databases. If the managed recovery is turned …
Read More »How To Use kfod and kfed on Exadata
kfed and kfod are under $ORACLE_HOME/bin. With these tools, we can learn about asm disks and edit the information in the disk headers. When using …
Read More »How To Find Serial Numbers of Exadata Servers and Components
The serial numbers and part codes of the compute nodes and cellnodes and components in these nodes in the Exadata are required to supply the …
Read More »