by Choma | Jan 23, 2018 | Uncategorized
What is DB_UNIQUE_NAME? DB_UNIQUE_NAME specifies a globally unique name for the database. Databases with the same DB_NAME within the same DB_DOMAIN (for example, copies of a database created for reporting or a physical standby) must have a unique DB_UNIQUE_NAME. Every...
by Choma | Jan 18, 2018 | Uncategorized
Trigger To Log Multiple DDL Activities Setup Database Triggers for Schema Auditing and Logon/Logoff Events In order to effectively audit schema changes, and logon and logoff events, Oracle provides DDL triggers to audit all schema changes and can report the exact...
by Choma | Jan 18, 2018 | Uncategorized
1. What are the types of Oracle Data Guard? Oracle Data Guard is classified in to two types based on way of creation and method used for Redo Apply. They are as follows. 1.Physical standby (Redo Apply technology) 2.Logical standby (SQL Apply Technology) 2. What are...
by mawundaga | Jan 14, 2018 | Uncategorized
ORA-00060: Deadlock detected while waiting for resource. Transactions deadlock one another waiting for resources. When this happens, these transactions are stuck (deadly embraced) and cannot continue processing. Oracle automatically detects deadlocks and resolves them...
by mawundaga | Jan 12, 2018 | Uncategorized
Blog I am running Oracle rdbms 11.2.0 on Windows Server 2012. I ran into a peculiar issue when I dropped dbconsole schema and then attempted recreating it. emca -config dbcontrol db -repos create -PORT 1521 Error: Enter the following information: Jan 11, 2018...
Recent Comments