Linux netstat to list open ports

 netstat -tulpn | grep LISTEN

Increasing the Java Heap size for a Admin Server & managed server in Weblogic

 The size is set in the setDomainEnv.sh file for Linux or setDomainEnv.cmd for Windows, which is in the $DOMAIN_HOME/bin directory.

Steps to set the heap size for Admin and managed server:

1. Shutdown Admin and Managed servers

2. Take backup of setDomainEnv.sh or setDomainEnv.cmd file in case something goes wrong, you can revert the changes. It is best practice to take backup before you made changes in the servers.

3. Open  setDomainEnv file that is under the  $DOMAIN_HOME/bin directory.

4. Copy and paste the below lines in the setDomainEnv file. Make sure you paste the below line at suitable location.

if [ "${SERVER_NAME}" == "AdminServer" ] ; then

USER_MEM_ARGS="-Xms1024m -Xmx1024m -XX:MaxPermSize=512m"

export USER_MEM_ARGS

fi

#In case of osb_server1 Server

if [ "${SERVER_NAME}" == "ms_server1" ] ; then

USER_MEM_ARGS="-Xms512m -Xmx4096m -XX:MaxPermSize=4096m"

export USER_MEM_ARGS

fi

Warning For server , the Node Manager associated with machine is not reachable.

 Modify $DOMAIN_NAME/nodemanager/nodemanager.properties

Make usre of below:

ListenAddress=localhost

ListenPort=5556

SecureListener=true from to flase

Oracle APEX ORDS with SSL and self signed certificate

 cd /u01/app/ords/config/global/standalone

openssl req -x509 -nodes -days 365 \

-newkey rsa:2048 \

-keyout self-signed.key \

-out self-signed.pem \

-subj "/CN=localhost" \

-addext "subjectAltName = DNS:195.229.192.147, DNS:meserver.mydomain.com"

export PATH=/u01/app/jdk11/bin/:$PATH

/u01/app/ords/bin/ords --config /u01/app/ords/config serve --secure --port 4445

oracle apex master details "ORA-01400" cant insert null into foreign key

 Create a new process after the master process and before the interactive grid process, make the editable region the interactive grid, include the below pl/sql code in the new process:

begin

    case :APEX$ROW_STATUS

    when 'C' then

        :QUOTATION_ID:=:P19_QUOTATION_ID;  -- The foreign key

    when 'U' then

    null;

    when 'D' then

        null;

    end case;

end;