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 …
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 …
Here are a few troubleshooting tips for ADOP failures in R12.2 How to set service ebs_patch in R12.2 While running the adop phase=prepare, we receive the below error [ERROR] Error Message : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach) Need to check for service in the listener …
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 »
