My Oracle Fusion Middleware Experiments

This Oracle provided security related post ( Prepared by Naga Srivalli Mantravedi  OUD   & Security Expert) will be useful to those who are working on Fusion Middleware products, Oracle E-Business Suite, that hosts OUD & OUDSM on it. This post compose with Q & A on OUD. Oracle Unified Directory What is OUD? What is so special about it? Great product from Oracle in recent years developed as a brand new LDAP Server completely rewritten in Java language for a very large & scalable deployment and a very performant directory server implementation. Best part of this OUD server is its capacity to store billions of user data. That is why Oracle’s recommended LDAP Server is OUD and it can be used with other Oracle products like Oracle Access Manager, Oracle E-Business Suite (R12), Oracle Identity Manager (OIM) or Oracle Fusion Middleware (FMW). Even this will be supported on Cloud services as OUD service. What is the relationship of OUD with OID? As we explore the OUD ...

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

Purpose This blog post is intended for all the Oracle Analytics Server Administrators, Developers, Data Model designers, DW architects. Prerequisites Installation of  Oracle Analytics Client Tools  5.5.0 on Windows 64bit Download the OAS Client Tool Step 1: Uncompress the downloaded zip file  OAS-5.5.0-bi_client-win64.zip use any unzip tool which runs on a Windows machine. Step 2 : Open a new CMD and 'Run as Administrator' enter the .exe file hit ENTER key C:\work\data>OAS-5.5.0-bi_client-win64.exe Step 3: Launches install wizard Wizard step 2 Wizard step 3 Wizard Step 4 Wizard Step 5 Wizard Step 6 (Development of RPD or online RPD connections required this configuraiton) Wizard Optional Step "Add" ODBC configuration Select "Oracle BI Server DSN Configuration" is specific to your Datasource to which you have target to use, stored as Data.Source.. (This step is must for Design Data Model and Develop new RPD files) Troubleshooting If you run the installer f...