Database Blog

Steps to Modify Scan listener port number

Introduction Steps to Modify Scan listener port number using a different port than default for the listener Posted by Selvakumar Raja Due to security reasons some of environment require using a…

Read More

Enable SQL Trace in Oracle Apps R12

Introduction SQL trace can be enabled in any E-Business module via different ways. The following table shows all possible ways for enabling trace in a form, self-service page, concurrent program,…

Read More

Reparing the OCR

Introduction we can use ocrconfig -repair command to repair ocr configuration on a node which was not up when the configuration was modified on the other nodes. Posted by Pushparaj Current…

Read More

SGA Resizing history

SGA resizing history Summary You can find all the resizing history of the SGA by querying the view V$SGA_RESIZE_OPS. As you know if you have set the parameter sga_target then…

Read More

Steps to create ORACLE_HOME after copying oracle binaries from source to destination.

WE ARE GOING TO COPY THE ORACLE BINARIES FORM SOURCE TO DESTINATION. Step 1 : Tar the ORACLE_HOME in the source instance. tar -cvf /DUMP_TABLE/backup/11203_PROD.tar /prddb01/oracle/PROD/db/tech_st/11.2.0.3/ Step 2 : Scp…

Read More

Import fails with ORA-39126,ORA-06512,ORA-01403

WE ARE GOING TO SEE THE IMPORT FAILURE with ORA-39126,ORA-06512,ORA-01403 . Cause: The issue happen when we migrate using export from 11gR2 windows and import it in 12cR2 Linux server.…

Read More

Useful Information Regarding Oracle Cloud Marketplace

Introduction Information about Oracle Cloud Marketplace Posted by Narasimha Rao.K Some of you might be aware of the Oracle Cloud Market place. But there are certain useful Applications services available for…

Read More

How to deploy Oracle EBS Cloud Manager from Market Place?

Introduction Steps to deploy oracle EBS cloud manager from market place. Posted by Narasimha Rao.K The Main agenda for this post is to demonstrate basic steps to deploy Oracle EBS Cloud…

Read More

WF Mailer Not able to start with the following error : FRAMEWORK_USER=Unable to make a connection with the user and responsibility

Introduction Solution to fix if the WF Mailer Not able to start with the  error : FRAMEWORK_USER=Unable to make a connection with the user and responsibility Posted by Saravanan Scenario: I…

Read More

Shareplex Installation for Oracle Replication

Introduction: Steps to install shareplux for oracle replication Posted by Hemanth Sathavalli Installation on Source Server : oracle@src_01:~ $ . ./SOURCEDB_12c.env oracle@src_01:/u03/db $ ls -lrt -rwxr-xr-x 1 oracle oinstall 151278802 Sep…

Read More