0 Comments

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 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 […]

 836 Total Views,  5 Views Today

Spread the love

2 Comments

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 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 […]

 1,951 Total Views,  1 Views Today

Spread the love

2 Comments

TABLE SHRINKING AND DATA FILE RESIZE 5 (1)

Step By Step Table Shrinking and Data File Resize 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 shrink those […]

 1,385 Total Views

Spread the love

0 Comments

Steps by steps WebLogic configuration 5 (1)

What is Weblogic ? • Is a Application Server: Java EE compliant• Used in Fusion Apps , OEM 13c• 12c version supports MT (multi tenancy) • Create stage and MW_home(Middle ware) directory • Create Oracle Group • Create Oracle User • Edit Oracle user .bashprofile GUI installed VNC • Installed VNC server • Steps to […]

 800 Total Views,  1 Views Today

3 Comments

How to increase Processes, Sessions and Transactions Initialization Parameters 4.8 (11)

Demonstration on how to increase processes, sessions and transactions parameter in Oracle. Whenever our processes utilized 100% then its NOT allowed any new sessions / connections to DB’s instances and we get 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 […]

 1,995 Total Views

Spread the love

6 Comments

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

In this article, we are going to demonstrate DATABASE MIGRATION FROM WINDOW SERVER TO LINUX SERVER. This is required as part of migration on request of the client to route application on new configuration (Weblogic). DATABASE DETAIL : Source: WINDOWS SERVER VERSION Windows server 2012 R2 Standard DATABASE VERSION 12c Enterprise Edition Release  12.1.0.2.0 – 64bit DATABASE […]

 1,925 Total Views

Spread the love

2 Comments

DBMS_LOCK.sleep procedure to suspend the session in Oracle 4.6 (21)

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 procedure, it will wait to complete procedure then next SQL statement will execute. DBMS_LOCK.SLEEP (seconds IN NUMBER); seconds : Amount of time, in seconds, to suspend the session. The smallest increment can […]

 2,061 Total Views

Spread the love

6 Comments

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

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. Before move ahead we will see here patch July patch IDs for all available version of Oracle database along with four next release date of […]

 4,691 Total Views,  4 Views Today

Spread the love

0 Comments

RMAN Duplicate fails to create block change tracking file in Oracle 4.4 (21)

RMAN Duplicate fails to create block change tracking file in Oracle While restoring of Oracle database on other database node than your source database, RMAN duplicate command may fails to create block change tracking file with following errors after restoring of database:  2,050 Total Views,  2 Views Today

 2,050 Total Views,  2 Views Today

Spread the love

6 Comments

Resolve ORA-10562,10564,01110,10561,00600 at Standby database In Oracle 4.7 (21)

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. Few days back, we got SYSAUX tablespace error at DBGURU STANDBY database and the error was as below: Errors in file /u02/app/oracle/diag/rdbms/dbguru/dbguru/trace/dbguru_mrp0_26696.trc:ORA-10562: Error occurred while applying redo to data block […]

 3,326 Total Views,  5 Views Today

Spread the love