Category Archives: Oracle

ORACLE TUTORIALS

Oracle is most widely used Oracle database in the world. It has the capacity to handle large database and high transaction

Here I am presenting the Oracle tutorials on Various Oracle products

  1. Oracle database
  2. Oracle sql/plsql
  3. Oracle application
  4. Weblogic
  5. Performance tuning.

These articles will be  really help in understanding the oracle products and getting started on Oracle system

EBS 12.2.5 and Higher: Login Page Button Misalignment

The Login page in Oracle E-Business Suite 12.2.5 and later may display button misalignment Correct Login Page Incorrect One Reason and Fix Oracle E-Business Suite 12 is not certified with IE11 using either ‘Enterprise Mode’ or ‘Compatibility View’. Enterprise Mode: Internet Explorer 11 includes an ‘Enterprise mode’ which can be used to emulate Internet Explorer 8 behavior and provide compatibility for earlier browser standards. This … Continue reading EBS 12.2.5 and Higher: Login Page Button Misalignment »

How to remotely clone a PDB or non-CDB in Oracle Database 12.1

Many times, we may need to copy the remote PDB to Local PDB for testing purpose. The case would be copying Production PDB to Development PDB box. Some times , we may want to migrate the non-CDB to PDB to make sure Multitenant features in the Oracle database Restriction for doing this 1)The default tablespaces for each common user in the remote PDB must exist … Continue reading How to remotely clone a PDB or non-CDB in Oracle Database 12.1 »

Hot PDB cloning in Oracle database 12.2

In Oracle database release 12.1, in order to clone a PDB, The source PDB must be quiescent(read only mode) for the duration of the clone operation. So it was called a “cold clone” operation because it involved an outage (from a transactional perspective) in the source database. This applies for both the same CDB clone or Remote CDB clone. Related Article Oracle database 12c:How to … Continue reading Hot PDB cloning in Oracle database 12.2 »

Refreshable PDB in Oracle Database 12.2

Refreshable PDB is a new features introduced in 12.2 . It builds upon hot clone capability in Oracle Database 12.2. It basically means we can refresh the remote PDB from source PDB on regular intervals by just applying the incremental redo This feature eliminates the need to re-create a cloned environment from scratch and also ensures that a cloned PDB can be periodically synchronized with … Continue reading Refreshable PDB in Oracle Database 12.2 »

PDB Relocate in Oracle database 12c Release 2

A pluggable database is a self-contained, fully-functional Oracle database. We often need to move the pluggable database from one CDB to another CDB. This will be a unplug/plug operation where outage will depend on the location of source and destination CDB 1) When moving between servers with shared storage, such as is typically the case in Cloud environments when the PDB is being moved for … Continue reading PDB Relocate in Oracle database 12c Release 2 »

Weblogic Administration Console

What is Weblogic Administration Console Web browser-based, graphical user interface to manage an Oracle WebLogic Server domain. Use the Administration Console to: Configure, start, and stop WebLogic Server instances Configure WebLogic Server clusters Configure WebLogic Server services, such as database connectivity (JDBC) and messaging (JMS) Configure security parameters, including managing users, groups, and roles Configure and deploy your applications Monitor server and application performance View server … Continue reading Weblogic Administration Console »

Enterprise Manager 11g FMW Control in R12.2

R12.2 comes with Enterprise Manager 11g FMW Control to manage FMW components What is Enterprise Manager 11g FMW Control Enterprise Manager 11g FMW Control is  aWeb application used to monitor and administer a farm A farm is a collection of components managed by Fusion Middleware Control. it Contains Oracle WebLogic Server domains, one Administration Server, one or more Managed Servers, clusters, and one or more Oracle … Continue reading Enterprise Manager 11g FMW Control in R12.2 »

RMAN connection decoded

RMAN is a important tool used in Backup and recovery. Whenever you use RMAN tool in $ORACLE_HOME/bin and connect to database, it makes multiple connection to the database.Here are RMAN connection decoded Whenever we make RMAN connection to database for backup with or with out catalog,many processes are spawned and worked upon. RMAN always spawns TWO processes (sessions) when connected to a target database: • 1st … Continue reading RMAN connection decoded »

Distributed AD

1)Distributed AD offers improved scalability, performance, and resource utilization by allowing workers of the same AD session to be started on additional middle tier systems. 2)AD has always utilized a Parallel Jobs System, where multiple AD workers start and are assigned jobs. Information for the Jobs System is stored in the database, and workers receive their assignments by monitoring certain tables in the database. 3) … Continue reading Distributed AD »

How to delete Virtual Machine from VirtualBox

Power off the Virtual Machine which you want to delete from the Virtual box 2) Select the VM to be deleted and then Click Machine on the top machine and choose remove from drop down menu 3) Below screen will come up Use delete all files option to remove the file which contains the virtual machine hard disk. This will free up all the space … Continue reading How to delete Virtual Machine from VirtualBox »

Step by Step R12.2.6 EBS installation on Virtual Box Part -2

We have already performed the installation of VirtualBox and download the VM appliance in the last post Now lets continue with the installation of 12.2.6 VM template in the Virtual box 1)  Check if the Hardware Virtualization is enabled in the Desktop of Laptop where you have installed the Virtualbox 2) Now Open the Virtual box  and click on Import Appliance 3) The Import Virtual Appliance … Continue reading Step by Step R12.2.6 EBS installation on Virtual Box Part -2 »