Home » Oracle » Page 5

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

Troubleshooting Workflow Notification Mailer issues

To Troubleshoot Workflow Notification  Mailer issues, we need to understand how outbound and inbound processing works Outbound Notification Processing – -Creation of Workflow notification raises oracle.apps.wf.notification.send event.-This event is deferred immediately and placed on the WF_DEFERRED agent.-Workflow Agent Listener on the WF_DEFERRED queue processes the deferred subscription.-Subscription to this event calls the Generate function (WF_XML.Generate) …

Troubleshooting Workflow Notification Mailer issues Read More »

adopscanlog log analyzer utility in R12.2

How to check logs in adop The adop log files are located on the non-editioned file system (fs_ne), under: s_ne_base/EBSapps/log/adop/<adop_session_id>/<phase>_<date>_<time>/<context_name>/log For example, if s_ne_base was /u00/app/TECHGO/fs_ne, the session ID was 10, and the <CONTEXT_NAME> was techgo_server, the path to the adop log files from 1th May 2016 would resemble this: /u00/app/TECHGO/fs_ne/EBSapps/log/adop/10/apply_20160501_101121/techgo_server Each cycle of adop …

adopscanlog log analyzer utility in R12.2 Read More »

Oracle Exadata: Oracle Exadata architecture, ExaCS, ExaCC

What is Oracle Exadata ? Oracle Exadata Architecture It consists of a Database server, storage server, InfiniBand switches used for intra-system servers to server communication, Administrative Ethernet switch for remote management Oracle Exadata Database Servers or Compute Nodes(1)It is a System that includes all the hardware necessary to run the Oracle Database(2)Database Servers Run Linux …

Oracle Exadata: Oracle Exadata architecture, ExaCS, ExaCC Read More »

How to clean up duplicate objects in SYS/SYSTEM

Sometimes we have different errors in the Oracle system because of duplicate objects in SYS/SYSTEM. This can happen as catalog.sql and catproc.sql were mistakenly run while connected as both users. In most cases, the only objects which should exist are those owned by SYS. The output can help determine which objects should be dropped from the SYSTEM schema. The …

How to clean up duplicate objects in SYS/SYSTEM Read More »

Scroll to Top