Scaling by adding Managed Servers on the provisioned nodes Using Oracle WebLogic Server [Marketplace] for Oracle Cloud Infrastructure

 

 

To add managed servers on the already provisioned VMs, and scale WLS managed servers without scaling the number of nodes,

 

1-    Create the new managed servers in the WLS Admin Console, or through scripting, making sure to select ports that are available

 

 

 

2-    Update security list with new port

 

 

 

3-    Add backends to the load balancer

 

Add New Managed port to load balancer Backends

 

 

Change port from default Managed server port (7003) to generics port (22) to avoid load balancer error when default managed server port unavailable  

 

 

 

 

 

 

Wait until see Load balancer Overall Health is OK

How To Select Number of Workers Based on Number of CPUs When Running ADADMIN or ADOP

 How To Select Number of Workers Based on Number of CPUs When Running ADADMIN or ADOP

EBS Application  Version: 12.2

How to select number of workers based on number of processors when running ADADMIN or ADOP

Solution

Select 4x the number of CPUs on the instance to be patched.

Ex. Machine has 4 CPUs , select number of workers 16 (4*4) when running  ADADMIN or ADOP.

The below command to determine CPUs number on Linux Platform.

lscpu | egrep 'Model name|Socket|Thread|NUMA|CPU\(s\)'

 INFO:

Problem

===========

During install database 19c we have the below error.

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

/bin/sh: line 2: /usr/bin/as: Permission denied

INFO:

mv: cannot stat ‘ntcontab.o’: No such file or directory

INFO:

/usr/bin/ar: /u01/install/DWH/19.0.0/lib/ntcontab.o: No such file or directory

INFO:

make: *** [ntcontab.o] Error 1

INFO: End output from spawned process.

INFO: ----------------------------------

INFO: Exception thrown from action: make

Exception Name: MakefileException

Exception String: Error in invoking target 'mkldflags ntcontab.o nnfgt.o' of makefile '/u01/install/DWH/19.0.0/network/lib/ins_net_client.mk'. See '/opt/oracle/oraInventory/logs/InstallActions2020-11-09_12-04-12PM/installActions2020-11-09_12-04-12PM.log' for details.

Exception Severity: 1

Solution:

==========

login by root user the run the below command

chmod 777 /usr/bin/as

Disable Oracle Label Security (OLS) 11gR1

Check Oracle Label Security OLS Status
=============================

SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Label Security';

Disable Oracle Label Security OLS
=============================

sqlplus sys as sysoper
Enter password: password

SQL> SHUTDOWN IMMEDIATE
SQL> EXIT

$ emctl stop dbconsole
$ lsnrctl stop [listener_name]

cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk lbac_off
cd $ORACLE_HOME/bin
relink all

Adop Apply patch and its translation:

adop phase=apply patches=1012464,10124646_AR:u10124646.drv

adop phase=apply apply_mode=downtime patches=30980514,30980514_AR:u30980514.drv

APP-FND-1434: fdlsql cannot find FROM clause in QuickPick statement is returned

PROBLEM STATEMENT
=================
While trying to setup the profile option PO : Attachments to display in Notification Header, 

when calling the LOV error APP-FND-1434: fdlsql cannot
find FROM clause in QuickPick statement is returned

Solution

==========

apply the following patch.

Patch 30007772: In oracle purchasing, profile option 

"PO: Attachment to display in Notification Header" can be set up successfully.