Posts
De-installation of WebLogic 12.2
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
Add Disks to ASM Disk Group in Oracle
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
EBS 12.2 : How to set Admin Password of an EBS WebLogic Domain is lost OR forgotten
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
Exadata : Snapshot Filesystem Backup
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
TABLE SHRINKING AND DATA FILE RESIZE
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
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
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,374 total views, 1 views today
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,035 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,511 total views, 2 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: 3,568 total views, 22 views today
3,568 total views, 22 views today
Recent Comments