managed server ports

[satish]

Dear Erman,

We would like to change a port for oacore_server3 manged server in our environment.we checked note id 1905593.1.

Note id didnt suggest to run autoconfig,but how does the new port gets reflected in database?


Thanks

[ErmanArslansOracleBlog]

It is already documented in the note.. (1905593.1)

4.2.4 Changing the Port Numbers of the Managed Servers

This question is weird -> "how does the new port gets reflected in database"
You already supply the context file while you are adding back the managed server using /txkSetAppsConf.pl

In addition to that, the whole process is documented by Oracle . So you don't need to worry about that :)

[satish]

Dear Erman,

I have changed the port of oacore from 7290 to 7333 in admin console and there after ran the below commands.

removing
======
[appldev@erpdevelopment config]$ perl $FND_TOP/patch/115/bin/txkSetAppsConf.pl -contextfile=/u02/DEVDBINST/fs1/inst/apps/DEVDB_erpdevelopment/appl/admin/DEVDB_erpdevelopment.xml \
> -configoption=removeMS -oacore=erpdevelopment.ttd.com:7290

*** LOG FILE: /u02/DEVDBINST/fs1/inst/apps/DEVDB_erpdevelopment/logs/appl/rgf/TXK/txkSetAppsConf_04061617.log ***
[appldev@erpdevelopment config]$


Adding
=====

[appldev@erpdevelopment config]$ perl $FND_TOP/patch/115/bin/txkSetAppsConf.pl -contextfile=/u02/DEVDBINST/fs1/inst/apps/DEVDB_erpdevelopment/appl/admin/DEVDB_erpdevelopment.xml \
> -configoption=addMS -oacore=erpdevelopment.ttd.com:7333

*** LOG FILE: /u02/DEVDBINST/fs1/inst/apps/DEVDB_erpdevelopment/logs/appl/rgf/TXK/txkSetAppsConf_04061621.log ***
[appldev@erpdevelopment config]$



still the new port number was not reflecting in context file

[appldev@erpdevelopment config]$ grep -i oacore_server5 $CONTEXT_FILE
         <oacore_server_ports oa_var="s_oacore_server_ports">oacore_server1:7218,oacore_server2:7219,oacore_server3:7206,oacore_server5:7290</oacore_server_ports>

so it means in database context file as well we have the same old port

[satish]

logs.txt

Logfile attached

[satish]

Dear Erman,

I have changed the port of oacore from 7290 to 7333 in admin console and there after ran the below commands.

removing
======
[appldev@erpdevelopment config]$ perl $FND_TOP/patch/115/bin/txkSetAppsConf.pl -contextfile=/u02/DEVDBINST/fs1/inst/apps/DEVDB_erpdevelopment/appl/admin/DEVDB_erpdevelopment.xml \
> -configoption=removeMS -oacore=erpdevelopment.ttd.com:7290

*** LOG FILE: /u02/DEVDBINST/fs1/inst/apps/DEVDB_erpdevelopment/logs/appl/rgf/TXK/txkSetAppsConf_04061617.log ***
[appldev@erpdevelopment config]$


Adding
=====

[appldev@erpdevelopment config]$ perl $FND_TOP/patch/115/bin/txkSetAppsConf.pl -contextfile=/u02/DEVDBINST/fs1/inst/apps/DEVDB_erpdevelopment/appl/admin/DEVDB_erpdevelopment.xml \
> -configoption=addMS -oacore=erpdevelopment.ttd.com:7333

*** LOG FILE: /u02/DEVDBINST/fs1/inst/apps/DEVDB_erpdevelopment/logs/appl/rgf/TXK/txkSetAppsConf_04061621.log ***
[appldev@erpdevelopment config]$



still the new port number was not reflecting in context file

[appldev@erpdevelopment config]$ grep -i oacore_server5 $CONTEXT_FILE
         <oacore_server_ports oa_var="s_oacore_server_ports">oacore_server1:7218,oacore_server2:7219,oacore_server3:7206,oacore_server5:7290</oacore_server_ports>

so it means in database context file as well we have the same old port

when will the context file gets reflected with new port?

[satish]

both the files mod_wl_ohs.conf and apps.conf are updated with new ports.But i dont see the new port in context file
Do we also need to edit the context file with new oacore port?

[ErmanArslansOracleBlog]

It may be changed the context file stored in the database;

Please check with following queries;

SELECT extractValue(XMLType(TEXT),'//host[@oa_var="s_hostname"]'),
extractValue(XMLType(TEXT),'//oacore_server_ports'),
extractValue(XMLType(TEXT),'//forms_server_ports'),
extractValue(XMLType(TEXT),'//oafm_server_ports'),
extractValue(XMLType(TEXT),'//forms-c4ws_server_ports'),
extractValue(XMLType(TEXT),'//oaea_server_ports')
from fnd_oam_context_files
where name not in ('TEMPLATE','METADATA')
and (status is null or status !='H')
and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type')='run'
and CTX_TYPE = 'A';

SELECT extractValue(XMLType(TEXT),'//host[@oa_var="s_hostname"]'),
extractValue(XMLType(TEXT),'//oacore_server_ports'),
extractValue(XMLType(TEXT),'//forms_server_ports'),
extractValue(XMLType(TEXT),'//oafm_server_ports'),
extractValue(XMLType(TEXT),'//forms-c4ws_server_ports'),
extractValue(XMLType(TEXT),'//oaea_server_ports')
from fnd_oam_context_files
where name not in ('TEMPLATE','METADATA')
and (status is null or status !='H')
and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type')='patch'
and CTX_TYPE = 'A';

If you see your new port returned as the output of the queries above; then probably, it will be reflected to the Apps tier context file after running autoconfig on apps tier..

Update me with the outcome..

[satish]

Dear Erman,

I have checked that but new port is not reflected in database as well

SELECT extractValue(XMLType(TEXT),'//host[@oa_var="s_hostname"]'),
extractValue(XMLType(TEXT),'//oacore_server_ports'),
extractValue(XMLType(TEXT),'//forms_server_ports'),
extractValue(XMLType(TEXT),'//oafm_server_ports'),
extractValue(XMLType(TEXT),'//forms-c4ws_server_ports'),
extractValue(XMLType(TEXT),'//oaea_server_ports')
from fnd_oam_context_files
where name not in ('TEMPLATE','METADATA')
and (status is null or status !='H')
and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type')='run'
and CTX_TYPE = 'A';

extractValue(XMLType(TEXT),'//oacore_server_ports') = oacore_server1:7218,oacore_server2:7219,oacore_server3:7206,oacore_server5:7290


7290 is old port and 7333 is new port

[ErmanArslansOracleBlog]

Please restart that managed server using admanagedsrvctl.sh and check the context file afterwards..

[satish]

Dear Erman,

It is unable to bring down the oacore managed server,please see the logs.It is connecting to old port

[appldev@erpdevelopment config]$ admanagedsrvctl.sh stop oacore_server5

You are running admanagedsrvctl.sh version 120.14.12020000.11

Enter the WebLogic Admin password:
Stopping oacore_server5...
Refer /u02/DEVDBINST/fs1/inst/apps/DEVDB_erpdevelopment/logs/appl/admin/log/adoacorectl.txt for details

Server specific logs are located at /u01/DEVDBAPPS/fs1/FMW_Home/user_projects/domains/EBS_domain_DEVDB/servers/oacore_server5/logs

admanagedsrvctl.sh: exiting with status 0

admanagedsrvctl.sh: check the logfile /u02/DEVDBINST/fs1/inst/apps/DEVDB_erpdevelopment/logs/appl/admin/log/adoacorectl.txt for more information ...

[appldev@erpdevelopment config]$


Logs


04/06/18-18:15:33 :: admanagedsrvctl.sh version 120.14.12020000.11


Validated the passed arguments for the option ebs-get-serverstatus
oacore_server5 is in RUNNING mode.

Validated the passed arguments for the option ebs-nmstop-managedsrv

Shutting down managed server oacore_server5

Connecting to t3://erpdevelopment.ttd.com:7290 with userid weblogic ...

Cannot connect to t3://erpdevelopment.ttd.com:7290
ERROR: Unable to shutdown the managed server oacore_server5

Server specific logs are located at /u01/DEVDBAPPS/fs1/FMW_Home/user_projects/domains/EBS_domain_DEVDB/servers/oacore_server5/logs

04/06/18-18:15:48 :: admanagedsrvctl.sh: exiting with status 0

================================================================================

[ErmanArslansOracleBlog]

Also restart the admin server and recheck the context file..

If you are still seeing the old port value then, you may consider running adSyncContext.pl, which can be used for the synchronization of the context variables with the WebLogic Server and Oracle HTTP Server configurations.  (As documented in "2.2 Run SyncContext on the Application Tier" -  Managing Configuration of Oracle HTTP Server and Web Application Services in Oracle E-Business Suite Release 12.2 (Doc ID 1905593.1) )

Or you may consider -> 2.1 run adRegisterWLSListeners Tool on the Application Tier"

EBS uses them to update the context file in anyways.

[satish]

Thanks for the updates erman,Trying it

[satish]

restarted the admin server-->didnt work
ran adRegisterWLSListeners.pl--->didnt work

Ran adSyncContext.pl and worked like a charm.Now i am able to stop and start oacore managed server.
It also updated the database context file with new port and also file system context file.

I think this all should happen without our intervention right?please correct me

Thanks for all your support.You are always the best man

[ErmanArslansOracleBlog]

thanks for your feedback.

Yes .. Those context files should normally be updated automatically, without your actions.. (as documented)
But in your case, it may be related with your env and patch levels.. More up-to-date AD & TXK, more stable AD & TXK related works :)