0 Comments

De-installation of WebLogic 12.2 0 (0)

We are decommissioning one of our Linux server, that server contains WebLogic instance, so as part of decommission we decided to de- installation WebLogic instance.Below are the steps that we have to follow to de install Weblogic. Step1:- Stop Node manager and WebLogic services. Step2 :- Go to <MW_HOME>\oui\bin and execute de install. Step3:- After successful […]

 331 total views

Spread the love

0 Comments

Add Disks to ASM Disk Group in Oracle 4.9 (10)

How to add disks to ASM disk group in oracle using command line. Application team requested to create new user along with new tablespace. This is require to deploy new application to fulfil testing. As per requirement, we need additional space in our database. Below are the steps that we have to follow to add […]

 1,173 total views

Spread the love

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

 564 total views

Spread the love

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

 1,575 total views,  6 views today

Spread the love

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

 1,074 total views

Spread the love

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

 572 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,374 total views,  1 views today

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,035 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,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

 3,568 total views,  22 views today

Spread the love