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 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 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