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 […]
All posts by Skant Gupta
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
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
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 […]
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 […]
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 […]
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 […]
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]
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]
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]