Oracle HCM Cloud Concepts – Part 1 (Colored E-Book)

The article is written by Ashish Harbhajanka. A handy reference guide explaining core concepts of Oracle HCM Cloud Application. All the worked out examples have been performed in a SaaS Deployment but very well applies for an On-Premise of Hybrid Deployment Model too. Topics covered includes HCM Data Loader, Comparison of HCM Data Loader with […]

Read More

dbaascli listener start

The listener start subcommand of the dbaascli utility is used to start the listener. Execute this command as the oracle user. dbaascli listener start

Read More

dbaascli listener status

The listener status subcommand of the dbaascli utility is used to obtain information about the status of the listener. Execute this command as the oracle user. dbaascli listener status

Read More

RDBMS DST Upgrade

After upgrading to Oracle 12.2, we face the issue of RDBMS DST timezones.Then either check support id 1585343.1 or else follow the below step 1.Connect to “sqlplus” and run the “upg_tzv_check.txt” file. If you want to download the content of upg_tzv_check [oracle@oracle122 admin]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Sat Mar 4 […]

Read More

Manual upgrading Oracle database 11gR2 to 12cR2

Manual upgrading Oracle database 11gR2 to 12cR2 If you want to know how we upgrade an 11.2.0.4 database to 12.2.0.1 using DBUA, click here. This article explains how to upgrade 11.2.0.2 and above, and 12.1.0.1 to 12.2.0.1 manually. Manually upgrading to 12c There are many DBAs who don’t want to follow the recommended way of upgrade […]

Read More

Upgrade Oracle 11gR2 (11.2.0.4) database to 12cR2 (12.2.0.1)

Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) database to Oracle 12cR2 (12.2.0.1) on the same server. This upgrade process was done on Linux 6 (x86_64). I used DBUA (Database Upgrade Assistant) to perform this upgrade. DBUA is also a recommended way to perform the upgrade as it would automate almost everything […]

Read More

Oracle Database 12c Release 2 (12.2) Installation On Redhat Linux 6

In this post, I’m installing the Oracle Database 12c Release 2 (12.2.0.1.0) software on Oracle Linux 6.4.  Only the software is being installed at this point, in preparation for a single database installation which I’ll create later on using the DBCA tool. First and foremost, before you start, make sure your Linux server meets the minimum […]

Read More

dbaascli dataguard reinstate

The dataguard reinstate subcommand of the dbaascli utility is used to reinstate a failed primary database as a standby database after a failover. Execute this command as the oracle user. dbaascli dataguard reinstate [–password password]

Read More

dbaascli dataguard failover

The dataguard failover subcommand of the dbaascli utility is used to perform a manual failover to the standby database in your Oracle Data Guard configuration. Execute this command as the oracle user. dbaascli dataguard failover [–force yes|no] [–password password]

Read More

dbaascli dataguard switchover

The dataguard switchover subcommand of the dbaascli utility is used to perform a switchover to the standby database in your Oracle Data Guard configuration. Execute this command as the oracle user. dbaascli dataguard switchover [–password password]

Read More