Davis Apps DBA

After cloning the EBS Application, we faced issue while trying log in to the application. Log in information is validated, but instead of the Home page a blank screen appears and also the error message is not thrown. Generally in EBS Click Here for Exception Details will appear. On clicking the button we'll able to see the error stack and we plan for some workaround. In my case that Click Here message itself is not displayed. To bring that message, need to enable the Profile Option FND:Diagnostics = YES. Since we can't login to the application we'll achieve that form backend. Step 1: DECLARE stat boolean; BEGIN dbms_output.disable; dbms_output.enable(100000); stat := FND_PROFILE.SAVE('FND_DIAGNOSTICS', 'YES', 'SITE'); IF stat THEN dbms_output.put_line( 'Stat = TRUE - profile updated' ); ELSE dbms_output.put_line( 'Stat = FALSE - profile NOT updated' ); END IF; commit; END; / Step 2: Re-attempt to login and clic...

Recently in our environment we've upgraded our OS from AIX 6.1 to AIX 7.1. OS up-gradation activity completed  successfully. We tried to bring our DB and APPS services online and faced this new issue while starting the DB listener. Below is the issue and the solution for the same. The problem is due to I/O Communication ports either not enabled or not installed. To check whether IOCP is installed run the following command.   #lslpp -l bos.iocp.rte  As shown above IOCP is installed and available in AIX. To check whether IOCP is enabled or not, run the following UNIX command # lsdev -Cc iocp It showed "Defined", which means not enabled. The output should show "Available" instead of "Defined". To change the status from Defined to Available, use the UNIX Smitty commad as follows #smitty iocp Select Change / Show characteristics of I/O Completion Ports Change configured state at system, restart to change for...

In this post we'll see the Installation and configuration of Weblogic Server 12.2.1.3 version in a detailed step by step process. Also here I've configured WLS for ADF. Below are the required setup files. Installing JDK: Untar the jdk file by using the below command tar -zxvf <jdk file name> Installing Weblogic Server : This 12.2. version of Weblogic Server is bit different in the Installation process in compared with the earlier releases. Here we need to run the Infrastructure installer. Let us see the steps in detail. Now the Installation of the Infrastructure is completed. Next we need to create the required schema's, repository and configure the Base Domain to start the WLS. Schema Creation: To create schema we need to create a user at DB level and assign him DBA privileges. Follow the below steps to accomplish the above said step. create user as below sqlplus '/as sysdba' ...