OGG-01172 Discard file (dirrpt/REPTMP.dsc) exceeded max bytes (20000000). One of my replicate got abended due to discard file reach max bytes value. There is two option to resolve this issue.…
Read MoreUnregistering an INTEGRATED REPLICAT from an unsupported Oracle database (11.2.0.3) OGG-02538 Cannot unregister REPLICAT REPIR because of the following SQL error: OCI Error ORA-00942: table or view does not exist…
Read MoreThis post is in continuation of my previous post. After you created promotion account, you will receive an confirmation email along with credentials from oracle. Login to Oracle Cloud 1.…
Read MoreThis post is to create Promotion (trial) account for Oracle public Cloud. 1. Open below link in Web Browser. Enter Valid Email Address https://myservices.us.oraclecloud.com/mycloud/signup?language=en&sourceType=:ow:o:h:feb:TESTA 2. Click on Next Button. Which…
Read MoreIn this post, We will share – What is Terraform, How to install it, and How to Create EC2 instance via Terraform. What is Terraform Terraform is a tool for…
Read MorePlease follow the below for database clone through RMAN using standby database. 1) Step 1: ——————- a) Cancel the recovery in CTL DR on dbprod01. b) Open the database in read only mode.…
Read MorePlease follow the below steps to update the timezone to 26 for 12.2 database. conn / as sysdba purge dba_recyclebin; EXEC DBMS_APPLICATION_INFO.SET_CLIENT_INFO(‘upg_tzv’) ; alter session set “_with_subquery”=materialize; alter session set…
Read More