Usman Shahid Oracle Apps DBA / APPS DBA / EBS DBA / Oracle E-Business Suite Applications

  I got recently a issue with Concurrent program, All program completed with below error. **Starts**09-MAY-2022 21:07:39 ORACLE error 20100 in FDPSTP Cause: FDPSTP failed due to ORA-20100: Error: FND_FILE failure. Unable to create file, o5819484.tmp in the directory, /usr/tmp. You will find more information in the request log. ORA-06512: at "APPS.FND_FILE", line 417 ORA-06 Solution :- change Directory file permssion to 777. so that others can write a file into it. # chmod 777 /usr/tmp Retest issue.

  How to change Oracle Applications R12.1.3 Port-8002 to 8050 Step:-1 Dowm Application Tier [applprod@prd-erp01 ~]$ cd $ADMIN_SCRIPTS_HOME [applprod@prd-erp01 scripts]$ ./adstpall.sh apps/apps Step:-2 Open your  Context XML file for edit it.  Go to Context XML path :- $INST_TOP/appl/admin/ Take backup of .XML file :- cp Oracle_prd-erp01.xml Oracle_prd-erp01.xml-bkp10MAY22 Edit Oracle_prd-erp01.xml file with below parameter port value replace from 8002 to 8050. Change the value from 8002 to be 8050 on the following lines:       <web_port oa_var="s_webport" oa_type="PORT" base="8000" step="1" range="-1" label="Web Listener Port">8050</web_port>       <activewebport oa_var="s_active_webport" oa_type="DUP_PORT"  base="8000" step="1" range="-1" label="Active Web Port">8050</activewebport>       <login_page oa_var="s_login_page">http:...

  So let us begin with the software downloads. You can download Oracle Database from either MOS or Oracle edelivery: https://www.oracle.com/in/database/technologies/oracle19c-linux-downloads.html https://edelivery.oracle.com I have configured  Linux 8  on  Oracle Virtual Box . I won’t go through the steps to setup OL8 in this post. The software I used are: Oracle Virtual Box Oracle Linux 8 Oracle Database 19c (19.3) Prerequisites Once you have downloaded and setup  OL8 , there are some prerequisite setups that needs to be performed before kicking of the installation. These steps are shown below. Get the IP Address using ‘ifconfig’ or ‘ip addr’ command. For example: [root@oracledb19col8 ~]# ifconfig Get the hostname. [root@oracledb19col8 ~]# hostname oracledb19col8.rishoradev.com Amend the IP address and hostname to  “/etc/hosts”  file to resolve the hostname. You can use the vi editor for this. [ Note: This can also be done with DNS ]. 127.0.0.1 loc...