by Choma | May 20, 2018 | Uncategorized
To blow away one of your newly created databases, instead of using the DBCA, try it manually in sqlplus. Requirements database must be closed, exclusively mounted, restricted 1- Start The database sqlplus / as sysdba SQL> startup ORACLE instance started. Total...
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 Choma | Nov 9, 2017 | oracle Administration, Oracle Patch, Patching
Oracle Critical Patch Update A Critical Patch Update (CPU) is a collection of patches for multiple security vulnerabilities. Critical Patch Update patches are usually cumulative, but each advisory describes only the security fixes added since the previous Critical...
Recent Comments