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

Namaste!(after Corona I've started saying this in my blog posts as well!), Welcome to My Oracle Fusion Middleware Experiments fans!! Oracle is dominant in the Relational Database Management tool. It is the strongest and core area among many Oracle products. it is flexible for on-premises development to the latest trending tech-ear  Cloud computing as well. I'm started exploring Oracle Analytics products recently and amazed by the tools and utilities which are built with greater vision.  Pre-requisites     To run in minimalistic operations for development purposes.  Install git bash for Windows Install  Oracle VM VirtualBox Install  Vagrant Some of Oracle community developers are doing R & D with minimalistic database creation and usage on Oracle VirtualBox and Vagrant.  git clone https://github.com/oracle/vagrant-projects.git After you download or clone the github repository. As we are interested in Oracle Database 19c only so copied t...

Project Oracle12c database As a non-Oracle DBA having minimum knowledge, started working on this project for installation of Oracle 12c Database on my personal laptop which have Windows 8.1 platform. Using this automation with Vagrant and Puppet provisioning on CentOS box it would be fantastic guest and on top of it running the Oracle 12c database will be hosted that's simple learning goal for today. Virtual box requirements for Oracle 12c Database Assume that latest version of Vagrant installed on your machine. I'm running on Vagrant 1.7.1. And also expecting Oracle VirtualBox installed on your machine. First get the Oracle database binaries from OTN Select Enterprise Edition or Standard Edition Database download link  [This may change for next version] Selecting Oracle 12c Database download from OTN Get the Vagrant setup from ora12base with clone command : git clone https://github.com/dgapitts/ora12base git clone command for ora12base Change th...