Posts
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
How to increase Processes, Sessions and Transactions Initialization Parameters
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
DATABASE MIGRATION FROM WINDOW SERVER TO LINUX SERVER
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
DBMS_LOCK.sleep procedure to suspend the session
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
Step by Step Apply Patch on Oracle DB Home (July 2020)
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
RMAN Duplicate fails to create block change tracking file
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
Resolve ORA-10562,10564,01110,10561,00600 at Standby database
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
Step by Step Weblogic Patching steps
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
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 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
Transparent Application Fail-over in Oracle RAC
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
Recent Comments