Since Oracle declared its "stand with Israel", it puts me in a moral dilemma, in one hand my main intention of blogging was to share the knowledge without any intention of promoting Oracle/or any other database vendor products, but in the other hand and during the period of joining Oracle ACE program, it was crystal clear for me that we were playing a major rule in promoting Oracle products through our blogs and websites. I admit that my blog will not make any difference in that regard, it's like a drop in the ocean, but at least I'll not "indirectly" promote the products of a company that sup ..read more

 Problem: When trying to enable flashback feature on a 19c DB I get this error:  26-Jun-2023 16:03:25 SYS@fq> alter database flashback on; alter database flashback on * ERROR at line 1: ORA-00479: RVWR process terminated with error Analysis: Current SQLPlus session settings can contribute in getting this error. Solution: Connect to SQLPlus using "nolog" option, where login.sql will not be effective, then enable the Flashback feature: [oracle@fq ~]$ sqlplus /nolog SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jun 26 16:10:52 2023 Version 19.5.0.0.0 Copyright (c) 1982, 2019 ..read more

 Oracle 23c comes with a new role called "DB_DEVELOPER_ROLE" packed with sufficient privileges for most developers on non-production systems, rather than assigning them the DBA role which violates the least-privilege security principle. DB_DEVELOPER_ROLE role is packed with the following privileges: CREATE TYPE CREATE MATERIALIZED VIEW CREATE TRIGGER CREATE PROCEDURE CREATE JOB CREATE SEQUENCE CREATE VIEW CREATE SYNONYM CREATE TABLE CREATE SESSION CREATE DOMAIN CREATE MLE CREATE ANALYTIC VIEW CREATE HIERARCHY CREATE ATTRIBUTE DIMENSION EXECUTE DYNAMIC MLE CREATE CUBE BUILD PROCESS CREATE ..read more

Problem: I came across a weird problem where top Linux command is not sorting the processes by the top consumer processes under oracle user, but when running top Linux command with any other user it sorts the processes in a right order. If you still unable to understand the issue, look at this screenshot which shows top command output under oracle user on the left side where the processes are listed randomly, and the same command output ran by opc user on the right side where the processes are sorted by the top consumers ..read more

 Oracle has released its first Developer release 23c, targeting developers by offering them a free database to explore and develop applications on it. This step came very late comparing to a database vendor like Microsoft SQL Server who is already having their developer edition long time back. But to come late is better than never! I saw many developers before favoring to run their application on SQL Server because they were having the option of free database having full features available to test and develop their code on. Yes, Before this Developer Edition, Oracle was having Express Ed ..read more

 Problem: On my Windows 10 machine and after installing Docker, I was unable to start any of my Oracle VirtualBox VM machines, they all throw the same error: VERR_NEM_VM_CREATE_FAILED ..read more

 The DBA Bundle release of May 2023 is now available, it's packed with new and updated scripts along with multiple bug fixes. Download it from here: https://www.dropbox.com/s/le5pxctq0w6v49u/DBA_BUNDLE7.tar?dl=0 Once you click on the link, first close this Window: Then, click on the Download button at the most upper right side of the page:  In case you are new to the DBA Bundle, this link will go you through its major features:http://dba-tips.blogspot.com/2014/02/oracle-database-administration-scripts.html DISCLAIMER: THIS BUNDLE IS AN OPEN SOURCE PROJECT, IT IS DISTRIBUTED IN T ..read more

 What this script for? This script kills all running processes having a string/pattern "provided by the user" in their name or description. This script works only on Linux environment, it won't work on Unix. When you need such script? Sometimes when I shut down an Oracle database it goes hung in the middle, in many cases it worth to kill all the connected sessions to the DB from OS to release this hung in many cases, so I kill all the processes having this pattern in their name, suppose that my instance name is ORCL: oracleORCL (LOCAL=NO) This script helps me to safely and easily do this ..read more

Problem: On a Goldengate 12.2 setup, one of the replicate processes get ABENDED with below error: ERROR   OGG-01172  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Discard file (/goldengate/gghome/dirrpt/rep1.dsc) exceeded max bytes (2000000000). Solution: You can modify the parameter file for the same processes increasing the maximum size of the discard file which can reach up to 2048 MB like this: DISCARDFILE ?GG_HOME/dirrpt/rep1.dsc, APPEND, MEGABYTES 2048 But again, once it reaches 2048 MB the process will ABEND, no matter what option you will use APPEND/PURGE ..read more

 I'm getting this question frequently and hence thought to write it in a separate post: Question: What are the Ports you need to Allow for goldengate to Work between Source & Target? Answer: You need to allow the following range of ports between Source and Target with bidirectional option in order for goldengate to work: First check if parameter DYNAMICPORTLIST is being used, it's specifying the list of ports which goldengate is using, then you can allow the firewall for this list plus port 7809.  For example, if the parameter is specifying the list of ports in this fashion: &nb ..read more