Database Blog

Not Able To Create A New Database Connection: FNDSECURITY_APPL_SERVER_ID with Instance Mapping For iSetup

ISSUE: On Oracle Applications 12.1.3 version, when attempt to register the target instance on a central instance,getting following error: Message not found. Application: AZ, Message Name: oracle.apps.fnd.common.PoolException: Not able to…

Read More

OPatch Failed with Error Code 19 – “The OPatch version is not applicable for current OUI version”

ISSUE: While trying to apply a patch on a Fusion Middleware or WebLogic Server Oracle home, the following error occurs: $ ./opatch lsinventory -jre /usr/java/jdk1.8.0_141/jre OPatch Version : 13.9.0.0.0 OUI…

Read More

Untitled

ORA-29702: error occurred in Cluster Group Service operation ORA-29702: error occurred in Cluster Group Service operation If you are working on Solaris and having Oracle database 10g or above, you might face…

Read More

Untitled

Applying WebLogic Server APRIL PSU 2019 WebLogic 29016089 PATCH Fails saying “Conflicts/Supersets” or “error code 73” OPatch details: – [oraapp@middleware$] export ORACLE_HOME=/u01/oracle/mw/12.2.1/app [oraapp@middleware$] export PATH=$ORACLE_HOME/OPatch$PATH [oraapp@middleware$] which opatch /u01/oracle/mw/12.2.1/app/OPatch/opatch [oraapp@middleware$] opatch version…

Read More

how to increase connection timeout in weblogic

We need to follow below steps to set this option : -Dsun.net.client.defaultConnectTimeout=5000) through Weblogic Admin Console. To set this JVM options using the weblogic administration console: 1.In the Domain Structure…

Read More

How to set initial and max heapsize in weblogic

When we create a managed server either on the same machine or on remote machine it gets its initial startup parameters from $DOMAIN_HOME/bin/setDomainEnv.sh/cmd file.By default two parameters are set:    Xms: The initial…

Read More

How to apply weblogic bsu patch

step1:  Download latest “patch-client-installer310_generic32.jar” from Oracle Support Site step2:      Go to “bsu” directory of your WLS Installation:     cd  /opt/app/bea1032/utils/bsu step3:   To apply patches run the folowing…

Read More

OGG-01172 Discard file (dirrpt/REPTMP.dsc) exceeded max bytes (20000000).

OGG-01172  Discard file (dirrpt/REPTMP.dsc) exceeded max bytes (20000000). One of my replicate got abended due to discard file reach max bytes value. There is two option to resolve this issue.…

Read More

OGG-02538 Cannot unregister REPLICAT REPIR because of the following SQL error: OCI Error ORA-00942: table or view does not exist (status = 942)

Unregistering an INTEGRATED REPLICAT from an unsupported Oracle database (11.2.0.3) OGG-02538  Cannot unregister REPLICAT REPIR because of the following SQL error: OCI Error ORA-00942: table or view does not exist…

Read More

Login to Oracle Cloud …. After Oracle Cloud Promotion Account Creation

This post is in continuation of my previous post. After you created promotion account, you will receive an confirmation email along with credentials from oracle. Login to Oracle Cloud 1.…

Read More