Sunday, December 12, 2021

adop prepare phase fails with TNS-12542 TNS-12560 TNS-00512 Address already in use

Did your adop phase=prepare fail in Oracle E-Business Suite 12.2.x version with the following error messages ?


Error listening on: (ADDRESS=(PROTOCOL=TCP)(Host=application-server)(Port=xxyy))
TNS-12542: TNS:address already in use
 TNS-12560: TNS:protocol adapter error
  TNS-00512: Address already in use
   Linux Error: 98: Address already in use


Solution

Under usual circumstances, this should not be an issue at all because the Oracle EBS apps listener should be up and running all the time (The tnslsnr process) and adop phase=prepare should successfully get completed by noting that the LISTENER listener-name has already been started.

However, due to some unexplained reasons, the prepare phase may still fail. It may be an Oracle bug. But we can simply abort the online patching, do a full cleanup, stop the apps listener and retry the adop phase=prepare.

 

Abort and do a full cleanup

adop -status  (Shows that it failed at the prepare or apply phase)
 
Set the RUN file system
 
echo $FILE_EDITION (Must show run)
 
adop phase=abort

adop phase=cleanup cleanup_mode=full 


Stop the LISTENER process

netstat -nlp | grep xxyy (Replace xxyy with the actual port number reported in the error message)

ps -ef | grep tnslsnr


Make sure the process id matches with that of the id shown from the output of netstat command above.

Now terminate the process id using the kill -15 processid command. 

Wait for a minute. If it is still running, then terminate using the kill -9 processid command.

 

Retry

adop phase=prepare

 

Conclusion

This issue can be an Oracle bug. If this error occurs frequently with the adop phase=prepare, then create a service request with Oracle support at https://support.oracle.com

Saturday, December 11, 2021

Oracle EBS online patching abort after adop prepare phase

If your Oracle E-Business Suite (Oracle EBS) online patching process failed only at the adop phase=prepare phase, then you can abort the online patching process by running the following commands.

 
adop -status (Shows that it failed at the prepare or apply phase)
 
Set the RUN file system
 
echo $FILE_EDITION (Must show run)
 
adop phase=abort

adop phase=cleanup cleanup_mode=full


The additional adop phase=fs_clone is required only if it failed at the actual patch apply phase i.e adop phase=apply. Otherwise fs_clone is not required.


Sunday, October 24, 2021

How to share VNC Viewer screen

Launch VNC Viewer

Click on Options

Choose Misc.

Check the Shared (don't disconnect other viewers)

 

 


 

 

  


 

 

Related Posts Plugin for WordPress, Blogger...