Posts by DBsGuru

How to find all physicals files in Oracle 4.5 (2)

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…

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…

De-installation of WebLogic 12.2 5 (1)

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…

Add Disks to ASM Disk Group in Oracle 4.8 (13)

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…

EBS 12.2 : How to set Admin Password of an EBS WebLogic Domain is lost OR forgotten 5 (1)

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…

Exadata : Snapshot Filesystem Backup 5 (5)

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…

TABLE SHRINKING AND DATA FILE RESIZE in Oracle 5 (1)

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…

Steps by step WebLogic configuration 5 (2)

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…

How to increase Processes, Sessions and Transactions Initialization Parameters in Oracle 4.8 (12)

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…

DATABASE MIGRATION FROM WINDOW SERVER TO LINUX SERVER IN ORACLE 4.7 (24)

DATABASE MIGRATION FROM WINDOW SERVER TO LINUX SERVER IN ORACLE In this article, we are going to demonstrate DATABASE MIGRATION FROM WINDOW SERVER TO LINUX SERVER. This is required as part of…