0 Comments

EBS 12.2 : How to set Admin Password of an EBS WebLogic Domain is lost OR forgotten 5 (1)

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 startup of the AdminServer and Managed Servers. For the EBS WebLogic domain, the Node Manager and WebLogic AdminServer passwords must be same. […]

 186 total views,  5 views today

2 Comments

Exadata : Snapshot Filesystem Backup 5 (4)

During Exadata patching event, it is advisable to take backup of filesystem and easiest way to take filesystem backup is with snapshot of mount point feature. Taking snapshot backup is not an Exadata feature but it is Linux functionality and can be used for any server running with Linux (RHEL/OEL etc.) By using below mentioned […]

 412 total views,  20 views today

2 Comments

TABLE SHRINKING AND DATA FILE RESIZE 5 (1)

Due to less budget sometimes client ask to shrink the mount point space where our datafiles exists 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 tables and resize the datafiles. Here are the steps to […]

 422 total views,  8 views today

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 [root@DBSGURU stage]# mkdir -p /u01/app/oracle/oraInventory [root@DBSGURU stage]# mkdir -p /u01/app/oracle/Middleware [root@DBSGURU stage]# mkdir -p /u01/product [root@DBSGURU stage]# mkdir -p /u02/JAVA [root@DBSGURU stage]# mkdir […]

 349 total views

2 Comments

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

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 process state objects are in use.Action: Increase the value of the PROCESSES initialization […]

 653 total views,  4 views today

4 Comments

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

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

 593 total views,  6 views today

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

 575 total views,  84 views today

4 Comments

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

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:  1,108 total views,  6 views today

 1,108 total views,  6 views today

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 :  502 total views,  4 views today

 502 total views,  4 views today

3 Comments

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

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

 479 total views,  16 views today