Archive logs keep accumulating and we need to put things in place to delete them on a regular basis. We should not be deleting the archivelog from the filesystem directly as the Oracle Database is not aware of that and space is not released in the Flash recovery area Let’s see a few commands on […]
How to delete the archive logs in Oracle Read More »
Workflow is an important part of Oracle Ebiz Applications In this post, we will check out what is Workflow Background Engine, How to run it from Unix, How to run it using SQLPLUS, how to submit workflow background process from the backend What is Workflow Background Engine How to run Workflow Background Process from Unix
How to submit workflow background process from the backend Read More »
We have touched upon many unix commands before in the previous article. Here are some more commands with downloadable basic unix commands pdf mv – move files(s) /dirs Options: – -f mv will move the file(s) without prompting even if it is writing over an existing target. -i mv will prompt for confirmation whenever
basic unix commands pdf 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 »
Oracle database is a complex system and objects are interrelated and have dependencies. Like a package may depend on a certain Oracle table, view or synonym. So objects may go invalid in case of deployments of new objects, alter table commands, packages, views, and synonyms. Now let’s find out how to find the invalid objects
How to Compile Invalid objects in Oracle Read More »
The Output Post Processor (OPP) is an enhancement to Concurrent Processing and is designed to support XML Publisher as a post-processing action for concurrent requests. If a request is submitted with an XML Publisher template specified as a layout for the concurrent request output, then after the concurrent manager finishes running the concurrent program, it
Output post Processor(OPP) Read More »
