How to change Oracle Applications R12.1.3 Port

 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://<host>.<domain>:8050/OA_HTML/AppsLogin</login_page>

      <chronosURL oa_var="s_chronosURL">http://<host>.<domain>:8050/oracle_smp_chronos/oracle_smp_chronos_sdk.gif</chronosURL> 

      <oa_var="s_endUserMonitoringURL">http://<host>.<domain>:8050/oracle_smp_chronos/oracle_smp_chronos_sdk.gif</EndUserMonitoringURL>

      <externURL oa_var="s_external_url">http://<host>.<domain>:8050</externURL>

      <httplistenparameter oa_var="s_http_listen_parameter">8050</httplistenparameter> 


 Save .XML file>>>>>>

Step:-3

Run Autoconfig on apps_tier for changes to take place.

[applprod@Oracle-prd-erp01 scripts]$ ./adautocfg.sh

Enter the APPS user password: *****

Step:-4

Start Application services.

[applprod@Oracle-prd-erp01 scripts]$ ./adstrtal.sh apps/apps

Step:-5

Verify new URL.

SQL> select HOME_URL from icx_parameters;

HOME_URL

--------------------------------------------------------------------------------

http://Oracle-prd-erp01.oracle.net:8050/OA_HTML/AppsLogin




FDPSTP failed due to ORA-20100: Error: FND_FILE failure

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.



ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf&#...