Patch Wizard is a tool provided by Oracle for finding the impact of application patches on the Environment. It is a handy tool and shows all the impacted files and appropriate action can be taken based on that information. It is an extremely important tool and here I will explain how to use Patch Wizard, … How to use Patch wizard in Oracle EBS environment Read More » The post How to use Patch wizard in Oracle EBS environment appeared first on Techgoeasy ..read more

APPLSYSPUB  is the database schema. it is the first schema that is used in any connection in Oracle apps. APPLSYSPUB default password is PUB. It is not an application user and thus you cannot find that in the FND_USER table in the Oracle database of Oracle applications Oracle forms, and OACORE  all connect to it … APPLSYSPUB schema Read More » The post APPLSYSPUB schema appeared first on Techgoeasy ..read more

Introduction We often want to run pre-defined jobs at different schedules. Oracle database provides dba_jobs/dbms_scheduler (Oracle Database job scheduler) for scheduling pre-defined jobs. Information about DBA_JOBS ( Till 9i) Query to see the jobs running through dba_jobs select /*+ rule */ * from dba_jobs_running; or select /*+ ordered */ * from dba_jobs_running; Common Reason why jobs … How to schedule jobs in Oracle Database: DBA_JOBS, DBA_SCHEDULER Read More » The post How to schedule jobs in Oracle Database: DBA_JOBS, DBA_SCHEDULER appeared first on Techgoeasy ..read more

We will be discussing Oracle create tablespace statement/oracle create tablespace 11g/12c/19c in detail in this post. I will through light on all the option on create tablespace statement.I would also be discussing  ,how to alter the tablespace to read-only, offline the tablespace,how to move tablespace to another location,drop the tablespace. Apart from that, how you … How to create tablespace in Oracle Read More » The post How to create tablespace in Oracle appeared first on Techgoeasy ..read more

What is FNDFS Explaining how FNDFS working (1) The user selects ‘Request Output’, ‘Request Log’, or ‘Manager Log’ (2) The file name and node name are selected from the database.Reports: SELECT outfile_name, outfile_node_name FROM fnd_concurrent_requests WHERE request_id = :id; Logfiles: SELECT logfile_name, logfile_node_name FROM fnd_concurrent_requests WHERE request_id = :id; Manager logs: SELECT logfile_name, node_name FROM fnd_concurrent_processes … How FNDFS (Oracle Report Review agent) works in EBS environment Read More » The post How FNDFS (Oracle Report Review agent) works in EBS e ..read more

External table is one of the important feature in oracle , we will exploring external table in oracle with example in this post What are EXTERNAL TABLES in Oracle? 1)External tables are read-only tables where the data is stored in flat files outside the database 2) You can use the external table feature to access external … Oracle External tables Read More » The post Oracle External tables appeared first on Techgoeasy ..read more

Oracle provides the  EBS data model comparison report to view the static database object definition changes between two EBS releases Applicable Releases Benefits of EBS Data Model Comparison Report We can view the Per product database object comparison between two releases for thefollowing object types -Regular tables, Partitioned tables, Index organized tables, Global temporary tables, Queued … EBS Data Model Comparison Report Read More » The post EBS Data Model Comparison Report appeared first on Techgoeasy ..read more

Downtime Mode adop R12.2 To run adop in downtime mode, you use the following command line options. In this example, patch 1111111 is applied in downtime mode: $ adop phase=apply patches=1111111 apply_mode=downtime It does not require the prepare phase The important point in downtime mode (1) Release 12.2 patches are not normally tested in downtime … Downtime and Hotpatch apply mode in adop R12.2 Read More » The post Downtime and Hotpatch apply mode in adop R12.2 appeared first on Techgoeasy ..read more

The Oracle Database Interactive Quick Reference is a multimedia tool for various terms and concepts used in the Oracle Database. Built as a multimedia web page, this diagram provides descriptions of database architectural components and references to relevant documentation. This is a beneficial reference and cheat sheet for writing custom data dictionary scripts, locating Oracle … Oracle Database Interactive Quick Reference Guide | 11g ,12c, 19c & 23c Read More » The post Oracle Database Interactive Quick Reference Guide | 11g ,12c, 19c & 23c appeared first on Techgoeasy ..read more

We have already installed VirtualBox and downloaded the VM appliance in the last post Now let’s continue with the installation of the 12.2.12 VM template in the Virtual box 1)  Check if the Hardware Virtualization is enabled on the Desktop of the Laptop where you have installed the Virtualbox 2) Now Open the Virtual box  … Step by Step R12.2.12 EBS installation on Virtual Box Part -2 Read More » The post Step by Step R12.2.12 EBS installation on Virtual Box Part -2 appeared first on Techgoeasy ..read more