TABLE SHRINKING AND DATA FILE RESIZE in Oracle

September 19, 2020

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…

Loading

πŸ“Œ
2πŸ’¬ read more

Steps by step WebLogic configuration September 13, 2020

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…

Loading

πŸ“Œ
0πŸ’¬ read more

How to increase Processes, Sessions and Transactions Initialization Parameters in Oracle

September 8, 2020

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…

Loading

πŸ“Œ
3πŸ’¬ read more

DATABASE MIGRATION FROM WINDOW SERVER TO LINUX SERVER IN ORACLE

September 4, 2020

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…

Loading

πŸ“Œ
6πŸ’¬ read more

DBMS_LOCK.sleep procedure to suspend the session in Oracle

August 31, 2020

DBMS_LOCK.sleep procedure to suspend the session in Oracle DBMS_LOCK.sleep procedure suspends the session for a given period of time or specified time in the procedure, it will wait to complete…

Loading

πŸ“Œ
2πŸ’¬ read more

Step by Step Apply Patch on Oracle Database Home (July 2020)

August 27, 2020

Steps to Apply Patch on Oracle Database Home I this article we are going to demonstrate step by Step Apply Patch on Oracle Database Home (July 2020) patch ID 31113348….

Loading

πŸ“Œ
8πŸ’¬ read more

RMAN Duplicate fails to create block change tracking file in Oracle

RMAN Duplicate fails to create block change tracking file in Oracle While restoring of Oracle database on another database node than your source database, RMAN duplicate command may fail to…

Loading

πŸ“Œ
0πŸ’¬ read more

Resolve ORA-10562,10564,01110,10561,00600 at Standby database In Oracle

August 25, 2020

Resolve ORA-10562, 10564, 01110, 10561, 00600 at Standby database In Oracle In this article, we will resolve errors ORA-10562, 10564, 01110, 10561, 00600 at Standby. A few days back, we…

Loading

πŸ“Œ
6πŸ’¬ read more

Step by Step Weblogic Patching steps

August 21, 2020

Below are step-by-step demonstrations about the apply patches in Weblogic. Create Directory PATCH (It’s optional) Go to the patch directory. Copy Weblogic patch from /tmp. Check opatch version. Go to…

Loading

πŸ“Œ
0πŸ’¬ read more

ORACLE APPS R12 CLONING STEPS

August 18, 2020

ORACLE APPS R12 CLONING STEPS In this article, we will set up Oracle APPS R12 on the server Oracle Linux. Follow the below ORACLE APPS R12 CLONING STEPS. (ON PRODUCTION…

Loading

πŸ“Œ
2πŸ’¬ read more