Oracle APPS Query to get Instance cloned Date
Query to get Instance cloned Date select to_char(CREATION_DATE,'DD/MM/RRRR HH24:MI') from fnd_nodes a ; OR select to_char(resetlo...Read More
Showing posts with label Oracle DBA. Show all posts
Showing posts with label Oracle DBA. Show all posts
ORA-01000 maximum open cursors exceeded
When youo get this error: " ora-01000 maximum open cursors exceeded " error during the database operation. Then check open_cursor...Read More
REP-52262 Diagnostic output is disabled when using reports server 11g on new installation
You may have noticed that when you have a new installation of reports 11.1.2.0 when you try to run a PDF report or even if you simply try...Read More
Oracle APPS Query to Get File Version
/* Using this Query to get Oracle APPS files version */ SELECT sub . filename , sub . version FROM ( SELECT adf . filen...Read More
Close Oracle Open Notifications wf_notifications
Closing WFERROR Notifications /* To Close Error Notifications use the Below Procedure : */ DECLARE CURSOR c_notif ...Read More
"Output Post Processor" Concurrent Manager not able to start R12.1
I tried to restart but still getting the same status. Later on I tried to query the "FNDOPP" process on the application tier...Read More
Create Appsutil and sub directories for DB Tier
Re-Create Appsutil and sub directories for DB Tier Problem Appsutil directory or sub directories of appsutil are missing Solutio...Read More
Oracle Apex Custom Authentication scheme
Default authentication of APEX: When Create new APEX application you can logon your application with username and password created by AP...Read More
Resolve ORA-02085: database link connects to by
Resolve ORA-02085: database link Error: ORA-02085: database link <name> connects to by<> Cause: When parameter global_n...Read More
AD-TXK Delta 7 New Feature
adcfgclone.pl appsTier dualfs Cloning Dualfs the new feature introduced in the latest AD-TXK Delta 7. This feature created both fs1...Read More
adop phase=fs_clone [ERROR]: At least one Oracle inventory check has failed.Provide the location of a valid inventory file.
$ <RUN> adop phase=fs_clone [ERROR]: At least one Oracle inventory check has failed.Provide the location of a valid inventory file. So...Read More
ADOP failes (Clean a previous Session)
Case: Checking for existing adop sessions. Session Id : 2 Prepare phase status : NOT APPLICABLE Apply phase s...Read More
How to recreate Oracle Inventory
$ export PATH=$PATH:$ORACLE_HOME/OPatch $ opatch lsinv Oracle Interim Patch Installer version 11.2.0.3.12 Copyright (c) 2016, Oracle Corpora...Read More
R12.2 Adop Does Nothing, Online Patching
Oracle ADOP do nothing and Hangs. Case: adop do nothing when run. Solution: Login by root user and run below command: c Make sure that the ...Read More
Subscribe to:
Posts
(
Atom
)
