This Find command article is part of Linux tutorials and it has detailed explanations, examples Find command in Unix is an extremely useful command. you can search for any file anywhere using this command provided that file and directory you are searching has read-write attributes set to you, your, group, or all. Find descends directory […]
How to check Patch application in Oracle E-Business Suite instance R12.1/R12.2
We often need to find out what all patches are applied to the EBS instance. Now, this varies as per the EBS instance version. We have different queries for R12.1 and R12.2. For R12.0/R12.1 ad_bugs tables contain the information for all the patches applied to the system. we can use the below query to find […]
Troubleshooting ADOP failures in R12.2
Here are a few troubleshooting tips for ADOP failures in R12.2 How to set service ebs_patch in R12.2 While running adop phase=prepare, we receive 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 ebs_patch $ […]
Login flow in R12.2 and basic troubleshooting
R12.2 is the latest Release of Oracle E-business Suite Products. Here we would be discussing the Login flow in R12.2 Login flow in R12.2 When a HTTP request is made for EBS, the request is received by the Oracle HTTP Server (OHS). When the configuration of OHS is for a resource that needs to be […]
How to Compile Invalid objects in Oracle
Oracle database is a complex system and objects are interrelated and have dependencies. Like a package, may depend on a certain oracle table or view or synonym. So objects may go invalid in case of deployments of new objects, alter table command, packages, views, synonyms. Now let’s find out how to find the invalid objects […]
Oracle password file Utility :ORAPWD
Introduction to ORAPWD orapwd is an oracle password file utility and it allows the remote connection to the database with administrative privilege i.e. if you want to connect a remote database with sysdba privilege, then a password file needs to be present in the remote database You can create a password file using the orapwd […]
