My Oracle Fusion Middleware Experiments

Oracle Database Tricks & Tips People in the Oracle technologies they always dealing with Oracle Database related queries, need some time help, best practices should be implement in the daily activities. Here are some common daily using SQL queries which work on 12c to 19c and later as well.  SQL commands run on Oracle Database using sqlplus, sqldeveloper   How to check user exists or not on Oracle DATABASE?   select username from DBA_USERS; Find connected to which user?  SQL> show user  How to search for specific user in the Oracle Database? SELECT username from DBA_USERS where username like '%DEMO%';  USERNAME  --------------------------------------------------------------------------------  DEMOADM  How do you know RCU users account_status expired?   Here we can query the username with 'PREFIX' containing word, and to know about EXPIRED account_status. set pagesize 100 column username format a25 Select username,...

I'm working on the Upgrade project where Oracle APEX 19.1 to Oracle APEX 20.1. All the steps which are given in the documentation I've followed. Able to login the the APEX Admin as well. Here the story begans, my other team members didn't observed there is a change in the ADMIN password and tried multiple times with OLD Password, then the ADMIN user was locked. Now even though I've correct password could not able to login to the APEX admin user.  How do we know this? Oracle Apex Workspace Admin login had an issue, where it was configured with a passwd which was mistakenly used old and that leads to lock the ADMIN user blocked. This APEX Login failed and say that account is blocked. There could be two reasons. First, the browser cache holding the old and wrong password so not allowing you to log in to the ADMIN account. You could try on a different browser if you are in Chrome(login issue), use Firefox or Internet Explorer try to login. Changing browser did not work!  Th...

The objective of this blog post is the Installation of Oracle Goldengate Monitoring Agent in a silent mode. Here in this experiment, we will see the silent mode installation of Oracle Fusion Middleware 12c GoldenGate Monitor & Veridata 12.2.1.2.0 Pre-requisite Operating System: oracle-6,oracle-7,redhat-7,redhat-6,SuSE-11,SuSE-12 for this experiment used Oracle Linux 7.8 CPU speed is above 300 MHz Memory ; 8GB (min) Diskspace: as per your Data needs to pumped Temp space: must be greater than 300 MB. Swap space: must be greater than 512 MB The platform requires a 64-bit JVM Java version: 1.8.0_101 Database: Any database fine- for this choose Oracle Database 12c Environment Setup Create Response File #DO NOT CHANGE THIS. Response File Version=1.0.0.0.0 [GENERIC] #The oracle home location. This can be an existing Oracle Home or a new Oracle Home ORACLE_HOME=/u01/GG_MONITOR12212 INSTALL_TYPE=GoldenGate Monitor Agent Installation There could be a few important fields that need t...

 The objective of this is post is for the installation of Oracle Golden gate 19.x on Oracle Linux. Pre-requisites Operating System: Oracle Linux 7.x Memory ; 8GB (min) Diskspace: as per your Data needs to pumped Temp space: must be greater than 120 MB. Swap space: must be greater than 150 MB. Database: Any database fine- for this choose Oracle Database 12c Environment setup Before running the installer we need to setup the Database Home you can run the 'oraenv' or else export the ORACLE_HOME, ORACLE_SID, and LD_LIBRARY_PATH Create Response File There could be a few important fields that need to add the values are:    INSTALL_OPTION =ORA12c or ORA19c  Specify ORA19c for installing Oracle GoldenGate for Oracle Database 19.x  ORA12c for installing Oracle GoldenGate for Oracle Database 12c and ORA11g for installing Oracle GoldenGate for Oracle Database 11g SOFTWARE_LOCATION =/u01/OGG_19C you can give as per your needs START_MANAGER =TRUE if you want to start th...