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 DBsGuruHello and welcome to DBsGuru, DBsGuru is a group […]

 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

0 Comments

Step by Step Weblogic Patching steps 4.7 (19)

Below are step by step demonstration about apply patch in weblogic. Create Directory PATCH (Its optional) Go to patch directory Copy weblogic patch from /tmp Check opatch version Go to patch directory Unzip patch Stop weblogic process Stopped nodemanager and weblogic process List current opatch inventory Go to patch directory and first upgrade opatch version […]

 985 Total Views

3 Comments

ORACLE APPS R12 CLONING STEPS 4.5 (19)

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 APPS TIER) +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Run adpreclone.pl on Production server. (It will create EBSapps on production) [appl@DBGURU]$ cd $ADMIN_SCRIPTS_HOME  perl adpreclone.pl appsTier Now, move EBSapps from Production […]

 2,669 Total Views,  1 Views Today

3 Comments

Transparent Application Fail-over in Oracle RAC 4.5 (22)

Transparent Application Failover (TAF) is used for failover process, if the database instance connection goes fails it would reconnect to available database instance. TAF can be configure in a 2 ways.1.server Side2. Client Side. IN this Blog, we will configure server side TAF. To configure TAF policy use SRVCTL as in the following example srvctl […]

 1,303 Total Views,  2 Views Today

Spread the love