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

 618 total views

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,487 total views

Spread the love

6 Comments

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

DATABASE DETAIL : Source: Windows Version Windows server 2012 R2 Standard DB VERSION 12c Enterprise Edition Release  12.1.0.2.0 – 64bit DB NAME DBSGURU Target: LINUX VERSION Linux x86_64 DB VERSION 12c Enterprise Edition Release  12.1.0.2.0 – 64bit DB NAME DBSGURU SUMMARY: Checked hardware, operating system, version and storage of both source & target servers. Verified […]

 1,125 total views

Spread the love

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,739 total views,  4 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: This document is only for learning purpose and always validate […]

 4,204 total views,  2 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,590 total views,  2 views today

 1,590 total views,  2 views today

Spread the love

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

 2,479 total views,  2 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 […]

 862 total views,  2 views today

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

 2,158 total views,  2 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,212 total views

Spread the love