Sometime we have to run the application script from application server, but the script required a defined oracle version to run the application script successfully. Below are the Sql query to find the oracle client version. SQL command to get oracle client version. Click here to get sample output. We always encourage the technical person
Below is command, how to find all physical files in Oracle in one short (control files, datafiles & redolog files). Click here to get sample output of all physical files in oracle Question: Why do we need all physical files together? Answer: Whenever we do decommission / clone / restore / migrate etc. We always
Below commands to find Database size in Oracle which includes Total DB size, Free size, used size of DB along with DB name & Hostname, etc. SQL command which fetches database size in GB. Click here to get a sample output of the Oracle client version. SQL command which fetch database size in MB. Click
De-installation of WebLogic 12.2 We are decommissioning one of our Linux server, that server contains WebLogic instance, so as part of decommission we decided to de- installation WebLogic instance.Below are the steps that we have to follow to de install Weblogic. Step1:- Stop Node manager and WebLogic services. Step2 :- Go to <MW_HOME>\oui\bin and execute de
How to add disks to ASM disk group in oracle using command line. Application team requested to create new user along with new tablespace. This is require to deploy new application to fulfil testing. As per requirement, we need additional space in our database. Below are the steps that we have to follow to add
EBS 12.2 : How to set Admin Password of an EBS WebLogic Domain is lost OR forgotten Taken from Oracle E-Business Suite Setup Guide Part No. E22953-31. January 2020 … Fundamental Oracle E-Business Suite Setup Tasks 1-11 … Oracle WebLogic Server 11g Administration Console. AS we know EBS WebLogic Domain uses Node Manager to control the startup of the AdminServer
Step by Step Exadata : Snapshot Filesystem Backup During the Exadata patching event, it is advisable to take the backup of the filesystem, and the easiest way to take filesystem backup is with a snapshot of the mount point feature. Taking snapshot backup is not an Exadata feature but it is Linux functionality and can
Step By Step Table Shrinking and Data File Resize in Oracle Due to less budget sometimes the client asks to shrink the mount point space where our datafiles exist and if developers said that the table size is getting high and due to that our database size is increasing so, in both scenarios we can
Steps by step WebLogic configuration What is Weblogic? • Is an application Server: Java EE compliant• Used in Fusion Apps, OEM 13c• 12c version supports MT (multi-tenancy) • Create stage and MW_home(Middleware) directory • Create Oracle Group • Create Oracle User • Edit Oracle user .bashprofile GUI installed VNC • Installed VNC server • Steps
Demonstration on how to increase processes, sessions, and transactions parameters in Oracle. Whenever DB processes are utilized 100% then it’s NOT allowed any new sessions/connections to DB’s instances and we get the below error:ORA-00020: No more process state objects availableORA-20 errors will not be written to the alert log forthe ORA-20 errors. Cause: All process state
