Last added datafile in Oracle
Below query will give you the last added datafile in oracle. This will be useful to check whenever you have datafile related issues. DBA_HIST_DATAFILE is the view stores information of…
Read MoreShrink datafile with free space beyond high water mark
There are times where we need to clear the space of the mount point when the database grows. Sometimes, we run out of space and we may need to wait…
Read MoreUnzip particular file from an zip file
Sometimes we would know the archive file present in zip folder and would like to unzip only that particular file. The ‘-j’ option help us to achieve the same. Lets…
Read MoreHow to Tar excluding few sub directories
Many of us would have perform tar of directories for cloning/file movement between the servers. Many times we would have think to exclude some sub-directories which are not needed, so…
Read MoreNot 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 MoreOPatch 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 MoreUntitled
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 Morehow 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 MoreHow 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