2 Comments

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

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 be entered in hundredths of a second; for […]

 1,511 total views,  2 views today

Spread the love

6 Comments

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

Steps to Apply Patch on DB Home Patch 31281355 – Database Release Update 19.8.0.0.200714 ==> 19cPatch 31308624 – Database Release Update 18.11.0.0.200714 ==> 18cPatch 31312468 – Database Release 12.2.0.1. 200714 ==> 12.2.0.1Patch 31113348 – Database Patch Set Update 12.1.0.2.200714 ==> 12.1.0.2 Patch 31103343 – Database Patch Set Update 11.2.0.4.200714 ==> 11.2.0.4 The next four dates for Critical Patch Updates are:  3,568 total views,  22 views today DBsGuruHello and welcome to DBsGuru, DBsGuru […]

 3,568 total views,  22 views today

Spread the love

0 Comments

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

While restoring of database on other database node than your source database, duplicate command may fail with following errors after restoring of database :  1,292 total views,  2 views today DBsGuruHello and welcome to DBsGuru, DBsGuru is a group of experienced DBA professionals and serves databases and its related community by providing technical blogs, projects, training. Technical […]

 1,292 total views,  2 views today

Spread the love

3 Comments

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

Few days back, we got SYSAUX tablespace error at DBGURU STANDBY database and the error was – 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 (file# 2, block# 3052738)ORA-10564: tablespace SYSAUXORA-01110: data file 2: ‘/u02/app/oracle/oradata/DBGURU_STAND/datafile/sysaux.dbf’ORA-10561: block type ‘TRANSACTION MANAGED INDEX BLOCK’, data object# 46394ORA-00600: internal error code, arguments: [kdxlin:bad itl index], […]

 1,473 total views,  6 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 […]

 685 total views,  2 views today

Spread the love

3 Comments

ORACLE APPS R12 CLONING STEPS 4.5 (19)

(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 server to test server through scp. Before moving EBSapps on test server rename the existing EBSapps from there and delete or rename fmw also. ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ (ON TEST APPS […]

 1,732 total views,  2 views today

Spread the love

3 Comments

Transparent Application Fail-over(TAF) 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,117 total views

Spread the love