Restart EBS Concurrent Manager; Oracle

 

[ebsApps@ebsServer1 scripts]$ ./adcmctl.sh stop

You are running adcmctl.sh version 120.19.12020000.7

Enter the APPS username : apps

Enter the APPS password :

[ebsApps@ebsServer1 scripts]$ ./adcmctl.sh start

kill any FND processes if exists.

ps -ef | grep FND

kill -9 <process_ids>

Oracle support document: 

E-Business Suite Concurrent Processing - After Cloning All The Concurrent Managers Do Not Start For The Cloned Instance (Doc ID 555081.1)

https://drive.google.com/file/d/1cmc6jeRoDJ3HrFGmn13EPtzFYW0S8OV_/view?usp=sharing

The server Managed_Server is in an incompatible state; WebLogic

 Delete the managed_server1.state file @ /appName/app/oracle/product/12.2.1.4/user_projects/domains/base_domain/servers/managed_server1/data/nodemanager/ 

and restart the admin and node manager to fix this issue.

https://ruleoftech.com/2014/weblogic-12c-and-managed-server-in-incompatible-state

List all processes running on port number; UNIX

 netstat -anp | grep <port_number>

Example: netstat -anp | grep 7111

         See the details of the PID:                                                                                                                  ps -elf |grep  <process_id>

                                                               

                                                              Example:  ps -elf |grep  113539

Setup load balancer on WebLogic Server using Proxy App;

Here are the steps:

1. Setup cluster environment with managed server.

2. Add Load Balancer standalone server listening to port 9999.

3. Deploy an app with web.xml and weblogic.xml settings. All the http requests to port 9999 will be redirected to managed servers on cluster. 

Update the myloadbal.war with respective managed server addresses and create a war to deploy to the load balancer server - port 9999. 

All apps (Java and ADF apps) should be deployed to the cluster environment. myloadbal.war would act as proxy to the cluster environment.

benefits.war is deployed to the cluster environment and can be accessed from load balancer port. 

itsp11648:9999 would open the welcome.html page.

 jar -xvf benefits.war
Above command extracts the contents of the file.

https://stackoverflow.com/questions/7882745/how-to-extract-war-files-in-java-zip-vs-jar

Below command is used to create a war file:

 jar -cvf myloadbal.war *

Helpful links:

https://www.ateam-oracle.com/using-weblogic-as-a-load-balancer

Oracle support documents: Note 1382494.1 and 1269410.1 

https://drive.google.com/drive/folders/17Snfpq1AUDABUG7lukjZle1NCbxvxdw2?usp=sharing

Creation and Extraction of war file contents ; LINUX

 jar -xvf benefits.war

Above command extracts the contents of the file.

https://stackoverflow.com/questions/7882745/how-to-extract-war-files-in-java-zip-vs-jar

Below command is used to create a war file:

 jar -cvf myloadbal.war *

Remote deployment failed (oracle.jdevimpl.deploy.common.Jsr88RemoteDeployer); ADF ; Deployment to WebLogic failed;

Error on WebLogic when deploying;

Message icon - Error An error occurred during activation of changes, please see the log for details.

Message icon - Error weblogic.common.ResourceException: No credential mapper entry found for password indirection user=apps for data source Apps

Message icon - Error No credential mapper entry found for password indirection user=apps for data source Apps

Resolution:

Uncheck below option (Auto Generate and Synchronize WebLogic Descriptors during deployment) under Application Properties->Deployments->WebLogic

Helpful links:

https://prashant-adf-sample.blogspot.com/2019/08/deployment-cancelled.html

Restart JIRA with MySQL DB; UNIX commands

ps -ef | grep jira

kill any running processes.

 

As app user:

 

Start database with /usr/local/mysql/bin and run ./mysqld

 

to stop database;

 

cd /usr/local/mysql/supporting-files/  and ./mysql.server stop

 

 

 

 

    export JAVA_HOME=/apname/src/jdk1.8.0_211/

​

    export PATH=$JAVA_HOME/bin:$PATH

 

 

cd /usr/local/mysql/

              

[app@ITSP14 bin]$ ./mysql -u root -p

 

password:<password>

 Below needs to be set for MySQL8

mysql>    SELECT @@global.time_zone;

​

mysql>   SET GLOBAL time_zone = '+00:00';

              

               After setting it up, Don't restart MySQL, Just restart JIRA

              

               Restart JIRA as jira user.

              

               ./config.sh is used to configure jira

 

 

As root run ->chown -R jira:jira /appname/apps/atlassian/

 

Reindex after logging to JIRA under Systems and Advanced options-->

Irrelevant errors occurring after building a java app on eclipse; JAVA

 Try to clean the project and re-run.

Kill multiple UNIX processes in single command;

 for pid in $(ps -ef | awk '/weblogic/ {print $2}'); do kill -9 $pid; done

https://unix.stackexchange.com/questions/50555/kill-many-instances-of-a-running-process-with-one-command

Run Excel Macro from Java;

 https://javaprogramming.language-tutorial.com/2012/10/run-excel-macro-from-java.html

Open Visual Basic Editor in Excel; Macros

Helpful links:

https://support.microsoft.com/en-us/office/copy-a-macro-module-to-another-workbook-13c0938b-8432-4259-9177-a71f7e626de0

https://excelzoom.com/how-to-open-excel-vba-editor/

UiPath Community Presentation Template; 2021; RPA

 https://drive.google.com/drive/folders/1n_qYZkFzdB6SRMRmpfAJ4KKVxi3gtGWF?usp=sharing

Power Point Presentation for Community Users for sharing their insights.