by mawundaga | Nov 1, 2020 | oracle Backup & Recovery, Oracle File System
Question : A datafile was wrongly added on file system instead of ASM diskgroup. How can you move it to the ASM disk group? As root: [root@L160 ~]# mkdir -p /u02/oradata/PDEV chown -R oracle:oinstall /u02/oradata As oracle: sqlplus system/sys@PDEV drop tablespace...
by mawundaga | Nov 1, 2020 | Uncategorized
This is an example of annotation, hover the highlighted “annotation” word to see it in action!If you find the plugin useful, I would love to get a review or rating: https://wordpress.org/support/view/plugin-reviews/tinymce-annotateAlso, any donation would...
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 mawundaga | May 1, 2018 | Uncategorized
Oracle introduced the long-awaited Database 12c Release 2 earlier this year at Oracle Open World. SQL and PL/SQL: Starting with Oracle Database 12c Release 2 (12.2), we can truncate the return string of LISTAGG function, to fit within the maximum length supported for...
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...
by mawundaga | Jan 9, 2018 | oracle Administration, Patching
Patching is one of the most common task performed by DBA’s in day-to-day life . Here , we will discuss about the various types of patches which are provided by Oracle . Oracle issues product fixes for its software called patches....
by mawundaga | Jan 9, 2018 | MSSQL, MSSQL Backup & Recovery, MySQL
Finding and Terminating SQL Server Blocking Processes – Dead Locks in MSQL We can free or release or remove or delete or check all locks on the sql server 2008,2012 and 2014 objects like table etc by killing the process id which is keeping the locks on the...
by mawundaga | Jan 9, 2018 | Dataguard, oracle Administration, oracle Backup & Recovery
Find the LAD (log_archive_dest_n) and the db_unique_name for the Standby that is being removed: show parameter log_archive_dest_ Take note of those that have values such as: log_archive_dest_1 string LOCATION=+RECOC1 VALID_FOR=(AL...
by mawundaga | Jan 9, 2018 | MSSQL, MSSQL Backup & Recovery, Uncategorized
How to detect if the disk space is running low on SQL Server. There are two different ways to do the same. I personally prefer method 2 as that is very easy to use and I can use it creatively along with database name. Method 1: EXEC MASTER..xp_fixeddrives GO...
by mawundaga | Jan 9, 2018 | Uncategorized
Question: Is there a way to copy maintenance plans from one SQL Server 2012 to another? Both servers are not accessible via the same copy of Management Studio at the same time (on different networks). Yes: Go to the server where the jobs exist, in Management...
by mawundaga | Jan 9, 2018 | MSSQL
You could use SQL Server Management Studio to backup the databases or even use Maintenance Plans, but using T-SQL is a much simpler and faster approach. With the use of T-SQL you can generate your backup commands and with the use of cursors, you can cursor through all...
by mawundaga | Jan 9, 2018 | Uncategorized
The quickest way to capture the SQL being processed by a session is to switch or turn on SQL trace or set the 10046 event for a representative period of time. The resulting trace files can be read in their raw state or translated using the tkprof utility. Explaining...
by mawundaga | Jan 9, 2018 | Uncategorized
Manually Resolving Gaps – Oracle Data Guard 11gR2 For simplicity, Gap is a range of archived redo logs that were created at a time when the standby database was not available to receive them; in many practices, it happens because of the network problems. We have...
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