Posts by Doyensys

How to apply weblogic bsu patch

step1:  Download latest “patch-client-installer310_generic32.jar” from Oracle Support Site step2:      Go to “bsu” directory of your WLS Installation:     cd  /opt/app/bea1032/utils/bsu step3:   To apply patches run the folowing…

Read More

OGG-01172 Discard file (dirrpt/REPTMP.dsc) exceeded max bytes (20000000).

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 More

OGG-02538 Cannot unregister REPLICAT REPIR because of the following SQL error: OCI Error ORA-00942: table or view does not exist (status = 942)

Unregistering 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 More

Login to Oracle Cloud …. After Oracle Cloud Promotion Account Creation

This 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 More

How to Create Oracle Cloud Promotion Account

This 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 More

Untitled

   18c Oracle Database Installation(On-Premise) You have three options to install database; Starting with Oracle Database 18c release. 1) Image-based Oracle Database Installation 2) RPM-Based Oracle Database Installation 3) Read-Only Oracle…

Read More

Untitled

SYSTEM Tablespace is space increasing Abnormally in 12c SYSTEM tablespace was growing rapidly. We observe that we were not doing much on this database. Only few users were working to…

Read More

Terraform : Creating New EC2 instance via Terraform

In 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 More

Untitled

List of hidden parameters in Oracle database:- SET PAUSE ON SET PAUSE 'Press Return to Continue' SET PAGESIZE 60 SET LINESIZE 300 COLUMN ksppinm FORMAT A50 COLUMN ksppstvl FORMAT A50…

Read More

Steps to clone a database through RMAN using standby database.

Please 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 More