Change WEB Port on 12.2
Change WEB Port on 12.2 The steps to change the webport to 8000. Step-1:Start only Weblogic admin using adadminsrvctl.sh start on run file system Login to Enterprise Manager(em) Console using below…
Read MoreAttributes for Finished Goods Item
Field Name Level Values User Item Type Master FINISHED GOOD Item Status Org Active Inventory Item Master Yes Stockable Org Yes Transactable Org Yes Reservable Org Reservable Cycle Count Enabled…
Read MoreWhen the Transactable Item Flag can be enabled
The Transactable Flag for an Item can be enabled only if the Item has Stockable Flag Enabled.
Read MoreReturnable Flag for an Item
The Returnable Flag should be Enabled, If the Item is returnable after successfully completion of order.
Read MoreHigh Water Mark management in Oracle Database
Description: Each table is made up of extents and each extent is made up of oracle blocks – a common block size is 8k. So you have a table with 10 extents (80K). When any table creates the…
Read MoreOracle 12c-Step by Step Manual Data Guard Switchover
Oracle 12c-Step by Step Manual Data Guard Switchover Prepared by Ranesh Details Primary Side Standby Side Server Name Primary Pysical Standby DB Name Warangal Mumbai IP Adresses 192.168.182.128 192.168.182.129 Step 1:- Check database role…
Read MoreRoll Forward Physical Standby Database using RMAN incremental backup
Roll Forward Physical Standby Database using RMAN incremental backup Current_scn from primary database and standby database. PRIMARY [oracle@ranesh ~]$ cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 192.168.182.130…
Read MoreOracle 12c Physical Standby Database Creation using Rman
Oracle 12c Physical Standby Database Creation using Rman Prerequisites for standby built for primary side. Ø Configure network files for both side (Primary,standby). Ø Parameter change in primary side. Ø Copy the Password file from primary…
Read MoreROLLBACK—-Oracle Database Patch
ROLLBACK [oracle@ranesh 30886680]$ opatch apply Oracle Interim Patch Installer version 12.2.0.1.19 Copyright (c) 2020, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/12.2.0.1/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/12.2.0.1/db_1/oraInst.loc OPatch version : 12.2.0.1.19 OUI version : 12.2.0.1.4 Log file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2021-02-18_15-43-47PM_1.log Verifying…
Read More